ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dayah Iman <dayah.i...@gmail.com>
Subject Why is Party Id set to ACCOUNTING release14.12 ofbizsetup wizard?
Date Thu, 04 Feb 2016 13:47:21 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message