none
Database re-provisioning failed RRS feed

  • Question

  • Hi there,

    I am trying to re-provision a local database but I keep on getting the following error:

    Database re-provisioning failed with the exception "SqlException Error Code: -2146232060 - SqlError Number:208, Message: Invalid object name 'DataSync.provision_marker_dss'.
    "

    For more information, provide tracing id ‘19f5d3b1-0244-4ff0-814d-19babe2fac41’ to customer support.

    Stack Trace:
    id:ClientRequestHandler_ExceptionProcessingRequest, rId:, sId:e4e38c20-9487-435f-94ae-1ded32731eaa, taskId:622860d1-aa09-4ed3-b3ba-50cf30949ff5, e:'Type=System.Data.SqlClient.SqlException,Message=Invalid object name 'DataSync.provision_marker_dss'.,Source=.Net SqlClient Data Provider,StackTrace=   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()
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Synchronization.Data.SqlServer.SqlSyncTrackingTableHelper.UpdateTrackingTableWhereColumnsNotNullInBaseTable(SqlConnection connection, SqlTransaction transaction, DbSyncColumnDescription[] addedColumns, DbSyncColumnDescription[] modifiedColumns, Int32 tableObjectId, SqlSyncMarkerTableHelper markerHelper)
       at Microsoft.Synchronization.Data.SqlServer.SqlSyncTableProvisioning.ReApply(SqlTransaction trans, SqlSyncProviderAdapterConfiguration oldConfiguration)
       at Microsoft.Synchronization.Data.SqlServer.SqlSyncScopeProvisioning.ReApplyScope(SqlConnection connection)
       at Microsoft.Synchronization.Data.SqlServer.SqlSyncScopeProvisioning.ReApplyInternal(SqlConnection connection)
       at Microsoft.Synchronization.Data.SqlServer.SqlSyncScopeProvisioning.ReApply()
       at Microsoft.SqlAzureDataSync.SyncControllerLib.SyncController.ReprovisionScope(DbSyncScopeDescription scopeDescription, List`1 tableDescriptionsWithFilters)
       at Microsoft.SqlAzureDataSync.AgentHostLib.ClientRequestHandler.<>c__DisplayClassc.<Reprovision>b__a()
       at Microsoft.SqlAzureDataSync.AgentHostLib.ClientRequestHandler.ExecuteMethodWithRetry(Action method, Int32 retryCount)
       at Microsoft.SqlAzureDataSync.AgentHostLib.ClientRequestHandler.Reprovision(ReprovisionRequest request),', eType:'Type=System.Data.SqlClient.SqlException', eMessage:'Message=Invalid object name 'DataSync.provision_marker_dss'.' Error Code: -2146232060 - SqlError Number:208, Message: Invalid object name 'DataSync.provision_marker_dss'.. , eTypeInner:, eMessageInner:

    Sync Group Id: 8ded819b-8456-4a4a-bcba-995dbf58b639
    Server Id: e4e38c20-9487-435f-94ae-1ded32731eaa

    The re-provisioning of the hub database succeeded.

    Any ideas?

    Tuesday, September 4, 2012 9:05 PM

Answers

  • try scripting that table from SQL Azure and run the script to create the table on the on-premise database.
    • Marked as answer by Marais van Zyl Wednesday, September 5, 2012 2:23 PM
    Wednesday, September 5, 2012 1:40 PM
    Answerer
  • here you go:
    CREATE TABLE [DataSync].[provision_marker_dss] (
        [object_id]                      INT        NOT NULL,
        [owner_scope_local_id]           INT        NOT NULL,
        [provision_scope_local_id]       INT        NULL,
        [provision_timestamp]            BIGINT     NOT NULL,
        [provision_local_peer_key]       INT        NOT NULL,
        [provision_scope_peer_key]       INT        NULL,
        [provision_scope_peer_timestamp] BIGINT     NULL,
        [provision_datetime]             DATETIME   NULL,
        [state]                          INT        NULL,
        [version]                        ROWVERSION NOT NULL,
        CONSTRAINT [PK_DataSync.provision_marker_dss] PRIMARY KEY CLUSTERED ([owner_scope_local_id] ASC, [object_id] ASC)
    );
    
    

    • Marked as answer by Marais van Zyl Wednesday, September 5, 2012 2:23 PM
    Wednesday, September 5, 2012 2:03 PM
    Answerer

All replies

  • try upgrading your Data Sync Client Agent...

    the recent service update has included changes to improve the provisioning/initial sync and the table you're getting an error is  exactly one of the new tables introduced in the last service update.

    Wednesday, September 5, 2012 12:07 AM
    Answerer
  • The tool is running on version 4.0.61.0 which is the latest.

    Edit: I have now uninstalled and reinstalled the tool and getting the same exception.

    • Edited by Marais van Zyl Wednesday, September 5, 2012 11:54 AM more information
    Wednesday, September 5, 2012 3:12 AM
  • try scripting that table from SQL Azure and run the script to create the table on the on-premise database.
    • Marked as answer by Marais van Zyl Wednesday, September 5, 2012 2:23 PM
    Wednesday, September 5, 2012 1:40 PM
    Answerer
  • Thanks. I thought of that last night, but there is no such object in the cloud database. Would you be able to post the script here maybe or upload it to a skydrive somewhere.
    Wednesday, September 5, 2012 1:46 PM
  • here you go:
    CREATE TABLE [DataSync].[provision_marker_dss] (
        [object_id]                      INT        NOT NULL,
        [owner_scope_local_id]           INT        NOT NULL,
        [provision_scope_local_id]       INT        NULL,
        [provision_timestamp]            BIGINT     NOT NULL,
        [provision_local_peer_key]       INT        NOT NULL,
        [provision_scope_peer_key]       INT        NULL,
        [provision_scope_peer_timestamp] BIGINT     NULL,
        [provision_datetime]             DATETIME   NULL,
        [state]                          INT        NULL,
        [version]                        ROWVERSION NOT NULL,
        CONSTRAINT [PK_DataSync.provision_marker_dss] PRIMARY KEY CLUSTERED ([owner_scope_local_id] ASC, [object_id] ASC)
    );
    
    

    • Marked as answer by Marais van Zyl Wednesday, September 5, 2012 2:23 PM
    Wednesday, September 5, 2012 2:03 PM
    Answerer
  • ran into this problem as well, and this fixed it.

    thanks again June.

    Tuesday, September 11, 2012 8:29 AM
  • Can anyone here provide some further information about your scenario to hit this "Invalid object name 'DataSync.provision_marker_dss'" issue?

    1. Is your database first provisioned by a old agent or latest version?

    2. what kind of schema refresh you are doing? Add\delete table or add\delete column or modify column length?

    Your information will help to make our service more muture.

    Also thanks for June to provide this solution to wordaround the issue.

    Regards,

    Jarod Zhu

    Tuesday, September 11, 2012 12:51 PM