OFBiz › OFBiz - User

Why is Party Id set to ACCOUNTING release14.12 ofbizsetup wizard?

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 2 messages Options
imand
Reply | Threaded
Open this post in threaded view
♦
♦
|

Why is Party Id set to ACCOUNTING release14.12 ofbizsetup wizard?

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

Re: Why is Party Id set to ACCOUNTING release14.12 ofbizsetup wizard?

Jacques Le Roux
Administrator
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
>
Free forum by Nabble Edit this page