Intermittently users get the following error when logging into the application which is built upon xmii:
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.