Thursday, March 22, 2012

Compact 3.5 SP1 "LoadProperties()" Thows Exception

Hi all,
I have SQL Server 2008 (Nov. CTP) as a publisher and a SQL Server Compact
3.5 SP1 as a client for merge replication.
The Compact database has two subscriptions. The synchronization worked
perfectly many times. If I look at the Compact database in Management Studio
I can see my subscriptions in the Replication folder.
Everything looked so promising.....until I added a call to
"SqlCeReplication.LoadProperties()". At this point I see an error that simply
says, "Unhandled Exception: The subscription could not be loaded because it
was not saved.".
In doing some research it turns out this is error:
SSCE_M_SUBSCRIPTIOWASNOTSAVED
described here: http://technet.microsoft.com/en-us/library/ms172898.aspx
The web page indicates:
"If the error appears again, you should immediately contact Microsoft
Product Support Services. The internal errors cannot be resolved by common
troubleshooting techniques."
Which is why I am posting here. Hopefully someone from Microsoft can
respond. The relevant code is listed here:
SqlCeReplication repl = new SqlCeReplication();
repl.Publisher = @."AOS-LAPASO-4\AOS_1";
repl.PublisherDatabase = @."RepTest";
repl.SubscriberConnectionString = @."Data Source=""C:\test.sdf"";Max Database
Size=128;Default Lock Escalation =100;";
repl.Publication = @."TestPub";
Console.WriteLine("LoadProperties: " + repl.LoadProperties());
Thanks very much.
Tom Baxter
Hi Tom,
Appreciate your understanding that our MSDN newsgroups are not very good at
handling such issue since this issue is an internal error and dump analysis
would be required in this case. We recommended that you contact Microsoft
Product Support Services (PSS) via telephone so that a dedicated Support
professional can assist you in a more efficient manner. Please be advised
that contacting phone support will be a charged call.
To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
If you have any other questions or concerns, please feel free to let us
know. Have a good day!
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
sql

No comments:

Post a Comment