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

Modified date:
15 June 2018

UID

swg21453172

Page Feedback