E1: CFR11: Table Update Failed with SQL7008 and CPF7002 error on IBM System i - AS400 iSeries platform
Last updated on JULY 26, 2017
Applies to:JD Edwards EnterpriseOne Tools - Version 8.98 and later
IBM i on POWER Systems
On : IBM System i (formally known as AS400)
When attempting to add voucher in P0411 application, the following error occurs:
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.
The issue can be reproduced at will with the following steps:
1. Fastpath P0411 XJDE0001
2. Add voucher
The issue has the following business impact:
Due to this issue, users cannot add payment voucher.
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