com.sap.xmii.Illuminator.logging.LHException: java.lang.NoClassDefFoundErro

[Former Member]

Hello,

Intermittently users get the following error when logging into the application which is built upon xmii:

com.microsoft.sqlserver.jdbc.SQLServerResource

At this point in the application it is trying to read information which is stored in a SQLServer database.

We see the following errors in trace files:

application [XMII] Processing HTTP request to servlet [Illuminator] finished with error.

The error is: com.sap.xmii.Illuminator.logging.LHException: com.sap.xmii.Illuminator.logging.LHException: java.lang.NoClassDefFoundError: com.microsoft.sqlserver.jdbc.SQLServerResource

Exception id: [00145E4D6... [see details]

This is running on a NW JavaAs 7.0 SP18, MII 12.0 SP8.

We've replaced the JDBC driver with one which SAP support told us would work, but that did not fix the problem either.

We can get the problem to go away for a period of time by simply disabling and then re-enabling the Data Server connection. It is using the IDBC Connector with a SQL connector type. STATUS shows No. Connections Used 0, No. Connections Available 1, Max No. Connections Used 2. Max. Wait Time 0.0.

Ideas?

[jcgood25]

A bit strange that your error mentions:

com.microsoft.sqlserver.jdbc.SQLServerResource

instead of :

com.microsoft.sqlserver.jdbc.SQLServerDriver

I would recommend you recheck all of your IDBC data server settings to confirm proper setup for the JDBCDriver. Depending upon how many active data server you have you might want to check the /XMII/Admin/ConnectionStatus.jsp page to see if any are not active.

This URL will also give you a list of the SQL type connections:

/XMII/Illuminator?Service=SystemInfo&Mode=ServerList&Method=SQL

[Former Member]

Hi John,

Before connecting SQL server with SAP MII, try connecting SQL server independently.

It helps to narrow down the problem.

If the independent connection works fine, try connecting with SAP MII with proper JDBC drivers

Go through the SAP Note 1109274 & forum

for more information on JDBC drivers.

Thanks

Rajesh Sivaprakasam.