Help get this topic noticed by sharing it on Twitter, Facebook, or email.

SF_TableLoader undelete error

I don't think that the undelete operation in SF_TableLoader is working. The table I'm using is a 1 column table with Id. Here is my exec:

exec SF_TableLoader 'undelete','g360','rateplancharge__c_undelete'

here is the output:

--- Starting SF_TableLoader for rateplancharge__c_undelete V3.5.6
14:07:50: Run the DBAmpNet2.exe program.
14:07:50: DBAmpNet2 3.5.6.0 (c) Copyright 2015-2017 forceAmp.com LLC
14:07:50: Parameters: undelete rateplancharge__c_undelete [COMPUTERNAME] G360 g360
14:07:50: Using the Salesforce SOAP API.
14:07:52: Drop rateplancharge__c_undelete_Result if it exists.
14:07:52: Create rateplancharge__c_undelete_Result with new structure.
14:07:52: Deleting Id's using rateplancharge__c_undelete
14:07:52: Error: Unable to set Error column to Null.
14:07:52: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Error'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParamet
erEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolea
n inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at DBAmpNet2.BulkOpsSoap.LoadRecords()
ClientConnectionId:XXXX
Error Number:207,State:1,Class:16
14:07:52: DBAmpNet2 Operation FAILED.
Msg 207, Level 16, State 1, Line 2
Invalid column name 'Error'.
Msg 207, Level 16, State 1, Line 2
Invalid column name 'Error'.
14:07:54: Error: DBAmpNet2.exe was unsuccessful.
14:07:54: Error: Command string is C:\"Program Files"\DBAmp\DBAmpNet2.exe BulkOpsSoap "undelete" "rateplancharge__c_undelete" "CVG-MISDB-V02" "G360" "g360" " "
--- Ending SF_TableLoader. Operation FAILED.
1 person has
this question
+1
Reply