Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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.

asked 15 Nov '11, 00:32

Kavita%20Nemad's gravatar image

Kavita Nemad
36337
accept rate: 0%

retagged 15 Nov '11, 09:27

RussC_FromSAP's gravatar image

RussC_FromSAP
1.3k11030

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?

(15 Nov '11, 10:52) Tim McClements

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?
permanent link

answered 15 Nov '11, 09:26

RussC_FromSAP's gravatar image

RussC_FromSAP
1.3k11030
accept rate: 18%

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?

permanent link

answered 15 Nov '11, 09:32

PhilippeBertrand%20_SAP_'s gravatar image

PhilippeBert...
1.8k42139
accept rate: 22%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×371
×162
×63
×19

question asked: 15 Nov '11, 00:32

question was seen: 2,660 times

last updated: 15 Nov '11, 10:52