Hello,
We just installed a fresh copy of MWS and the underlying db is MS SQL server. However while trying to bring the server up we are getting the below error,
Error Details:
1.
<log4j:event logger=“Framework” timestamp=“1393330355583” level=“FATAL” thread=“WrapperSimpleAppMain”>
log4j:message</log4j:message>
log4j:throwable<![CDATA[java.lang.IllegalStateException: [Pool - default]: can’t retrieve a object within 90 seconds.
-
<log4j:event logger=“Framework” timestamp=“1393330769748” level=“FATAL” thread=“WrapperSimpleAppMain”>
log4j:message</log4j:message>
log4j:throwable<![CDATA[java.sql.SQLInvalidAuthorizationSpecException: [sag-cjdbc42-0011][SQLServer JDBC Driver][SQLServer]Login failed for user ‘WMWMS’.
-
<log4j:event logger=“Framework” timestamp=“1393330859879” level=“FATAL” thread=“WrapperSimpleAppMain”>
log4j:message</log4j:message>
log4j:throwable<![CDATA[java.lang.IllegalStateException: [Pool - default]: can’t retrieve a object within 90 seconds.
Please find the msw.db.xml file details below,
<?xml version="1.0" encoding="UTF-8"?>
com.webmethods.portal.service.sql.core.BaseSqlWorker
com.webmethods.portal.service.sql.core.provider.pool.PooledConnectionProvider
com.wm.dd.jdbc.sqlserver.SQLServerDriver
jdbc:wm:sqlserver://157.184.229.183:1433;databaseName=wmdbden5
WMWMS
{DES}QuPg8sRwxPg=
false
SELECT COUNT(*) FROM TBLTHING WHERE IDTHING = 1
100
0
60
10
Can anyone tell me is there anything wrong in the configuration xml file above for sqlserver.
#MWS-CAF-Task-Engine#webMethods#webMethods-BPMS