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

SQL DBamp Error on job activity monitor

I keep getting this error inconsistently in SQL trying to upsert to different objects. What does it mean?

Error: Unable to close job. [SQLSTATE 01000] (Message 0) 14:33:42: Error: InvalidSessionId. Invalid session id [SQLSTATE 01000] (Message 0) 14:33:42: 80406 rows read from SQL Table. [SQLSTATE 01000] (Message 0) 14:33:42: 80406 rows processed. [SQLSTATE 01000] (Message 0) --- Ending SF_BulkOps. Operation successful. [SQLSTATE 01000] (Message 0) Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) --- Starting SF_BulkOps for SP_Category__c_Upsert_New [SQLSTATE 01000] (Message 0) 14:37:41: Run the DBAmp.exe program. [SQLSTATE 01000] (Message 0) 14:37:41: DBAmp Bulk Operations. V2.14.4 (c) Copyright 2006-2012 forceAmp.com LLC [SQLSTATE 01000] (Message 0) 14:37:41: Upserting Salesforce using SP_Category__c_Upsert_New (SQLSRV10 / SalesForceLocal) . [SQLSTATE 01000] (Message 0) 14:37:42: DBAmp is using the SQL Native Client. [SQLSTATE 01000] (Message 0) 14:40:08: Batch 751a0000004qXxzAAE created with 10000 rows. [SQLSTATE 01000] (Message 0) 14:44:29: Batch 751a0000004qXy9AAE created with 10000 rows. [SQLSTATE 01000] (Message 0) 14:49:33: Batch 751a0000004qXyJAAU created with 10000 rows. [SQLSTATE 01000] (Message 0) 14:53:07: Batch 751a0000004qXyOAAU created with 10000 rows. [SQLSTATE 01000] (Message 0) 14:57:26: Batch 751a0000004qXyTAAU created with 10000 rows. [SQLSTATE 01000] (Message 0) 14:59:18: Batch 751a0000004qXyYAAU created with 10000 rows. [SQLSTATE 01000] (Message 0) 15:00:40: Batch 751a0000004qXydAAE created with 10000 rows. [SQLSTATE 01000] (Message 0) 15:01:58: Batch 751a0000004qXz2AAE created with 10000 rows. [SQLSTATE 01000] (Message 0) 15:05:23: Batch 751a0000004qXzWAAU created with 10000 rows. [SQLSTATE 01000] (Message 0) 15:06:47: Batch 751a0000004qXzqAAE created with 10000 rows. [SQLSTATE 01000] (Message 0) 15:08:11: Batch 751a0000004qY00AAE created with 10000 rows. [SQLSTATE 01000] (Message 0) 15:10:08: Batch 751a0000004qY0FAAU created with 10000 rows. [SQLSTATE 01000] (Message 0) 15:11:42: Batch 751a0000004qY0KAAU created with 10000 rows. [SQLSTATE 01000] (Message 0) 15:13:30: Batch 751a0000004qY0UAAU created with 10000 rows. [SQLSTATE 01000] (Message 0) 15:15:24: Batch 751a0000004qY0jAAE created with 10000 rows. [SQLSTATE 01000] (Message 0) 15:17:16: Batch 751a0000004qY0oAAE created with 10000 rows. [SQLSTATE 01000] (Message 0) 15:18:57: Batch 751a0000004qY13AAE created with 10000 rows. [SQLSTATE 01000] (Message 0) 15:20:43: Batch 751a0000004qY18AAE created with 10000 rows. [SQLSTATE 01000] (Message 0) 15:22:10: Batch 751a0000004qY1DAAU created with 10000 rows. [SQLSTATE 01000] (Message 0) 15:23:40: Batch 751a0000004qY1SAAU created with 10000 rows. [SQLSTATE 01000] (Message 0) 15:... The step failed.
1 person has
this question
+1
Reply
  • The output from the job history is truncated (see the ... at the very end.)

    To diagnose I need to see the complete output.

    Can you modify the job step using the Advanced tab and write the output to table ? Then when the job fails , return to the Advanced tab and view the table. It will contain the complete message output that you can forward to me at support at forceamp.com

    Do not post to the forum; it will be too large.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated indifferent, undecided, unconcerned kidding, amused, unsure, silly happy, confident, thankful, excited