Sign in
Microsoft.com
 
Microsoft
 
 
 

none
Invalid Column name during deprovisioning RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
    |
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    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
    |
  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    Saturday, March 31, 2012 10:49 AM
    |
    Moderator