cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SEVERE: couldn't connect to DB

Go to solution
Former Member

on ‎02-15-2008 5:02 PM

0 Kudos

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)

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎02-15-2008 8:01 PM
0 Kudos

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

Show replies
Show replies
Former Member
‎04-09-2008 8:06 AM
0 Kudos

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

Former Member
‎04-10-2008 12:46 AM
0 Kudos

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

Answers (2)

Answers (2)

Former Member
‎07-03-2008 4:25 PM
0 Kudos

!!!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.

Show replies
Show replies
Former Member
‎08-14-2008 10:11 PM
0 Kudos

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

Former Member
‎04-11-2008 10:29 AM
0 Kudos

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!

Show replies
Show replies
Former Member
‎04-15-2008 9:06 AM
0 Kudos

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?.

Ask a Question