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

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
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`))))))