Quickinitdatawarehouse shows following error: -fresh installation with update 17.11.12
EXCEPTION THROWN WHILE CREATING THE "FACT" GENERICVALUE: ERROR WHILE INSERTING: [GENERICENTITY:INVENTORYITEMFACT][CREATEDSTAMP,2012-11-18 01:43:20.227(JAVA.SQL.TIMESTAMP)][CREATEDTXSTAMP,2012-11-18 01:43:18.142(JAVA.SQL.TIMESTAMP)][INVENTORYDATEDIMID,_NF_(JAVA.LANG.STRING)][INVENTORYITEMID,9000(JAVA.LANG.STRING)][LASTUPDATEDSTAMP,2012-11-18 01:43:20.227(JAVA.SQL.TIMESTAMP)][LASTUPDATEDTXSTAMP,2012-11-18 01:43:18.142(JAVA.SQL.TIMESTAMP)][ORIGCURRENCYDIMID,11506(JAVA.LANG.STRING)][PRODUCTDIMID,10783(JAVA.LANG.STRING)] (SQL EXCEPTION WHILE EXECUTING THE FOLLOWING:INSERT INTO INVENTORY_ITEM_FACT (INVENTORY_ITEM_ID, FACILITY_ID, PRODUCT_DIM_ID, ORIG_CURRENCY_DIM_ID, INVENTORY_DATE_DIM_ID, QUANTITY_ON_HAND_TOTAL, AVAILABLE_TO_PROMISE_TOTAL, UNIT_COST, SOLDOUT_AMOUNT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (CANNOT ADD OR UPDATE A CHILD ROW: A FOREIGN KEY CONSTRAINT FAILS (`OFBIZOLAP`.`INVENTORY_ITEM_FACT`, CONSTRAINT `IIF_INVDATE` FOREIGN KEY (`INVENTORY_DATE_DIM_ID`) REFERENCES `DATE_DIMENSION` (`DIMENSION_ID`)))) FEHLER BEIM STARTEN DER TRANSAKTION, METHODE KONNTE NICHT VERARBEITET WERDEN: THE CURRENT TRANSACTION IS MARKED FOR ROLLBACK, NOT BEGINNING A NEW TRANSACTION AND ABORTING CURRENT OPERATION; THE ROLLBACKONLY WAS CAUSED BY: FAILURE IN CREATE OPERATION FOR ENTITY [INVENTORYITEMFACT]: ORG.OFBIZ.ENTITY.GENERICENTITYEXCEPTION: ERROR WHILE INSERTING: [GENERICENTITY:INVENTORYITEMFACT][CREATEDSTAMP,2012-11-18 01:43:20.227(JAVA.SQL.TIMESTAMP)][CREATEDTXSTAMP,2012-11-18 01:43:18.142(JAVA.SQL.TIMESTAMP)][INVENTORYDATEDIMID,_NF_(JAVA.LANG.STRING)][INVENTORYITEMID,9000(JAVA.LANG.STRING)][LASTUPDATEDSTAMP,2012-11-18 01:43:20.227(JAVA.SQL.TIMESTAMP)][LASTUPDATEDTXSTAMP,2012-11-18 01:43:18.142(JAVA.SQL.TIMESTAMP)][ORIGCURRENCYDIMID,11506(JAVA.LANG.STRING)][PRODUCTDIMID,10783(JAVA.LANG.STRING)] (SQL EXCEPTION WHILE EXECUTING THE FOLLOWING:INSERT INTO INVENTORY_ITEM_FACT (INVENTORY_ITEM_ID, FACILITY_ID, PRODUCT_DIM_ID, ORIG_CURRENCY_DIM_ID, INVENTORY_DATE_DIM_ID, QUANTITY_ON_HAND_TOTAL, AVAILABLE_TO_PROMISE_TOTAL, UNIT_COST, SOLDOUT_AMOUNT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (CANNOT ADD OR UPDATE A CHILD ROW: A FOREIGN KEY CONSTRAINT FAILS (`OFBIZOLAP`.`INVENTORY_ITEM_FACT`, CONSTRAINT `IIF_INVDATE` FOREIGN KEY (`INVENTORY_DATE_DIM_ID`) REFERENCES `DATE_DIMENSION` (`DIMENSION_ID`)))). ROLLING BACK TRANSACTION.ORG.OFBIZ.ENTITY.GENERICENTITYEXCEPTION: ERROR WHILE INSERTING: [GENERICENTITY:INVENTORYITEMFACT][CREATEDSTAMP,2012-11-18 01:43:20.227(JAVA.SQL.TIMESTAMP)][CREATEDTXSTAMP,2012-11-18 01:43:18.142(JAVA.SQL.TIMESTAMP)][INVENTORYDATEDIMID,_NF_(JAVA.LANG.STRING)][INVENTORYITEMID,9000(JAVA.LANG.STRING)][LASTUPDATEDSTAMP,2012-11-18 01:43:20.227(JAVA.SQL.TIMESTAMP)][LASTUPDATEDTXSTAMP,2012-11-18 01:43:18.142(JAVA.SQL.TIMESTAMP)][ORIGCURRENCYDIMID,11506(JAVA.LANG.STRING)][PRODUCTDIMID,10783(JAVA.LANG.STRING)] (SQL EXCEPTION WHILE EXECUTING THE FOLLOWING:INSERT INTO INVENTORY_ITEM_FACT (INVENTORY_ITEM_ID, FACILITY_ID, PRODUCT_DIM_ID, ORIG_CURRENCY_DIM_ID, INVENTORY_DATE_DIM_ID, QUANTITY_ON_HAND_TOTAL, AVAILABLE_TO_PROMISE_TOTAL, UNIT_COST, SOLDOUT_AMOUNT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (CANNOT ADD OR UPDATE A CHILD ROW: A FOREIGN KEY CONSTRAINT FAILS (`OFBIZOLAP`.`INVENTORY_ITEM_FACT`, CONSTRAINT `IIF_INVDATE` FOREIGN KEY (`INVENTORY_DATE_DIM_ID`) REFERENCES `DATE_DIMENSION` (`DIMENSION_ID`)))) (ERROR WHILE INSERTING: [GENERICENTITY:INVENTORYITEMFACT][CREATEDSTAMP,2012-11-18 01:43:20.227(JAVA.SQL.TIMESTAMP)][CREATEDTXSTAMP,2012-11-18 01:43:18.142(JAVA.SQL.TIMESTAMP)][INVENTORYDATEDIMID,_NF_(JAVA.LANG.STRING)][INVENTORYITEMID,9000(JAVA.LANG.STRING)][LASTUPDATEDSTAMP,2012-11-18 01:43:20.227(JAVA.SQL.TIMESTAMP)][LASTUPDATEDTXSTAMP,2012-11-18 01:43:18.142(JAVA.SQL.TIMESTAMP)][ORIGCURRENCYDIMID,11506(JAVA.LANG.STRING)][PRODUCTDIMID,10783(JAVA.LANG.STRING)] (SQL EXCEPTION WHILE EXECUTING THE FOLLOWING:INSERT INTO INVENTORY_ITEM_FACT (INVENTORY_ITEM_ID, FACILITY_ID, PRODUCT_DIM_ID, ORIG_CURRENCY_DIM_ID, INVENTORY_DATE_DIM_ID, QUANTITY_ON_HAND_TOTAL, AVAILABLE_TO_PROMISE_TOTAL, UNIT_COST, SOLDOUT_AMOUNT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (CANNOT ADD OR UPDATE A CHILD ROW: A FOREIGN KEY CONSTRAINT FAILS (`OFBIZOLAP`.`INVENTORY_ITEM_FACT`, CONSTRAINT `IIF_INVDATE` FOREIGN KEY (`INVENTORY_DATE_DIM_ID`) REFERENCES `DATE_DIMENSION` (`DIMENSION_ID`))))) -- View this message in context: http://ofbiz.135035.n4.nabble.com/eror-quickinitdatawarehouse-tp4637715.html Sent from the OFBiz - User mailing list archive at Nabble.com.
