on 02-15-2008 5:02 PM
Hi folks,
I have encountered a serious problem during SAP NetWeaver 7.00 installation. In the progress bar it fails when it reaches the "Import Java Dump" phase. The content for sapinst.log and jload.log have been appended below. Any help is appreciated.
Sapinst.log
ERROR 2008-02-15 15:53:06
CJS-30049 <html>Execution of JLoad tool '/opt/java1.4/bin/java -classpath /tmp/sapinst_instdir/NW04S/
SYSTEM/ORA/CENTRAL/AS/install/sharedlib/launcher.jar -showversion -Xmx512m -Xmpas:on -d64 com.sap.engi
ne.offline.OfflineToolStart com.sap.inst.jload.Jload /tmp/sapinst_instdir/NW04S/SYSTEM/ORA/CENTRAL/AS/
install/lib/iaik_jce.jar:/tmp/sapinst_instdir/NW04S/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/jload.jar:
/tmp/sapinst_instdir/NW04S/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/antlr.jar:/tmp/sapinst_instdir/NW04
S/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/exception.jar:/tmp/sapinst_instdir/NW04S/SYSTEM/ORA/CENTRAL/
AS/install/sharedlib/jddi.jar:/tmp/sapinst_instdir/NW04S/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/loggi
ng.jar:/tmp/sapinst_instdir/NW04S/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/offlineconfiguration.jar:/tm
p/sapinst_instdir/NW04S/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/opensqlsta.jar:/tmp/sapinst_instdir/NW
04S/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/tc_sec_secstorefs.jar:/oracle/client/10x_64/instantclient/
ojdbc14.jar -sec S0H,jdbc/pool/S0H,/usr/sap/S0H/SYS/global/security/data/SecStore.properties,/usr/sap/
S0H/SYS/global/security/data/SecStore.key -dataDir /prog/depot/NW_2004s_SR2/NW_2004s_SR2_Java_based_So
ftware_Components/JAVA_EXPORT/JDMP -job /tmp/sapinst_instdir/NW04S/SYSTEM/ORA/CENTRAL/AS/IMPORT.XML -l
og jload.log' aborts with return code 1.<br>SOLUTION: Check 'jload.log' and '/tmp/sapinst_instdir/NW04
S/SYSTEM/ORA/CENTRAL/AS/jload.java.log' for more information.</html>
jload.log
15.02.08 14:22:01 com.sap.inst.jload.Jload main
INFO: Jload -sec S0H,jdbc/pool/S0H,/usr/sap/S0H/SYS/global/security/data/SecStore.properties,/usr/sap/
S0H/SYS/global/security/data/SecStore.key -dataDir /prog/depot/NW_2004s_SR2/NW_2004s_SR2_Java_based_So
ftware_Components/JAVA_EXPORT/JDMP -job /tmp/sapinst_instdir/NW04S/SYSTEM/ORA/CENTRAL/AS/IMPORT.XML -l
og jload.log
15.02.08 14:22:06 com.sap.inst.jload.Jload main
SEVERE: couldn't connect to DB
15.02.08 14:22:06 com.sap.inst.jload.Jload logStackTrace
SEVERE: java.sql.SQLException: Io exception: Invalid number format for port number
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:420)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.jav
a:215)
at com.sap.sql.connect.OpenSQLDataSourceImpl.createConnection(OpenSQLDataSourceImpl.java:522)
at com.sap.sql.connect.OpenSQLDataSourceImpl.getConnection(OpenSQLDataSourceImpl.java:276)
at com.sap.inst.jload.db.DBConnection.connectViaSecureStore(DBConnection.java:105)
at com.sap.inst.jload.db.DBConnection.connect(DBConnection.java:149)
at com.sap.inst.jload.Jload.main(Jload.java:580)
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)
...skipping...
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)
This could happen when ports are not correctly maintained in listener.ora /sqlnet.ora.
Could you please check those files ?
Also, if the installation has already passed the point where configtool directory exists, please start the config tool and make sure that in the secure store the URL to connect to DB is correctly maintained.
http://help.sap.com/saphelp_nw70/helpdata/en/ec/9432d189c445cdacdc7e520981b4b6/frameset.htm
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
I am trying to connect MS SQL 2005 though config tool.
I am not able to connect to Default database.So I am trying to connect manually by mentioning all the info of database.
I followed the url
http://help.sap.com/saphelp_nw04s/helpdata/en/ec/9432d189c445cdacdc7e520981b4b6/content.htm
but not sure of all values(3 a to h from URL) to be entered to connect to database.Could you please let me know as what vales have to be given for the following
e)RDBMS Connections contains a property key of which the value contains the DB connection settings.
f)RDBMS Driver Location contains the path to the RDBMS driver
Appreciate the help
Regards,
Santhosh
Hello Santosh,
Giving an example below from my test instance 'ABC' on machine nspadabc :
This will only give you an idea of what needs to be maintained. You will need to change the values as per your host and instance.
Secure Store File :
nspadabc\sapmnt\ABC\SYS\global\security\data\SecStore.properties
Secure Store Key File :
nspadabc\sapmnt\ABC\SYS\global\security\data\SecStore.key
System Name : ABC
Secure Store Lib :
nspadabc\sapmnt\ABC\SYS\global\security\lib
RDBMS Connections : jdbc/pool/ABC
RDBMS Driver Location : D:\sapdb\programs\runtime\jar\sapdbc.jar
(I am using SAPDB for which the driver resides at the above location. In your case, since you are using MSSQL, you will need to find the correct driver file and put that path here as shown above. I thnk it should be the path to util.jar, spy.jar and sqlserver.jar)
RDBMS Initial Connections : 1
RDBMS Maximum Connections : 5
You don't necessarily have to overwrite secure store entry settings. But just in case you need to :
RDBMS URL : jdbc:sapdb://10.48.150.95/TDS?timeout=0
(this is an example of SAPDB again. You need to put a url for MSSQL database, I think it would be something like :
jdbc:datadirect:sqlserver://<host>:<port>;databasename=<databasename>
)
user name for connecting to the database : SAPABCDB (usually SAP<instance name>DB)
password : password for SAPABCDB
Hope this helps.
Regards,
Snehal
!!!URGENT!!!
Dear Gurus...
I´m installing ECC6 With SQL Server 2005, Distributed System.
I have instaled SCS instance sucessfully. Thus I´m facing the same issue in database instance exactly in step 18 "Import Java Dump". The user SAPPRDDB exist in database and no have problems with password.
Follows my sapinst.log.
"
WARNING 2008-07-02 16:55:05
Execution of the command "C:j2sdk1.4.2_13-x64 injava.exe -classpath "C:Program Filessapinst_instdirERPSYSTEMMSSDISTRIBUTEDASDBinstallsharedliblauncher.jar" -showversion -Xmx512m com.sap.engine.offline.OfflineToolStart com.sap.inst.jload.Jload "C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/DISTRIBUTED/AS/DB/install/lib/iaik_jce.jar;C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/DISTRIBUTED/AS/DB/install/sharedlib/jload.jar;C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/DISTRIBUTED/AS/DB/install/sharedlib/antlr.jar;C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/DISTRIBUTED/AS/DB/install/sharedlib/exception.jar;C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/DISTRIBUTED/AS/DB/install/sharedlib/jddi.jar;C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/DISTRIBUTED/AS/DB/install/sharedlib/logging.jar;C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/DISTRIBUTED/AS/DB/install/sharedlib/offlineconfiguration.jar;C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/DISTRIBUTED/AS/DB/install/sharedlib/opensqlsta.jar;C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/DISTRIBUTED/AS/DB/install/sharedlib/tc_sec_secstorefs.jar;
sapprodap/sapmnt/PRD/SYS/exe/uc/NTAMD64/mssjdbc/base.jar;
sapprodap/sapmnt/PRD/SYS/exe/uc/NTAMD64/mssjdbc/util.jar;
sapprodap/sapmnt/PRD/SYS/exe/uc/NTAMD64/mssjdbc/sqlserver.jar;
sapprodap/sapmnt/PRD/SYS/exe/uc/NTAMD64/mssjdbc/spy.jar" -sec PRD,jdbc/pool/PRD,
sapprodap/sapmnt/PRD/SYS/global/security/data/SecStore.properties,
sapprodap/sapmnt/PRD/SYS/global/security/data/SecStore.key -dataDir "G:/SAP downloads/Java_componentsJAVA_EXPORTJDMP" -job "C:Program Filessapinst_instdirERPSYSTEMMSSDISTRIBUTEDASDBIMPORT.XML" -log jload.log" finished with return code 1. Output:
java version "1.4.2_13"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_13-b06)
Java HotSpot(TM) 64-Bit Server VM (build 1.4.2_13-b06, mixed mode)
Jul 2, 2008 4:55:04 PM com.sap.inst.jload.Jload main
INFO: Jload -sec PRD,jdbc/pool/PRD,
sapprodap/sapmnt/PRD/SYS/global/security/data/SecStore.properties,
sapprodap/sapmnt/PRD/SYS/global/security/data/SecStore.key -dataDir G:/SAP downloads/Java_componentsJAVA_EXPORTJDMP -job C:Program Filessapinst_instdirERPSYSTEMMSSDISTRIBUTEDASDBIMPORT.XML -log jload.log
Jul 2, 2008 4:55:05 PM com.sap.inst.jload.Jload main
SEVERE: couldn't connect to DB
Jul 2, 2008 4:55:05 PM com.sap.inst.jload.Jload logStackTrace
SEVERE: java.sql.SQLException: [SQLServer JDBC Driver][SQLServer]Login failed for user 'SAPPRDDB'.
at com.sap.nwmss.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.sap.nwmss.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.sap.nwmss.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.sap.nwmss.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.sap.nwmss.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)
at com.sap.nwmss.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.sap.nwmss.jdbc.sqlserver.tds.TDSLoginRequest.submitRequest(Unknown Source)
at com.sap.nwmss.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.sap.nwmss.jdbc.base.BaseConnection.connect(Unknown Source)
at com.sap.nwmss.jdbc.base.BaseConnection.setupImplConnection(Unknown Source)
at com.sap.nwmss.jdbc.base.BaseConnection.open(Unknown Source)
at com.sap.nwmss.jdbc.base.BaseDriver.connect(Unknown Source)
at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215)
at com.sap.sql.connect.OpenSQLDataSourceImpl.createConnection(OpenSQLDataSourceImpl.java:522)
at com.sap.sql.connect.OpenSQLDataSourceImpl.getConnection(OpenSQLDataSourceImpl.java:276)
at com.sap.inst.jload.db.DBConnection.connectViaSecureStore(DBConnection.java:105)
at com.sap.inst.jload.db.DBConnection.connect(DBConnection.java:149)
at com.sap.inst.jload.Jload.main(Jload.java:580)
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)
ERROR 2008-07-02 16:55:05
CJS-30049 Execution of JLoad tool 'C:j2sdk1.4.2_13-x64 injava.exe -classpath "C:Program Filessapinst_instdirERPSYSTEMMSSDISTRIBUTEDASDBinstallsharedliblauncher.jar" -showversion -Xmx512m com.sap.engine.offline.OfflineToolStart com.sap.inst.jload.Jload "C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/DISTRIBUTED/AS/DB/install/lib/iaik_jce.jar;C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/DISTRIBUTED/AS/DB/install/sharedlib/jload.jar;C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/DISTRIBUTED/AS/DB/install/sharedlib/antlr.jar;C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/DISTRIBUTED/AS/DB/install/sharedlib/exception.jar;C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/DISTRIBUTED/AS/DB/install/sharedlib/jddi.jar;C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/DISTRIBUTED/AS/DB/install/sharedlib/logging.jar;C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/DISTRIBUTED/AS/DB/install/sharedlib/offlineconfiguration.jar;C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/DISTRIBUTED/AS/DB/install/sharedlib/opensqlsta.jar;C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/DISTRIBUTED/AS/DB/install/sharedlib/tc_sec_secstorefs.jar;
sapprodap/sapmnt/PRD/SYS/exe/uc/NTAMD64/mssjdbc/base.jar;
sapprodap/sapmnt/PRD/SYS/exe/uc/NTAMD64/mssjdbc/util.jar;
sapprodap/sapmnt/PRD/SYS/exe/uc/NTAMD64/mssjdbc/sqlserver.jar;
sapprodap/sapmnt/PRD/SYS/exe/uc/NTAMD64/mssjdbc/spy.jar" -sec PRD,jdbc/pool/PRD,
sapprodap/sapmnt/PRD/SYS/global/security/data/SecStore.properties,
sapprodap/sapmnt/PRD/SYS/global/security/data/SecStore.key -dataDir "G:/SAP downloads/Java_componentsJAVA_EXPORTJDMP" -job "C:Program Filessapinst_instdirERPSYSTEMMSSDISTRIBUTEDASDBIMPORT.XML" -log jload.log' aborts with return code 1.
SOLUTION: Check 'jload.log' and 'C:/Program Files/sapinst_instdir/ERP/SYSTEM/MSS/DISTRIBUTED/AS/DB/jload.java.log' for more information.
ERROR 2008-07-02 16:55:05
FCO-00011 The step importJavaDump with step key |NW_Doublestack_DB|ind|ind|ind|ind|0|0|NW_CreateDBandLoad|ind|ind|ind|ind|9|0|NW_Jload|ind|ind|ind|ind|9|0|importJavaDump was executed with status ERROR ."
My Environment
Windows 2003 Enterprise Edition 64 bits
SAP ECC6 64 bits installation
MS SQL SERVER 2005 64bits
Reward points to solution...
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I was able to resolve this issue by doing following :
1. Open SQL Server Config manager ( for sql 2005 )
goto SQL Server 2005 Network Configuration
Protocol for <SID>
Select TCP/IP and make sure Protocol Active and Enabled for all IP addresses .. just make that change ..you can keep dynamic port .
Restart SQL Server Services
2. Start SQL Server Browser
=
After that retry or restaret sapinst.exe
Hi Erik,
For Oracle database, I managed to resolve the problem by opening the secure store (using the configtool) and editing the value for key jdbc/pool/<SID>/Url as "jdbc:oracle:thin:@hostname:port:DBSID". The port should match the value in the listener.ora file. eg: jdbc:oracle:thin:@sgsgpsv0019:1527:MSX.
Before editing, the key value was jdbc:oracle:thin:@sgsgpsv0019:unindentified:MSX
Hope this helps!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello All,
Can you please give tips to solve the same issue with respect to MS SQL 2005. As per snehals advice, we copied the config.properties to the config tools directory ( from another server and renamed the SID and hostname ) and tried to connect again.
But it is stucked with java errors.
###
Exception occurred in openJar(null) :
java.io.IOException: Jar name is null
at com.sap.engine.offline.JarFilter.<init>(JarFilter.java:25)
at com.sap.engine.offline.FileClassLoader.openJar(FileClassLoader.java:1
131)
at com.sap.engine.offline.FileClassLoader.findClass(FileClassLoader.java
:623)
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 com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnection
Pool.<init>(DBConnectionPool.java:108)
at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceH
andler.<init>(PersistenceHandler.java:38)
at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.<init
>(ConfigurationCache.java:149)
at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBoots
trapImpl.init(ConfigurationManagerBootstrapImpl.java:236)
at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBoots
trapImpl.<init>(ConfigurationManagerBootstrapImpl.java:49)
at com.sap.engine.configtool.visual.ConfigTool.loadClusterData(ConfigToo
l.java:99)
at com.sap.engine.configtool.visual.ConfigTool.initScan(ConfigTool.java:
87)
at com.sap.engine.configtool.visual.ConfigTool.<init>(ConfigTool.java:82
)
at com.sap.engine.configtool.visual.ConfigTool.main(ConfigTool.java:961)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81
)
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.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.NoClassDefFoundError: com/sap/nwmss/util/UtilDummyPrintWrit
er
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:141)
at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(Nativ
eConnectionFactory.java:134)
at com.sap.sql.connect.OpenSQLDataSourceImpl.createPooledConnection(Open
SQLDataSourceImpl.java:608)
at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQL
DataSourceImpl.java:285)
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnection
Pool.createConnection(DBConnectionPool.java:302)
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnection
Pool.<init>(DBConnectionPool.java:125)
at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceH
andler.<init>(PersistenceHandler.java:38)
at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.<init
>(ConfigurationCache.java:149)
at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBoots
trapImpl.init(ConfigurationManagerBootstrapImpl.java:236)
at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBoots
trapImpl.<init>(ConfigurationManagerBootstrapImpl.java:49)
####
On secure store, the correct java class as well as the URL was specified. However the following parameters like admin/host/name and admin/host/password was not there which I added manually.
Can you please let me know what else have to be checked?.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.