book
Article ID: KB0075645
calendar_today
Updated On:
Description
Using the TIBCO Scribe® Online Connector For ODBC to connect to an AS/400 table, the Scribe® Online connection tests successfully, but running a Solution results in the error below. The ODBC datasource is configured to use the Progress DataDirect DB2 Wire Protocol Driver.
SLSREL in TEST#FILE not valid for operation. 3
: Error in calling Operation Create
On the server hosting the on-premise agent, a test of the ODBC datasource using a SQL query tool returns the following error:
ERROR: [DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]SLSREL in TEST#FILE not valid for operation. 3 Error Code: -7008
Default "Advanced" settings for the DB2 datasource
Resolution
This error is unique to DB2 on the AS/400. The DB2 error SQL7008 is returned when an update is attempted to a table on the AS/400 that is not journalled with an Isolation Level that requires journalling. There are two ways to resolve this error:
- Change the ODBC datasource Default Isolation Level from “1 - READ COMMITTED” to “4 - NONE”
- Work with the Database Administrator to enable journalling on the AS/400 server for the target table.
"Advanced" settings for the DB2 datasource
For additional information, see the following Progress DataDirect DB2 Wire Protocol Driver reference:
Default Isolation Level
Issue/Introduction
Using the TIBCO Scribe® Online Connector For ODBC to connect to an AS/400 table, the “not valid for operation. 3” error can occur when the ODBC datasource Default Isolation Level is set to “1 - READ COMMITTED”.