cancel
Showing results for 
Search instead for 
Did you mean: 

Migration export failure due to database connection issue

Former Member
0 Kudos

Hello ,

We are trying to export the portal databse which is on MSCS clustor environment. Database is on MSSQL server 2000. But we have trouble in the initial phase itself while connecting to database using sapinst installer SR3 version. Actully the problem is only on clustor environments. We have exported the in standalone environments it works fine ..

does any one come across this situation in sqlserver clustor environment, please find the log..

<!LOGHEADERSTART/>

<!HELPManual modification of the header may cause parsing problem!/>

<!LOGGINGVERSIONhttp://1.5.3.7185 - 630/>

<!NAMEhttp://UTL_load_usages.log/>

<!PATTERNhttp://UTL_load_usages.log/>

<!FORMATTERcom.sap.tc.logging.TraceFormatter(%24d %7s: %m)/>

<!ENCODINGCp1252/>

<!LOGHEADEREND/>

Feb 12, 2009 4:41:37 PM Info : Successfully parsed!

Feb 12, 2009 4:41:37 PM Info : Executing command Export...

Feb 12, 2009 4:41:37 PM Info : Establishing DB connection...

Feb 12, 2009 4:41:39 PM Path : Exception : The DataBase is down or the connection parameters are wrong: -sid=TP1 -dsn=jdbc/pool/TP1 -ssprops=R:/usr/sap/TP1/SYS/global/security/data/SecStore.properties -ssk=R:/usr/sap/TP1/SYS/global/security/data/SecStore.key -keyphrase=null

java.lang.Exception

at com.sap.exception.BaseExceptionInfo.traceAutomatically(BaseExceptionInfo.java:1141)

at com.sap.exception.BaseExceptionInfo.<init>(BaseExceptionInfo.java:413)

at com.sap.exception.BaseException.<init>(BaseException.java:302)

at com.sap.sl.ut.infoprovider.exceptions.UTInfoException.<init>(UTInfoException.java:96)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.connect(DataBaseInfoFactory.java:215)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.constructSystemInfo(DataBaseInfoFactory.java:624)

at com.sap.sl.ut.manager.command.Export.executeExportKDB(Export.java:56)

at com.sap.sl.ut.manager.command.Export.execute(Export.java:80)

at com.sap.sl.ut.manager.command.Command.exec(Command.java:88)

at com.sap.sl.ut.manager.UtlMain.exec(UtlMain.java:60)

at com.sap.sl.ut.manager.UtlMain.main(UtlMain.java:56)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

Caused by: com.sap.sql.log.OpenSQLException: Could not load class com.sap.nwmss.jdbc.sqlserver.SQLServerDriver.

at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:106)

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:143)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createConnection(OpenSQLDataSourceImpl.java:522)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getConnection(OpenSQLDataSourceImpl.java:276)

at com.sap.sl.ut.manager.persistence.db.DBConnection.connectViaSecureStore(DBConnection.java:159)

at com.sap.sl.ut.manager.persistence.db.DBConnection.connect(DBConnection.java:171)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.connect(DataBaseInfoFactory.java:213)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.constructSystemInfo(DataBaseInfoFactory.java:624)

at com.sap.sl.ut.manager.command.Export.executeExportKDB(Export.java:56)

at com.sap.sl.ut.manager.command.Export.execute(Export.java:80)

at com.sap.sl.ut.manager.command.Command.exec(Command.java:88)

at com.sap.sl.ut.manager.UtlMain.exec(UtlMain.java:60)

at com.sap.sl.ut.manager.UtlMain.main(UtlMain.java:56)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

Caused by: java.lang.ClassNotFoundException: com.sap.nwmss.jdbc.sqlserver.SQLServerDriver

at com.sap.engine.offline.FileClassLoader.findClass(FileClassLoader.java:691)

at com.sap.engine.offline.FileClassLoader.loadClass(FileClassLoader.java:600)

at com.sap.engine.offline.FileClassLoader.loadClass(FileClassLoader.java:578)

at java.lang.ClassLoader.loadClassInternal(Unknown Source)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Unknown Source)

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:134)

... 16 more

caused by

java.lang.ClassNotFoundException: com.sap.nwmss.jdbc.sqlserver.SQLServerDriver

at com.sap.engine.offline.FileClassLoader.findClass(FileClassLoader.java:691)

at com.sap.engine.offline.FileClassLoader.loadClass(FileClassLoader.java:600)

at com.sap.engine.offline.FileClassLoader.loadClass(FileClassLoader.java:578)

at java.lang.ClassLoader.loadClassInternal(Unknown Source)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Unknown Source)

at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:134)

at com.sap.sql.connect.OpenSQLDataSourceImpl.createConnection(OpenSQLDataSourceImpl.java:522)

at com.sap.sql.connect.OpenSQLDataSourceImpl.getConnection(OpenSQLDataSourceImpl.java:276)

at com.sap.sl.ut.manager.persistence.db.DBConnection.connectViaSecureStore(DBConnection.java:159)

at com.sap.sl.ut.manager.persistence.db.DBConnection.connect(DBConnection.java:171)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.connect(DataBaseInfoFactory.java:213)

at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.constructSystemInfo(DataBaseInfoFactory.java:624)

at com.sap.sl.ut.manager.command.Export.executeExportKDB(Export.java:56)

at com.sap.sl.ut.manager.command.Export.execute(Export.java:80)

at com.sap.sl.ut.manager.command.Command.exec(Command.java:88)

at com.sap.sl.ut.manager.UtlMain.exec(UtlMain.java:60)

at com.sap.sl.ut.manager.UtlMain.main(UtlMain.java:56)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

Feb 12, 2009 4:41:39 PM Info : Severe (database) error. Return code: 64

Thanks in Advance..

Surendra

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Issue Resolved

Former Member
0 Kudos

Any pointers on how to solve this particular problem?

Thanks

Former Member
0 Kudos

Implemented this note Note 1109274 - New JDBC driver for NetWeaver 7.0 and higher

Upgraded the sqlserver driver from

com.sap.nwmss.jdbc.sqlserver.SQLServerDriver

To new value in Secure store (configtool)

com.microsoft.sqlserver.jdbc.SQLServerDriver

Which solved the problem.

Thanks,

Surendra