Publications in ultralite

[Former Member]

Hi All

We are using ultralite as a remote database (version 11.0.1.2376) and Sql Server 2008 as consolidated database . Our mobilink server version is 12.0.1.3484.

We have two publications in the remote database (udb). One publication contain tables thoese are download only direction and other publication contain tables thoese are both upload and download. These publication works fine with sybase 11.

When we switched to sybase 12 download work fine but upload doesn't work and Syncronization Succeeded . If we create the publications one is download only and other is upload only then upload is working.

Is it possible to use upload-download table in a single publication ? Or pleaese suggest what is the best way to use publication in ultralite.

[former_SQLA_member1694876]

An even more basic question perhaps: when you say you create a publication as download only, what do you mean? An UL publication is not inherently up or down itself... (What publications do is group tables and optionally filter upload rows for synchronization.) So do you mean that when you synchronize that publication you always specify the 'download_only' parameter? Or are there never any rows inserted directly to the UL table so there's nothing to upload? Or are you referring to how your ML scripts are configured?

Also, can you say what platform and language you are using?

[philippefbertrand]

Tables should work fine as upload and download in a single synchronization. This is the normal behaviour.

Are there any errors in the MobiLink log (use -vx -v+ on the ML command line)?

How do you determine that the upload failed?

[Former Member]

Some basic questions:

• Have you run mlsrv12 with -v+ to see the details of what happens in the consolidated database? Do you see any rows coming up?
• If not, do you have committed upload rows in the upload/download tables in the UltraLite database before synchronizing?
• Are you using the proper publication during upload synchronization?
• Does the upload work if you specify NO publication?