Solved

Millions of IFSCONNECT records appearing in IFSAPP.SERVER_LOG_TAB

R
Rank
Userlevel 7
Badge +18

since 30th April we are having millions of records appearing in the IFSAPP.SERVER_LOG_TAB and they relate to 2 application messages that do not exist.

TEXT1  Number of Rows 
ORA-20111: ApplicationMessage.NOTEXIST: The Application Message "379851" does not exist.
ORA-06512: at "IFSAPP.ERROR_SYS", line 138
ORA-06512: at "IFSAPP.ERROR_SYS", line 376
ORA-06512: at "IFSAPP.APPLICATION_MESSAGE_API", line 2003
ORA-06512: at "IFSAPP.APPLICATION_MESSAGE_API", line 2024
ORA-06512: at "IFSAPP.APPLICATION_MESSAGE_API", line 456
ORA-06512: at "IFSAPP.APPLICATION_MESSAGE_API", line 463
ORA-06512: at line 1		        5,779,206
ORA-20111: ApplicationMessage.NOTEXIST: The Application Message "379836" does not exist.
ORA-06512: at "IFSAPP.ERROR_SYS", line 138
ORA-06512: at "IFSAPP.ERROR_SYS", line 376
ORA-06512: at "IFSAPP.APPLICATION_MESSAGE_API", line 2003
ORA-06512: at "IFSAPP.APPLICATION_MESSAGE_API", line 2024
ORA-06512: at "IFSAPP.APPLICATION_MESSAGE_API", line 456
ORA-06512: at "IFSAPP.APPLICATION_MESSAGE_API", line 463
ORA-06512: at line 1		        5,779,090
ORA-20111: ApplicationMessage.NOTEXIST: The Application Message "379836" does not exist.
ORA-06512: at "IFSAPP.ERROR_SYS", line 138
ORA-06512: at "IFSAPP.ERROR_SYS", line 376
ORA-06512: at "IFSAPP.APPLICATION_MESSAGE_API", line 2003
ORA-06512: at "IFSAPP.APPLICATION_MESSAGE_API", line 2024
ORA-06512: at "IFSAPP.APPLICATION_MESSAGE_API", line 456
ORA-06512: at "IFSAPP.APPLICATION_MESSAGE_API", line 463
ORA-06512: at "IFSAPP.APP_MESSAGE_PROCESSING_API", line 751
ORA-06512: at "IFSAPP.APP_MESSAGE_PROCESSING_API", line 756
ORA-06512: at line 1		        5,779,086
ORA-20111: ApplicationMessage.NOTEXIST: The Application Message "379851" does not exist.
ORA-06512: at "IFSAPP.ERROR_SYS", line 138
ORA-06512: at "IFSAPP.ERROR_SYS", line 376
ORA-06512: at "IFSAPP.APPLICATION_MESSAGE_API", line 2003
ORA-06512: at "IFSAPP.APPLICATION_MESSAGE_API", line 2024
ORA-06512: at "IFSAPP.APPLICATION_MESSAGE_API", line 456
ORA-06512: at "IFSAPP.APPLICATION_MESSAGE_API", line 463
ORA-06512: at "IFSAPP.APP_MESSAGE_PROCESSING_API", line 751
ORA-06512: at "IFSAPP.APP_MESSAGE_PROCESSING_API", line 756
ORA-06512: at line 1		        5,779,206

 

 

How can I investigate this and stop the millions of records from appearing?

 

Thank you.

icon

Best answer by Charith Epitawatta 14 May 2021, 13:32

View original

2 replies

N
Rank
Userlevel 7
Badge +11

Hi @johnw66,

Try searching the database by SELECT * FROM application_message for the message id if the message is not visible in IEE. Also look for any deliveries/deployments made to the environment on a date range that could affect the behaviour: you could query in modul_tab table for that. And you could also check for event actions in fnd_event_action view (check created/modified date columns within the time period) to see whether there are any events with schedules...

 

- Nalaka -
Charith Epitawatta
Rank
Userlevel 7
Badge +31

Hi @johnw66,

There is a bug associated with this particular issue where the Integration Server tries to process a non existing application message again and again. You would probably see the same error flooding Integration Server logs as well.

There is a fix for this in IFSAPP10 UPD9 via patch ID 153502 (Global Solution ID - 285205).

Alternatively, as a workaround, you can clear the persistent stores in Weblogic by deleting the DAT files in following locations and restarting the Integration Server:

\\<IFS_HOME>\wls_domain<InstanceID>\servers\IntServer2\data\store\diagnostics
\\<IFS_HOME>\wls_domain<InstanceID>\servers\IntServer2\data\store\defa

Hope this helps!

Charith - https://charith.xyz

Reply


Terms & ConditionsCookie settings