| abpeterson231 2007-03-19, 7:28 pm |
| I am getting the following errors on a fresh install of IBM and then doing the process of a database-transfer. I also applied the fix pack and get the same exact error. I am running the following script for the transfer and attached is the .properties o
f the dbdomain. Any reason this is happening?
/WPSconfig.sh database-transfer -Drelease.DbPassword=<removed password> -Dcustomization.DbPassword=<removed password>-Dcommunity.DbPassword=<removed password> -Djcr.DbPassword=<removed password> -Dwmm.DbPassword=<removed password> -Dfeedback.DbPassword=<r
emoved password> -Dlikeminds.DbPassword=<removed password>
[sqlproc] TRG_PROP_NSPC VARCHAR2(100) NOT NULL,
[sqlproc] TRG_PROP_NAME VARCHAR2(90) NOT NULL,
[sqlproc] SRC_JNDI VARCHAR2(254) NOT NULL,
[sqlproc] TRG_JNDI VARCHAR2(254) NOT NULL,
[sqlproc] BINDERGUID VARCHAR2(35) NOT NULL,
[sqlproc] CONSTRAINT PK4220 PRIMARY KEY (GENERATED_PK),
[sqlproc] CONSTRAINT UQ4220A UNIQUE (SRC_PATH, SRC_PROP_NSPC, SRC_PROP_NAME, TRG_PATH, TRG_PROP_NSPC, TRG_PROP_NAME),
[sqlproc] CONSTRAINT FK4220A FOREIGN KEY (SRC_PROP_NSPC, SRC_PROP_NAME) REFERENCES releaseusr.PBS_PROPERTIES (NAMESPACE, NAME) ON DELETE CASCADE,
[sqlproc] CONSTRAINT FK4220B FOREIGN KEY (TRG_PROP_NSPC, TRG_PROP_NAME) REFERENCES releaseusr.PBS_PROPERTIES (NAMESPACE, NAME) ON DELETE CASCADE,
[sqlproc] CONSTRAINT FK4220D FOREIGN KEY (BINDERGUID) REFERENCES releaseusr.PBS_BINDER (GUID) ON DELETE CASCADE
[sqlproc] )
[sqlproc] CREATE TABLE releaseusr.APPLICATION_ROLE (
[sqlproc] OID RAW(18) NOT NULL,
[sqlproc] NAME VARCHAR2(255) NOT NULL,
[sqlproc] ALIAS VARCHAR2(255),
[sqlproc] PARENT_OID RAW(18),
[sqlproc] EXTERNALIZED INTEGER DEFAULT 0 NOT NULL,
[sqlproc] APPLICATION_OID VARCHAR2(220),
[sqlproc] BASE_APPROLE RAW(18),
[sqlproc] CREATED NUMBER(19) NOT NULL,
[sqlproc] MODIFIED NUMBER(19) NOT NULL,
[sqlproc] CONSTRAINT PK2230 PRIMARY KEY (OID),
[sqlproc] CONSTRAINT FK2230A FOREIGN KEY (PARENT_OID) REFERENCES releaseusr.APPLICATION_ROLE (OID) ON DELETE CASCADE,
[sqlproc] CONSTRAINT FK2230B FOREIGN KEY (BASE_APPROLE) REFERENCES releaseusr.APPLICATION_ROLE (OID) ON DELETE CASCADE,
[sqlproc] CONSTRAINT UN2230 UNIQUE (NAME)
[sqlproc] )
[sqlproc] CREATE INDEX releaseusr.IX2230A ON releaseusr.APPLICATION_ROLE (PARENT_OID, OID)
[sqlproc] CREATE INDEX releaseusr.IX2230B ON releaseusr.APPLICATION_ROLE (BASE_APPROLE, OID)
[sqlproc] CREATE TABLE releaseusr.APPROLE_LOD (
[sqlproc] APPROLE_OID RAW(18) NOT NULL,
[sqlproc] LOCALE VARCHAR2(64) NOT NULL,
[sqlproc] TITLE VARCHAR2(255 CHAR) NOT NULL,
[sqlproc] DESCRIPTION VARCHAR2(1024 CHAR),
[sqlproc] CONSTRAINT PK2235 PRIMARY KEY (APPROLE_OID, LOCALE),
[sqlproc] CONSTRAINT FK2235 FOREIGN KEY (APPROLE_OID) REFERENCES releaseusr.APPLICATION_ROLE (OID) ON DELETE CASCADE
[sqlproc] )
[sqlproc] CREATE TABLE releaseusr.LNK_APPROLE_ROLE (
[sqlproc] APPROLE_OID RAW(18) NOT NULL,
[sqlproc] ROLE_INST_OID RAW(18) NOT NULL,
[sqlproc] CONSTRAINT PK2240 PRIMARY KEY (APPROLE_OID, ROLE_INST_OID),
[sqlproc] CONSTRAINT FK2240A FOREIGN KEY (APPROLE_OID) REFERENCES releaseusr.APPLICATION_ROLE (OID) ON DELETE CASCADE,
[sqlproc] CONSTRAINT FK2240B FOREIGN KEY (ROLE_INST_OID) REFERENCES releaseusr.ROLE_INST (OID) ON DELETE CASCADE
[sqlproc] )
[sqlproc] CREATE INDEX releaseusr.IX2240A ON releaseusr.LNK_APPROLE_ROLE (ROLE_INST_OID)
[sqlproc] CREATE TABLE releaseusr.LNK_USER_APPROLE (
[sqlproc] USER_DESC_TYPE NUMBER(19) NOT NULL,
[sqlproc] USER_DESC_UID VARCHAR2(220) NOT NULL,
[sqlproc] APPROLE_OID RAW(18) NOT NULL,
[sqlproc] CONSTRAINT PK2250 PRIMARY KEY (USER_DESC_UID, APPROLE_OID),
[sqlproc] CONSTRAINT FK2250B FOREIGN KEY (APPROLE_OID) REFERENCES releaseusr.APPLICATION_ROLE (OID) ON DELETE CASCADE
[sqlproc] )
[sqlproc] DROP INDEX releaseusr.IX3003B
[sqlproc] Not required (java.sql.SQLException: ORA-01418: specified index does not exist
[sqlproc] )
[sqlproc] DROP TABLE releaseusr.WPS_SCDLMPR
[sqlproc] Not required (java.sql.SQLException: ORA-38301: can not perform DDL/DML over objects in Recycle Bin
[sqlproc] )
[sqlproc] DROP TABLE releaseusr.WPS_SCDLMGR
[sqlproc] Not required (java.sql.SQLException: ORA-38301: can not perform DDL/DML over objects in Recycle Bin
[sqlproc] )
[sqlproc] DROP TABLE releaseusr.WPS_SCDTREG
[sqlproc] Not required (java.sql.SQLException: ORA-38301: can not perform DDL/DML over objects in Recycle Bin
[sqlproc] )
[sqlproc] DROP INDEX releaseusr.IX3000B
[sqlproc] Not required (java.sql.SQLException: ORA-01418: specified index does not exist
[sqlproc] )
[sqlproc] DROP INDEX releaseusr.IX3000A
[sqlproc] Not required (java.sql.SQLException: ORA-01418: specified index does not exist
[sqlproc] )
[sqlproc] DROP TABLE releaseusr.WPS_SCDTASK
[sqlproc] Not required (java.sql.SQLException: ORA-38301: can not perform DDL/DML over objects in Recycle Bin
[sqlproc] )
[sqlproc] CREATE TABLE releaseusr.WPS_SCDTASK (
[sqlproc] TASKID NUMBER(19) NOT NULL,
[sqlproc] VERSION VARCHAR2(5) NOT NULL,
[sqlproc] ROW_VERSION INTEGER NOT NULL,
[sqlproc] TASKTYPE INTEGER NOT NULL,
[sqlproc] TASKSUSPENDED NUMBER(5) NOT NULL,
[sqlproc] CANCELLED NUMBER(5) NOT NULL,
[sqlproc] NEXTFIRETIME NUMBER(19) NOT NULL,
[sqlproc] STARTBYINTERVAL VARCHAR2(254),
[sqlproc] STARTBYTIME NUMBER(19),
[sqlproc] VALIDFROMTIME NUMBER(19),
[sqlproc] VALIDTOTIME NUMBER(19),
[sqlproc] REPEATINTERVAL VARCHAR2(254),
[sqlproc] MAXREPEATS INTEGER NOT NULL,
[sqlproc] REPEATSLEFT INTEGER NOT NULL,
[sqlproc] TASKINFO BLOB,
[sqlproc] NAME VARCHAR2(254),
[sqlproc] AUTOPURGE INTEGER NOT NULL,
[sqlproc] FAILUREACTION INTEGER,
[sqlproc] MAXATTEMPTS INTEGER,
[sqlproc] QOS INTEGER,
[sqlproc] PARTITIONID INTEGER,
[sqlproc] OWNERTOKEN VARCHAR2(200) NOT NULL,
[sqlproc] CREATETIME NUMBER(19) NOT NULL,
[sqlproc] CONSTRAINT PK3000 PRIMARY KEY (TASKID)
[sqlproc] )
[sqlproc] CREATE INDEX releaseusr.IX3000A ON releaseusr.WPS_SCDTASK (TASKID, OWNERTOKEN)
[sqlproc] CREATE INDEX releaseusr.IX3000B ON releaseusr.WPS_SCDTASK (NEXTFIRETIME, REPEATSLEFT, PARTITIONID)
[sqlproc] CREATE TABLE releaseusr.WPS_SCDTREG (
[sqlproc] REGKEY VARCHAR2(254) NOT NULL,
[sqlproc] REGVALUE VARCHAR2(254),
[sqlproc] CONSTRAINT PK3001 PRIMARY KEY (REGKEY)
[sqlproc] )
[sqlproc] CREATE TABLE releaseusr.WPS_SCDLMGR (
[sqlproc] LEASENAME VARCHAR2(254) NOT NULL,
[sqlproc] LEASEOWNER VARCHAR2(254) NOT NULL,
[sqlproc] LEASE_EXPIRE_TIME NUMBER(19),
[sqlproc] DISABLED VARCHAR2(254),
[sqlproc] CONSTRAINT PK3002 PRIMARY KEY (LEASENAME)
[sqlproc] )
[sqlproc] CREATE TABLE releaseusr.WPS_SCDLMPR (
[sqlproc] LEASENAME VARCHAR2(254) NOT NULL,
[sqlproc] NAME VARCHAR2(254) NOT NULL,
[sqlproc] VALUE VARCHAR2(254) NOT NULL
[sqlproc] )
[sqlproc] CREATE INDEX releaseusr.IX3003B ON releaseusr.WPS_SCDLMPR (LEASENAME, NAME)
[sqlproc] The database was updated successfully.
[sqlproc] ________________________________________
_________________
[logmsg] 2007.03.19 14:20:05.967 action-init-database-wps
[logmsg] EJPCA3108I: Database "breeze_wcmprd" initialized
action-transfer-data:
Mon Mar 19 14:20:07 CST 2007
action-set-time-property:
Mon Mar 19 14:20:09 CST 2007
action-init-zos:
Mon Mar 19 14:20:09 CST 2007
[echo] Setting property isZos to ${isZos}
[echo] Setting property jvmArgForZos to -Dzos.argsconversion=none
action-set-managed-node-flag:
Mon Mar 19 14:20:09 CST 2007
[echo] Is this a Managed Node ? false
action-set-conntype-property:
Mon Mar 19 14:20:09 CST 2007
init:
Mon Mar 19 14:20:09 CST 2007
action-dist:
Mon Mar 19 14:20:09 CST 2007
action-prepare:
Mon Mar 19 14:20:11 CST 2007
action-prepare:
Mon Mar 19 14:20:13 CST 2007
action-prepare:
Mon Mar 19 14:20:15 CST 2007
action-prepare:
Mon Mar 19 14:20:17 CST 2007
action-prepare:
Mon Mar 19 14:20:19 CST 2007
action-prepare:
Mon Mar 19 14:20:20 CST 2007
action-prepare:
Mon Mar 19 14:20:22 CST 2007
action-prepare:
Mon Mar 19 14:20:24 CST 2007
action-process-constraints:
Mon Mar 19 14:20:24 CST 2007
[java] [03/19/07 14:20:25.543 CST] Attempting to create a new Instance of oracle.jdbc.driver.OracleDriver
[java] [03/19/07 14:20:25.552 CST] Instance of oracle.jdbc.driver.OracleDriver created successfully
[java] [03/19/07 14:20:25.552 CST] Attempting to make connection using: jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = biwabik-vip.westlan.com)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = bixby-vip.westlan.com)(PORT = 1521))(L
OAD_BALANCE = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = <removed server name> )(FAILOVER_MODE =(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5)))) :: releaseusr :: PASSWORD_REMOVED
[java] [03/19/07 14:20:26.312 CST] Connection successfully made
action-drop-constraints:
Mon Mar 19 14:20:42 CST 2007
[java] Reading file /was/was60/WebSphere/PortalServer/config/DBTransfer/wps/disableConstraints.sql
[java] Connected to jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = biwabik-vip.westlan.com)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = bixby-vip.westlan.com)(PORT = 1521))(LOAD_BALANCE = yes)(CONNECT_DATA =(SERVER = DEDICATED
)(SERVICE_NAME = breeze_wcmprd.westlan.com)(FAILOVER_MODE =(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5))))
[java] ALTER TABLE RELEASEUSR.APPLICATION_ROLE DROP CONSTRAINT FK2230A
[java] ALTER TABLE RELEASEUSR.APPLICATION_ROLE DROP CONSTRAINT FK2230B
[java] ALTER TABLE RELEASEUSR.CDO_CATEGORY DROP CONSTRAINT FK4010A
[java] ALTER TABLE RELEASEUSR.COMP_INST DROP CONSTRAINT FK320D
[java] ALTER TABLE RELEASEUSR.COMP_INST DROP CONSTRAINT FK320E
[java] ALTER TABLE RELEASEUSR.PAGE_INST DROP CONSTRAINT FK280B
[java] ALTER TABLE RELEASEUSR.PAGE_INST DROP CONSTRAINT FK280E
[java] ALTER TABLE RELEASEUSR.PORT_INST DROP CONSTRAINT FK300B
[java] ALTER TABLE RELEASEUSR.PROT_RES DROP CONSTRAINT FK2110A
[java] ALTER TABLE RELEASEUSR.URL_MAP_CTX DROP CONSTRAINT FK830
[echo] Transfer Data :: MaxMemory is 512M
[java] [03/19/07 14:20:45.031 CST] Attempting to make connection using: jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = biwabik-vip.westlan.com)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = bixby-vip.westlan.com)(PORT = 1521))(L
OAD_BALANCE = yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = breeze_wcmprd.westlan.com)(FAILOVER_MODE =(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5)))) :: releaseusr :: PASSWORD_REMOVED
[java] [03/19/07 14:20:45.740 CST] Connection successfully made
[java] [03/19/07 14:20:45.740 CST] Attempting to make connection using: jdbc:db2j:wpsdb;create=true :: db2admin :: PASSWORD_REMOVED
[java] [03/19/07 14:20:46.303 CST] Connection successfully made
[java] [03/19/07 14:20:46.309 CST] Transfer started
[java] [03/19/07 14:21:01.526 CST] Transferring table --{ RELEASE.WEB_MOD}-- to table --{RELEASEUSR.WEB_MOD }--
[java] [03/19/07 14:21:01.790 CST] Transferring table --{ RELEASE.WSRP_PROD}-- to table --{RELEASEUSR.WSRP_PROD }--
[java] [03/19/07 14:21:01.849 CST] Transferring table --{ RELEASE.APP_DESC}-- to table --{RELEASEUSR.APP_DESC }--
[java] [03/19/07 14:21:02.812 CST] Transferring table --{ RELEASE.APP_DESC_DD}-- to table --{RELEASEUSR.APP_DESC_DD }--
[java] [03/19/07 14:21:03.044 CST] Transferring table --{ RELEASE.SERV_DESC}-- to table --{RELEASEUSR.SERV_DESC }--
[java] [03/19/07 14:21:03.187 CST] Transferring table --{ RELEASE.SERV_DESC_MAD}-- to table --{RELEASEUSR.SERV_DESC_MAD }--
[java] [03/19/07 14:21:03.217 CST] error.executing.transfer
[java] err.dbtransfer.exception.labelclass java.sql.BatchUpdateException: ORA-02291: integrity constraint (RELEASEUSR.FK18) violated - parent key not found
[java] java.sql.BatchUpdateException: ORA-02291: integrity constraint (RELEASEUSR.FK18) violated - parent key not found
[java] at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:367)
[java] at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9040)
[java] at com.ibm.wps.config.db.transfer.DefaultTableHandler.execute(DefaultTableHandler.java:126)
[java] at com.ibm.wps.config.db.transfer.TransferEngine.execute(TransferEngine.java:57)
[java] at com.ibm.wps.config.db.transfer.CmdLineTransfer.execute(CmdLineTransfer.java:93)
[java] at com.ibm.wps.config.db.transfer.CmdLineTransfer.main(CmdLineTransfer.java:43)
BUILD FAILED
file:../config/actions/dbt_dbcfg.xml:281: Java returned: 1
Total time: 3 minutes 16 seconds
was@brewster:/was/WebSphere/PortalServer/config>
|