Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Failed to Execute Provider Command RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I am using VS2008 , SQL Server 2008 and SyncFramework 2.0.

    When I tried to Execute sample project ( WebSharingAppDemo-CEProviderEndToEnd )

    SyncOperationStatistics stats = orchestrator.Synchronize(); on this line I am gettting below error

    Failed to Execute Provider Command: 'SelectNewTimestampCommand'; the transaction was rolled back. Ensure that the command syntax is correct..

    Have anyone know solution for this?

    Saturday, May 15, 2010 9:09 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Besides enabling sync tracing, you may also monitor with SQL profiler if the command is failed on SQL Server side and re-run the SelectNewTimestampCommand manually to repro the error.

    Thanks,
    Dong

    This posting is provided AS IS with no warranties, and confers no rights.
    Monday, May 17, 2010 7:58 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    can you try enabling sync tracing so you get all the exception details?
    Monday, May 17, 2010 10:32 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Besides enabling sync tracing, you may also monitor with SQL profiler if the command is failed on SQL Server side and re-run the SelectNewTimestampCommand manually to repro the error.

    Thanks,
    Dong

    This posting is provided AS IS with no warranties, and confers no rights.
    Monday, May 17, 2010 7:58 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi friend,

     

    Can you give the step for to SelectNewTimestampCommand manually .

     

    Thanks & Regrads,

     

    Arun 

     

    Saturday, May 22, 2010 1:34 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Dear JuneT,

    Thanks for Replie, can say how to enable sync tracing..

     

    Thanks & Regards

     

    Arun

     

    Saturday, May 22, 2010 1:35 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    you can check out the steps for enabling tracing here: http://msdn.microsoft.com/en-us/library/cc807160.aspx

    as for SelectNewTimestampCommand, i believe what Dong was referring to was for you to capture the failing SelectNewTimestampCommand  query using SQL Profiler, copying and pasting it on another query window, executing and checking if you get the same error.

    Sunday, May 23, 2010 11:42 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Dear JuneT,

    Thanks for Reply. now also i unable to run the sample program (WebSharingAppDemo-CEProviderEndToEnd).

    I am unable to resolve the problem.

    Do you have any other demo program for Database Synchronization between SQLCE and SQLServer.

     

    Thanks

     

    Arun

     

    Tuesday, May 25, 2010 9:03 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I have same problem

    and this is my sync trace

    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:00:702, Connecting using string: Data Source=MILADLP\SQLSERVER2005;Initial Catalog=peer1;Integrated Security=True;Connect Timeout=1
    INFO   , SyncApplication, 1, 08/24/2010 03:39:00:800, Version of connection detected to be Sql2005
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:00:825, Connecting using string: Data Source=MILADLP\SQLSERVER2005;Initial Catalog=peer1;Integrated Security=True;Connect Timeout=1
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:00:836, Reading Schema Version Info
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:00:837,    Executing Command: SELECT [schema_major_version], [schema_minor_version], [schema_extended_info] FROM [schema_info]
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:00:843, Connecting using string: Data Source=MILADLP\SQLSERVER2005;Initial Catalog=peer1;Integrated Security=True;Connect Timeout=1
    INFO   , SyncApplication, 1, 08/24/2010 03:39:37:848,    BatchingDirectory has been set to: D:\Milad\Amoozeshi\Sync Framework\SQL Server with 2 Compact\bin\Debug\Sync_BatchFiles
    INFO   , SyncApplication, 1, 08/24/2010 03:39:37:849,    BatchingDirectory has been set to: D:\Milad\Amoozeshi\Sync Framework\SQL Server with 2 Compact\bin\Debug\Sync_BatchFiles
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:37:889, Connecting to database: D:\Milad\Amoozeshi\Sync Framework\SQL Server with 2 Compact\bin\Debug\Client01.sdf
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:37:917, Connecting to database: D:\Milad\Amoozeshi\Sync Framework\SQL Server with 2 Compact\bin\Debug\Client01.sdf
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:37:937, Connecting using string: Data Source=MILADLP\SQLSERVER2005;Initial Catalog=peer1;Integrated Security=True;Connect Timeout=1
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:37:940, Reading Schema Version Info
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:37:940,    Executing Command: SELECT [schema_major_version], [schema_minor_version], [schema_extended_info] FROM [schema_info]
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:37:941, Connecting using string: Data Source=MILADLP\SQLSERVER2005;Initial Catalog=peer1;Integrated Security=True;Connect Timeout=1
    INFO   , SyncApplication, 1, 08/24/2010 03:39:38:494, ----- Populating Scope Provisioning from Scope Description for 'sales' -----
    INFO   , SyncApplication, 1, 08/24/2010 03:39:38:495, Adding Table Provisioning for '[orders]'
    INFO   , SyncApplication, 1, 08/24/2010 03:39:38:505, Adding Table Provisioning for '[order_details]'
    INFO   , SyncApplication, 1, 08/24/2010 03:39:38:507, --- END Populating Scope Provisioning from Scope Description for 'sales' ---
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:508, Connecting to database: D:\Milad\Amoozeshi\Sync Framework\SQL Server with 2 Compact\bin\Debug\Client01.sdf
    INFO   , SyncApplication, 1, 08/24/2010 03:39:38:532, ----- Provisioning Scope 'sales' on Database 'D:\Milad\Amoozeshi\Sync Framework\SQL Server with 2 Compact\bin\Debug\Client01.sdf' -----
    INFO   , SyncApplication, 1, 08/24/2010 03:39:38:537, Creating Schema Info Table '[schema_info]'
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:538,    Executing Command: CREATE TABLE [schema_info] ([schema_major_version] integer NOT NULL, [schema_minor_version] integer NOT NULL, [schema_extended_info] nvarchar(100) NOT NULL)
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:540,    Executing Command: ALTER TABLE [schema_info] ADD CONSTRAINT [PK_schema_info] PRIMARY KEY ([schema_major_version], [schema_minor_version])
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:542,    Executing Command: SELECT [schema_major_version], [schema_minor_version], [schema_extended_info] FROM [schema_info]
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:543,    Executing Command: INSERT INTO [schema_info] ([schema_major_version], [schema_minor_version], [schema_extended_info]) VALUES (@majorVersion, @minorVersion, @extendedInfo)
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:545,       Parameter: @majorVersion Value: 2
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:546,       Parameter: @minorVersion Value: 1
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:547,       Parameter: @extendedInfo Value:
    INFO   , SyncApplication, 1, 08/24/2010 03:39:38:551, Creating Scope Info Table '[scope_info]'
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:551,    Executing Command: CREATE TABLE [scope_info] ([scope_local_id] int IDENTITY(1,1) NOT NULL, [scope_id] uniqueidentifier DEFAULT NEWID() NOT NULL, [sync_scope_name] nvarchar(100) NOT NULL, [scope_sync_knowledge] image NULL, [scope_tombstone_cleanup_knowledge] image NULL, [scope_timestamp] bigint NULL, [snapshot_timestamp] bigint NULL, [scope_config_id] uniqueidentifier NULL, [scope_user_comment] ntext NULL, [scope_tomb_mark] bigint DEFAULT 0 NOT NULL)
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:553,    Executing Command: ALTER TABLE [scope_info] ADD CONSTRAINT [PK_scope_info] PRIMARY KEY ([sync_scope_name])
    INFO   , SyncApplication, 1, 08/24/2010 03:39:38:557, Creating Scope Config table '[scope_config]'
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:557,    Executing Command: CREATE TABLE [scope_config] ([config_id] uniqueidentifier NOT NULL, [config_data] ntext NOT NULL)
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:559,    Executing Command:     ALTER TABLE [scope_config] ADD CONSTRAINT [PK_scope_config] PRIMARY KEY ([config_id])
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:563,    Executing Command: SELECT [schema_major_version], [schema_minor_version], [schema_extended_info] FROM [schema_info]
    INFO   , SyncApplication, 1, 08/24/2010 03:39:38:567, Creating Table '[orders]'
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:567,    Executing Command: CREATE TABLE [orders] ([order_id] int NOT NULL, [order_date] datetime NULL)
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:569,    Executing Command: ALTER TABLE [orders] ADD CONSTRAINT [PK_orders] PRIMARY KEY ([order_id])
    INFO   , SyncApplication, 1, 08/24/2010 03:39:38:579, Enabling Change Tracking on Table '[orders]'
    INFO   , SyncApplication, 1, 08/24/2010 03:39:38:584, Creating Change Tracking Index on Table '[orders]'
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:585,    Executing Command: CREATE INDEX sysChangeTxBsn_idx ON [orders] (__sysChangeTxBsn);
    INFO   , SyncApplication, 1, 08/24/2010 03:39:38:592, Dropping Tracking Table '[orders]'
    INFO   , SyncApplication, 1, 08/24/2010 03:39:38:595, Creating Tracking Table '[orders_tracking]'
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:596,    Executing Command: CREATE TABLE [orders_tracking] ([order_id] int NOT NULL, [sync_row_is_tombstone] int NOT NULL, [sync_update_peer_key] int NOT NULL, [sync_update_peer_timestamp] bigint NOT NULL, [sync_create_peer_key] int NOT NULL, [sync_create_peer_timestamp] bigint NOT NULL, [sync_update_bsn] bigint DEFAULT 0 NOT NULL, [last_change_datetime] datetime DEFAULT GETDATE() NULL)
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:599,    Executing Command: ALTER TABLE [orders_tracking] ADD CONSTRAINT [PK_orders_tracking] PRIMARY KEY ([order_id])
    INFO   , SyncApplication, 1, 08/24/2010 03:39:38:601, Adding Change Tracking index to Tracking Table '[orders_tracking]'
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:601,    Executing Command: CREATE INDEX sysChangeTxBsn_idx ON [orders_tracking] (sync_update_bsn);
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:604,    Executing Command: SELECT [schema_major_version], [schema_minor_version], [schema_extended_info] FROM [schema_info]
    INFO   , SyncApplication, 1, 08/24/2010 03:39:38:606, Creating Table '[order_details]'
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:606,    Executing Command: CREATE TABLE [order_details] ([order_id] int NOT NULL, [order_details_id] int NOT NULL, [product] nvarchar(100) NULL, [quantity] int NULL)
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:607,    Executing Command: ALTER TABLE [order_details] ADD CONSTRAINT [PK_order_details] PRIMARY KEY ([order_details_id])
    INFO   , SyncApplication, 1, 08/24/2010 03:39:38:615, Enabling Change Tracking on Table '[order_details]'
    INFO   , SyncApplication, 1, 08/24/2010 03:39:38:618, Creating Change Tracking Index on Table '[order_details]'
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:619,    Executing Command: CREATE INDEX sysChangeTxBsn_idx ON [order_details] (__sysChangeTxBsn);
    INFO   , SyncApplication, 1, 08/24/2010 03:39:38:622, Dropping Tracking Table '[order_details]'
    INFO   , SyncApplication, 1, 08/24/2010 03:39:38:623, Creating Tracking Table '[order_details_tracking]'
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:624,    Executing Command: CREATE TABLE [order_details_tracking] ([order_details_id] int NOT NULL, [sync_row_is_tombstone] int NOT NULL, [sync_update_peer_key] int NOT NULL, [sync_update_peer_timestamp] bigint NOT NULL, [sync_create_peer_key] int NOT NULL, [sync_create_peer_timestamp] bigint NOT NULL, [sync_update_bsn] bigint DEFAULT 0 NOT NULL, [last_change_datetime] datetime DEFAULT GETDATE() NULL)
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:626,    Executing Command: ALTER TABLE [order_details_tracking] ADD CONSTRAINT [PK_order_details_tracking] PRIMARY KEY ([order_details_id])
    INFO   , SyncApplication, 1, 08/24/2010 03:39:38:627, Adding Change Tracking index to Tracking Table '[order_details_tracking]'
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:38:627,    Executing Command: CREATE INDEX sysChangeTxBsn_idx ON [order_details_tracking] (sync_update_bsn);
    INFO   , SyncApplication, 1, 08/24/2010 03:39:39:033, Deleting Scope Info entry 'sales'
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:034,    Executing Command: DELETE [scope_info] WHERE [sync_scope_name] = @scopeName
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:035,       Parameter: @scopeName Len: 5 Value: sales
    INFO   , SyncApplication, 1, 08/24/2010 03:39:39:037, Adding Scope Info entry for 'sales'
    INFO   , SyncApplication, 1, 08/24/2010 03:39:39:037,    UserComment:
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:038,    Executing Command: INSERT INTO [scope_info] ([sync_scope_name], [scope_config_id], [scope_timestamp], [scope_user_comment]) VALUES (@scopeName, @configId , 1, @userDesc)
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:039,       Parameter: @scopeName Len: 5 Value: sales
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:039,       Parameter: @configId Value: 5e240ee8-745e-45dc-b578-5bfe25e7389c
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:039,       Parameter: @userDesc Value:
    INFO   , SyncApplication, 1, 08/24/2010 03:39:39:041, Adding Scope Config Entry for config id '5e240ee8-745e-45dc-b578-5bfe25e7389c'
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:042,    Executing Command: INSERT INTO [scope_config] ([config_id], [config_data]) VALUES (@configId, @configData)
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:042,       Parameter: @configId Value: 5e240ee8-745e-45dc-b578-5bfe25e7389c
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:042,       Parameter: @configData Len: 737 Value: <SqlCeSyncProviderScopeConfiguration xmlns:xsi="ht...
    INFO   , SyncApplication, 1, 08/24/2010 03:39:39:052, --- END Provisioning Scope 'sales' on Database 'D:\Milad\Amoozeshi\Sync Framework\SQL Server with 2 Compact\bin\Debug\Client01.sdf' ---
    INFO   , SyncApplication, 1, 08/24/2010 03:39:39:185,    BeginSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:191, Connecting using string: Data Source=MILADLP\SQLSERVER2005;Initial Catalog=peer1;Integrated Security=True;Connect Timeout=1
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:193, Reading Schema Version Info
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:194,    Executing Command: SELECT [schema_major_version], [schema_minor_version], [schema_extended_info] FROM [schema_info]
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:195, Connecting using string: Data Source=MILADLP\SQLSERVER2005;Initial Catalog=peer1;Integrated Security=True;Connect Timeout=1
    INFO   , SyncApplication, 1, 08/24/2010 03:39:39:232,    BeginSession() called on Provider SqlCeSyncProvider, Microsoft.Synchronization.Data.SqlServerCe, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:235, Connecting to database: D:\Milad\Amoozeshi\Sync Framework\SQL Server with 2 Compact\bin\Debug\Client01.sdf
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:249,    Executing Command: SELECT [schema_major_version], [schema_minor_version], [schema_extended_info] FROM [schema_info]
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:252, Connecting to database: D:\Milad\Amoozeshi\Sync Framework\SQL Server with 2 Compact\bin\Debug\Client01.sdf
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:314, Closing Connection
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:317, Connecting to database: D:\Milad\Amoozeshi\Sync Framework\SQL Server with 2 Compact\bin\Debug\Client01.sdf
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:332,    Executing Command: SELECT [schema_major_version], [schema_minor_version], [schema_extended_info] FROM [schema_info]
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:335, Connecting to database: D:\Milad\Amoozeshi\Sync Framework\SQL Server with 2 Compact\bin\Debug\Client01.sdf
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:348, Reading Snapshot preparation timestamp for Scope sales
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:349,    Executing Command: select snapshot_timestamp from [scope_info] where sync_scope_name = @sync_scope_name
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:350,       Parameter: @sync_scope_name Len: 5 Value: sales
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:353, Read Snapshot preparation timestamp for Scope sales as 0.
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:353, Closing Connection
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:360, Connecting to database: D:\Milad\Amoozeshi\Sync Framework\SQL Server with 2 Compact\bin\Debug\Client01.sdf
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:373,    Executing Command: SELECT [schema_major_version], [schema_minor_version], [schema_extended_info] FROM [schema_info]
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:377, Connecting to database: D:\Milad\Amoozeshi\Sync Framework\SQL Server with 2 Compact\bin\Debug\Client01.sdf
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:396,    Executing Command: select scope_local_id, scope_id, scope_sync_knowledge, scope_tombstone_cleanup_knowledge, scope_timestamp, scope_tomb_mark, scope_config_id from [scope_info] with (HOLDLOCK, XLOCK) where sync_scope_name = @sync_scope_name
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:396,       Parameter: @sync_scope_name Len: 5 Value: sales
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:654, Closing Connection
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:667, Connecting using string: Data Source=MILADLP\SQLSERVER2005;Initial Catalog=peer1;Integrated Security=True;Connect Timeout=1
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:675, Reading Schema Version Info
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:675,    Executing Command: SELECT [schema_major_version], [schema_minor_version], [schema_extended_info] FROM [schema_info]
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:680,    Executing Command: SELECT @sync_new_timestamp = min_active_rowversion() - 1
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:681,       Parameter: @sync_new_timestamp Value: Skipped since Not Input/InputOutput
    ERROR  , SyncApplication, 1, 08/24/2010 03:39:39:703, Caught DbException while executing SelectNewTimestampCommand
    System.Data.SqlClient.SqlException: 'min_active_rowversion' is not a recognized built-in function name.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Synchronization.Data.SqlServer.SqlSyncScopeHandler.GetLocalTimestamp(IDbConnection connection, IDbTransaction transaction)

    ERROR  , SyncApplication, 1, 08/24/2010 03:39:39:712, Caught exception while getting changes: Microsoft.Synchronization.Data.DbSyncException: Failed 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. ---> System.Data.SqlClient.SqlException: 'min_active_rowversion' is not a recognized built-in function name.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Synchronization.Data.SqlServer.SqlSyncScopeHandler.GetLocalTimestamp(IDbConnection connection, IDbTransaction transaction)
       --- End of inner exception stack trace ---
       at Microsoft.Synchronization.Data.SqlServer.SqlSyncScopeHandler.GetLocalTimestamp(IDbConnection connection, IDbTransaction transaction)
       at Microsoft.Synchronization.Data.SqlServer.SqlSyncScopeHandler.ReadScope(IDbConnection connection, IDbTransaction transaction, ReadKnowledgeType readType, ReadForgottenKnowledgeType readFKtype)
       at Microsoft.Synchronization.Data.SyncScopeHandlerBase.ReadScope(IDbTransaction transaction, ReadKnowledgeType readType, ReadForgottenKnowledgeType readFKtype)
       at Microsoft.Synchronization.Data.RelationalSyncProvider.GetChanges(DbSyncScopeMetadata scopeMetadata, DbSyncSession DbSyncSession, UInt32 memoryBatchSize)
    ERROR  , SyncApplication, 1, 08/24/2010 03:39:39:717, Disposing of transaction
    VERBOSE, SyncApplication, 1, 08/24/2010 03:39:39:718, Closing Connection
    INFO   , SyncApplication, 1, 08/24/2010 03:39:39:720,    EndSession() called on Provider SqlCeSyncProvider, Microsoft.Synchronization.Data.SqlServerCe, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
    INFO   , SyncApplication, 1, 08/24/2010 03:39:39:720,    EndSession() called on Provider SqlSyncProvider, Microsoft.Synchronization.Data.SqlServer, Version=3.1.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91

     

    min_active_rowversion() dose not exist in database peer1!!!

     

    Tuesday, August 24, 2010 4:05 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    are you running SQL Server 2005 Service Pack 2? min_active_rowversion() was introduced in SQL Server 2005 Service Pack 2
    Tuesday, August 24, 2010 4:28 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    oh, no!

    Thank you

    Tuesday, August 24, 2010 4:52 AM