Error due to missing table space in JCR database

When i was executing ConfigEngine.sh database-transfer to transfer data from derby to DB2 data based it was failing with this error


action-switch-database:
Sat May 16 20:17:54 EDT 2009

action-create-jcrls-tables:
Sat May 16 20:17:54 EDT 2009
[echo] Calling cmcfgdbu to create LS tables
[echo] In case of error, refer to /software/WebSphere/wp_profile/ConfigEngine/log/JCRDB61.log
[java] com.ibm.cm.dbutil.ICMDBUtilsException: Fail to create database
[java] 2009-05-16 20:18:01 cmcfgdbu: ERROR ->Fail to create database
[java] at com.ibm.cm.dbutil.ICMConfigureLSDB.createDB(ICMConfigureLSDB.java:337)
[java] at com.ibm.cm.dbutil.ICMConfigureLSDB.configureLSDB(ICMConfigureLSDB.java:1193)
[java] at com.ibm.cm.dbutil.ICMConfigureLSDB.start(ICMConfigureLSDB.java:1860)
[java] at com.ibm.cm.dbutil.cmcfgdbu.startSilentMode(cmcfgdbu.java:162)
[java] at com.ibm.cm.dbutil.cmcfgdbu.startConfig(cmcfgdbu.java:275)
[java] at com.ibm.cm.dbutil.cmcfgdbu.main(cmcfgdbu.java:291)

BUILD FAILED
/software/WebSphere/wp_profile/ConfigEngine/base_dynamic.xml:821: The following error occurred while executing this line:
/software/WebSphere/wp_profile/ConfigEngine/config/actions/db_cfg_mgr.xml:290: The following error occurred while executing this line:
/software/WebSphere/PortalServer/jcr/prereq.jcr/config/includes/jcr_cfg.xml:117: The following error occurred while executing this line:
/software/WebSphere/PortalServer/jcr/prereq.jcr/config/includes/jcr_cfg.xml:1005: The following error occurred while executing this line:
/software/WebSphere/PortalServer/jcr/prereq.jcr/config/includes/jcr_cfg.xml:1069: The following error occurred while executing this line:
/software/WebSphere/PortalServer/jcr/prereq.jcr/config/includes/jcr_cfg.xml:3924: Java returned: 202
Total time: 6 minutes 53 seconds
isIseries currently set to: null
uploading registry
CELL: spinfotech
Websphere:_Websphere_Config_Data_Type=Registry,_Websphere_Config_Data_Id=cells/spinfotech|registry.xml#Registry_1242441339497,_WEBSPHERE_CONFIG_SESSION=anonymous1242519482288


This is what the stack trace looked like like in the JCRDB61.log file.


2009-05-16 20:18:00 cmcfgls: TRACE -> - getDBOperations()
2009-05-16 20:18:00 cmcfgls: Creating Server database
2009-05-16 20:18:00 cmcfgls: TRACE -> + createDB()
2009-05-16 20:18:00 cmcfgls: Starting database creation
2009-05-16 20:18:00 cmcfgls: TRACE -> + connectToDB()
2009-05-16 20:18:00 cmcfgls: TRACE -> dbJDBCDriverType 4
2009-05-16 20:18:00 cmcfgls: TRACE -> conString jdbc:db2://dbserver.wpcertification.com:50000/JCRDB61
2009-05-16 20:18:00 cmcfgls: TRACE -> loading jdbc driver : com.ibm.db2.jcc.DB2Driver
2009-05-16 20:18:00 cmcfgls: TRACE -> Connecting jdbc:db2://dbserver.wpcertification.com:50000/JCRDB61
2009-05-16 20:18:01 cmcfgls: TRACE -> Connected jdbc:db2://dbserver.wpcertification.com:50000/JCRDB61
2009-05-16 20:18:01 cmcfgls: TRACE -> - connectToDB()
2009-05-16 20:18:01 cmcfgls: Creating DB2 Content Manager tables
2009-05-16 20:18:01 cmcfgls: TRACE -> + executeSQL()
2009-05-16 20:18:01 cmcfgls: TRACE -> source --> /software/WebSphere/wp_profile/PortalServer/jcr/config/icmplsct.ddl
2009-05-16 20:18:01 cmcfgls: DEBUG -> Executing:
CREATE TABLE jcr.ICMSTADMINDOMAINS ( DOMAINID INTEGER NOT NULL, PRIMARY KEY (DOMAINID) ) IN ICMSFQ04

2009-05-16 20:18:01 cmcfgls: ERROR ->Fail to execute:
CREATE TABLE jcr.ICMSTADMINDOMAINS ( DOMAINID INTEGER NOT NULL, PRIMARY KEY (DOMAINID) ) IN ICMSFQ04

com.ibm.cm.dbutil.ICMDBUtilsException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: ICMSFQ04
at com.ibm.cm.dbutil.ICMDBUtilsCommon.executeSQL(ICMDBUtilsCommon.java:875)
at com.ibm.cm.dbutil.ICMDBUtilsCommon.executeSQL(ICMDBUtilsCommon.java:768)
at com.ibm.cm.dbutil.ICMConfigureLSDB.createDB(ICMConfigureLSDB.java:321)
at com.ibm.cm.dbutil.ICMConfigureLSDB.configureLSDB(ICMConfigureLSDB.java:1193)
at com.ibm.cm.dbutil.ICMConfigureLSDB.start(ICMConfigureLSDB.java:1860)
at com.ibm.cm.dbutil.cmcfgdbu.startSilentMode(cmcfgdbu.java:162)
at com.ibm.cm.dbutil.cmcfgdbu.startConfig(cmcfgdbu.java:275)
at com.ibm.cm.dbutil.cmcfgdbu.main(cmcfgdbu.java:291)
com.ibm.cm.dbutil.ICMDBUtilsException: DB2 SQL error: SQLCODE: -204, SQLSTATE: 42704, SQLERRMC: ICMSFQ04
at com.ibm.cm.dbutil.ICMDBUtilsCommon.executeSQL(ICMDBUtilsCommon.java:903)
at com.ibm.cm.dbutil.ICMDBUtilsCommon.executeSQL(ICMDBUtilsCommon.java:768)
at com.ibm.cm.dbutil.ICMConfigureLSDB.createDB(ICMConfigureLSDB.java:321)
at com.ibm.cm.dbutil.ICMConfigureLSDB.configureLSDB(ICMConfigureLSDB.java:1193)
at com.ibm.cm.dbutil.ICMConfigureLSDB.start(ICMConfigureLSDB.java:1860)
at com.ibm.cm.dbutil.cmcfgdbu.startSilentMode(cmcfgdbu.java:162)
at com.ibm.cm.dbutil.cmcfgdbu.startConfig(cmcfgdbu.java:275)
at com.ibm.cm.dbutil.cmcfgdbu.main(cmcfgdbu.java:291)
com.ibm.cm.dbutil.ICMDBUtilsException: Fail to create database
at com.ibm.cm.dbutil.ICMConfigureLSDB.createDB(ICMConfigureLSDB.java:337)
at com.ibm.cm.dbutil.ICMConfigureLSDB.configureLSDB(ICMConfigureLSDB.java:1193)
at com.ibm.cm.dbutil.ICMConfigureLSDB.start(ICMConfigureLSDB.java:1860)
at com.ibm.cm.dbutil.cmcfgdbu.startSilentMode(cmcfgdbu.java:162)
at com.ibm.cm.dbutil.cmcfgdbu.startConfig(cmcfgdbu.java:275)
at com.ibm.cm.dbutil.cmcfgdbu.main(cmcfgdbu.java:291)


I did some googling and it seems that this problem is because i did not execute these configuration commands on my JCR database

db2 "CONNECT TO JCRDB61 USER jcr"
db2 "CREATE BUFFERPOOL ICMLSFREQBP4 SIZE 1000 PAGESIZE 4 K"
db2 "CREATE BUFFERPOOL ICMLSVOLATILEBP4 SIZE 8000 PAGESIZE 4 K"
db2 "CREATE BUFFERPOOL ICMLSMAINBP32 SIZE 8000 PAGESIZE 32 K"
db2 "CREATE BUFFERPOOL CMBMAIN4 SIZE 1000 PAGESIZE 4 K"
db2 "CREATE REGULAR TABLESPACE ICMLFQ32 PAGESIZE 32 K MANAGED BY SYSTEM USING ('ICMLFQ32') BUFFERPOOL ICMLSMAINBP32"
db2 "CREATE REGULAR TABLESPACE ICMLNF32 PAGESIZE 32 K MANAGED BY SYSTEM USING ('ICMLNF32') BUFFERPOOL ICMLSMAINBP32"
db2 "CREATE REGULAR TABLESPACE ICMVFQ04 PAGESIZE 4 K MANAGED BY SYSTEM USING ('ICMVFQ04') BUFFERPOOL ICMLSVOLATILEBP4"
db2 "CREATE REGULAR TABLESPACE ICMSFQ04 PAGESIZE 4 K MANAGED BY SYSTEM USING ('ICMSFQ04') BUFFERPOOL ICMLSFREQBP4"
db2 "CREATE REGULAR TABLESPACE CMBINV04 PAGESIZE 4 K MANAGED BY SYSTEM USING ('CMBINV04') BUFFERPOOL CMBMAIN4"
db2 "CREATE SYSTEM TEMPORARY TABLESPACE ICMLSSYSTSPACE32 PAGESIZE 32 K MANAGED BY SYSTEM USING ('icmlssystspace32') BUFFERPOOL ICMLSMAINBP32"
db2 "CREATE SYSTEM TEMPORARY TABLESPACE ICMLSSYSTSPACE4 PAGESIZE 4 K MANAGED BY SYSTEM USING ('icmlssystspace4') BUFFERPOOL ICMLSVOLATILEBP4"

db2 "DISCONNECT jcrdb"
db2 "TERMINATE"


These commands are explained in more details on Creating Remote database page.

After executing these set of commands i re-executed the database-transfer configuration command and that problem seems to be solved now. The DB transfer is still going on but i passed the step where it failed last time

3 comments:

srjwebsolutions said...


We are leading responsive website designing and development company in Noida.
We are offering mobile friendly responsive website designing, website development, e-commerce website, seo service and sem services in Noida.

Responsive Website Designing Company in Noida
Website Designing Company in Noida
SEO Services in Noida
SMO Services in Noida

EG MEDI said...

Egmedi.com is online medical store pharmacy in laxmi nagar Delhi. You can Order prescription/OTC medicines online.
Cash on Delivery available. Free Home Delivery


Online Pharmacy in Delhi
Buy Online medicine in Delhi
Online Pharmacy in laxmi nagar
Buy Online medicine in laxmi nagar
Onine Medical Store in Delhi
Online Medical store in laxmi nagar
Online medicine store in delhi
online medicine store in laxmi nagar
Purchase Medicine Online
Online Pharmacy India
Online Medical Store


Vikas Chaudhary said...

Battery Mantra is Authorized exide car battery dealer in Noida and Greater Noida. We are providing our service in Indirapuram, Delhi, Ashok Nagar.

Exide Battery Dealer in Noida
Battery Dealer in Noida
Authorized Battery Dealer in Noida
Car Battery Dealer in Noida
Car Battery Dealer
Exide Battery Dealer