CJS-30071 Execution of UTL tool

[Former Member]

Hi All,

I am performing homogeneous system copy on my SAP BI system (dual Stack). But during export process of sourcing system, got stuck and not able proceed.

Getting the below error, tried replacing the sqljdbc.jar file. but not luck.

ERROR 2012-12-17 21:57:55

CJS-30071  Execution of UTL tool 'C:\j2sdk1.4.2_21-x64\bin\java.exe -classpath F:\usr\sap\BID\SYS\global\sltools\sharedlib\launcher.jar -showversion -Xmx256m com.sap.engine.offline.OfflineToolStart com.sap.sl.ut.manager.UtlMain \\sapdevbibo/sapmnt/BID/SYS/global/security/lib/tools/iaik_jce.jar;\\sapdevbibo/sapmnt/BID/SYS/globa... -export -type=keydb "-expfile=C:/Program Files/sapinst_instdir/NW04S/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/usages_data.xml" -log=UTL_load_usages.log -sid=BID -dsn=jdbc/pool/BID -ssprops=F:/usr/sap/BID/SYS/global/security/data/SecStore.properties -ssk=F:/usr/sap/BID/SYS/global/security/data/SecStore.key' aborts due to database connection error with return code 64.<br>DIAGNOSIS: The connection parameters are wrong or the database server is shutdown.<br> SOLUTION: Check 'UTL_load_usages.log' and 'C:/Program Files/sapinst_instdir/NW04S/LM/COPY/MSS/EXP/CENTRAL/AS/EXP/UTL.java.log' for more information.

Exception : The DataBase is down or the connection parameters are wrong: -sid=BID -dsn=jdbc/pool/BID -ssprops=F:/usr/sap/BID/SYS/global/security/data/SecStore.properties -ssk=F:/usr/sap/BID/SYS/global/security/data/SecStore.key -keyphrase=null

java.lang.Exception

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

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

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

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

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

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

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

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

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

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

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

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

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

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

Regards
Ponnusamy

[Former Member]

Hi Ponnusamy,

Set JAVA_HOME environment variable.

JAVA_HOME=C:\j2sdk1.4.2_21-x64\

[Former Member]

Hi Srinivasan,

I already set the JAVA_HOME variable under system and user. But still the same error.

Regards

Ponnusamy

[Former Member]

Hi Ponnu,

Please send UTL.java.log file

[Former Member]

Hi Srinivasan,

Below is the logs,
UTL.java.log

java version "1.4.2_21"

Java(TM) Platform, Standard Edition for Business (build 1.4.2_21-b03)

Java HotSpot(TM) 64-Bit Server VM (build 1.4.2_21-b03, mixed mode)

==============

UTL_load_usages.log

=============

<!--LOGHEADER[START]/-->
<!--HELP[Manual modification of the header may cause parsing problem!]/-->
<!--LOGGINGVERSION[1.5.3.7185 - 630]/-->
<!--NAME[UTL_load_usages.log]/-->
<!--PATTERN[UTL_load_usages.log]/-->
<!--FORMATTER[com.sap.tc.logging.TraceFormatter(%24d %7s: %m)]/-->
<!--ENCODING[UTF8]/-->
<!--LOGHEADER[END]/-->
Dec 20, 2012 7:55:22 PM  Info   : Successfully parsed!
Dec 20, 2012 7:55:22 PM  Info   : Executing command Export...
Dec 20, 2012 7:55:22 PM  Info   : Establishing DB connection...
Dec 20, 2012 7:55:24 PM  Path   : Exception : The DataBase is down or the connection parameters are wrong: -sid=BID -dsn=jdbc/pool/BID -ssprops=F:/usr/sap/BID/SYS/global/security/data/SecStore.properties -ssk=F:/usr/sap/BID/SYS/global/security/data/SecStore.key -keyphrase=null
java.lang.Exception
at com.sap.exception.BaseExceptionInfo.traceAutomatically(BaseExceptionInfo.java:1175)
at com.sap.exception.BaseExceptionInfo.<init>(BaseExceptionInfo.java:423)
at com.sap.exception.BaseException.<init>(BaseException.java:316)
at com.sap.sl.ut.infoprovider.exceptions.UTInfoException.<init>(UTInfoException.java:99)
at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.connect(DataBaseInfoFactory.java:398)
at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.constructSystemInfo(DataBaseInfoFactory.java:795)
at com.sap.sl.ut.manager.command.Export.execute(Export.java:36)
at com.sap.sl.ut.manager.command.Command.exec(Command.java:90)
at com.sap.sl.ut.manager.UtlMain.exec(UtlMain.java:61)
at com.sap.sl.ut.manager.UtlMain.main(UtlMain.java:56)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)
Caused by: com.sap.sql.log.OpenSQLException: Could not load class com.microsoft.sqlserver.jdbc.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:396)
at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.constructSystemInfo(DataBaseInfoFactory.java:795)
at com.sap.sl.ut.manager.command.Export.execute(Export.java:36)
at com.sap.sl.ut.manager.command.Command.exec(Command.java:90)
at com.sap.sl.ut.manager.UtlMain.exec(UtlMain.java:61)
at com.sap.sl.ut.manager.UtlMain.main(UtlMain.java:56)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)
Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.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(ClassLoader.java:302)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:141)
at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:134)
... 15 more
caused by
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.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(ClassLoader.java:302)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:141)
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:396)
at com.sap.sl.ut.manager.persistence.db.DataBaseInfoFactory.constructSystemInfo(DataBaseInfoFactory.java:795)
at com.sap.sl.ut.manager.command.Export.execute(Export.java:36)
at com.sap.sl.ut.manager.command.Command.exec(Command.java:90)
at com.sap.sl.ut.manager.UtlMain.exec(UtlMain.java:61)
at com.sap.sl.ut.manager.UtlMain.main(UtlMain.java:56)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

Dec 20, 2012 7:55:24 PM  Info   : Severe (database) error. Return code: 64

Regards

Ponnusamy

[Former Member]

Hi Ponnusamy,

Refer to SAP Note "1145221 - JDBC driver exchange to Microsoft JDBC Driver"

[Former Member]

Hi Srinivasan,

I followed the below note and replaced the driver.

Note 639702 - JDBC Driver for Microsoft SQL Server.

Regards

Ponnusamy