locked
Sync : Failed to Execute Provider Command 'SelectNewTimestampCommand' RRS feed

  • Question

  • Hello Guys,

     I want to implement offline application services for iPhone apps using sync framework. I already install visual studio 2010 , SQL server 2005 and sync framework 2.1 and also followed the sync framework toolkit documentation (which included with downloaded sync framework 2.1 ). Now I have configured database and services as per sync framework toolkit documentation process and try to execute the application but getting exception error like below :

    {"ErrorDescription":"Microsoft.Synchronization.Data.DbSyncException\u000d\u000aFailed to Execute Provider Command 'SelectNewTimestampCommand'. The transaction was rolled back. Ensure that the command syntax is correct and check the inner exception for any store-specific errors.\u000d\u000a  at Microsoft.Synchronization.Data.SqlServer.SqlSyncScopeHandler.GetLocalTimestamp(IDbConnection connection, IDbTransaction transaction)\u000d\u000a  at Microsoft.Synchronization.Data.SqlServer.SqlSyncScopeHandler.ReadScope(IDbConnection connection, IDbTransaction transaction, ReadKnowledgeType readType, ReadForgottenKnowledgeType readFKtype)\u000d\u000a  at Microsoft.Synchronization.Data.SyncScopeHandlerBase.ReadScope(IDbTransaction transaction, ReadKnowledgeType readType, ReadForgottenKnowledgeType readFKtype)\u000d\u000a  at Microsoft.Synchronization.Data.RelationalSyncProvider.GetChanges(DbSyncScopeMetadata scopeMetadata, DbSyncSession DbSyncSession, UInt32 memoryBatchSize)\u000d\u000a  at Microsoft.Synchronization.Data.RelationalSyncProvider.GetChangeBatch(UInt32 batchSize, SyncKnowledge destinationKnowledge, Object& changeDataRetriever)\u000d\u000a  at Microsoft.Synchronization.Services.SqlProvider.SqlSyncProviderService.GetChanges(Byte[] clientKnowledgeBlob)\u000d\u000a  at Microsoft.Synchronization.Services.DownloadChangesRequestProcessor.ProcessRequest(Request incomingRequest)\u000d\u000a  at Microsoft.Synchronization.Services.SyncService`1.ProcessRequestForMessage(Stream messageBody)\u000d\u000a\u000d\u000aSystem.Data.SqlClient.SqlException\u000d\u000a'min_active_rowversion' is not a recognized built-in function name.\u000d\u000a  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)\u000d\u000a  at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)\u000d\u000a  at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)\u000d\u000a  at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)\u000d\u000a  at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)\u000d\u000a  at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)\u000d\u000a  at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)\u000d\u000a  at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)\u000d\u000a  at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()\u000d\u000a  at Microsoft.Synchronization.Data.SqlServer.SqlSyncScopeHandler.GetLocalTimestamp(IDbConnection connection, IDbTransaction transaction)\u000d\u000a\u000d\u000a\u000d\u000a"}

     Can someone tell, what reason for getting this error and how can solve the error?

    Thanks,

    Pradipta Nilav Saha


    Pradipta Nilav Saha

    Sunday, September 16, 2012 5:20 AM

Answers

  • is your SQL Server 2005 running at least on SP2 ?
    • Marked as answer by Pradipta Nilav Tuesday, September 18, 2012 4:48 AM
    Monday, September 17, 2012 2:33 AM