Hi,
I am performing MWS migration from 10.5 to 10.15 .
Have migrated MWS cloned database to latest version using configurator and it migrated successfully.
After that during MWS default server migration using migration utility(migrate.bat),
Migration utility not able to establish db connection and giving error as below
20:35:55.650 [main] ERROR com.webMethods.portal.service.sql.core.provider.pool.ConnectionPoolManager - Error creating database connection to:
jdbc:wm:sqlserver://(Database Server Name):Port Number ;databaseName= ();AuthenticationMethod=ntlm
java.sql.SQLException: [SoftwareAG][SQLServer JDBC Driver]NTLM (type-2) Authentication was requested but the required DDJDBCx64Auth05.dll was not found on the path specified by the java.library.path system property.
at com.wm.dd.sqlserver.jdbc.base.BaseExceptions.b(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0098-0001.jar:?]
at com.wm.dd.sqlserver.jdbc.base.BaseExceptions.a(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0098-0001.jar:?]
at com.wm.dd.sqlserver.jdbc.base.BaseExceptions.b(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0098-0001.jar:?]
at com.wm.dd.sqlserver.jdbc.base.BaseExceptions.b(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0098-0001.jar:?]
at com.wm.dd.jdbc.sqlserver.tds.c.(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0098-0001.jar:?]
at com.wm.dd.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0098-0001.jar:?]
at com.wm.dd.sqlserver.jdbc.base.BaseConnection.c(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0098-0001.jar:?]
at com.wm.dd.sqlserver.jdbc.base.BaseConnection.fp(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0098-0001.jar:?]
at com.wm.dd.sqlserver.jdbc.base.BaseConnection.k(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0098-0001.jar:?]
at com.wm.dd.sqlserver.jdbc.base.BaseConnection.a(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0098-0001.jar:?]
at com.wm.dd.sqlserver.jdbc.base.BaseDriver.connect(Unknown Source) ~[com.softwareag.ext.dd.cjdbc_6.0.0.0098-0001.jar:?]
at java.sql.DriverManager.getConnection(DriverManager.java:677) ~[java.sql:?]
at java.sql.DriverManager.getConnection(DriverManager.java:228) ~[java.sql:?]
at com.webMethods.portal.service.sql.core.provider.pool.ConnectionPoolManager.create(ConnectionPoolManager.java:159) [com.webMethods.caf.server_10.15.0.0000-0385.jar:10.15.0.0000-0385]
at com.softwareag.mws.migrate.util.DbUtil.openDBConnection(DbUtil.java:187) [wm-mws-migrate.jar:10.15.0.0000-0385]
at com.softwareag.mws.migrate.cmd.CmdServerNodeMigratorClient.testDbOptions(CmdServerNodeMigratorClient.java:367) [wm-mws-migrate.jar:10.15.0.0000-0385]
at com.softwareag.mws.migrate.cmd.CmdServerNodeMigratorClient.setDbOptions(CmdServerNodeMigratorClient.java:313) [wm-mws-migrate.jar:10.15.0.0000-0385]
at com.softwareag.mws.migrate.cmd.CmdServerNodeMigratorClient.gatherServerNodeData(CmdServerNodeMigratorClient.java:248) [wm-mws-migrate.jar:10.15.0.0000-0385]
I’ve provided db alias as below ,
jdbc:wm:sqlserver://(Database Server Name):Port Number ;databaseName= ();AuthenticationMethod=ntlm
I’ve also provided DB user name and password in utility.
Same alias was worked fine during run of DB configurator but failing to establish db connection using migration utility.
I’ve checked all permission from db side and mws server side and provided required permissions.
Also, I’ve tried to apply below fix for DDJDBCx64Auth05.dll which is there in D:\SoftwareAG\common\bin in migrate.bat file. but, it didn’t work.
set SSO=D:\SoftwareAG\common\bin
set JAVA_OPTS=%JAVA_OPTS% -Djava.library.path=“%SSO%”
This issue I am only facing during execution of MWS migration utility.
Same DB alias of MWS cloned DB is working in case of IS migration from 10.5 to 10.15.
Can anyone help on this further?