on 09-17-2009 8:37 AM
Hi all,
we have a problem with a database connection. If the connection fails, e.g. because of network problems, jobs got stuck. Thats ok, but when the connection is up again, MII cannot reconnect to the DB again, but seems to hung up itself. Processes in the Message Monitor remain in status running. After a while not even login to MII is possible.
Is there a possibility to "wake up" the connection without restarting MII? Can I reset something? Currently we are rebooting the whole system. We are using 12.0.2 (88).
I should also mention that I only have access to NetWeaver NWA, not the server level (Visual Admin etc.).
Michael
Do you have a validation query defined in your data server? I would also recommend updating to the latest sp.
Jamie
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Although it was addressing nuances with DB2, SAP Note 1346624 mentions data server system hanging symptoms, and SAP Note 1373034 also touched upon JDBC connections.
To Jamie's earlier point about upgrading, you mention being on 12.0.2 which is the first GA release of MII version 12 and there have been some tweaks in the JDBC connection pooling area that may very well have already addressed your issue.
If you have a sandbox or dev system on a newer release I would be curious to know if your problem does not happen, but if for some reason you must stay at 12.0.2 for the short term, then another option to consider would be to create a NetWeaver JDBC connection, and then change your data server to a Datasource connection. Deleting the existing one, creating a new one with the same name, but of type Datasource will allow all your query templates to work in the same capacity.
Jeremy,
thanks for the notes. Currently we have no time to upgrade, but looking at the fixed problems list described in the notes it would be a good thing to go up to 12.0.7 SP08. However as we also have to upgrade NW and Java, this it not done in a minute.
Using the Datasource would be an option. I successfully tried it once for an oracle connection and it worked fine. Meanwhile it seems that we have solved the connection problem, apparently some DNS settings have been wrong.
Michael
User | Count |
---|---|
8 | |
7 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.