eror quickinitdatawarehouse

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

eror quickinitdatawarehouse

flopau
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`)))))
Reply | Threaded
Open this post in threaded view
|

Re: eror quickinitdatawarehouse

Jacques Le Roux
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
Reply | Threaded
Open this post in threaded view
|

Re: eror quickinitdatawarehouse

flopau
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?
Reply | Threaded
Open this post in threaded view
|

Re: eror quickinitdatawarehouse

Jacques Le Roux
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
Reply | Threaded
Open this post in threaded view
|

Re: eror quickinitdatawarehouse

flopau
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