Swingbench version number : 2.7.0.1189
Platform : Linux / Oracle 12.2
JDK Version : openjdk 19.0.1 2022-10-18
what you were trying to do :
I used this command to create TPCDS data -> bin/tpcdswizard -cl -cs //${ORACLE_HOSTNAME}:1531/${DBNAME} -v -create -c /opt/swingbench/tmp/configs/tpcds_create.xml
I always get these errors :
Starting script ../sql/tpcds_constraints.sql
ERROR : The following statement failed : ALTER TABLE catalog_returns
ADD CONSTRAINT cr_cc FOREIGN KEY (cr_call_center_sk)
REFERENCES call_center (cc_call_center_sk) : Due to : ORA-02298: cannot validate (TPCDSLIKE.CR_CC) - parent keys not found
ERROR : The following statement failed : ALTER TABLE catalog_sales
ADD CONSTRAINT cs_p FOREIGN KEY (cs_promo_sk)
REFERENCES promotion (p_promo_sk) : Due to : ORA-02298: cannot validate (TPCDSLIKE.CS_P) - parent keys not found
With gui interface it works well.
log information :
SwingBench Wizard
Author : Dominic Giles
Version : 2.7.0.1189
Running in Lights Out Mode using config file : ../wizardconfigs/tpcdswizard.xml
Starting run
Starting script ../sql/tpcds_droptables.sql
Script completed in 0 hour(s) 0 minute(s) 1 second(s) 168 millisecond(s)
Starting script ../sql/tpcds_createtables.sql
Script completed in 0 hour(s) 0 minute(s) 0 second(s) 155 millisecond(s)
Inserting data into table INVENTORY_2
Inserting data into table INVENTORY_1
Inserting data into table CUSTOMER_DEMOGRAPHICS_2
Inserting data into table CUSTOMER_DEMOGRAPHICS_1
Completed processing table CUSTOMER_DEMOGRAPHICS_1 in 0:00:19
Inserting data into table STORE_SALES_2
Completed processing table CUSTOMER_DEMOGRAPHICS_2 in 0:00:21
Inserting data into table STORE_SALES_1
Completed processing table STORE_SALES_2 in 0:00:05
Inserting data into table CUSTOMER_2
Completed processing table STORE_SALES_1 in 0:00:05
Inserting data into table CUSTOMER_1
Completed processing table CUSTOMER_2 in 0:00:05
Inserting data into table CATALOG_SALES_2
Completed processing table CUSTOMER_1 in 0:00:05
Inserting data into table CATALOG_SALES_1
Completed processing table CATALOG_SALES_2 in 0:00:04
Inserting data into table CUSTOMER_ADDRESS_2
Completed processing table CATALOG_SALES_1 in 0:00:03
Inserting data into table CUSTOMER_ADDRESS_1
Completed processing table CUSTOMER_ADDRESS_2 in 0:00:01
Inserting data into table WEB_SALES_2
Completed processing table CUSTOMER_ADDRESS_1 in 0:00:01
Inserting data into table WEB_SALES_1
Completed processing table WEB_SALES_2 in 0:00:01
Inserting data into table DATE_DIM
Completed processing table WEB_SALES_1 in 0:00:02
Inserting data into table ITEM
Completed processing table ITEM in 0:00:01
Inserting data into table TIME_DIM
Completed processing table TIME_DIM in 0:00:05
Inserting data into table CATALOG_PAGE
Completed processing table CATALOG_PAGE in 0:00:00
Inserting data into table STORE_RETURNS_2
Completed processing table STORE_RETURNS_2 in 0:00:00
Inserting data into table STORE_RETURNS_1
Completed processing table STORE_RETURNS_1 in 0:00:00
Inserting data into table CATALOG_RETURNS_2
Completed processing table DATE_DIM in 0:00:10
Inserting data into table CATALOG_RETURNS_1
Completed processing table CATALOG_RETURNS_2 in 0:00:00
Inserting data into table WEB_RETURNS_2 4) : Data generation completed : 56.47%
Completed processing table WEB_RETURNS_2 in 0:00:00
Inserting data into table WEB_RETURNS_1
Completed processing table CATALOG_RETURNS_1 in 0:00:00
Inserting data into table HOUSEHOLD_DEMOGRAPHICS
Completed processing table WEB_RETURNS_1 in 0:00:00
Inserting data into table WEB_PAGE
Completed processing table WEB_PAGE in 0:00:00
Inserting data into table WEB_SITE s (4/4) : Data generation completed : 67.83%
Completed processing table WEB_SITE in 0:00:00
Inserting data into table STORE
Completed processing table HOUSEHOLD_DEMOGRAPHICS in 0:00:00
Completed processing table STORE in 0:00:00
Inserting data into table CALL_CENTER
Inserting data into table PROMOTION
Completed processing table CALL_CENTER in 0:00:00
Inserting data into table WAREHOUSE
Completed processing table PROMOTION in 0:00:00
Inserting data into table REASON
Completed processing table WAREHOUSE in 0:00:00
Inserting data into table INCOME_BAND
Completed processing table REASON in 0:00:00
Inserting data into table SHIP_MODE
Completed processing table INCOME_BAND in 0:00:00
Completed processing table SHIP_MODE in 0:00:00
Completed processing table INVENTORY_2 in 0:01:01
Starting script ../sql/tpcds_analyzeschema.sql
Script completed in 0 hour(s) 0 minute(s) 13 second(s) 361 millisecond(s)
Starting script ../sql/tpcds_constraints.sql
ERROR : The following statement failed : ALTER TABLE catalog_returns
ADD CONSTRAINT cr_cc FOREIGN KEY (cr_call_center_sk)
REFERENCES call_center (cc_call_center_sk) : Due to : ORA-02298: cannot validate (TPCDSLIKE.CR_CC) - parent keys not found
ERROR : The following statement failed : ALTER TABLE catalog_sales
ADD CONSTRAINT cs_p FOREIGN KEY (cs_promo_sk)
REFERENCES promotion (p_promo_sk) : Due to : ORA-02298: cannot validate (TPCDSLIKE.CS_P) - parent keys not found
FlyBzh
commented
1 year ago
Swingbench version number : 2.7.0.1189 Platform : Linux / Oracle 12.2 JDK Version : openjdk 19.0.1 2022-10-18 what you were trying to do : I used this command to create TPCDS data -> bin/tpcdswizard -cl -cs //${ORACLE_HOSTNAME}:1531/${DBNAME} -v -create -c /opt/swingbench/tmp/configs/tpcds_create.xml I always get these errors : Starting script ../sql/tpcds_constraints.sql ERROR : The following statement failed : ALTER TABLE catalog_returns ADD CONSTRAINT cr_cc FOREIGN KEY (cr_call_center_sk) REFERENCES call_center (cc_call_center_sk) : Due to : ORA-02298: cannot validate (TPCDSLIKE.CR_CC) - parent keys not found
ERROR : The following statement failed : ALTER TABLE catalog_sales ADD CONSTRAINT cs_p FOREIGN KEY (cs_promo_sk) REFERENCES promotion (p_promo_sk) : Due to : ORA-02298: cannot validate (TPCDSLIKE.CS_P) - parent keys not found
With gui interface it works well.
log information : SwingBench Wizard Author : Dominic Giles Version : 2.7.0.1189
Running in Lights Out Mode using config file : ../wizardconfigs/tpcdswizard.xml Starting run Starting script ../sql/tpcds_droptables.sql Script completed in 0 hour(s) 0 minute(s) 1 second(s) 168 millisecond(s) Starting script ../sql/tpcds_createtables.sql Script completed in 0 hour(s) 0 minute(s) 0 second(s) 155 millisecond(s) Inserting data into table INVENTORY_2 Inserting data into table INVENTORY_1 Inserting data into table CUSTOMER_DEMOGRAPHICS_2 Inserting data into table CUSTOMER_DEMOGRAPHICS_1 Completed processing table CUSTOMER_DEMOGRAPHICS_1 in 0:00:19 Inserting data into table STORE_SALES_2 Completed processing table CUSTOMER_DEMOGRAPHICS_2 in 0:00:21 Inserting data into table STORE_SALES_1 Completed processing table STORE_SALES_2 in 0:00:05 Inserting data into table CUSTOMER_2 Completed processing table STORE_SALES_1 in 0:00:05 Inserting data into table CUSTOMER_1 Completed processing table CUSTOMER_2 in 0:00:05 Inserting data into table CATALOG_SALES_2 Completed processing table CUSTOMER_1 in 0:00:05 Inserting data into table CATALOG_SALES_1 Completed processing table CATALOG_SALES_2 in 0:00:04 Inserting data into table CUSTOMER_ADDRESS_2 Completed processing table CATALOG_SALES_1 in 0:00:03 Inserting data into table CUSTOMER_ADDRESS_1 Completed processing table CUSTOMER_ADDRESS_2 in 0:00:01 Inserting data into table WEB_SALES_2 Completed processing table CUSTOMER_ADDRESS_1 in 0:00:01 Inserting data into table WEB_SALES_1 Completed processing table WEB_SALES_2 in 0:00:01 Inserting data into table DATE_DIM Completed processing table WEB_SALES_1 in 0:00:02 Inserting data into table ITEM Completed processing table ITEM in 0:00:01 Inserting data into table TIME_DIM Completed processing table TIME_DIM in 0:00:05 Inserting data into table CATALOG_PAGE Completed processing table CATALOG_PAGE in 0:00:00 Inserting data into table STORE_RETURNS_2 Completed processing table STORE_RETURNS_2 in 0:00:00 Inserting data into table STORE_RETURNS_1 Completed processing table STORE_RETURNS_1 in 0:00:00 Inserting data into table CATALOG_RETURNS_2 Completed processing table DATE_DIM in 0:00:10 Inserting data into table CATALOG_RETURNS_1 Completed processing table CATALOG_RETURNS_2 in 0:00:00 Inserting data into table WEB_RETURNS_2 4) : Data generation completed : 56.47% Completed processing table WEB_RETURNS_2 in 0:00:00 Inserting data into table WEB_RETURNS_1 Completed processing table CATALOG_RETURNS_1 in 0:00:00 Inserting data into table HOUSEHOLD_DEMOGRAPHICS Completed processing table WEB_RETURNS_1 in 0:00:00 Inserting data into table WEB_PAGE Completed processing table WEB_PAGE in 0:00:00 Inserting data into table WEB_SITE s (4/4) : Data generation completed : 67.83% Completed processing table WEB_SITE in 0:00:00 Inserting data into table STORE Completed processing table HOUSEHOLD_DEMOGRAPHICS in 0:00:00 Completed processing table STORE in 0:00:00 Inserting data into table CALL_CENTER Inserting data into table PROMOTION Completed processing table CALL_CENTER in 0:00:00 Inserting data into table WAREHOUSE Completed processing table PROMOTION in 0:00:00 Inserting data into table REASON Completed processing table WAREHOUSE in 0:00:00 Inserting data into table INCOME_BAND Completed processing table REASON in 0:00:00 Inserting data into table SHIP_MODE Completed processing table INCOME_BAND in 0:00:00 Completed processing table SHIP_MODE in 0:00:00 Completed processing table INVENTORY_2 in 0:01:01 Starting script ../sql/tpcds_analyzeschema.sql Script completed in 0 hour(s) 0 minute(s) 13 second(s) 361 millisecond(s) Starting script ../sql/tpcds_constraints.sql ERROR : The following statement failed : ALTER TABLE catalog_returns ADD CONSTRAINT cr_cc FOREIGN KEY (cr_call_center_sk) REFERENCES call_center (cc_call_center_sk) : Due to : ORA-02298: cannot validate (TPCDSLIKE.CR_CC) - parent keys not found
ERROR : The following statement failed : ALTER TABLE catalog_sales ADD CONSTRAINT cs_p FOREIGN KEY (cs_promo_sk) REFERENCES promotion (p_promo_sk) : Due to : ORA-02298: cannot validate (TPCDSLIKE.CS_P) - parent keys not found
Script completed in 0 hour(s) 0 minute(s) 16 second(s) 613 millisecond(s) Starting script ../sql/tpcds_indexes.sql Script completed in 0 hour(s) 0 minute(s) 1 second(s) 892 millisecond(s) Starting script ../sql/tpcds_transactions_pkg.sql Script completed in 0 hour(s) 0 minute(s) 0 second(s) 170 millisecond(s)
Data Generation Runtime Metrics +-------------------------+-------------+ | Description | Value | +-------------------------+-------------+ | Connection Time | 0:00:00.003 | | Data Generation Time | 0:01:01.363 | | DDL Creation Time | 0:00:33.437 | | Total Run Time | 0:01:34.812 | | Rows Inserted per sec | 182,992 | | Actual Rows Generated | 11,069,444 | | Commits Completed | 612 | | Batch Updates Completed | 56,196 | +-------------------------+-------------+
Validation Report The schema appears to have been created successfully.
Valid Objects Valid Tables : 'CALL_CENTER','CATALOG_PAGE','CATALOG_RETURNS','CATALOG_SALES','CUSTOMER','CUSTOMER_ADDRESS','CUSTOMER_DEMOGRAPHICS','DATE_DIM','HOUSEHOLD_DEMOGRAPHICS','INCOME_BAND','INVENTORY','ITEM','PROMOTION','REASON','SHIP_MODE','STORE','STORE_RETURNS','STORE_SALES','TIME_DIM','WAREHOUSE','WEB_PAGE','WEB_RETURNS','WEB_SALES' Valid Indexes : 'CALL_CENTER_PK_IDX','CATALOG_PAGE_PK_IDX','CATALOG_RETURNS_PK_IDX','CATALOG_SALES_PK_IDX','CUSTOMER_PK_IDX','CA_ADDRESS_PK_IDX','CD_DEMO_PK_IDX','D_DATE_PK_IDX','HOUSEHOLD_DEMOGRAPHICS_PK_IDX','INCOME_BAND_PK_IDX','INVENTORY_NUK','ITEM_PK_IDX','PROMOTION_PK_IDX','REASON_PK_IDX','SHIP_MODE_PK_IDX','STORE_PK_IDX','STORE_RETURNS_PK_IDX','STORE_SALES_PK_IDX','TIME_DIM_PK_IDX','W_WAREHOUSE_PK_IDX','WEB_PAGE_PK_IDX','WEB_RETURNS_PK_IDX','WEB_SALES_PK_IDX' Valid Views : Valid Sequences : Valid Code : 'PKG_TPCDS_TRANSACTIONS' Schema Created