Skip to main content
Solved

Millions of IFSCONNECT records appearing in IFSAPP.SERVER_LOG_TAB

R
Superhero (Partner)
Forum|alt.badge.img+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.

Best answer by Charith Epitawatta

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!

View original
Did this topic help you find an answer to your question?

2 replies

N
Hero (Employee)
Forum|alt.badge.img+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
P
2 people like this
  • Charith Epitawatta
    Charith Epitawatta
  • P
    Pabasara Gunathilaka
Charith Epitawatta
Ultimate Hero (Employee)
Forum|alt.badge.img+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.pro
N
1 person likes this
  • N
    Nalaka Samarasinghe

Reply


Related Topics

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings