IBM Support

While updating records in AS400/DB2 tables, receiving the error message: error occurred with SQLCode -7008

Troubleshooting


Problem

While updating records in AS400/DB2 tables, receiving the error message: error occurred with SQLCode -7008

Symptom

The full error is: Exception processing SingleTableNotification Job.Data error at row number 0 of table Lib.tablename". The Error is [CastIron Systems][DB2 JDBC Driver][DB2]Error occurred with SQLCode -7008 with the following parameters: ID, Name, 3, null, null Encountered fault of type (database.outbound.internal), please see rest of the log for more information

Cause

Database table is not journaled.

Resolving The Problem

If you see the above error message during runtime,
1. please verify whether the table is journaled
2. If the table is not journaled, then you will need to ask the DB2 Administrator to journal the table.
3. Once the required tables are journaled then you can insert / update / delete i.e. can perform DB operation without issues.

[{"Product":{"code":"SSGR73","label":"IBM Cast Iron Cloud Integration"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"5.0.1.8;6.1.0.6;6.1.0.9","Edition":"Virtual;Physical;Cloud","Line of Business":{"code":"LOB45","label":"Automation"}}]

Historical Number

00000277

Product Synonym

Cast Iron Solution
Cast Iron Operating System
Cast Iron Studio

Document Information

More support for:
IBM Cast Iron Cloud Integration

Software version:
5.0.1.8, 6.1.0.6, 6.1.0.9

Operating system(s):
Linux, Windows

Document number:
410693

Modified date:
15 June 2018

UID

swg21453172

Manage My Notification Subscriptions

Page Feedback