SQL Anywhere Mobile - create ASA remote database out of consolidated database

Author

create ASA remote database out of consolidated database

Eric Verhorstert

2005-06-09, 7:24 am

I am trying to make a remote database out of a consolidated database.

The scheme of the remote database should be parallel in structure to the
scheme of the consolidated database. The database has about 300 tables.
In all our tables is a identifier company_id and in some tables (about
200) the identifier user_id.

After the remote database is created synchronisation should work as
follows:
The tables with the identifier user_id are changed in the remote
database and should be uploaded to the consolidated database. The tables
with no user_id are changed in the consolidated database and should be
downloaded to all remote databases.
User_id is a number from 1 til 999. So we could have a maximum of up to
999 remote databases.

Creating the remote database I made a publication with all tables and
all columns included in the consolidated database (and yes, I have a
copy). I did not use the where clause. Then I created a mobilink user.
When I create the remote database for user 1 the data should be
extracted from tables with the column user_id in it where user_id = 1
and all the data from the tables without column used_id. For user 2 the
same except of course that user_id = 2. etc.

Should I make for each user a seperate publication and add for each
table the where clause or what is the best way to continue or perhaps
start again?

Thanks

Eric

Breck Carter [TeamSybase]

2005-06-09, 7:24 am

The download_cursor scripts SELECT from the consolidated table with
whatever WHERE clause is required to select rows the currently
synchronizing remote database needs. The MobiLink user name is passed
as a string parameter to the script. If you use your "user id" value
as the MobiLink user name (CREATE SYNCHRONIZATION USER on the remote)
then life becomes simpler when writing the consolidated scripts.

With many installations the first synchronization is used to initially
populate the remote database. The last download datetime (also passed
to download_cursor scripts as a parameter) is initially set to a very
old value so download_cursor WHERE clauses can use it to select all
rows only on the first sync, and recently-changed rows on later syncs.
This is called "Timestamp-based synchronization" in the Help.

Breck

On 9 Jun 2005 01:59:05 -0700, Eric Verhorstert
<eric.verhorstert@farm.nl> wrote:

>I am trying to make a remote database out of a consolidated database.
>
>The scheme of the remote database should be parallel in structure to the
>scheme of the consolidated database. The database has about 300 tables.
>In all our tables is a identifier company_id and in some tables (about
>200) the identifier user_id.
>
>After the remote database is created synchronisation should work as
>follows:
>The tables with the identifier user_id are changed in the remote
>database and should be uploaded to the consolidated database. The tables
>with no user_id are changed in the consolidated database and should be
>downloaded to all remote databases.
>User_id is a number from 1 til 999. So we could have a maximum of up to
> 999 remote databases.
>
>Creating the remote database I made a publication with all tables and
>all columns included in the consolidated database (and yes, I have a
>copy). I did not use the where clause. Then I created a mobilink user.
>When I create the remote database for user 1 the data should be
>extracted from tables with the column user_id in it where user_id = 1
>and all the data from the tables without column used_id. For user 2 the
>same except of course that user_id = 2. etc.
>
>Should I make for each user a seperate publication and add for each
>table the where clause or what is the best way to continue or perhaps
>start again?
>
>Thanks
>
>Eric

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Eric Verhorstert

2005-06-09, 11:24 am

I forgot to tell that all databases are ASA 9.0.????

Ok, so I read in the newsgroups that the publication is NOT used in the
consolidated database but only in the remote database. So, now I still
do not understand how to create the remote database out of the
consolidated database.

Is the only thing I have to do write the download_cursor script for each
table (about 300) and can I then run a program that creates the remote
database out of the consolidated database?

If I write all the download_cursor scripts, can I easily export and
import them to another database (als ASA same structure but other client).

Thanks to all the people spending the time on helping me.

Thanks,
Eric

Breck Carter [TeamSybase] wrote:
> The download_cursor scripts SELECT from the consolidated table with
> whatever WHERE clause is required to select rows the currently
> synchronizing remote database needs. The MobiLink user name is passed
> as a string parameter to the script. If you use your "user id" value
> as the MobiLink user name (CREATE SYNCHRONIZATION USER on the remote)
> then life becomes simpler when writing the consolidated scripts.
>
> With many installations the first synchronization is used to initially
> populate the remote database. The last download datetime (also passed
> to download_cursor scripts as a parameter) is initially set to a very
> old value so download_cursor WHERE clauses can use it to select all
> rows only on the first sync, and recently-changed rows on later syncs.
> This is called "Timestamp-based synchronization" in the Help.
>
> Breck
>
>
> On 9 Jun 2005 01:59:05 -0700, Eric Verhorstert
> <eric.verhorstert@farm.nl> wrote:
>
>
>
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com

Reg Domaratzki $iAnywhere Solutions$

2005-06-09, 11:24 am

There's a program called mlxtract you can use on an ASA consolidated
database, but to use it you need to define publications and synchronization
users on the consolidated. Personally, I never use it.

I've attached a simple batch file I use to automate testing of MobiLink. It
uses a template SQL file to create the remote databases. To use the
scripts, unzip the contents of the zip file into an EMPTY directory (I'm not
kidding, make sure it's empty), open a DOS prompt, CD into the directory
where the files exist, make sure ASA9 is in your path, and type "mlrep".
The batch file will create the consolidated database (including schema and
synchronization scripts), start the MobiLink server, creates the remote
databases, then perform the first synchronization for each of the remote
databases. It will over write a DSN called "cons_90" just in case you
already have a DSN with that name on your system. The batch file is
repeatable. If you run it a 2nd time, it will clean up all files from the
previous run and start from scratch again.

To learn how it's done, first look at the mlrep.bat file to see the steps
taken, and then look at cons.sql and rem.sql to figure out how the
consolidated and remote databases are created. Note that the entire admin
table synchronizes, but only a subset of the data in the Parent and Child
tables are synchronized from the consolidated based on the user_id column.
This is done with the download_cursor, not with publication definitions.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Eric Verhorstert" <eric.verhorstert@farm.nl> wrote in message
news:42a804d9$1@foru
ms-1-dub...
> I am trying to make a remote database out of a consolidated database.
>
> The scheme of the remote database should be parallel in structure to the
> scheme of the consolidated database. The database has about 300 tables.
> In all our tables is a identifier company_id and in some tables (about
> 200) the identifier user_id.
>
> After the remote database is created synchronisation should work as
> follows:
> The tables with the identifier user_id are changed in the remote
> database and should be uploaded to the consolidated database. The tables
> with no user_id are changed in the consolidated database and should be
> downloaded to all remote databases.
> User_id is a number from 1 til 999. So we could have a maximum of up to
> 999 remote databases.
>
> Creating the remote database I made a publication with all tables and
> all columns included in the consolidated database (and yes, I have a
> copy). I did not use the where clause. Then I created a mobilink user.
> When I create the remote database for user 1 the data should be
> extracted from tables with the column user_id in it where user_id = 1
> and all the data from the tables without column used_id. For user 2 the
> same except of course that user_id = 2. etc.
>
> Should I make for each user a seperate publication and add for each
> table the where clause or what is the best way to continue or perhaps
> start again?
>
> Thanks
>
> Eric

begin 666 ml9basic.zip
M4$L#! H``@```,%9R"A?-O>4- ```#0````+````8V]N;F
5C="YB871S=&%R
M="!D8FES<6QC("UC(")E;F<]8V]N<SMD8FX])3$[=6ED/61B83MP=V0]<W%L
M(@T*4$L#!!0````(`/-:R3($0%]:( 8``/H5```(````8V]N<RYS<6S%6%ES
MVS80?I9G_!_V362JI%*<=MI17$>5&%M3A4ID*6V?.#0)27!(@@6I*&[3_]Y=
M@ =T^%+2UA,[)+#8\\,>3'WIQRQG$I)5[$D6BYQEW>.CXZ.,Y2#2G(L$TM55
MQ(-GYY&X\B,O]'/ _RL^8QT,XA79W'VG((F3
JB2CT(K'(D*XY=IN*;R"9GS-
M'AACS!*SCHX9/3\2RT>!)SA:H4<CF_BK*8:'D@K_*!4_P>,R2'%+)8U_>
MP =VT\+CI%2CT?CHRV#I2^ND;=-JY&>Y%XN0SSD+H?[)><RRW(_32D:U<GQD
MFVH6LG,6IT*2/$-OKR^2. 5J;;QI0J%]J!5LZ2;'V\
IN45>L=&X(E"SZ !:\"
M$0$YI#ENMJ#ITI]^TP9
UT+ 8K%):"TI^]I;F6M&WOB1OH8*E[:E:P:.5HQN/
M<?0J8U(=KGS=>?Z#_6^&0!O27_(H5(X.Z.E@_7?-!\GF#!<#EA7NVF,-G+3A
M2^WI3YS>U(&WDW'?&<PF#LQ&%WX21LR14L@B1./95/'S`W6?JI\:5?0V=/4J
MHY->($)V/ Q5JD_D+(JPBUVZK()FT*
KX)YH1"[E:435(5&(/6) 6$X\_.^=#5
M1YX^A:>='& #91;'GL'ENY'C#=V!\Y
OGCJ?>S!V^FSDFU0N#ZGUO-!QXK\<39WCN
M>K\XOVM"/C<M/]6\A=Q9? 'YDB4U]E$`7R1",EK7U( 10&RP%!8(FD5->^E,
MRR"<`GFJJ_=8E+$-COZ5D+EBF-TDP5**A/_IT[E;> )T8O% VG^.+XPXTY/TH
M@CCR_##TM'NS0/(TMZ#YL4/90"4>>EBED?#Q&B08K[Q)R&SJ9\* *!+K1S]:
M(:JML]99:^"\[LU&4[M97:_'REJE>"F8EJ6?"S&4_U6J.X4S6"_Q,D&5#7'I
M<(ESE@=++3##BH*9MLY[2N!<BKA0XFO*I;I%>=7TKF*B",NTWPO#B5BC>^&L
MA88;GM6)*Y4B8.%*LKW'+$KT)&BG< )0;V]6#[M056W %K)U@U]6HC/H&]U;%
M$LT<-'NWL-EK\-5/;K3ZZ9,%($(Q[^-`V*0L/5.#!YB-,4"N6#Q;,(A8$>-
M/:W";7&W'AIIL,R(A2R(L+S FYO^2D*PDAEFGSG^%IX.>99CV:I=;OBYLK-K
M<@H,U&QM;&-G<WLI>(#I*D;3\+A&`J;43Z@!NK#0I[-/OFUD5)&R1%M3I#-U
M76'.99875JI(!1H*1+'&VLTP2-D?49&EL:Q")$1:)DO*)85^IQ!@L;5 8HJV
M;'AR`GY6FFMWRP.HN%6?(':;.?_;;Z&XSMH>W>/"&K%4$]V6SDI?;"6;&G8[
M^%<QH9I2]7G4^V(/MY>RLH*JRJ8EG7V6%)?B_[/$?9 E&SHK6&%I)3Z %3 0
M228B3FJ&_ZWR_?N5+PNR?M6 3MBG73S3=EW$"<'%J2 2&3.N1<52I$#,J$>
MIG0VTL]?O>Z%8ITH63HMW5%R<8,<4\E7[UJ'S=;XI\<HHOON!_0UQ3QC-C:'
MM#8[\O;T-H4H@F$Q])!S6]N=3C50/,[U.QK<%N5"C8.$$2\21_^7`A7_.$=
MB6B59N\$7K.Z*_*:6%U PW</]XZ:]AX`!ST5?BD:MJ7M`8,61%C8",$.&LKA
M],O,O0T+6HM#))E(**3
=!P1%]JP4TRK>#7CHA2UL:!7I&\4USE.[4-&'[@*,
M/O)L'VXV#<1"DC U56W[<ZG&:D\->(7-O=%H:]XN.L7B'_:*<.N@+EFJ.BH+
M1U].'\N&[M0Y=R908 TZ+9J*0X$ZQ3'/=_:Q>3? FX8'3'_60+2_INN;J]=Y
5
M+"<S] B\[TWZ%[V)&K(5`?W2?,FI9U KOUX,1\3\Y2G\97S5^QM
&X_%;7:3H
M0,D1"R-2-.'S9^#=>OL:],<]>M<<K^&EMK[F0Q\#+IW)E%0>ZX)@D:-LU',T
M<R[!ZO<NI]:DYPXL^\GS-GR#?4WO$K0);=NN^SB3D8: M9%_:I:5Y@C!N[G#
M?O8*@Y:!Y"W^KU[Q$+=X?O,8":73KHFHEOO:@ 5U==,+QZT[GO[XS9OAM*)V
MW &>*%[IA5QM!(6"S"O^&P05IXUO" 15RX;NVTE5K@@__`%!+`
P04``(`" "M
M2GPO6>N=1A8"```?!@``"0```&UL<F5P+F)A=)5438O;,!"]&_P?AD"@W8V<
MW:440C" 44GKJI=#C0I$L)1%K2:X
DYP/ZXSN2G%W'-DWV(ENCF?=&,V_T150[
M`V:SR;,\LT)!6G\9J'9
4;P7XG0#=*B8L>@&>&2^@=<*ZQ< %]M1*RFHTF&A+
M4%PX:04'JDRK?1&->>:$#S'E4^#E3-7.FP;(`4\\M1Z6!RH]< );,)R 5S(3>
MEI71;LV93C^MY"5G=-T<>.G^U+,`)2QU(H0$C^>P%)SEV<986/Z ^5R"U/#A
M<?&XF&,"\X_ #?2B,#OT>4Z?&)EGZ7#Y$Y;?(^H5M+Y& #91;PHG%55S:6\*3XUL@

M]=Y*!L3"77'WNKVWH&HKFH)1WS?&"V,M^C;$&IK038O*#Z/=25>[9(S"./WE
MHK[@)5.\9(*7C'G)-"^YX T]Y$['IA_:B/M[]7"S`/),O=Q8Z.3X5FBY`6T\
MB*-T'KQ0S;>OG4_:3'J<%88:DAHE2QKX]+#Z/#PE.C!4ICD-3]XATZGPL5XY
MJ\T6B$\M"?_OFH0NN ,,NZF1N)Q2B;6O8HL&#<%.;<H^_9JVWH2A+K591Q!T
M=W:_`K+%- Z*N@1RQQEK,D);R5UE!3
#$P7TG__ZD,K])/IV/L1 M1%%?(5!U>
MPLB&DBT[K<Z M%W1@ASB!)PK%I^Z>-W]/1#44MP6_NA'*'G64(2_>N?+5B >
MSM)X7%(^HX$!HF*&73& #91;GML=\7O+L'U!+`P0
4``(`" "S2GPOT1F!0QX#``!I
M" ``!P```')E;2YS<6RE55V/FD 4?=;$_W##B& #91;!KC+8O3:S)(K);4P
4"V,2^
M$(1129&QS+#;3=/_WCM\B%C7-E9#PLS<>^ZY'W.P5%M=Z*YN.Y QDGI)MA]U
MVITV(QSH@4<T@4.VCJ.@_Q33M1][H<_]M< ^(%X4PAI^5TZ_1)9^0Q(
03C\:A
M%],M0X>N:73S`)JMJZX.KCJ9ZR!- )ZK4E]1P'R52IRUWVBW)
%PN,(D'^:[6B
MA),M2<$P73"6\SE,]4=U.7=AFS,#/^,T2H*4[$G"H2<P!%E)^+:>_338^:G\
M?J 4SCU `[#LV4*U5_!97X%<AU2$=Z>M=-I;>IFJY:<8I> )ZR%='LC=QS2MY
M3!=JRL-W'RK.-^144_M[4MHNBL,JIT L_K/^;]?EUG2.K)K9!'2_CSB\T/1;
ML2'^ZASG^G*&+74ZA4?3UF=/1HY<-;19,4' UA]U6S<TW3GK?=/T"@\LB<\)
M'%(:D#!+"2!,/R6'_"& #91;)40(1QY)4I0G)QL]
B#L,>GH34*R'/CP<8<4VV4=)I
M`VX&,5*!F-*#AW6LK$>GAUJ6+G'&X'2N+ADP"%\3?Q\%P(*4QC$$6<IH"AM\
M&%[H@$,8,8ZMYL"0NH?&!#8IW8.S<OKX." M#RY'I@21'V'QG0WBP@T
V4,E['
M0[:T6N56+]@F(K/O<4!#@JJ!$R%2$T<`0F:J1,>#4;&9>]3Y?RQJ6CL!!D%T
M7L3*A486Y5>P''%&F!SXC,NV:DSE.^7NW>!^"#Z#HDX#15%&EV"*09#+F]MK
MX)7I]&[!S:=4/@Y7$_CA(0IQ/^*O_XS=J%CU<C^L8V].!FT,0^ [DE2'`(VA
M+K9($J)7L1+O`K2$*SJ
<D!]O-%A8-5R"F#+2G!+-7"QF+KZBX96+56J8M9S,
M9YKJSDRCNJ*<,([?H%+++GQD9*C5O@>E"N6:<DGFT;J^ZFA>:?45ST)IT/&H
M6+TSD-+S7)'%Y? EDF\;L:Y'1TD$1DU!5ZV
^M=-7!64X<S9Y9^<(U_RQ)U5?4
MOW- @J$_=E:5#U]6LF=4]V4;
AM'7'@>Z.,H[#%/BQ>#LU,8O0SI=Q]WDH#D0#
M?P-02P,$% `"``@`)4M\+UA#,W1/````4 ````D```!S>6YC:"YB870-QCL*
M@# 0!<!>\ Z/0"I9(77(84Q61,Q/L_YNKU--D^D0L$^QO3F `M2<%Q=*;I9]
M=MK8<V7'?K+U9M?VJ !*%?] UP`JT&:41T ;^NX#4$L!`A0`"@`"````P5G(
M*%\V]Y0T````- ````L``````````0`@`/^!`````&-O;FYE8W0N8F%T4$L!
M`A0`% ````@`\UK),@1 7UH@!@``^A4```@`````
`````0`@`+:!70```&-O
M;G,N<W%L4$L!`A0`% `" ``@`K4I\+UGKG486`@``
'P8```D``````````0`@

M`/^!HP8``&UL< F5P+F)A=%!+`0(4`!0``
@`(`+-*?"_1&8%#'@,``&D(```'
M``````````$`( "V@> (``!R96TN<W%L4$L!`A0`% `"``@`)4M\+UA#,W1/
M````4 ````D``````````0`@`/^!(PP``'-Y;F- H+F)A=%!+!08`````!0`
%
+`!(!``"9# ``````
`
end

Breck Carter [TeamSybase]

2005-06-09, 8:24 pm

FWIW mlxtract is deprecated.

On 9 Jun 2005 08:26:50 -0700, "Reg Domaratzki $iAnywhere Solutions$"
<FirstName.LastName@ianywhere.com> wrote:

>There's a program called mlxtract you can use on an ASA consolidated
>database, but to use it you need to define publications and synchronization
>users on the consolidated. Personally, I never use it.
>
>I've attached a simple batch file I use to automate testing of MobiLink. It
>uses a template SQL file to create the remote databases. To use the
>scripts, unzip the contents of the zip file into an EMPTY directory (I'm not
>kidding, make sure it's empty), open a DOS prompt, CD into the directory
>where the files exist, make sure ASA9 is in your path, and type "mlrep".
>The batch file will create the consolidated database (including schema and
>synchronization scripts), start the MobiLink server, creates the remote
>databases, then perform the first synchronization for each of the remote
>databases. It will over write a DSN called "cons_90" just in case you
>already have a DSN with that name on your system. The batch file is
>repeatable. If you run it a 2nd time, it will clean up all files from the
>previous run and start from scratch again.
>
>To learn how it's done, first look at the mlrep.bat file to see the steps
>taken, and then look at cons.sql and rem.sql to figure out how the
>consolidated and remote databases are created. Note that the entire admin
>table synchronizes, but only a subset of the data in the Parent and Child
>tables are synchronized from the consolidated based on the user_id column.
>This is done with the download_cursor, not with publication definitions.

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Eric Verhorstert

2005-06-10, 3:24 am

What is deprecated??

Looking in the dictionary is says: Gods judgement

Is that what you mean????

Breck Carter [TeamSybase] wrote:
> FWIW mlxtract is deprecated.
>
> On 9 Jun 2005 08:26:50 -0700, "Reg Domaratzki $iAnywhere Solutions$"
> <FirstName.LastName@ianywhere.com> wrote:
>
>
>
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com

Eric Verhorstert

2005-06-10, 3:24 am

Running this batch file i receive the message:

Error in file "rem.sgl" at table 81
Column 'publication_id' in table SYSSYNC' cannot be null

What should I change?

Reg Domaratzki (iAnywhere Solutions) wrote:
> There's a program called mlxtract you can use on an ASA consolidated
> database, but to use it you need to define publications and synchronization
> users on the consolidated. Personally, I never use it.
>
> I've attached a simple batch file I use to automate testing of MobiLink. It
> uses a template SQL file to create the remote databases. To use the
> scripts, unzip the contents of the zip file into an EMPTY directory (I'm not
> kidding, make sure it's empty), open a DOS prompt, CD into the directory
> where the files exist, make sure ASA9 is in your path, and type "mlrep".
> The batch file will create the consolidated database (including schema and
> synchronization scripts), start the MobiLink server, creates the remote
> databases, then perform the first synchronization for each of the remote
> databases. It will over write a DSN called "cons_90" just in case you
> already have a DSN with that name on your system. The batch file is
> repeatable. If you run it a 2nd time, it will clean up all files from the
> previous run and start from scratch again.
>
> To learn how it's done, first look at the mlrep.bat file to see the steps
> taken, and then look at cons.sql and rem.sql to figure out how the
> consolidated and remote databases are created. Note that the entire admin
> table synchronizes, but only a subset of the data in the Parent and Child
> tables are synchronized from the consolidated based on the user_id column.
> This is done with the download_cursor, not with publication definitions.
>

Breck Carter [TeamSybase]

2005-06-10, 7:24 am

I'm sorry... "deprecated" is a pompous (and inadequate) word
developers sometimes use instead of admitting the truth: "we strongly
suggest you use some other technique because, for some unspoken and
possibly frivolous reason, this feature *may* be removed in the
future... we're not saying when, and it is up to you to figure out
what the "other technique" might be because we're not telling." <g>

You can also get a tshirt with a slightly different definition of
"deprecated" <g>...
http://www.80stees.com/products/Mon...-shirt_fart.asp

Breck

On 9 Jun 2005 23:21:50 -0700, Eric Verhorstert
<eric.verhorstert@farm.nl> wrote:
[color=darkred]
>What is deprecated??
>
>Looking in the dictionary is says: Gods judgement
>
>Is that what you mean????
>
>Breck Carter [TeamSybase] wrote:

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Reg Domaratzki $iAnywhere Solutions$

2005-06-10, 7:24 am

What os are you running this on?
Are you using some special shell, or just "command/cmd" ?

I don't get any errors when I run this using the XP or Win2K command shell.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Eric Verhorstert" <eric.verhorstert@farm.nl> wrote in message
news:42a94321@forums
-2-dub...[color=darkred]
> Running this batch file i receive the message:
>
> Error in file "rem.sgl" at table 81
> Column 'publication_id' in table SYSSYNC' cannot be null
>
> What should I change?
>
> Reg Domaratzki (iAnywhere Solutions) wrote:
synchronization[colo
r=darkred]
It[color=darkred]
not[color=darkred]
and[color=darkred]
the[color=darkred]
steps[color=darkred]

admin[color=darkred]

Child[color=darkred]

column.[color=darkred]

Eric Verhorstert

2005-06-13, 7:24 am

Windows XP Professional 2002 Service Pack 2

Dell Pentium IV 2,8 GHz 512 Mb

ASA 9.0.2.3131

I go to the dos prompt (%SystemRoot%\system
32\cmd.exe).

Here is the output:

MobiLink Stop Server Utility Version 9.0.2.3131
Unable to find MobiLink Server with name "<default>"
Adaptive Server Anywhere Erase Utility Version 9.0.2.3131
Erasing database file "cons\cons.db"
Erasing transaction log file "cons\cons.log"
Adaptive Server Anywhere Erase Utility Version 9.0.2.3131
Erasing database file "rem1\rem1.db"
Erasing transaction log file "rem1\rem1.log"
Adaptive Server Anywhere Erase Utility Version 9.0.2.3131
Erasing database file "rem2\rem2.db"
Erasing transaction log file "rem2\rem2.log"
C:\testmob\*.*. Weet u het zeker (J/N)? y
C:\testmob\*.*. Weet u het zeker (J/N)?
Adaptive Server Anywhere Data Source Utility Version 9.0.2.3131
User Data Source "cons_90" written to registry.
1 bestand(en) gekopieerd.
1 bestand(en) gekopieerd.
1 bestand(en) gekopieerd.
Adaptive Server Anywhere Transaction Log Utility Version 9.0.2.3131
"cons\cons.db" was using no log file
"cons\cons.db" is using no log mirror file
"cons\cons.db" is now using log file "cons.log"
Transaction log starting offset is 0000000000
Transaction log current relative offset is 0000000000
Adaptive Server Anywhere Transaction Log Utility Version 9.0.2.3131
"rem1\rem1.db" was using no log file
"rem1\rem1.db" is using no log mirror file
"rem1\rem1.db" is now using log file "rem1.log"
Transaction log starting offset is 0000000000
Transaction log current relative offset is 0000000000
Adaptive Server Anywhere Transaction Log Utility Version 9.0.2.3131
"rem2\rem2.db" was using no log file
"rem2\rem2.db" is using no log mirror file
"rem2\rem2.db" is now using log file "rem2.log"
Transaction log starting offset is 0000000000
Transaction log current relative offset is 0000000000
MobiLink User Utility Version 9.0.2.3131
ODBC: [Sybase][ODBC Driver][Adaptive Server Anywhere]Column
'last_upload_time' not found (ODBC State = 42S22, Native error code = -143)
The MobiLink system table 'ml_user' is missing column 'last_upload_time'
MobiLink User Utility Version 9.0.2.3131
ODBC: [Sybase][ODBC Driver][Adaptive Server Anywhere]Column
'last_upload_time' not found (ODBC State = 42S22, Native error code = -143)
The MobiLink system table 'ml_user' is missing column 'last_upload_time'

Reg Domaratzki (iAnywhere Solutions) wrote:
> What os are you running this on?
> Are you using some special shell, or just "command/cmd" ?
>
> I don't get any errors when I run this using the XP or Win2K command shell.
>

Sponsored Links