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`))))) |
Administrator
|
I don't reproduce locally (trunk), nor on trunk demo
Did you load data before? Wich Release.revision are you using? (see bottom of backend pages, if nothing run ant svninfo) Jacques From: "flopau" <[hidden email]> > Quickinitdatawarehouse shows following error: > > -fresh installation with update 17.11.12 |
Thanks for Reply
Base intallation with demo data was 20.05.2011 Could the reason be, that the demo data is not longer consistent with new release? Should i clean db an reload demo data? |
Administrator
|
From: "flopau" <[hidden email]>
> Thanks for Reply > > Base intallation with demo data was 20.05.2011 > Could the reason be, that the demo data is not longer consistent with new > release? > > Should i clean db an reload demo data? You may try that, I guess you use trunk then, and are in demo mode. Jacques |
In reply to this post by flopau
installed themes doestn display version info in the bottom info.
only....copyright, date and language svn info in ofbiz shows: revision: 1409330 last changed revision: 1408408svn |
Free forum by Nabble | Edit this page |