You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by flopau <fl...@web.de> on 2012/11/18 00:51:29 UTC
eror quickinitdatawarehouse
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.
Re: eror quickinitdatawarehouse
Posted by Jacques Le Roux <ja...@les7arts.com>.
From: "flopau" <fl...@web.de>
> 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
Re: eror quickinitdatawarehouse
Posted by flopau <fl...@web.de>.
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
--
View this message in context: http://ofbiz.135035.n4.nabble.com/eror-quickinitdatawarehouse-tp4637715p4637736.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: eror quickinitdatawarehouse
Posted by flopau <fl...@web.de>.
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?
--
View this message in context: http://ofbiz.135035.n4.nabble.com/eror-quickinitdatawarehouse-tp4637715p4637734.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: eror quickinitdatawarehouse
Posted by Jacques Le Roux <ja...@les7arts.com>.
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" <fl...@web.de>
> Quickinitdatawarehouse shows following error:
>
> -fresh installation with update 17.11.12