E1: OUTBND RTE Message Doesn't Get Processed - Row or object F90710 in SY910 type *FILE in use Error - AS/400 (Doc ID 1905345.1)

Last updated on MAY 30, 2017

Applies to:

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

Symptoms

Issue:
---------
You are using Real Time Events and 3 times a day, you get status "3" records stuck in F90710 table. The workaround is to reset F90708 to "0", then it gets processed.

Error:
---------
"An SQL exception occurred: [SQL0913] Row or object F90710 in SY910 type *FILE in use"

30 Jun 2014 18:24:21,570 [SEVERE]  - [JDBJ]            SQLException occured in the SQLPhysicalConnection.select(): | Table or View Name = F90710 - Data Source[0] = System - 910 java.sql.SQLException: [SQL0913] Row or object F90710 in SY910 type *FILE in use.
30 Jun 2014 18:24:21,570 [SEVERE]  - [BASE]            com.jdedwards.database.base.JDBException: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: [SQL0913] Row or object F90710 in SY910 type *FILE in use.. java.sql.SQLException: [SQL0913] Row or object F90710 in SY910 type *FILE in use.
30 Jun 2014 18:24:21,570 [SEVERE]  - [BASE]            com.jdedwards.database.base.JDBException: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: [SQL0913] Row or object F90710 in SY910 type *FILE in use.. com.jdedwards.database.base.JDBException: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: [SQL0913] Row or object F90710 in SY910 type *FILE in use..
30 Jun 2014 18:24:21,570 [SEVERE]  - [EVENTPROCESSOR]  Exception from database: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: [SQL0913] Row or object F90710 in SY910 type *FILE in use.. com.jdedwards.database.base.JDBException: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: [SQL0913] Row or object F90710 in SY910 type *FILE in use..
30 Jun 2014 18:24:21,570 [SEVERE]  - [EVENTPROCESSOR]  Failed to get committed events from the database: Exception from database: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: [SQL0913] Row or object F90710 in SY910 type *FILE in use.. com.peoplesoft.pt.e1.common.events.EventProcessingException: Exception from database: [SQL_EXCEPTION_OCCURRED] An SQL exception occurred: [SQL0913] Row or object F90710 in SY910 type *FILE in use..



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