E1: CFR11: R950005 Fails to Print Audit Information and No Records in Table F9500005 (Doc ID 1274209.1)

Last updated on JUNE 21, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.

Symptoms

User runs R9500005 (Delete Unmatched Audit Log Records) batch application by following the steps in <Document 978642.1>, but no data is displayed in the report/PDF. Also, there is no data in table F9500005 (Temporary Audit).

The following errors are in the Server JDE.LOG:

452/6608 FOREIGN_THREAD Fri Dec 10 07:42:51.098017 Odbc_p1.c1681
ODB0000092 - SQLExtendedFetch failed. Table(1st) F9500004, ODBC DSN GC-SRV-E1SQL.

3452/6608 FOREIGN_THREAD Fri Dec 10 07:42:51.098019 Jdb_drvm.c1188
JDB9900172 - Failed to execute db fetch

3452/6608 FOREIGN_THREAD Fri Dec 10 07:45:59.378027 Odbc_p1.c1681
ODB0000092 - SQLExtendedFetch failed. Table(1st) F9500004, ODBC DSN GC-SRV-E1SQL.

3452/6608 FOREIGN_THREAD Fri Dec 10 07:45:59.378029 Jdb_drvm.c1188
JDB9900172 - Failed to execute db fetch

3452/6608 FOREIGN_THREAD Fri Dec 10 07:46:01.425027 Odbc_p1.c1681
ODB0000092 - SQLExtendedFetch failed. Table(1st) F9500004, ODBC DSN GC-SRV-E1SQL.

3452/6608 FOREIGN_THREAD Fri Dec 10 07:46:01.441001 Jdb_drvm.c1188
JDB9900172 - Failed to execute db fetch


The following errors are in the Server JDEDEBUG.LOG:

Dec 10 07:45:59.378010 - 3452/6608 FOREIGN_THREAD ODBC[Jdbodbc.c,7882] wSQLExecute warning. rc = 1
Dec 10 07:45:59.378011 - 3452/6608 FOREIGN_THREAD ODBC[Jdbodbc.c,7882] STMT:00 [22003][0] [Microsoft][SQL Native Client]Numeric value out of range
Dec 10 07:45:59.378012 - 3452/6608 FOREIGN_THREAD ODBC[Jdbodbc.c,7882] STMT:01 [22003][0] [Microsoft][SQL Native Client]Numeric value out of range

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