Help get this topic noticed by sharing it on Twitter, Facebook, or email.
I’m frustrated

SF_BulkOps Upsert unable to set Error column to Null Issue

Help with SF_BulkOps upsert

I am running:
EXEC dbo.SF_BulkOps 'Upsert', 'SFDC_TARGET', 'UserRole_Stage', 'Name'

I am receiving:
10:43:59: Run the DBAmpNet2.exe program.
10:43:59: DBAmpNet2 3.5.3.0 (c) Copyright 2015-2017 forceAmp.com LLC
10:43:59: Parameters: upsert UserRole_Stage 220A10058 SF_Data_Migration SFDC_TARGET
10:44:01: Drop UserRole_Stage_Result if it exists.
10:44:01: Create UserRole_Stage_Result with new structure.
10:44:04: Error: Unable to set Error column to Null.
10:44:04: 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:2f0a4bc8-2877-46b3-a980-f68251271303
Error Number:207,State:1,Class:16
Msg 207, Level 16, State 1, Line 2
Invalid column name 'Error'.
Msg 207, Level 16, State 1, Line 2
Invalid column name 'Error'.
10:44:06: Error: DBAmpNet2.exe was unsuccessful.
10:44:06: Error: Command string is C:\"Program Files"\DBAmp\DBAmpNet2.exe BulkOpsSoap "upsert" "UserRole_Stage" "220A10058" "SF_Data_Migration" "SFDC_TARGET" "Name" " "
--- Ending SF_BulkOps. Operation FAILED.
1 person has
this question
+1
Reply