Invalid Column name during deprovisioning RRS feed

  • Question

  • When i tried to sync a database im getting this error during provisioning.

    [bgworkerSync_DoWork ]:.Net SqlClient Data Provider:Void OnError(System.Data.SqlClient.SqlException, Boolean):Invalid column name 'payment_alert'.:System.Collections.ListDictionaryInternal   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.SqlSyncProcedureHelper.CreateBulkInsert(SqlTransaction trans, DbSyncCreationOption option)
       at Microsoft.Synchronization.Data.SqlServer.SqlSyncTableProvisioning.Apply(SqlTransaction trans)
       at Microsoft.Synchronization.Data.SqlServer.SqlSyncScopeProvisioning.ApplyScope(SqlConnection connection)
       at Microsoft.Synchronization.Data.SqlServer.SqlSyncScopeProvisioning.ApplyInternal(SqlConnection connection)
       at Microsoft.Synchronization.Data.SqlServer.SqlSyncScopeProvisioning.Apply()
       at AmisSync.frmAmisSync.bgworkerSync_DoWork(Object sender, DoWorkEventArgs e)
    I think this database copied from a  previously synced database.But when i get this DB in my hand  it doesnt have any data sync objects .I think may be some one manually delete all.But i need to sync this database . So how could i fix this..Is there anyway to find this was previously provisioned?

    Any help appreciate.

    Saturday, March 31, 2012 7:26 AM

All replies

  • try running calling DeprovisionStore...just look it up in the docs how to call it.

    or you can manually visually inspect for sync fx objects, triggers on the tables, _tracking tables, stored procs, and a UDT under Programmability->Types->User-Defined Table Types

    Saturday, March 31, 2012 7:55 AM
  • There is no Sync fx objects. so now the problem is neither i cant provision nor deprovision this database.
    • Edited by sharon 5656 Saturday, March 31, 2012 8:51 AM
    Saturday, March 31, 2012 8:27 AM
  • what's the data type of the failing column?

    can you try the GenerateScript option for the provisioning and have a look at the SQL itself.

    • Edited by JuneT Saturday, March 31, 2012 10:50 AM
    Saturday, March 31, 2012 10:49 AM