Asked by:
Invalid Column name during deprovisioning

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