• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 840
  • Last Modified:

WCF Synchronization Services TargetInvocationException on updating

Hello experts!
I'm building a simple WCF synchronization service using the the Local Database Cache Wizard.
The client is a Windows Mobile 6 windows forms application.
I need to sync only 10 small tables.
I configured the service to use basicHttpBinding and decorated the contract  with the XmlSerializerFormat attribute.
I published the service to the server and created the proxy in the client. Then I tried to sync before making any changes to the DB. Both application and server behaved correctly and informed that no updates were downloaded/uploaded. Then I changed a record in a single table on the client and tried to sync again. It should send 1 record to the server, but then I got the TargetInvocationException. After checking the error, I saw that it was saying that the Update Command could not be executed. Nothing more than this...
I have no clues on how to solve this problem. The configurations seams to be correct and the proxy was created.
Anyone help please...
0
andrepires
Asked:
andrepires
  • 3
1 Solution
 
KBergerCommented:
Hi,

could this be a problem with privileges?
Is your service running in the context of a specific account? Does this account have the privileges needed to update records (DataWriter Role in the DB)?

Regards,
-Kristof
0
 
andrepiresAuthor Commented:
KBerger,
Sorry for this long delay. It was not related to privileges, but an difference in the DB schema.
I ended up by hiring someone to fix the problem.
Thanks for helping!
0
 
andrepiresAuthor Commented:
I'm choosing my own answer because I didn't find any other way to close this subject...
0
 
andrepiresAuthor Commented:
If there is any other way to close the subject when there is no good answers from the experts, please let me know...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now