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

ID and Error not populating

Two issues. All of a sudden we are experiencing problems with the ID columns of our loading tables. For years we have been setting the ID column to nvarchar(18) and today we got the errror:

Error: Id column is not a defined correctly. The Id column must be defined as type nchar and be 18 characters long.

After changing the ID column to nchar(18), records starts loading, but ID and error fields do not populate:

Here is the result set:
--- Starting SF_BulkOps for Opportunity_IS_SFDC_load V3.5.1
14:13:46: Run the DBAmpNet2.exe program.
14:13:46: DBAmpNet2 3.5.1.0 (c) Copyright 2015-2017 forceAmp.com LLC
14:13:46: Parameters: insert Opportunity_IS_SFDC_load MT-SQL Staging_SB MT_NEW_SL_SBX
14:13:48: Drop Opportunity_IS_SFDC_load_Result if it exists.
14:13:48: Create Opportunity_IS_SFDC_load_Result with new structure.
14:13:50: Column ID ignored because it not insertable in the opportunity object.
14:13:50: Warning: Column AccountId_orig ignored because it does not exist in the opportunity object.
14:13:50: Warning: Column CreatedById_orig ignored because it does not exist in the opportunity object.
14:13:50: Column ForecastCategory ignored because it not insertable in the opportunity object.
14:13:50: Warning: Column IsClosed_orig ignored because it does not exist in the opportunity object.
14:13:50: Warning: Column IsWon_orig ignored because it does not exist in the opportunity object.
14:13:50: Warning: Column LeadSource_orig ignored because it does not exist in the opportunity object.
14:13:50: Warning: Column OwnerId_orig ignored because it does not exist in the opportunity object.
14:13:50: Warning: Column OwnerId_mt_new ignored because it does not exist in the opportunity object.
14:13:50: Warning: Column Pricebook2Id_orig ignored because it does not exist in the opportunity object.
14:13:50: Warning: Column Project_ID__c_orig ignored because it does not exist in the opportunity object.
14:13:50: Warning: Column StageName_orig ignored because it does not exist in the opportunity object.
14:13:50: Warning: Column Total_Amount__c_orig ignored because it does not exist in the opportunity object.
14:14:31: 2039 rows read from SQL Table.
14:14:31: 1083 rows failed. See Error column of row for more information.
14:14:31: 956 rows successfully processed.
14:14:31: Errors occurred. See Error column of row for more information.
14:14:31: Error: Unable to update SQL table.
14:14:31: System.InvalidOperationException: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column. ---> System.InvalidOperationException: String or binary data would be truncated.
at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed)
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed)
at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col)
at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationToken ctoken)
at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
at DBAmpNet2.BulkOpsSoap.LoadRecords()
14:14:31: Percent Failed = 100.000.
14:14:31: Error: DBAmpNet2.exe was unsuccessful.
14:14:31: Error: Command string is C:\"Program Files"\DBAmp\DBAmpNet2.exe BulkOpsSoap "insert" "Opportunity_IS_SFDC_load" "MT-SQL" "Staging_SB" "MT_NEW_SL_SBX" " "
--- Ending SF_BulkOps. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_BulkOps, Line 420
SF_BulkOps Error: 14:13:46: DBAmpNet2 3.5.1.0 (c) Copyright 2015-2017 forceAmp.com LLC14:13:46: Parameters: insert Opportunity_IS_SFDC_load MT-SQL Staging_SB MT_NEW_SL_SBX 14:13:48: Drop Opportunity_IS_SFDC_load_Result if it exists.14:13:48: Create Opportunity_IS_SFDC_load_Result with new structure.14:13:50: Column ID ignored because it not insertable in the opportunity object.14:13:50: Warning: Column AccountId_orig ignored because it does not exist in the opportunity object.14:13:50: Warning: Column CreatedById_orig ignored because it does not exist in the opportunity object.14:13:50: Column ForecastCategory ignored because it not insertable in the opportunity object.14:13:50: Warning: Column IsClosed_orig ignored because it does not exist in the opportunity object.14:13:50: Warning: Column IsWon_orig ignored because it does not exist in the opportunity object.14:13:50: Warning: Column LeadSource_orig ignored because it does not exist in the opportunity object.14:13:50: Warning: Column OwnerId_orig ignored because it does not exist in the opportunity object.14:13:50: Warning: Column OwnerId_mt_new ignored because it does not exist in the opportunity object.14:13:50: Warning: Column Pricebook2Id_orig ignored because it does not exist in the opportunity object.14:13:50: Warning: Column Project_ID__c_orig ignored because it does not exist in the opportunity object.14:13:50: Warning: Column StageName_orig ignored because it does not exist in the opportunity object.14:13:50: Warning: Column Total_Amount__c_orig ignored because it does not exist in the opportunity object.14:14:31: 2039 rows read from SQL Table.14:14:31: 1083 rows failed. See Error column of row for more information.14:14:31: 956 rows successfully processed.14:14:31: Errors occurred. See Error column of row for more information.14:14:31: Error: Unable to update SQL table.14:14:31: System.InvalidOperationException: The given value of type String from the data source cannot be converted to type nvarchar of the specified...
1 person has
this question
+1
Reply