NW04- WEB AS-Java installation ,Error on step 18

[Former Member]

Hi Guys,

I do WEB-AS java installation and it stop @ step 18,I have JDK 1.4.2_09 installed and I changed the timezone for the installation to the German timezone,too.I download the recent

We have Microsoft windows server 2003 and MSSQL Server 2000.

The error that I've got is:

WARNING 2006-02-20 22:13:41

Execution of the command "C:\j2sdk1.4.2_09/bin/java.exe '-classpath' './sharedlib/antlr.jar;./sharedlib/exception.jar;./sharedlib/jddi.jar;./sharedlib/jload.jar;./sharedlib/logging.jar;./sharedlib/offlineconfiguration.jar;./sharedlib/opensqlsta.jar;./sharedlib/tc_sec_secstorefs.jar;C:\usr\sap/DP1/JC00/j2ee\jdbc\base.jar;C:\usr\sap/DP1/JC00/j2ee\jdbc\util.jar;C:\usr\sap/DP1/JC00/j2ee\jdbc\sqlserver.jar;C:\usr\sap/DP1/JC00/j2ee\jdbc\spy.jar;C:/usr/sap/DP1/SYS/global/security/lib/tools/iaik_jce_export.jar;C:/usr/sap/DP1/SYS/global/security/lib/tools/iaik_jsse.jar;C:/usr/sap/DP1/SYS/global/security/lib/tools/iaik_smime.jar;C:/usr/sap/DP1/SYS/global/security/lib/tools/iaik_ssl.jar;C:/usr/sap/DP1/SYS/global/security/lib/tools/w3c_http.jar' '-showversion' '-Xmx512m' 'com.sap.inst.jload.Jload' '-sec' 'DP1,jdbc/pool/DP1,C:\usr\sap\DP1\SYS\global/security/data/SecStore.properties,C:\usr\sap\DP1\SYS\global/security/data/SecStore.key' '-dataDir' 'E:/J2EE/DVD_NW_04_SR1_SAP_Web_AS_JAVA\J2EE_OSINDEP\J2EE-ENG/JDMP' '-job' 'C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_JAVA\ONE_HOST/IMPORT.XML' '-log' 'C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_JAVA\ONE_HOST/jload.log'" finished with return code 1. Output: java version "1.4.2_09"Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_09-b05)Java HotSpot(TM) Client VM (build 1.4.2_09-b05, mixed mode)20.02.2006 22:13:40 com.sap.inst.jload.Jload mainINFO: Jload -sec DP1,jdbc/pool/DP1,C:\usr\sap\DP1\SYS\global/security/data/SecStore.properties,C:\usr\sap\DP1\SYS\global/security/data/SecStore.key -dataDir E:/J2EE/DVD_NW_04_SR1_SAP_Web_AS_JAVA\J2EE_OSINDEP\J2EE-ENG/JDMP -job C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_JAVA\ONE_HOST/IMPORT.XML -log C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_JAVA\ONE_HOST/jload.log20.02.2006 22:13:40 com.sap.inst.jload.Jload mainSCHWERWIEGEND: couldn't connect to DBjava.sql.SQLException: [SAP NetWeaver][SQLServer JDBC Driver]Unable to connect. Invalid URL.

ERROR 2006-02-20 22:13:41

CJS-20065 Execution of JLoad tool 'C:\j2sdk1.4.2_09/bin/java.exe '-classpath' './sharedlib/antlr.jar;./sharedlib/exception.jar;./sharedlib/jddi.jar;./sharedlib/jload.jar;./sharedlib/logging.jar;./sharedlib/offlineconfiguration.jar;./sharedlib/opensqlsta.jar;./sharedlib/tc_sec_secstorefs.jar;C:\usr\sap/DP1/JC00/j2ee\jdbc\base.jar;C:\usr\sap/DP1/JC00/j2ee\jdbc\util.jar;C:\usr\sap/DP1/JC00/j2ee\jdbc\sqlserver.jar;C:\usr\sap/DP1/JC00/j2ee\jdbc\spy.jar;C:/usr/sap/DP1/SYS/global/security/lib/tools/iaik_jce_export.jar;C:/usr/sap/DP1/SYS/global/security/lib/tools/iaik_jsse.jar;C:/usr/sap/DP1/SYS/global/security/lib/tools/iaik_smime.jar;C:/usr/sap/DP1/SYS/global/security/lib/tools/iaik_ssl.jar;C:/usr/sap/DP1/SYS/global/security/lib/tools/w3c_http.jar' '-showversion' '-Xmx512m' 'com.sap.inst.jload.Jload' '-sec' 'DP1,jdbc/pool/DP1,C:\usr\sap\DP1\SYS\global/security/data/SecStore.properties,C:\usr\sap\DP1\SYS\global/security/data/SecStore.key' '-dataDir' 'E:/J2EE/DVD_NW_04_SR1_SAP_Web_AS_JAVA\J2EE_OSINDEP\J2EE-ENG/JDMP' '-job' 'C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_JAVA\ONE_HOST/IMPORT.XML' '-log' 'C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_JAVA\ONE_HOST/jload.log'' aborts with returncode 1. Check 'C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_JAVA\ONE_HOST/jload.log' and 'C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_JAVA\ONE_HOST/jload.java.log' for more information.

It could create the database but couldn't create any table.

anybody has any idea about it?

Thanks,

Maryam

[sam_venkat]

Folks, we have tried the below solution and it has worked consistently for NW2004s SR1 Installation on Windows/MSSQLServer:

1. Use a simple password e.g. abcde@12 as the master password

2. On the server, launch Server Network Utility, go to TCP/IP properties and verify if there is just 1 port or 2. If there are two ports (e.g. 1433,3150) remove the second port and just leave 1433.

3. Delete folder usr\sap\<SID>

4. Start sapinst all over

[Former Member]

Hi Maryam,

Have you checked that the DP1adm user has rights to modify the database in SQL2000? It looks like some sort of security error.

Perhaps if you post the last few relevant lines of the jload.log it might give us some more info.

Cheers,

Jonathan

[Former Member]

Hi Jonathan,

Thanks for your answer,This is the jload file:

21.02.06 22:12 com.sap.inst.jload.Jload main

INFO: Jload -sec DP1,jdbc/pool/DP1,C:\usr\sap\DP1\SYS\global/security/data/SecStore.properties,C:\usr\sap\DP1\SYS\global/security/data/SecStore.key -dataDir E:/J2EE/DVD_NW_04_SR1_SAP_Web_AS_JAVA\J2EE_OSINDEP\J2EE-ENG/JDMP -job C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_JAVA\ONE_HOST/IMPORT.XML -log C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_JAVA\ONE_HOST/jload.log

21.02.06 22:12 com.sap.inst.jload.Jload main

SEVERE: couldn't connect to DB

java.sql.SQLException: [SAP NetWeaver][SQLServer JDBC Driver]Unable to connect. Invalid URL.

As you see on log file,it says couldn't connect to DB,but it created database and user on the SQL server.

I don't know which URL is invalid,Do you have any suggestion?

Thanks alot,

Maryam

[Former Member]

Hi Maryam!

For my install I had to use Java 1.4.2_08, all other version was failed by the install. Maybe you try another Java version. Hope I could help you.

Steffen

[Former Member]

Hi Maryam,

It sounds like there might be an error in the database instance name that you are using in the install process. Are there any special characters, spaces, other weirdness in the database name? How long is the name?

Regarding the version of Java, I've successfully installed using 1.4.2_10 three times, so I'm confident that will work for you.

[Former Member]

Hi,

this sounds weired, but we have had this problem several times and normally it was caused by the password we were using.

So we found out that a password like this abcde#12 is working fine, i.e. length between 6 and 8 digits; no capital letters; using letters, 1 special character and digits.

If you don't have any other solution, just try this.

Regards, Astrid

[Former Member]

Hi guys,

Finally our problem is solved by SAP Guys on Germany and Washington.

The problem was the value of the following registry key on our SQL server

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL

Server\CRM\MSSQLServer\SuperSocketNetLib\Tcp\TcpPort

it was port#1,port#2, as SAP suggestion we changed it to port#1 and we could finish our installation without any other issue.

Thank you everybody for your help

Maryam

[Former Member]

HI

when we try to install WEBAS Java add-in during on step 16 getting error unable to connect db invalid URL.

we are doing this installtion with MSSQL 2005 and checked with port (TCP) 1433

please advice how we can edit the regedit as the above post pointing to the same error , do we need to delete that port#2 entry in regedit or can we delete at SQl config

please advice and for your ref log file content

Thanks

Subrahmanyeswara_nutakki@satyam.com

919849287333

java version "1.4.2_12"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_12-b03)

Java HotSpot(TM) Client VM (build 1.4.2_12-b03, mixed mode)

Sep 21, 2006 9:17:28 PM com.sap.inst.jload.Jload main

INFO: Jload -sec DEV,jdbc/pool/DEV,E:\usr\sap\DEV\SYS\global/security/data/SecStore.properties,E:\usr\sap\DEV\SYS\global/security/data/SecStore.key -dataDir F:/SAP/J2EE_OI/DVD_NW_04_SR1_SAP_Web_AS_JAVA\J2EE_OSINDEP\J2EE-ENG/JDMP -job C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_JAVA_MSS\ONE_HOST/IMPORT.XML -log C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_JAVA_MSS\ONE_HOST/jload.log

Sep 21, 2006 9:17:29 PM com.sap.inst.jload.Jload main

SEVERE: couldn't connect to DB

java.sql.SQLException: [SAP NetWeaver][SQLServer JDBC Driver]Unable to connect. Invalid URL.

[Former Member]

Hi,

Can you pl more specific about how did you resolve this issue.

We are facing the same issue while installing Java Add-in with Mssql 2005 with was 6.40, MSSQL port is 1433.

Please advice

Thanks

Subrahmanyeswara Nutakki

java version "1.4.2_12"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_12-b03)

Java HotSpot(TM) Client VM (build 1.4.2_12-b03, mixed mode)

Oct 22, 2006 10:23:32 AM com.sap.inst.jload.Jload main

INFO: Jload -sec DEV,jdbc/pool/DEV,E:\usr\sap\DEV\SYS\global/security/data/SecStore.properties,E:\usr\sap\DEV\SYS\global/security/data/SecStore.key -dataDir F:/SAP/J2EE_OI/DVD_NW_04_SR1_SAP_Web_AS_JAVA\J2EE_OSINDEP\J2EE-ENG/JDMP -job C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_JAVA_MSS\ONE_HOST/IMPORT.XML -log C:\Program Files\sapinst_instdir\NW04SR1\WEBAS_JAVA_MSS\ONE_HOST/jload.log

Oct 22, 2006 10:23:34 AM com.sap.inst.jload.Jload main

SEVERE: couldn't connect to DB

java.sql.SQLException: [SAP NetWeaver][SQLServer JDBC Driver]Unable to connect. Invalid URL.

[Former Member]

Hi,

I've similar problem on Solaris 10 Unix. I'm installing NW04

6.40 Java system with Oracle 9i database.

/tmp/sapinst_instdir/NW04SR1/WEBAS_JAVA/CENTRAL/ONE_HOST/jload.java.log

java version "1.4.2_12"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_12-b03)

Java HotSpot(TM) Client VM (build 1.4.2_12-b03, mixed mode)

Oct 27, 2006 4:36:07 PM com.sap.inst.jload.Jload main

INFO: Jload -sec SDN,jdbc/pool/SDN,/sapmnt/SDN/global/security/data/SecStore.properties,/sapmnt/SDN/global/security/data/SecStore.key -dataDir /export/home/sap/images/sap-nw04-support-release1-webasjava-nwdeveloperstudio-igs/J2EE_OSINDEP/J2EE-ENG/JDMP -job /tmp/sapinst_instdir/NW04SR1/WEBAS_JAVA/CENTRAL/ONE_HOST/IMPORT.XML -log /tmp/sapinst_instdir/NW04SR1/WEBAS_JAVA/CENTRAL/ONE_HOST/jload.log

Oct 27, 2006 4:36:10 PM com.sap.inst.jload.Jload main

SEVERE: couldn't connect to DB

java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

Thanks,

Ram