Error during 2004s installation. Java Import Phase

[Former Member]

Hi All,

Below is the sapinst.log. Please check it out.

SAPINST.LOG

-

---

INFO 2007-10-09 07:01:53

Copied file 'C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/inifile.xml' to 'C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/inifile.2.xml'.

INFO 2007-10-09 07:01:53

Copied file 'C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/inifile.xml' to 'C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/inifile.3.xml'.

INFO 2007-10-09 07:02:02

Execute step

Component W2K_ServicePack_Check|ind|ind|ind|ind

Preprocess of component |NW_Onehost|ind|ind|ind|ind|0|0|NW_First_Steps|ind|ind|ind|ind|0|0|W2K_ServicePack_Check|ind|ind|ind|ind|2|0.

INFO 2007-10-09 07:02:36

Copied file 'C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/keydb.xml' to 'C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/keydb.2.xml'.

INFO 2007-10-09 07:02:36

Execute step importJavaDump of component |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_Jload|ind|ind|ind|ind|9|0.

INFO 2007-10-09 07:02:38

Copied file 'D:/Temp/51032257/JAVA_EXPORT/JDMP/IMPORT.XML' to 'C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS'.

INFO 2007-10-09 07:02:38

Creating file C:\Program Files\sapinst_instdir\SRM05\SYSTEM\ORA\CENTRAL\AS\jload.java.log.

INFO 2007-10-09 07:02:38

Output of C:\j2sdk1.4.2_13-x64\bin\java.exe -classpath "C:\Program Files\sapinst_instdir\SRM05\SYSTEM\ORA\CENTRAL\AS\install\sharedlib\launcher.jar" -showversion -Xmx512m com.sap.engine.offline.OfflineToolStart com.sap.inst.jload.Jload "C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/lib/iaik_jce.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/jload.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/antlr.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/exception.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/jddi.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/logging.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/offlineconfiguration.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/opensqlsta.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/tc_sec_secstorefs.jar;C:\usr\sap\SR1\SYS\exe\uc\NTAMD64\ojdbc14.jar" -sec SR1,jdbc/pool/SR1,
MDCSAP09/sapmnt/SR1/SYS/global/security/data/SecStore.properties,
MDCSAP09/sapmnt/SR1/SYS/global/security/data/SecStore.key -dataDir D:/Temp/51032257\JAVA_EXPORT\JDMP -job "C:\Program Files\sapinst_instdir\SRM05\SYSTEM\ORA\CENTRAL\AS\IMPORT.XML" -log jload.log is written to the logfile C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/jload.java.log.

WARNING 2007-10-09 07:02:41

Execution of the command "C:\j2sdk1.4.2_13-x64\bin\java.exe -classpath "C:\Program Files\sapinst_instdir\SRM05\SYSTEM\ORA\CENTRAL\AS\install\sharedlib\launcher.jar" -showversion -Xmx512m com.sap.engine.offline.OfflineToolStart com.sap.inst.jload.Jload "C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/lib/iaik_jce.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/jload.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/antlr.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/exception.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/jddi.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/logging.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/offlineconfiguration.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/opensqlsta.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/tc_sec_secstorefs.jar;C:\usr\sap\SR1\SYS\exe\uc\NTAMD64\ojdbc14.jar" -sec SR1,jdbc/pool/SR1,
MDCSAP09/sapmnt/SR1/SYS/global/security/data/SecStore.properties,
MDCSAP09/sapmnt/SR1/SYS/global/security/data/SecStore.key -dataDir D:/Temp/51032257\JAVA_EXPORT\JDMP -job "C:\Program Files\sapinst_instdir\SRM05\SYSTEM\ORA\CENTRAL\AS\IMPORT.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)

Oct 9, 2007 7:02:39 AM com.sap.inst.jload.Jload main

INFO: Jload -sec SR1,jdbc/pool/SR1,
MDCSAP09/sapmnt/SR1/SYS/global/security/data/SecStore.properties,
MDCSAP09/sapmnt/SR1/SYS/global/security/data/SecStore.key -dataDir D:/Temp/51032257\JAVA_EXPORT\JDMP -job C:\Program Files\sapinst_instdir\SRM05\SYSTEM\ORA\CENTRAL\AS\IMPORT.XML -log jload.log

Oct 9, 2007 7:02:40 AM com.sap.inst.jload.db.DBConnection connectViaSecureStore

INFO: connected to SR1 on jdbc/pool/SR1

Oct 9, 2007 7:02:41 AM com.sap.inst.jload.JobStatus readStatus

INFO: trying to read status file C:\Program Files\sapinst_instdir\SRM05\SYSTEM\ORA\CENTRAL\AS\IMPORT.sta

Oct 9, 2007 7:02:41 AM com.sap.inst.jload.JobStatus readStatus

INFO: commencing restart

Oct 9, 2007 7:02:41 AM com.sap.inst.jload.Jload dbImport

INFO: trying to drop table BC_SLD_INSTANCES

Oct 9, 2007 7:02:41 AM com.sap.inst.jload.Jload dbImport

INFO: table dropped

Oct 9, 2007 7:02:41 AM com.sap.inst.jload.Jload dbImport

INFO: trying to create table BC_SLD_INSTANCES

Oct 9, 2007 7:02:41 AM com.sap.inst.jload.Jload logStackTrace

SEVERE: com.sap.dictionary.database.dbs.JddException: CREATE TABLE BC_SLD_INSTANCES failed

7:02:41 2007-10-09 dbs-Info: <<< Analyze table BC_SLD_INSTANCES >>>

7:02:41 2007-10-09 dbs-Info: predefined action is: >>>null<<<

7:02:41 2007-10-09 dbs-Info: Table BC_SLD_INSTANCES not found on DB

7:02:41 2007-10-09 dbs-Info: Action: CREATE

7:02:41 2007-10-09 ope-Info: Create table in database ORACLE

E R R O R ******* (DbObjectSqlStatements)

7:02:41 2007-10-09 dbs-Error: Exception caught during SQL execution F

7:02:41 2007-10-09 ope-Info: Table BC_SLD_INSTANCES could not be created in database

at com.sap.inst.jload.db.DBTable.create(DBTable.java:109)

at com.sap.inst.jload.Jload.dbImport(Jload.java:278)

at com.sap.inst.jload.Jload.executeJob(Jload.java:397)

at com.sap.inst.jload.Jload.main(Jload.java:621)

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)

Oct 9, 2007 7:02:41 AM com.sap.inst.jload.db.DBConnection disconnect

INFO: disconnected

ERROR 2007-10-09 07:02:41

CJS-30049 <html>Execution of JLoad tool 'C:\j2sdk1.4.2_13-x64\bin\java.exe -classpath "C:\Program Files\sapinst_instdir\SRM05\SYSTEM\ORA\CENTRAL\AS\install\sharedlib\launcher.jar" -showversion -Xmx512m com.sap.engine.offline.OfflineToolStart com.sap.inst.jload.Jload "C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/lib/iaik_jce.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/jload.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/antlr.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/exception.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/jddi.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/logging.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/offlineconfiguration.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/opensqlsta.jar;C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/install/sharedlib/tc_sec_secstorefs.jar;C:\usr\sap\SR1\SYS\exe\uc\NTAMD64\ojdbc14.jar" -sec SR1,jdbc/pool/SR1,
MDCSAP09/sapmnt/SR1/SYS/global/security/data/SecStore.properties,
MDCSAP09/sapmnt/SR1/SYS/global/security/data/SecStore.key -dataDir D:/Temp/51032257\JAVA_EXPORT\JDMP -job "C:\Program Files\sapinst_instdir\SRM05\SYSTEM\ORA\CENTRAL\AS\IMPORT.XML" -log jload.log' aborts with return code 1.<br>SOLUTION: Check 'jload.log' and 'C:/Program Files/sapinst_instdir/SRM05/SYSTEM/ORA/CENTRAL/AS/jload.java.log' for more information.</html>

ERROR 2007-10-09 07:02:41

FCO-00011 The step importJavaDump with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|1|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_Jload|ind|ind|ind|ind|9|0|importJavaDump was executed with status ERROR .

-

---

The error says that >>7:02:41 2007-10-09 ope-Info: Table BC_SLD_INSTANCES could not be created in database<<

It seems that it cannot create the table BC_SLD_INSTANCES in the database. What seems to be the problem?

This is what i have done.

1.Check if Oracle services are up

2. Check if Database is up

3. Restart server

After doing those it still gives the same error.

Thanks for your help.

Reward points will be given generously.

[Former Member · Accepted solution]

What java are you using? use java 1.4.2...12 ? dont download the latest one. I've had similar problem in ECC installation. Also, give the following permission to folders.

1. 755 -R /sapmnt,

2. installation directory, give 777

3. 755 -R /usr/sap/

Thanks,

[Former Member]

Hi All,

This thread will now be closed. I have resolved this by checking more logs and i found out that i need to extend some tablespaces namely PSAPTEMP, PSAP<SID> and SYSTEM.

Thank you for all your efforts.

[Former Member]

Hi Afi,

I'm using 1.4.2_13. We have been using this in our 64-bit APO build.

_________________

1. 755 -R /sapmnt,

2. installation directory, give 777

3. 755 -R /usr/sap/

_________________

I think this are for Unix. we are using windows 2003 server.

What are your other suggestions?

[Former Member]

hi,

did u install JCE policy 1.4.2?

regards

ajai

[Former Member]

Hi Joseph,

Copy the iaik_jce.jar file for encryption into the <jdk installation directory>\jre\lib\ext directory.

Regards,

Indu

Reward Points if Helpful

[Former Member]

Hi,

I'm Installing SRM 5.0 of NW2004s and i'm stuck in the java import phase.

It cannot create the table BC_SLD_INSTANCES in the database as says in the log. I'm done checking the Oracle services and database if it is up.

What do you suggest?

[Former Member]

can you explain what are you doing?

Thanks,