Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DB2 Error while installing

Hi

I am installing NW 04 SR1 on Linux / DB2

Completed the steps of ABAP Central instance and Database instance successfully.

While installing the JAVA Add-in, everything seems to go smoothly till step 20 of 26.

In the "load java database content" step, I get an error as follows:

Log file: jload.java.log

exerpts of the error:

12:00:48 2006-05-25 dbs-Error: Exception caught during SQL execution DB2 SQL error: SQLCODE: -622, SQLSTATE: 56031, SQLERRMC: CCSID UNICODE CREATE TABLE .......

May 25, 2006 12:00:45 PM com.sap.inst.jload.Jload main

INFO: Jload -sec XO2,jdbc/pool/XO2,/sapmnt/XO2/global/security/data/SecStore.properties,/sapmnt/XO2/global/security/data/SecStore.key -dataDir /mnt/sapsw/SAP-Linux-IDES-4.7X200-DB2UDB/51030724_2/DVD_NW_04_SR1_SAP_Web_AS_JAVA/J2EE_OSINDEP/J2EE-ENG/JDMP -job /tmp/sapinst_instdir/NW04SR1/WEBAS_JAVA_DB6/ONE_HOST/IMPORT.XML -log /tmp/sapinst_instdir/NW04SR1/WEBAS_JAVA_DB6/ONE_HOST/jload.log

May 25, 2006 12:00:47 PM com.sap.inst.jload.db.DBConnection connectViaSecureStore

INFO: connected to XO2 on jdbc/pool/XO2

May 25, 2006 12:00:47 PM com.sap.inst.jload.JobStatus readStatus

INFO: commencing restart

May 25, 2006 12:00:48 PM com.sap.inst.jload.Jload dbImport

INFO: trying to drop table BC_COMPVERS

May 25, 2006 12:00:48 PM com.sap.inst.jload.Jload dbImport

INFO: table dropped

May 25, 2006 12:00:48 PM com.sap.inst.jload.Jload dbImport

INFO: trying to create table BC_COMPVERS

May 25, 2006 12:00:48 PM com.sap.inst.jload.Jload logStackTrace

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

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

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

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

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

May 25, 2006 12:00:48 PM com.sap.inst.jload.db.DBConnection disconnect

INFO: disconnected

The SQLCODES and SQLSTATUS mentions that either:

Possible reasons:

  • CCSID ASCII cannot be specified when connected to a database created using a UNICODE code page.

  • CCSID UNICODE cannot be specified when connected to a database created using a non-UNICODE code page.

I am installing this for Non-unicode database, so I guess the above SQL statement should not be :

CCSID UNICODE CREATE TABLE

and should be "CCSID ASCII CREATE TABLE"

This statement seems to come from an EXPDUMP1.001 file from an OS independant J2EE engine DVD:

51030724_2 SAP NW04 SR1 SAP J2EE Engine (OS independent parts)

Wonder where I should be looking to go beyond this block.

Thanks

Former Member
Not what you were looking for? View more on this topic or Ask a question