Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQL Server 2000 problem with MII Version 12.1.8 Build(24) Reconnecting

Hi,

I have a problem using XMII Version 12.1.8 Build(24) with com.microsoft.sqlserver.jdbc.SQLServerDriver JDBC driver with SQL 2000.

The problem we have is the machine where the SQL server is installed on reboot as per schedule once a week. When the server comes back online, XMII seems to get problem to reconnect correctly. Sometimes it reconnects perfectly, sometimes not.

When it fails, the only way to fix the problem is to uncheck the 'Enabled' checkbox, then save the data server, then check the 'Enabled' checkbox, then save again.

When the reconnect issue happens, uploading messages to SAP fail 100% of time, but downloading Control Recipes from SAP works 50% of time. For example, some PO's can be processed correctly, some others not, causing data losses due to poor data buffering(buffering doesn't cover connection time out). The failed PO's are marked as 'Sent' into CO53 SAP transaction but in fact, are lost in a hole causing data losses.

See the error we get atfer the server reboot:

Unable to get a connection from the pool

[EXCEPTION]

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host VANASR70, port 1433 has failed. Error: "connect timed out. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting... [see details]

Cannot create a connection to the database

[EXCEPTION]

com.sap.xmii.Illuminator.system.CommunicationException: Cannot create a connection to the database... [see details]

Error processing transaction com.sap.xmii.bls.engine.TransactionInstance@cee764f

[EXCEPTION]

com.sap.xmii.scheduler.CronException: PMU ERR VAN - Cannot Qry MSIDs.... [see details]

Unable to get a connection from the pool

[EXCEPTION]

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host VANASR70, port 1433 has failed. Error: "Connection refused. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting... [see details]

Unable to get a connection from the pool

[EXCEPTION]

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host VANASR70, port 1433 has failed. Error: "connect timed out. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting... [see details]

The only way we have thought to workaround this problem is to develop our own buffering method into XMII workbench puting all data received from SAP or SQL insert query into an Oracle temp database. We should probably be able to fix this by this way, but it reprensents many costs and efforts, so we try to avoid this for sure.

Please, if you can provide us a patches or hints about how to fix this, it could be very appreciated because loosing data is very anoying.

Thanks a lot!

Edited by: mrmans on May 19, 2011 5:48 PM

Edited by: Michael Appleby on May 19, 2011 6:10 PM

Former Member
Not what you were looking for? View more on this topic or Ask a question