Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Database-transfert command

4 views
Skip to first unread message

fabrice SZNAJDERMAN

unread,
Sep 4, 2006, 5:16:05 AM9/4/06
to
Hello,

I have used the database-transfert command to transfert data from cloudscape Database to DB2 database.

During the script's execution I get the following error :

....

[java] Not required (COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0204N "DB2INST1.ID_TABLE" is an undefined name. SQLSTATE=42704
[java] )
[java] CREATE TABLE db2inst1.ID_TABLE (
[java] RES_TYPE INTEGER NOT NULL,
[java] LAST_ID BIGINT NOT NULL,
[java] LOCAL_PID INTEGER
[java] )

[java] CREATE UNIQUE INDEX db2inst1.IX10A ON db2inst1.ID_TABLE (RES_TYPE, LOCAL_PID)

[java] CREATE TABLE db2inst1.WEB_MOD (
[java] OID BIGINT NOT NULL,
[java] FILE_NAME VARCHAR(255),
[java] CONTEXT_ROOT VARCHAR(255),
[java] WAS_DISPLAY_NAME VARCHAR(255),
[java] IS_ACTIVE INTEGER NOT NULL,
[java] IS_REMOVABLE INTEGER DEFAULT 1 NOT NULL,
[java] GUID VARCHAR(255),
[java] MAJOR_VERSION INTEGER,
[java] MINOR_VERSION INTEGER,
[java] ANON_SESSION CHAR(1) NOT NULL,
[java] IS_PREDEPLOYED INTEGER DEFAULT 0 NOT NULL,
[java] CREATED BIGINT NOT NULL,
[java] MODIFIED BIGINT NOT NULL,
[java] WEB_MOD_NAME VARCHAR(255),
[java] IS_JSR_TYPE INTEGER DEFAULT 0 NOT NULL,
[java] CONSTRAINT db2inst1.PK15 PRIMARY KEY (OID)
[java] )

[java] Error during statement execution!
[java] COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0108N The name "PK15" has the wrong number of qualifiers. SQLSTATE=42601

[java] at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
[java] at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Unknown Source)
[java] at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(Unknown Source)
[java] at COM.ibm.db2.jdbc.app.DB2Statement.execute2(Unknown Source)
[java] at COM.ibm.db2.jdbc.app.DB2Statement.execute(Unknown Source)
[java] at com.ibm.wps.config.SqlProcessor.process(SqlProcessor.java:450)
[java] at com.ibm.wps.config.SqlProcessor.main(SqlProcessor.java:631)
[java] (ErrCode=-108, SqlState=42601)


My database architecture is particular :

I have one machine with an OS 32Bits where I have installed my DB2 database.
I have another machine with an OS 64bits where I have installed WPS 51. On the second machine I have installed DB2 administration client (64bits).
I have tested the communication between the two machines with the script available (WPSconfig.sh validate-database-connection-***).

Have you any ideas?

Best regards!


Fabrice SZNAJDERMAN

mahmo...@hotmail.com

unread,
Sep 4, 2006, 8:01:35 AM9/4/06
to
Hi,

It seems that you have set the value for dbuser in wpconfig.properties to DB2INST1, change this value to db2admin and sure create this user as database administrator.

I don't know actually how data is organzed in cloudscape but it always fails with me when I write any user sxcept for db2admin as this value is used as default scheme when retrieving data from cloudscape e.g. db2admin.TABLE1 etc.

Hope this will sove your problem.

fabrice SZNAJDERMAN

unread,
Sep 4, 2006, 12:25:37 PM9/4/06
to
Hello,

Thank you for your answer!

I have checked my properties file (wpconfig) and I found a mistake. I have corrected it. Now it's ok.
But I have new problem now.

I get this error :
action-drop-constraints-wmm:
[java] Connected to jdbc:db2:wps51
[java] Reading file /opt/WebSphere/PortalServer/config/DBTransfer/wps/wmmDropConstraints.sql
[java] ALTER TABLE DB2INST1.WMMDBACMPV DROP CONSTRAINT WMMF_39


action-transfer-database:

action-prepare:

action-dist:

action-transfer-wps:
[echo] Transferring the WPS database
[java] Attempting to create a new Instance of com.ibm.db2j.jdbc.DB2jDriver
[java] Instance of com.ibm.db2j.jdbc.DB2jDriver created successfully
[java] Attempting to create a new Instance of COM.ibm.db2.jdbc.app.DB2Driver
[java] Instance of COM.ibm.db2.jdbc.app.DB2Driver created successfully
[java] Attempting to make connection using: jdbc:db2j:wpsdb;create=true :: db2admin :: PASSWORD_REMOVED
[java] Level.SEVERE, Error Connecting db
[java] SQL Exception: Failed to start database 'wpsdb', see the next exception for details.
[java] at db2j.ai.j._e22(Unknown Source)
[java] at db2j.ai.j.newCloudscapeSQLException(Unknown Source)
[java] at db2j.ai.j.generateCsSQLException(Unknown Source)
[java] at db2j.ai.c._vh(Unknown Source)
[java] at db2j.ai.c.<init>(Unknown Source)
[java] at com.ibm.db2j.jdbc.EmbeddedDriver30.getNewLocalConnection(Unknown Source)
[java] at com.ibm.db2j.jdbc.EmbeddedDriver.connect(Unknown Source)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:539)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:189)
[java] at com.ibm.wps.config.db.Database.init(Database.java:125)
[java] at com.ibm.wps.config.db.transfer.TransferDatabase.process(TransferDatabase.java:199)
[java] at com.ibm.wps.config.db.transfer.TransferDatabase.initiate(TransferDatabase.java:167)
[java] at com.ibm.wps.config.db.transfer.TransferDatabase.main(TransferDatabase.java:458)
[java] Attempting to make connection using: jdbc:db2:wps51 :: db2inst1 :: PASSWORD_REMOVED
[java] Connection successfully made
[java] java.lang.NullPointerException
[java] at com.ibm.wps.config.db.Database.getTables(Database.java:213)
[java] at com.ibm.wps.config.db.transfer.TransferDatabase.process(TransferDatabase.java:238)
[java] at com.ibm.wps.config.db.transfer.TransferDatabase.initiate(TransferDatabase.java:167)
[java] at com.ibm.wps.config.db.transfer.TransferDatabase.main(TransferDatabase.java:458)
[java] Exception in thread "main" java.lang.Error
[java] at com.ibm.wps.config.db.transfer.TransferDatabase.process(TransferDatabase.java:430)
[java] at com.ibm.wps.config.db.transfer.TransferDatabase.initiate(TransferDatabase.java:167)
[java] at com.ibm.wps.config.db.transfer.TransferDatabase.main(TransferDatabase.java:458)

BUILD FAILED
file:../config/actions/dbt_cfg.xml:634: Java returned: 1

how I can check my cloudscape DB.

Have you an ideas?

Fabrice SZNAJDERMAN

mahmo...@hotmail.com

unread,
Sep 5, 2006, 5:23:10 AM9/5/06
to
Hi,

I don't know what could raise this error, but u can check ur cloudscape by running the cview.bat tool from AppServer\cloudscape\bin\embedded\cview.bat

hope this will help, but as I told u before, I noticed that the scheme used in cloudscape is always db2admin so using the db2inst1 as db2 admin id may be the problem.

Good Luck

fabrice SZNAJDERMAN

unread,
Sep 5, 2006, 5:33:16 AM9/5/06
to
Hello,

I have checked in the log file which user cloudscape used. It use the db2admin.

The db2inst1 user is for the DB2 Database.

I will try to use the executed file (AppServer\cloudscape\bin\embedded\cview.bat)

Thank you again for your help! I will give you back about the result.

Best regards


Fabrice SZNAJDERMAN

jpi...@hertz.com

unread,
Dec 1, 2006, 10:54:23 AM12/1/06
to
Hello,

Were you able to resolve the issue that was being experienced?

I am getting the same error when I run the WPSconfig.sh transfer-database command (In Linux obviously).

action-transfer-wps:
[echo] Transferring the WPS database
[java] Attempting to create a new Instance of com.ibm.db2j.jdbc.DB2jDriver
[java] Instance of com.ibm.db2j.jdbc.DB2jDriver created successfully
[java] Attempting to create a new Instance of COM.ibm.db2.jdbc.app.DB2Driver
[java] Instance of COM.ibm.db2.jdbc.app.DB2Driver created successfully
[java] Attempting to make connection using: jdbc:db2j:wpsdb;create=true :: db2admin :: PASSWORD_REMOVED
[java] Level.SEVERE, Error Connecting db
[java] SQL Exception: Failed to start database 'wpsdb', see the next exception for details.
[java] at db2j.ai.j._e22(Unknown Source)
[java] at db2j.ai.j.newCloudscapeSQLException(Unknown Source)
[java] at db2j.ai.j.generateCsSQLException(Unknown Source)
[java] at db2j.ai.c._vh(Unknown Source)
[java] at db2j.ai.c.<init>(Unknown Source)

[java] at db2j.ax.b.<init>(Unknown Source)
[java] at db2j.aw.c.<init>(Unknown Source)


[java] at com.ibm.db2j.jdbc.EmbeddedDriver30.getNewLocalConnection(Unknown Source)
[java] at com.ibm.db2j.jdbc.EmbeddedDriver.connect(Unknown Source)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:539)
[java] at java.sql.DriverManager.getConnection(DriverManager.java:189)
[java] at com.ibm.wps.config.db.Database.init(Database.java:125)
[java] at com.ibm.wps.config.db.transfer.TransferDatabase.process(TransferDatabase.java:199)
[java] at com.ibm.wps.config.db.transfer.TransferDatabase.initiate(TransferDatabase.java:167)
[java] at com.ibm.wps.config.db.transfer.TransferDatabase.main(TransferDatabase.java:458)

[java] Attempting to make connection using: jdbc:db2:wpsdb :: db2user :: PASSWORD_REMOVED


[java] Connection successfully made
[java] java.lang.NullPointerException
[java] at com.ibm.wps.config.db.Database.getTables(Database.java:213)
[java] at com.ibm.wps.config.db.transfer.TransferDatabase.process(TransferDatabase.java:238)
[java] at com.ibm.wps.config.db.transfer.TransferDatabase.initiate(TransferDatabase.java:167)
[java] at com.ibm.wps.config.db.transfer.TransferDatabase.main(TransferDatabase.java:458)
[java] Exception in thread "main" java.lang.Error
[java] at com.ibm.wps.config.db.transfer.TransferDatabase.process(TransferDatabase.java:430)
[java] at com.ibm.wps.config.db.transfer.TransferDatabase.initiate(TransferDatabase.java:167)
[java] at com.ibm.wps.config.db.transfer.TransferDatabase.main(TransferDatabase.java:458)

BUILD FAILED
file:../config/actions/dbt_cfg.xml:630: Java returned: 1


Thanks, for any assistance that can be rendered,
Josh Pierce

0 new messages