Huge amount of INACTIVE sessions from SAP ME NW

[former_member323997]

Hello,

Today we experienced a SAP ME WIP database issue, the database reached to its maximum connections. After checking the database, we realized there were a lot of INACTIVE sessions from the SAP ME NetWeaver with the WIP user, so I think those inactive sessions are from the SAP ME system, many sessions were executed in the database level successfully but not cleared from the application point of view.

One of the example I can find there were more than 100 INACTIVE session is from this query:

select value$ from props$ where name = 'GLOBAL_DB_NAME'

Can you please confirm why this kind of behavior could happen? We basically only use the supported API, only very few cases we send the direct query from SAP ME.

Thanks & regards,

Leon

[sergiy_katerinich · Accepted solution]

Hi Leon,

You said that everything was executed successfully, but are you sure that your WIP database has enough permissions to access props$ table? If you logon to SQL Developer as WIP user, will this query return anything instead of failing with error message?

By default, an access to this table is not required, and thus I doubt SAP ME uses the data from props$ table.

The only place I can think about which collects some database related info is DB Diagnostics Report. But even there I do not see reading of GLOBAL_DB_NAME value.

Regards,

Sergiy

[former_member323997 · Accepted solution]

Hi Sergiy,

I tried this query select value$ from props$ where name = 'GLOBAL_DB_NAME' with WIP user, and got the error that the table or view does not exist.

Do you know what I am missing?

Thanks & regards,

Leon

[sergiy_katerinich · Accepted solution]

Leon,

I have not seen the rest of your findings, besides this query. So, I'm not sure what data you got and how you are analyzing it.

In fact, this is a good question to your DBA who can clarify which requests were coming from. If our DBA manages to prove the relation of this query to WIP database and NW, then you should submit his findings and reasoning to SAP Support team for deeper investigaion.

Regards,

Sergiy

[Former Member]

Hi Leon,

were you able to solve this issue? We face the same problem and don't know why...

Thank you and best regards

Fabian