timeout setting on the Data Server and on the Configtool

[former_member323997]

Hello,

We are using the MII to run some queries to our Oracle database, therefore we defined the Data Server in MII, one setting is related to timeout. In the meantime, I also know that on the NetWeaver Configtool - ts area we also can define the TransactionTimeout.    

Here are the setting we had for testing:

On the data server page, we define the timeout 1, it means 1 minute

On the Configtool Transaction Timeout, we define the timeout 300, which means 5 minutes.

We then sent a heavy query from MII workbench to Oracle. And this query did run more than 1 minutes from the Oracle perspective. But what we saw is that, the Oracle session didn't stop after 1 minute. I don't understand here, because it seems the Data Server timeout setting does not influence the session to Oracle.

Can you please explain to me what the relationship between those timeout?

Thanks & regards,

Leon

[Former Member]

Hi Leon,

I think the Timeout in SAP MII means the time after which the connection object is returned to the Connection Pool. SAP MII will not try to cancel the session created in the System where you made the connection.

So in your case as the query took more than 1 minute so the connection object would be returned to the connection pool of MII and will not wait for the response to come from Oracle database. So the session created in Oracle database will not get effected. Just that there is no one to listen to its response.

Regards,

Rohit Negi.

[former_member323997]

Hi Rohit,

Thanks for the reply. I have one more question: From your description, where is the right place to set the timeout for the Oracle database session? The timeout setting in the NetWeaver - configtool ?

We would like to control the heavy query from the MII to Oracle, that is the reason we are trying to find where is the place.

Thanks & regards,

Leon

[Former Member]

Hi Leon,

MII workbench is a client to the Oracle database and here the Netweaver will also not come into picture as you are connection to the Oracle database through the driver you would have uploaded in the JDBC Drivers screen in MII.

Check the Oracle JDBC driver documentation to see if something is there.

Also I think this thing will be handled in the database itself. So you need to check Oracle database documentation also.

Regards,

Rohit Negi.