Asked by:
Sync : Timeout expired or the server is not responding

Question
-
Hello Guys,
I want to implement offline application services for iPhone apps using sync framework. I already install visual studio 2010 , SQL server 2008 R2 and sync framework 2.1 and also followed the sync framework toolkit documentation (which included with downloaded sync framework 2.1 ). Now I am trying to configure and provisioning the database (size 6GB) through command prompt as per sync framework toolkit documentation process but getting exception error like below :
Can someone tell, what reason for getting this error and how can solve the error?
Thanks,
Pradipta Nilav Saha
Pradipta Nilav Saha
Friday, October 5, 2012 4:59 AM
All replies
-
are you sure you have configured the correct connection string and credentials to connect to your database?Monday, October 15, 2012 2:59 AM
-
Yea. I have configured correct connection string and credential.
Pradipta Nilav Saha
Wednesday, October 17, 2012 6:27 AM -
modify the utility and set the CommandTimeout property
file:SyncSvcUtil.cs
set the timeout before the line prov.Apply();
- Edited by JuneT Wednesday, October 17, 2012 7:13 AM
- Proposed as answer by Simon MᶜKenzie Monday, May 4, 2020 4:26 AM
Wednesday, October 17, 2012 7:12 AM -
JuneT,
As per your instruction, I have set commandTimeout property like below but still getting the Timeout issue
prov.CommandTimeout = 3600;
prov.Apply();
Pradipta Nilav Saha
Wednesday, October 17, 2012 1:30 PM -
Set it higher then. During provisioning, sync fx will populate the tracking tables. If you have 10 million rows in a table it will insert 10 million rows in the tracking table as well.Wednesday, October 17, 2012 1:46 PM