Timeout

[latifa]

Hi Erman,

Users are facing a timeout disconnections (around 3 mins) while looking for customers in EBS.

We set The timeout to but no chnages:

ICX-Timeout 30 minutes
Forms Timeout    30 minutes
OHS Timeout 30 minutes

Error message:
Disconnections.docx

What could be this behavior.

Thank you for your help

Regards,
Latifa

[ErmanArslansOracleBlog]

This is a custom message Latifa. Custom error message.
Ask it to your developers first.. Start with this question: "In what conditions do you display this error?.."

[latifa]

The user has this error message while looking for a customer: using a responsiblity like FTA_AR_SUPERUTILISATEUR (OU07) (which UTILISATEUR means USER) --> client --> standard --> client and put the client id and search for.

I reproduced the issue and it took almost 5 min to appear.

Regards
Latifa

[ErmanArslansOracleBlog]

Did you ask your developers the question : "In what conditions do you display this error?.."

Because this seems like a custom error.

[latifa]

Yes I did Erman. Result: Silence. No reply.

How do you see that it looks like custom error. because it's written half frensh and the other english ?

Thank you Erman.

[ErmanArslansOracleBlog]

Okay.. The error message seemed strange, the error code was also strange and that's why I thought it was a custom error.
But now I changed my mind :)

It may be related with an Oracle application.. It may be a standard error of that Oracle Application..

However, this is not EBS.. RPG error code is strange.. It is like JD Edwards..
so what is this application? What is its name?

Note that, this error may be directly related with a db connection problem caused by a bug..
But I need to know the name of the application to go further..

[latifa]

Hi Erman,

I think RPG it's not a good indication. (RPG=Reverse Proxy Gassi).

The module involved in the search customer of the user is AR. It can succeed but after 3 to 5 mins

Running statistics in EBS doesn't change any thing.

Regards,
Latifa

[ErmanArslansOracleBlog]

what is Gassi? :)

What is the navigation for reproducing this issue? (EBS screen navigation)

[ErmanArslansOracleBlog]

Okay this error is produced by a thing in the middle of client and application server.
a proxy maybe.. something in the network..

So, that thing thinks your EBS application server is not responding, then?

anything in the oacore server related logs?

[latifa]

Hi Erman,

Oh sorry, Gassi : I think it's a network communication tool proper to the user (client).
Issue.docx

Regards,
Latifa

[ErmanArslansOracleBlog]

This is French Latifa :)

Please send the english version of it.
Also please send step by step screenshots, from login page , to the error screen.

[latifa]

So, that thing thinks your EBS application server is not responding, then?
--> We get the error message after 3 - 5 Min searching.

In the oacore log (application.log), there is sommething like:

18/03/05 09:19:22.220 html: 10.1.3.5.0 Started
18/03/05 09:19:25.197 html: oracle.apps.fnd.security.LeakDetectionFilter.initialized:1520237965197
18/03/05 09:19:25.197 html: LeakSetting:
        global:true,session:false,aggressive:false,stderr:false,appslog:false,corelog:false
        ignoring:null

[latifa]

Sorry :)

Here you are, I hope it's the right one (I ate a lot :)) :

Issue2.docx

So user put the customer looking for and he wait for 3 or 5 mins, after that the error message screen appear (that I sent before).

[ErmanArslansOracleBlog]

:) now it is ok.

So it is related with Oracle Trading Community.

did you see this note? ->

Customer Search After Update Has Poor Performance (Doc ID 2322052.1)

[latifa]

--> This note is about 12.2.4 and later (our system is 12.1.3)
--> this is for an updated customer

I don't think it's the same case. For us we just search for customer :)

can we use this note ?

[ErmanArslansOracleBlog]

Okay I see..

Check this note -> API Performance Issues: Standard Party Search API has Poor Performance (Doc ID 1577796.1)

If the above action doesn't solve your problem, then we need to investigate the issue from backend latifa :) I mean tracing the session from db to see what query it is running and what that query is waiting for..

[latifa]

Hi Erman,

The request didn't repair the issue :(

So as you said we should explore the issue from the back end I think...

How to do that Erman ?

Regards,
Latifa

[ErmanArslansOracleBlog]

For a quick investigation;

reproduce the issue from frontend and while the frontend is working, check the active db sessions, filter them and try to get the related one.
Get its query and check its explain plan.

Send me the query as well..

[latifa]

Hi Erman,

1. To query the sql_id for the right session, I run the script in this lynk:

https://dba.stackexchange.com/questions/8828/how-do-you-show-sql-executing-on-an-oracle-database

request.txt

2. Explain plan
expl_1.lst

Thank you in advance Erman.

Regards,
Latifa

[ErmanArslansOracleBlog]

It seems that query does a full table scan to HZ_PARTIES.

What is the object named "XXNCV_HZ_CUSTOMER_PARTY_FIND_V"

This seems custom, as it starts with "XX"

Please ask your developers about it.. This customization may affect the performance.

Check this note as well: Customer Workbench Performance Issue: Customer Search Using Account Number Or Other Fields Is Slow (Doc ID 1399774.1)