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

Recently Upgraded. Getting a Null Reference Exception Error

I recently upgraded to the latest version. During Exec SF_TableLoader 'Insert', 'OnePlace', 'GroupMember_upsert2' command, I receive a Null Reference Exception. Just need clues on how to troubleshoot this issue.

The following is the complete error message:

--- Starting SF_TableLoader for GroupMember_upsert2 V3.5.7
13:06:22: Run the DBAmpNet2.exe program.
13:06:22: DBAmpNet2 3.5.7.0 (c) Copyright 2015-2017 forceAmp.com LLC
13:06:22: Parameters: insert GroupMember_upsert2 DC1SVPSFSQL01 OnePlace_Data OnePlace
13:06:22: Using the Salesforce bulkapi2 API.
13:06:24: Drop GroupMember_upsert2_Result if it exists.
13:06:24: Create GroupMember_upsert2_Result with new structure.
13:06:24: Sort column will be used to order input rows.
13:06:34: Add Error column in GroupMember_upsert2_Result.
13:06:34: Warning: Column Id ignored because it does not exist in the groupmember object.
13:06:34: Warning: Column Sort ignored because it does not exist in the groupmember object.
13:07:23: 12388795 rows read from SQL Table.
13:07:23: Job 7503600000L1IoAAAV created on salesforce.
13:07:48: Error: System.NullReferenceException: Object reference not set to an instance of an object.
at DBAmpNet2.BulkOpsJobSubmitProcessor.CreateBatch()
at DBAmpNet2.Program.HandleBulkOpsBulk(String currentOperation, Options currentOptions, DBAmpRegistry currentDBAmpRegistry)
at DBAmpNet2.Program.Main(String[] args)
13:07:48: DBAmpNet2 Operation FAILED.
13:07:49: Error: DBAmpNet2.exe was unsuccessful.
13:07:49: Error: Command string is C:\"Program Files"\DBAmp\DBAmpNet2.exe BulkOpsBulk "insert" "GroupMember_upsert2" "DC1SVPSFSQL01" "OnePlace_Data" "OnePlace" " "
--- Ending SF_TableLoader. Operation FAILED.
Msg 50000, Level 16, State 1, Procedure SF_TableLoader, Line 307 [Batch Start Line 61]
SF_TableLoader Error: 13:06:22: DBAmpNet2 3.5.7.0 (c) Copyright 2015-2017 forceAmp.com LLC13:06:22: Parameters: insert GroupMember_upsert2 DC1SVPSFSQL01 OnePlace_Data OnePlace13:06:22: Using the Salesforce bulkapi2 API.13:06:24: Drop GroupMember_upsert2_Result if it exists.13:06:24: Create GroupMember_upsert2_Result with new structure.13:06:24: Sort column will be used to order input rows.13:06:34: Add Error column in GroupMember_upsert2_Result.13:06:34: Warning: Column Id ignored because it does not exist in the groupmember object.13:06:34: Warning: Column Sort ignored because it does not exist in the groupmember object.13:07:23: 12388795 rows read from SQL Table.13:07:23: Job 7503600000L1IoAAAV created on salesforce.13:07:48: Error: System.NullReferenceException: Object reference not set to an instance of an object. at DBAmpNet2.BulkOpsJobSubmitProcessor.CreateBatch() at DBAmpNet2.Program.HandleBulkOpsBulk(String currentOperation, Options currentOptions, DBAmpRegistry currentDBAmpRegistry) at DBAmpNet2.Program.Main(String[] args)13:07:48: DBAmpNet2 Operation FAILED.
1 person likes
this idea
+1
Reply