You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Dayah Iman <da...@gmail.com> on 2016/02/04 14:47:21 UTC
Why is Party Id set to ACCOUNTING release14.12 ofbizsetup wizard?
Hi,
I have been playing with releases 13.07.02 and 14.12. I'm new to Ofbiz but
was able to run release 13 on my windows laptop, configure it as
multitenant, and use to the ofbizsetup wizard. However, release 13 doesn't
include the specialpurpose components (myportal, bi, project, assetmaint,
to name those I'm interested in).
So I went ahead and installed release 14 with the same setup. When I run
the ofbizsetup wizard I found that ACCOUNTING Party has already been
created. Even if I want to use ACCOUNTING I'm facing the foreign key
violation error shown below.
Any help would be greatly appreciated.
I performed the following steps.
1. created DBs (ofbiz, ofbizolap, ofbiztenant, ofbiz_sbe, ofbizolap_sbe) on
MySQL
2. ran ant load-demo
3. ran ant create-tenant
4. ran ant start
5. ran the ofbizsetup wizard
6. logged into the tenant
Error:
[java] org.ofbiz.entity.GenericEntityException:
org.ofbiz.entity.GenericEntityException:
org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:CarrierShipmentMethod][createdStamp,2016-01-30
19:21:05.166(java.sql.Timestamp)][createdTxStamp,2016-01-30
19:21:02.774(java.sql.Timestamp)][lastUpdatedStamp,2016-01-30
19:21:05.166(java.sql.Timestamp)][lastUpdatedTxStamp,2016-01-30
19:21:02.774(java.sql.Timestamp)][partyId,ACCOUNTING(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, ROLE_TYPE_ID,
SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, 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 (`ofbiz_sbe`.`carrier_shipment_method`, CONSTRAINT
`CARR_SHMETH_PROLE` FOREIGN KEY (`PARTY_ID`, `ROLE_TYPE_ID`) REFERENCES
`party_role` (`PARTY_ID`, `ROLE_TYPE_ID`)))) (Error while inserting:
[GenericEntity:CarrierShipmentMethod][createdStamp,2016-01-30
19:21:05.166(java.sql.Timestamp)][createdTxStamp,2016-01-30
19:21:02.774(java.sql.Timestamp)][lastUpdatedStamp,2016-01-30
19:21:05.166(java.sql.Timestamp)][lastUpdatedTxStamp,2016-01-30
19:21:02.774(java.sql.Timestamp)][partyId,ACCOUNTING(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, ROLE_TYPE_ID,
SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, 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 (`ofbiz_sbe`.`carrier_shipment_method`, CONSTRAINT
`CARR_SHMETH_PROLE` FOREIGN KEY (`PARTY_ID`, `ROLE_TYPE_ID`) REFERENCES
`party_role` (`PARTY_ID`, `ROLE_TYPE_ID`)))))
(org.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:CarrierShipmentMethod][createdStamp,2016-01-30
19:21:05.166(java.sql.Timestamp)][createdTxStamp,2016-01-30
19:21:02.774(java.sql.Timestamp)][lastUpdatedStamp,2016-01-30
19:21:05.166(java.sql.Timestamp)][lastUpdatedTxStamp,2016-01-30
19:21:02.774(java.sql.Timestamp)][partyId,ACCOUNTING(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, ROLE_TYPE_ID,
SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, 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 (`ofbiz_sbe`.`carrier_shipment_method`, CONSTRAINT
`CARR_SHMETH_PROLE` FOREIGN KEY (`PARTY_ID`, `ROLE_TYPE_ID`) REFERENCES
`party_role` (`PARTY_ID`, `ROLE_TYPE_ID`)))) (Error while inserting:
[GenericEntity:CarrierShipmentMethod][createdStamp,2016-01-30
19:21:05.166(java.sql.Timestamp)][createdTxStamp,2016-01-30
19:21:02.774(java.sql.Timestamp)][lastUpdatedStamp,2016-01-30
19:21:05.166(java.sql.Timestamp)][lastUpdatedTxStamp,2016-01-30
19:21:02.774(java.sql.Timestamp)][partyId,ACCOUNTING(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, ROLE_TYPE_ID,
SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, 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 (`ofbiz_sbe`.`carrier_shipment_method`, CONSTRAINT
`CARR_SHMETH_PROLE` FOREIGN KEY (`PARTY_ID`, `ROLE_TYPE_ID`) REFERENCES
`party_role` (`PARTY_ID`, `ROLE_TYPE_ID`))))))
Thanks
Re: Why is Party Id set to ACCOUNTING release14.12 ofbizsetup
wizard?
Posted by Jacques Le Roux <ja...@les7arts.com>.
Please open a Jira for this
Thanks
Jacques
Le 04/02/2016 14:47, Dayah Iman a écrit :
> Hi,
>
> I have been playing with releases 13.07.02 and 14.12. I'm new to Ofbiz but
> was able to run release 13 on my windows laptop, configure it as
> multitenant, and use to the ofbizsetup wizard. However, release 13 doesn't
> include the specialpurpose components (myportal, bi, project, assetmaint,
> to name those I'm interested in).
> So I went ahead and installed release 14 with the same setup. When I run
> the ofbizsetup wizard I found that ACCOUNTING Party has already been
> created. Even if I want to use ACCOUNTING I'm facing the foreign key
> violation error shown below.
>
> Any help would be greatly appreciated.
>
> I performed the following steps.
> 1. created DBs (ofbiz, ofbizolap, ofbiztenant, ofbiz_sbe, ofbizolap_sbe) on
> MySQL
> 2. ran ant load-demo
> 3. ran ant create-tenant
> 4. ran ant start
> 5. ran the ofbizsetup wizard
> 6. logged into the tenant
>
>
> Error:
> [java] org.ofbiz.entity.GenericEntityException:
> org.ofbiz.entity.GenericEntityException:
> org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:CarrierShipmentMethod][createdStamp,2016-01-30
> 19:21:05.166(java.sql.Timestamp)][createdTxStamp,2016-01-30
> 19:21:02.774(java.sql.Timestamp)][lastUpdatedStamp,2016-01-30
> 19:21:05.166(java.sql.Timestamp)][lastUpdatedTxStamp,2016-01-30
> 19:21:02.774(java.sql.Timestamp)][partyId,ACCOUNTING(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, ROLE_TYPE_ID,
> SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, 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 (`ofbiz_sbe`.`carrier_shipment_method`, CONSTRAINT
> `CARR_SHMETH_PROLE` FOREIGN KEY (`PARTY_ID`, `ROLE_TYPE_ID`) REFERENCES
> `party_role` (`PARTY_ID`, `ROLE_TYPE_ID`)))) (Error while inserting:
> [GenericEntity:CarrierShipmentMethod][createdStamp,2016-01-30
> 19:21:05.166(java.sql.Timestamp)][createdTxStamp,2016-01-30
> 19:21:02.774(java.sql.Timestamp)][lastUpdatedStamp,2016-01-30
> 19:21:05.166(java.sql.Timestamp)][lastUpdatedTxStamp,2016-01-30
> 19:21:02.774(java.sql.Timestamp)][partyId,ACCOUNTING(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, ROLE_TYPE_ID,
> SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, 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 (`ofbiz_sbe`.`carrier_shipment_method`, CONSTRAINT
> `CARR_SHMETH_PROLE` FOREIGN KEY (`PARTY_ID`, `ROLE_TYPE_ID`) REFERENCES
> `party_role` (`PARTY_ID`, `ROLE_TYPE_ID`)))))
> (org.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:CarrierShipmentMethod][createdStamp,2016-01-30
> 19:21:05.166(java.sql.Timestamp)][createdTxStamp,2016-01-30
> 19:21:02.774(java.sql.Timestamp)][lastUpdatedStamp,2016-01-30
> 19:21:05.166(java.sql.Timestamp)][lastUpdatedTxStamp,2016-01-30
> 19:21:02.774(java.sql.Timestamp)][partyId,ACCOUNTING(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, ROLE_TYPE_ID,
> SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, 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 (`ofbiz_sbe`.`carrier_shipment_method`, CONSTRAINT
> `CARR_SHMETH_PROLE` FOREIGN KEY (`PARTY_ID`, `ROLE_TYPE_ID`) REFERENCES
> `party_role` (`PARTY_ID`, `ROLE_TYPE_ID`)))) (Error while inserting:
> [GenericEntity:CarrierShipmentMethod][createdStamp,2016-01-30
> 19:21:05.166(java.sql.Timestamp)][createdTxStamp,2016-01-30
> 19:21:02.774(java.sql.Timestamp)][lastUpdatedStamp,2016-01-30
> 19:21:05.166(java.sql.Timestamp)][lastUpdatedTxStamp,2016-01-30
> 19:21:02.774(java.sql.Timestamp)][partyId,ACCOUNTING(java.lang.String)][roleTypeId,CARRIER(java.lang.String)][sequenceNumber,4(java.lang.Long)][shipmentMethodTypeId,LOCAL_DELIVERY(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> CARRIER_SHIPMENT_METHOD (SHIPMENT_METHOD_TYPE_ID, PARTY_ID, ROLE_TYPE_ID,
> SEQUENCE_NUMBER, CARRIER_SERVICE_CODE, 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 (`ofbiz_sbe`.`carrier_shipment_method`, CONSTRAINT
> `CARR_SHMETH_PROLE` FOREIGN KEY (`PARTY_ID`, `ROLE_TYPE_ID`) REFERENCES
> `party_role` (`PARTY_ID`, `ROLE_TYPE_ID`))))))
>
>
> Thanks
>