E1: CFR11: Table Update Failed with SQL7008 and CPF7002 error on IBM System i - AS400 iSeries platform (Doc ID 1915881.1)

Last updated on JULY 26, 2017

Applies to:

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

Symptoms

On :  IBM System i (formally known as AS400)

When attempting to add voucher in P0411 application, the following error occurs:

ERROR
-----------------------
Select Application Failure Header Label

The jde.log shows the following:

There was a problem with the server while running the business function F0411FSEndDoc.  The server may still be availlable, but because of state information, the entire unit of work must be

508/4328 WRK:Starting jdeCallObject            Tue Jul 08 16:20:36.343003    Jdbodbc.c7639
    ODB0000073 - Contact the Sys Admin to undo the command: FAILED #Command failed: STRJRNPF FILE(LIBA/F0401        ) JRN(OWJRNL/OW_JRNL       ) IMAGES(*BOTH) OMTJRNE(*OPNCLO) with exception: CPF7002.

3508/4328 WRK:Starting jdeCallObject            Tue Jul 08 16:20:36.359003    Jdbodbc.c8346
    ODB0000163 - wSQLExecute failure. rc=-1

3508/4328 WRK:Starting jdeCallObject            Tue Jul 08 16:20:36.375001    Jdbodbc.c8346
    ODB0000164 - STMT:00 [HY000][-7008] [IBM][System i Access ODBC Driver][DB2 for i5/OS]SQL7008 - F0401 in LIBA not valid for operation.

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Fastpath P0411 XJDE0001
2. Add voucher

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot add payment voucher.

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