E1: OS: SQL0204 and SQL7008 CALL STRJOURNAL Error for Some Applications and UBEs (Doc ID 643056.1)

Last updated on JULY 28, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version SP23 and Prior and later
IBM i on POWER Systems




Symptoms

Any applications which requires iSeries database files to be journaled, may encounter STRJOURNAL error in JDE.LOG, and the most common issue reported are:

1. OMW P98220 check in or check out objects

2. Working with OMW project

3. Issue related to UBE like:

4. Transaction fails like Creating Journal Entries P0911, Account Payable, Sales Order P4210, P4310 etc

Sample errors in local JDE.LOG look like the following:

509/325 Thu Mar 13 08:40:41 2003 JDBODBC.C5066
ODB0000167 - Unable to prepare statement: CALL STRJOURNAL (?, ?, ?).

509/325 Thu Mar 13 08:40:41 2003 JDBODBC.C5067
[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0204 - STRJOURNAL in type *N not found. - SQLSTATE: S0002

509/325 Thu Mar 13 08:40:41 2003 JDBODBC.C2128
ODB0000183 - SQLExecute failed

509/325 Thu Mar 13 08:40:41 2003 JDBODBC.C2128
[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7008 - F9202 in DD812 not valid for operation. - SQLSTATE: S1000

509/325 Thu Mar 13 08:40:41 2003 jdb_exet.c5349
JDB9900228 - Failed to commit user

509/325 Thu Mar 13 08:40:41 2003 DLG_MSGB.CPP190
Commit Failed or was Canceled. Transaction not committed.

 JDE.LOG from check in/out in OMW:

 

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms