SQL Anywhere Mobile - Re: 2nd part of the file attached Problem in transactionsl Log File Deletion

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: 2nd part of the file attached Problem in transactionsl Log File Deletion

Bob

2005-10-27, 8:21 am

> Hi,
> Thanks for the Response.
> Here is the result of that -v+ option in our sync.
> process. Now in our client place we got the error like
> cannot update the Primary Key column in the Table included
> in the subscription.
> Suddenly it is coming there. what might be the problem.
> Error is :
> SQL statement failed: (-780) Cannot update primary key for
> table
> 'EFB_EfbWpi_waypoint
_info' involved in a publication
> For this i ask them to set the option
> SET OPTION PUBLIC. PREVENT_ARTICLE_PKEY
_UPDATE='OFF';
> apart from this any other option is there to set.
> I have attached one part of the file with this post next
> part i will post in the next post. Pls look in to it and
> tell me the suggestion and solution for both the problem.
> Regards,
> Bob
>
>
> [Attachment: EFBSync01.zip]

Sponsored Links