Error messages when uploading xml files

[wp.rauchholz]

I am trying to upload xml data that I had exported previously form ofbiz. Some of the files fail to load. But it does not give an error message.

Got 1 entities from CostComponentCalc.xml
Got 1 entities from WorkEffortCostCalc.xml
Got 1 entities from FacilityParty.xml
Failed GlAccountOrganization.xml adding to retry list for next pass
Failed GlAccountTypeDefault.xml adding to retry list for next pass
Got 1 entities from WorkEffortPartyAssignment.xml

Pass 1 complete

Failed PaymentGatewayClearCommerce.xml adding to retry list for next pass
Failed PaymentGatewayOrbital.xml adding to retry list for next pass
Failed PaymentGatewayPayflowPro.xml adding to retry list for next pass
Failed PaymentGatewaySecurePay.xml adding to retry list for next pass
Failed PaymentGatewayiDEAL.xml adding to retry list for next pass
Failed ShipmentGatewayDhl.xml adding to retry list for next pass
Failed ShipmentGatewayUps.xml adding to retry list for next pass
Failed ShipmentGatewayUsps.xml adding to retry list for next pass
Failed GlAccount.xml adding to retry list for next pass
Failed GlAccountOrganization.xml adding to retry list for next pass
Failed GlAccountTypeDefault.xml adding to retry list for next pass

Pass 2 complete

---------------------------------------
Succeeded: 254 of 265
Failed: 11 of 265
---------------------------------------

Failed Files:
/home/wp.rauchholz/ofbiz/PaymentGatewayClearCommerce.xml
/home/wp.rauchholz/ofbiz/PaymentGatewayOrbital.xml
/home/wp.rauchholz/ofbiz/PaymentGatewayPayflowPro.xml
/home/wp.rauchholz/ofbiz/PaymentGatewaySecurePay.xml
/home/wp.rauchholz/ofbiz/PaymentGatewayiDEAL.xml
/home/wp.rauchholz/ofbiz/ShipmentGatewayDhl.xml
/home/wp.rauchholz/ofbiz/ShipmentGatewayUps.xml
/home/wp.rauchholz/ofbiz/ShipmentGatewayUsps.xml
/home/wp.rauchholz/ofbiz/GlAccount.xml
/home/wp.rauchholz/ofbiz/GlAccountOrganization.xml
/home/wp.rauchholz/ofbiz/GlAccountTypeDefault.xml

Any suggestions?

Thanks for your help, WOlfgang

[Paul Foxworthy]

Hi Wolfgang,

These import errors are usually caused by circular or missing foreign key
relationships.

You can ignore the payment and shipping gateways. If you ever want to use a
particular credit card payment gateway or shipping company, you can enter
that data into your new OFBiz.

The GL accounts may be more significant. If you check the OFBiz log
(/webtools/control/LogView), you should see which records are failing.

Cheers

Paul Foxworthy


On 29 May 2018 at 05:38, [hidden email] <[hidden email]>
wrote:

> I am trying to upload xml data that I had exported previously form ofbiz.
> Some of the files fail to load. But it does not give an error message.
>
> Got 1 entities from CostComponentCalc.xml
> Got 1 entities from WorkEffortCostCalc.xml
> Got 1 entities from FacilityParty.xml
> Failed GlAccountOrganization.xml adding to retry list for next pass
> Failed GlAccountTypeDefault.xml adding to retry list for next pass
> Got 1 entities from WorkEffortPartyAssignment.xml
>
> Pass 1 complete
>
> Failed PaymentGatewayClearCommerce.xml adding to retry list for next pass
> Failed PaymentGatewayOrbital.xml adding to retry list for next pass
> Failed PaymentGatewayPayflowPro.xml adding to retry list for next pass
> Failed PaymentGatewaySecurePay.xml adding to retry list for next pass
> Failed PaymentGatewayiDEAL.xml adding to retry list for next pass
> Failed ShipmentGatewayDhl.xml adding to retry list for next pass
> Failed ShipmentGatewayUps.xml adding to retry list for next pass
> Failed ShipmentGatewayUsps.xml adding to retry list for next pass
> Failed GlAccount.xml adding to retry list for next pass
> Failed GlAccountOrganization.xml adding to retry list for next pass
> Failed GlAccountTypeDefault.xml adding to retry list for next pass
>
> Pass 2 complete
>
> ---------------------------------------
> Succeeded: 254 of 265
> Failed: 11 of 265
> ---------------------------------------
>
> Failed Files:
> /home/wp.rauchholz/ofbiz/PaymentGatewayClearCommerce.xml
> /home/wp.rauchholz/ofbiz/PaymentGatewayOrbital.xml
> /home/wp.rauchholz/ofbiz/PaymentGatewayPayflowPro.xml
> /home/wp.rauchholz/ofbiz/PaymentGatewaySecurePay.xml
> /home/wp.rauchholz/ofbiz/PaymentGatewayiDEAL.xml
> /home/wp.rauchholz/ofbiz/ShipmentGatewayDhl.xml
> /home/wp.rauchholz/ofbiz/ShipmentGatewayUps.xml
> /home/wp.rauchholz/ofbiz/ShipmentGatewayUsps.xml
> /home/wp.rauchholz/ofbiz/GlAccount.xml
> /home/wp.rauchholz/ofbiz/GlAccountOrganization.xml
> /home/wp.rauchholz/ofbiz/GlAccountTypeDefault.xml
>
> Any suggestions?
>
> Thanks for your help, WOlfgang
>
>

--
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Australia

Phone: [phone]
Web: http://www.coherentsoftware.com.au/
Email: [hidden email]

[wp.rauchholz]

Thank you for following up Paul. The log is very long. This is a very small
snapshot

2018-05-29 09:22:49,152 |http-nio-8443-exec-3 |EntitySaxReader |I|
Beginning import from URL: file:/home/wp.rauchholz/ofbiz/GlAccount.xml
2018-05-29 09:22:49,156 |http-nio-8443-exec-3 |EntitySaxReader |I|
Transaction Timeout set to 2 hours (7200 seconds)
2018-05-29 09:22:49,159 |xer_default_products |DocumentIndexer |I|
DocumentIndexer_default_products: indexed Lucene document: productId:20011
2018-05-29 09:22:49,170 |xer_default_products |DocumentIndexer |I|
DocumentIndexer_default_products: indexed Lucene document: productId:10003
2018-05-29 09:22:49,171 |http-nio-8443-exec-3 |GenericDelegator |E| Failure
in create operation for entity [GlAccount]:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:GlAccount][accountCode,402000(java.lang.String)][accountName,Miscellaneous
Sales(java.lang.String)][createdStamp,2018-05-29
09:22:49.175(java.sql.Timestamp)][createdTxStamp,2018-05-29
09:22:49.156(java.sql.Timestamp)][glAccountClassId,REVENUE(java.lang.String)][glAccountId,10015(java.lang.String)][glAccountTypeId,_NA_(java.lang.String)][glResourceTypeId,MONEY(java.lang.String)][lastUpdatedStamp,2018-05-29
09:22:49.175(java.sql.Timestamp)][lastUpdatedTxStamp,2018-05-29
09:22:49.156(java.sql.Timestamp)][parentGlAccountId,10177(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO GL_ACCOUNT
(GL_ACCOUNT_ID, GL_ACCOUNT_TYPE_ID, GL_ACCOUNT_CLASS_ID,
GL_RESOURCE_TYPE_ID, GL_XBRL_CLASS_ID, PARENT_GL_ACCOUNT_ID, ACCOUNT_CODE,
ACCOUNT_NAME, DESCRIPTION, PRODUCT_ID, EXTERNAL_ID, 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`.`GL_ACCOUNT`, CONSTRAINT `GLACCT_PAR`
FOREIGN KEY (`PARENT_GL_ACCOUNT_ID`) REFERENCES `GL_ACCOUNT`
(`GL_ACCOUNT_ID`)))). Rolling back transaction.
2018-05-29 09:22:49,171 |http-nio-8443-exec-3 |TransactionUtil |W| Calling
transaction setRollbackOnly; this stack trace shows where this is happening:
java.lang.Exception: Failure in create operation for entity [GlAccount]:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:GlAccount][accountCode,402000(java.lang.String)][accountName,Miscellaneous
Sales(java.lang.String)][createdStamp,2018-05-29
09:22:49.175(java.sql.Timestamp)][createdTxStamp,2018-05-29
09:22:49.156(java.sql.Timestamp)][glAccountClassId,REVENUE(java.lang.String)][glAccountId,10015(java.lang.String)][glAccountTypeId,_NA_(java.lang.String)][glResourceTypeId,MONEY(java.lang.String)][lastUpdatedStamp,2018-05-29
09:22:49.175(java.sql.Timestamp)][lastUpdatedTxStamp,2018-05-29
09:22:49.156(java.sql.Timestamp)][parentGlAccountId,10177(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO GL_ACCOUNT
(GL_ACCOUNT_ID, GL_ACCOUNT_TYPE_ID, GL_ACCOUNT_CLASS_ID,
GL_RESOURCE_TYPE_ID, GL_XBRL_CLASS_ID, PARENT_GL_ACCOUNT_ID, ACCOUNT_CODE,
ACCOUNT_NAME, DESCRIPTION, PRODUCT_ID, EXTERNAL_ID, 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`.`GL_ACCOUNT`, CONSTRAINT `GLACCT_PAR`
FOREIGN KEY (`PARENT_GL_ACCOUNT_ID`) REFERENCES `GL_ACCOUNT`
(`GL_ACCOUNT_ID`)))). Rolling back transaction.




2018-05-29 09:22:49,183 |xer_default_products |DocumentIndexer |I|
DocumentIndexer_default_products: indexed Lucene document: productId:20017
2018-05-29 09:22:49,176 |http-nio-8443-exec-3 |GenericDelegator |E| Failure
in storeAll operation: org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:GlAccount][accountCode,402000(java.lang.String)][accountName,Miscellaneous
Sales(java.lang.String)][createdStamp,2018-05-29
09:22:49.175(java.sql.Timestamp)][createdTxStamp,2018-05-29
09:22:49.156(java.sql.Timestamp)][glAccountClassId,REVENUE(java.lang.String)][glAccountId,10015(java.lang.String)][glAccountTypeId,_NA_(java.lang.String)][glResourceTypeId,MONEY(java.lang.String)][lastUpdatedStamp,2018-05-29
09:22:49.175(java.sql.Timestamp)][lastUpdatedTxStamp,2018-05-29
09:22:49.156(java.sql.Timestamp)][parentGlAccountId,10177(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO GL_ACCOUNT
(GL_ACCOUNT_ID, GL_ACCOUNT_TYPE_ID, GL_ACCOUNT_CLASS_ID,
GL_RESOURCE_TYPE_ID, GL_XBRL_CLASS_ID, PARENT_GL_ACCOUNT_ID, ACCOUNT_CODE,
ACCOUNT_NAME, DESCRIPTION, PRODUCT_ID, EXTERNAL_ID, 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`.`GL_ACCOUNT`, CONSTRAINT `GLACCT_PAR`
FOREIGN KEY (`PARENT_GL_ACCOUNT_ID`) REFERENCES `GL_ACCOUNT`
(`GL_ACCOUNT_ID`)))) (Error while inserting:
[GenericEntity:GlAccount][accountCode,402000(java.lang.String)][accountName,Miscellaneous
Sales(java.lang.String)][createdStamp,2018-05-29
09:22:49.175(java.sql.Timestamp)][createdTxStamp,2018-05-29
09:22:49.156(java.sql.Timestamp)][glAccountClassId,REVENUE(java.lang.String)][glAccountId,10015(java.lang.String)][glAccountTypeId,_NA_(java.lang.String)][glResourceTypeId,MONEY(java.lang.String)][lastUpdatedStamp,2018-05-29
09:22:49.175(java.sql.Timestamp)][lastUpdatedTxStamp,2018-05-29
09:22:49.156(java.sql.Timestamp)][parentGlAccountId,10177(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO GL_ACCOUNT
(GL_ACCOUNT_ID, GL_ACCOUNT_TYPE_ID, GL_ACCOUNT_CLASS_ID,
GL_RESOURCE_TYPE_ID, GL_XBRL_CLASS_ID, PARENT_GL_ACCOUNT_ID, ACCOUNT_CODE,
ACCOUNT_NAME, DESCRIPTION, PRODUCT_ID, EXTERNAL_ID, 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`.`GL_ACCOUNT`, CONSTRAINT `GLACCT_PAR`
FOREIGN KEY (`PARENT_GL_ACCOUNT_ID`) REFERENCES `GL_ACCOUNT`
(`GL_ACCOUNT_ID`))))). Rolling back transaction.
org.apache.ofbiz.entity.GenericEntityException:
org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
[GenericEntity:GlAccount][accountCode,402000(java.lang.String)][accountName,Miscellaneous
Sales(java.lang.String)][createdStamp,2018-05-29
09:22:49.175(java.sql.Timestamp)][createdTxStamp,2018-05-29
09:22:49.156(java.sql.Timestamp)][glAccountClassId,REVENUE(java.lang.String)][glAccountId,10015(java.lang.String)][glAccountTypeId,_NA_(java.lang.String)][glResourceTypeId,MONEY(java.lang.String)][lastUpdatedStamp,2018-05-29
09:22:49.175(java.sql.Timestamp)][lastUpdatedTxStamp,2018-05-29
09:22:49.156(java.sql.Timestamp)][parentGlAccountId,10177(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO GL_ACCOUNT
(GL_ACCOUNT_ID, GL_ACCOUNT_TYPE_ID, GL_ACCOUNT_CLASS_ID,
GL_RESOURCE_TYPE_ID, GL_XBRL_CLASS_ID, PARENT_GL_ACCOUNT_ID, ACCOUNT_CODE,
ACCOUNT_NAME, DESCRIPTION, PRODUCT_ID, EXTERNAL_ID, 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`.`GL_ACCOUNT`, CONSTRAINT `GLACCT_PAR`
FOREIGN KEY (`PARENT_GL_ACCOUNT_ID`) REFERENCES `GL_ACCOUNT`
(`GL_ACCOUNT_ID`)))) (Error while inserting:
[GenericEntity:GlAccount][accountCode,402000(java.lang.String)][accountName,Miscellaneous
Sales(java.lang.String)][createdStamp,2018-05-29
09:22:49.175(java.sql.Timestamp)][createdTxStamp,2018-05-29
09:22:49.156(java.sql.Timestamp)][glAccountClassId,REVENUE(java.lang.String)][glAccountId,10015(java.lang.String)][glAccountTypeId,_NA_(java.lang.String)][glResourceTypeId,MONEY(java.lang.String)][lastUpdatedStamp,2018-05-29
09:22:49.175(java.sql.Timestamp)][lastUpdatedTxStamp,2018-05-29
09:22:49.156(java.sql.Timestamp)][parentGlAccountId,10177(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO GL_ACCOUNT
(GL_ACCOUNT_ID, GL_ACCOUNT_TYPE_ID, GL_ACCOUNT_CLASS_ID,
GL_RESOURCE_TYPE_ID, GL_XBRL_CLASS_ID, PARENT_GL_ACCOUNT_ID, ACCOUNT_CODE,
ACCOUNT_NAME, DESCRIPTION, PRODUCT_ID, EXTERNAL_ID, 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`.`GL_ACCOUNT`, CONSTRAINT `GLACCT_PAR`
FOREIGN KEY (`PARENT_GL_ACCOUNT_ID`) REFERENCES `GL_ACCOUNT`
(`GL_ACCOUNT_ID`)))))


Thanks for he help, Wolfgang





On Tue, May 29, 2018 at 2:47 AM, Paul Foxworthy <[hidden email]> wrote:

> Hi Wolfgang,
>
> These import errors are usually caused by circular or missing foreign key
> relationships.
>
> You can ignore the payment and shipping gateways. If you ever want to use a
> particular credit card payment gateway or shipping company, you can enter
> that data into your new OFBiz.
>
> The GL accounts may be more significant. If you check the OFBiz log
> (/webtools/control/LogView), you should see which records are failing.
>
> Cheers
>
> Paul Foxworthy
>
>
> On 29 May 2018 at 05:38, [hidden email] <[hidden email]>
> wrote:
>
> > I am trying to upload xml data that I had exported previously form ofbiz.
> > Some of the files fail to load. But it does not give an error message.
> >
> > Got 1 entities from CostComponentCalc.xml
> > Got 1 entities from WorkEffortCostCalc.xml
> > Got 1 entities from FacilityParty.xml
> > Failed GlAccountOrganization.xml adding to retry list for next pass
> > Failed GlAccountTypeDefault.xml adding to retry list for next pass
> > Got 1 entities from WorkEffortPartyAssignment.xml
> >
> > Pass 1 complete
> >
> > Failed PaymentGatewayClearCommerce.xml adding to retry list for next
> pass
> > Failed PaymentGatewayOrbital.xml adding to retry list for next pass
> > Failed PaymentGatewayPayflowPro.xml adding to retry list for next pass
> > Failed PaymentGatewaySecurePay.xml adding to retry list for next pass
> > Failed PaymentGatewayiDEAL.xml adding to retry list for next pass
> > Failed ShipmentGatewayDhl.xml adding to retry list for next pass
> > Failed ShipmentGatewayUps.xml adding to retry list for next pass
> > Failed ShipmentGatewayUsps.xml adding to retry list for next pass
> > Failed GlAccount.xml adding to retry list for next pass
> > Failed GlAccountOrganization.xml adding to retry list for next pass
> > Failed GlAccountTypeDefault.xml adding to retry list for next pass
> >
> > Pass 2 complete
> >
> > ---------------------------------------
> > Succeeded: 254 of 265
> > Failed: 11 of 265
> > ---------------------------------------
> >
> > Failed Files:
> > /home/wp.rauchholz/ofbiz/PaymentGatewayClearCommerce.xml
> > /home/wp.rauchholz/ofbiz/PaymentGatewayOrbital.xml
> > /home/wp.rauchholz/ofbiz/PaymentGatewayPayflowPro.xml
> > /home/wp.rauchholz/ofbiz/PaymentGatewaySecurePay.xml
> > /home/wp.rauchholz/ofbiz/PaymentGatewayiDEAL.xml
> > /home/wp.rauchholz/ofbiz/ShipmentGatewayDhl.xml
> > /home/wp.rauchholz/ofbiz/ShipmentGatewayUps.xml
> > /home/wp.rauchholz/ofbiz/ShipmentGatewayUsps.xml
> > /home/wp.rauchholz/ofbiz/GlAccount.xml
> > /home/wp.rauchholz/ofbiz/GlAccountOrganization.xml
> > /home/wp.rauchholz/ofbiz/GlAccountTypeDefault.xml
> >
> > Any suggestions?
> >
> > Thanks for your help, WOlfgang
> >
> >
>
>
> --
> Coherent Software Australia Pty Ltd
> PO Box 2773
> Cheltenham Vic 3192
> Australia
>
> Phone: [phone]
> Web: http://www.coherentsoftware.com.au/
> Email: [hidden email]
>

--

Wolfgang Rauchholz

[wp.rauchholz]

Manually I can enter the GL accounts without a problem.

Wolfgang


On Tue, May 29, 2018 at 9:26 AM, Wolfgang Paul Rauchholz <
[hidden email]> wrote:

> Thank you for following up Paul. The log is very long. This is a very
> small snapshot
>
> 2018-05-29 09:22:49,152 |http-nio-8443-exec-3 |EntitySaxReader |I|
> Beginning import from URL: file:/home/wp.rauchholz/ofbiz/GlAccount.xml
> 2018-05-29 09:22:49,156 |http-nio-8443-exec-3 |EntitySaxReader |I|
> Transaction Timeout set to 2 hours (7200 seconds)
> 2018-05-29 09:22:49,159 |xer_default_products |DocumentIndexer |I|
> DocumentIndexer_default_products: indexed Lucene document: productId:20011
> 2018-05-29 09:22:49,170 |xer_default_products |DocumentIndexer |I|
> DocumentIndexer_default_products: indexed Lucene document: productId:10003
> 2018-05-29 09:22:49,171 |http-nio-8443-exec-3 |GenericDelegator |E|
> Failure in create operation for entity [GlAccount]: org.apache.ofbiz.entity.GenericEntityException:
> Error while inserting: [GenericEntity:GlAccount][
> accountCode,402000(java.lang.String)][accountName,Miscellaneous
> Sales(java.lang.String)][createdStamp,2018-05-29 09:22:49.175(java.sql.
> Timestamp)][createdTxStamp,2018-05-29 09:22:49.156(java.sql.
> Timestamp)][glAccountClassId,REVENUE(java.lang.String)][
> glAccountId,10015(java.lang.String)][glAccountTypeId,_NA_(
> java.lang.String)][glResourceTypeId,MONEY(java.lang.String)][lastUpdatedStamp,2018-05-29
> 09:22:49.175(java.sql.Timestamp)][lastUpdatedTxStamp,2018-05-29
> 09:22:49.156(java.sql.Timestamp)][parentGlAccountId,10177(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO GL_ACCOUNT
> (GL_ACCOUNT_ID, GL_ACCOUNT_TYPE_ID, GL_ACCOUNT_CLASS_ID,
> GL_RESOURCE_TYPE_ID, GL_XBRL_CLASS_ID, PARENT_GL_ACCOUNT_ID, ACCOUNT_CODE,
> ACCOUNT_NAME, DESCRIPTION, PRODUCT_ID, EXTERNAL_ID, 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`.`GL_ACCOUNT`, CONSTRAINT `GLACCT_PAR`
> FOREIGN KEY (`PARENT_GL_ACCOUNT_ID`) REFERENCES `GL_ACCOUNT`
> (`GL_ACCOUNT_ID`)))). Rolling back transaction.
> 2018-05-29 09:22:49,171 |http-nio-8443-exec-3 |TransactionUtil |W| Calling
> transaction setRollbackOnly; this stack trace shows where this is happening:
> java.lang.Exception: Failure in create operation for entity [GlAccount]:
> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:GlAccount][accountCode,402000(java.lang.
> String)][accountName,Miscellaneous Sales(java.lang.String)][createdStamp,2018-05-29
> 09:22:49.175(java.sql.Timestamp)][createdTxStamp,2018-05-29
> 09:22:49.156(java.sql.Timestamp)][glAccountClassId,
> REVENUE(java.lang.String)][glAccountId,10015(java.lang.
> String)][glAccountTypeId,_NA_(java.lang.String)][
> glResourceTypeId,MONEY(java.lang.String)][lastUpdatedStamp,2018-05-29
> 09:22:49.175(java.sql.Timestamp)][lastUpdatedTxStamp,2018-05-29
> 09:22:49.156(java.sql.Timestamp)][parentGlAccountId,10177(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO GL_ACCOUNT
> (GL_ACCOUNT_ID, GL_ACCOUNT_TYPE_ID, GL_ACCOUNT_CLASS_ID,
> GL_RESOURCE_TYPE_ID, GL_XBRL_CLASS_ID, PARENT_GL_ACCOUNT_ID, ACCOUNT_CODE,
> ACCOUNT_NAME, DESCRIPTION, PRODUCT_ID, EXTERNAL_ID, 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`.`GL_ACCOUNT`, CONSTRAINT `GLACCT_PAR`
> FOREIGN KEY (`PARENT_GL_ACCOUNT_ID`) REFERENCES `GL_ACCOUNT`
> (`GL_ACCOUNT_ID`)))). Rolling back transaction.
>
>
>
>
> 2018-05-29 09:22:49,183 |xer_default_products |DocumentIndexer |I|
> DocumentIndexer_default_products: indexed Lucene document: productId:20017
> 2018-05-29 09:22:49,176 |http-nio-8443-exec-3 |GenericDelegator |E|
> Failure in storeAll operation: org.apache.ofbiz.entity.GenericEntityException:
> org.apache.ofbiz.entity.GenericEntityException: Error while inserting:
> [GenericEntity:GlAccount][accountCode,402000(java.lang.
> String)][accountName,Miscellaneous Sales(java.lang.String)][createdStamp,2018-05-29
> 09:22:49.175(java.sql.Timestamp)][createdTxStamp,2018-05-29
> 09:22:49.156(java.sql.Timestamp)][glAccountClassId,
> REVENUE(java.lang.String)][glAccountId,10015(java.lang.
> String)][glAccountTypeId,_NA_(java.lang.String)][
> glResourceTypeId,MONEY(java.lang.String)][lastUpdatedStamp,2018-05-29
> 09:22:49.175(java.sql.Timestamp)][lastUpdatedTxStamp,2018-05-29
> 09:22:49.156(java.sql.Timestamp)][parentGlAccountId,10177(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO GL_ACCOUNT
> (GL_ACCOUNT_ID, GL_ACCOUNT_TYPE_ID, GL_ACCOUNT_CLASS_ID,
> GL_RESOURCE_TYPE_ID, GL_XBRL_CLASS_ID, PARENT_GL_ACCOUNT_ID, ACCOUNT_CODE,
> ACCOUNT_NAME, DESCRIPTION, PRODUCT_ID, EXTERNAL_ID, 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`.`GL_ACCOUNT`, CONSTRAINT `GLACCT_PAR`
> FOREIGN KEY (`PARENT_GL_ACCOUNT_ID`) REFERENCES `GL_ACCOUNT`
> (`GL_ACCOUNT_ID`)))) (Error while inserting: [GenericEntity:GlAccount][
> accountCode,402000(java.lang.String)][accountName,Miscellaneous
> Sales(java.lang.String)][createdStamp,2018-05-29 09:22:49.175(java.sql.
> Timestamp)][createdTxStamp,2018-05-29 09:22:49.156(java.sql.
> Timestamp)][glAccountClassId,REVENUE(java.lang.String)][
> glAccountId,10015(java.lang.String)][glAccountTypeId,_NA_(
> java.lang.String)][glResourceTypeId,MONEY(java.lang.String)][lastUpdatedStamp,2018-05-29
> 09:22:49.175(java.sql.Timestamp)][lastUpdatedTxStamp,2018-05-29
> 09:22:49.156(java.sql.Timestamp)][parentGlAccountId,10177(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO GL_ACCOUNT
> (GL_ACCOUNT_ID, GL_ACCOUNT_TYPE_ID, GL_ACCOUNT_CLASS_ID,
> GL_RESOURCE_TYPE_ID, GL_XBRL_CLASS_ID, PARENT_GL_ACCOUNT_ID, ACCOUNT_CODE,
> ACCOUNT_NAME, DESCRIPTION, PRODUCT_ID, EXTERNAL_ID, 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`.`GL_ACCOUNT`, CONSTRAINT `GLACCT_PAR`
> FOREIGN KEY (`PARENT_GL_ACCOUNT_ID`) REFERENCES `GL_ACCOUNT`
> (`GL_ACCOUNT_ID`))))). Rolling back transaction.
> org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException:
> Error while inserting: [GenericEntity:GlAccount][
> accountCode,402000(java.lang.String)][accountName,Miscellaneous
> Sales(java.lang.String)][createdStamp,2018-05-29 09:22:49.175(java.sql.
> Timestamp)][createdTxStamp,2018-05-29 09:22:49.156(java.sql.
> Timestamp)][glAccountClassId,REVENUE(java.lang.String)][
> glAccountId,10015(java.lang.String)][glAccountTypeId,_NA_(
> java.lang.String)][glResourceTypeId,MONEY(java.lang.String)][lastUpdatedStamp,2018-05-29
> 09:22:49.175(java.sql.Timestamp)][lastUpdatedTxStamp,2018-05-29
> 09:22:49.156(java.sql.Timestamp)][parentGlAccountId,10177(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO GL_ACCOUNT
> (GL_ACCOUNT_ID, GL_ACCOUNT_TYPE_ID, GL_ACCOUNT_CLASS_ID,
> GL_RESOURCE_TYPE_ID, GL_XBRL_CLASS_ID, PARENT_GL_ACCOUNT_ID, ACCOUNT_CODE,
> ACCOUNT_NAME, DESCRIPTION, PRODUCT_ID, EXTERNAL_ID, 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`.`GL_ACCOUNT`, CONSTRAINT `GLACCT_PAR`
> FOREIGN KEY (`PARENT_GL_ACCOUNT_ID`) REFERENCES `GL_ACCOUNT`
> (`GL_ACCOUNT_ID`)))) (Error while inserting: [GenericEntity:GlAccount][
> accountCode,402000(java.lang.String)][accountName,Miscellaneous
> Sales(java.lang.String)][createdStamp,2018-05-29 09:22:49.175(java.sql.
> Timestamp)][createdTxStamp,2018-05-29 09:22:49.156(java.sql.
> Timestamp)][glAccountClassId,REVENUE(java.lang.String)][
> glAccountId,10015(java.lang.String)][glAccountTypeId,_NA_(
> java.lang.String)][glResourceTypeId,MONEY(java.lang.String)][lastUpdatedStamp,2018-05-29
> 09:22:49.175(java.sql.Timestamp)][lastUpdatedTxStamp,2018-05-29
> 09:22:49.156(java.sql.Timestamp)][parentGlAccountId,10177(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO GL_ACCOUNT
> (GL_ACCOUNT_ID, GL_ACCOUNT_TYPE_ID, GL_ACCOUNT_CLASS_ID,
> GL_RESOURCE_TYPE_ID, GL_XBRL_CLASS_ID, PARENT_GL_ACCOUNT_ID, ACCOUNT_CODE,
> ACCOUNT_NAME, DESCRIPTION, PRODUCT_ID, EXTERNAL_ID, 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`.`GL_ACCOUNT`, CONSTRAINT `GLACCT_PAR`
> FOREIGN KEY (`PARENT_GL_ACCOUNT_ID`) REFERENCES `GL_ACCOUNT`
> (`GL_ACCOUNT_ID`)))))
>
>
> Thanks for he help, Wolfgang
>
>
>
>
>
> On Tue, May 29, 2018 at 2:47 AM, Paul Foxworthy <[hidden email]>
> wrote:
>
>> Hi Wolfgang,
>>
>> These import errors are usually caused by circular or missing foreign key
>> relationships.
>>
>> You can ignore the payment and shipping gateways. If you ever want to use
>> a
>> particular credit card payment gateway or shipping company, you can enter
>> that data into your new OFBiz.
>>
>> The GL accounts may be more significant. If you check the OFBiz log
>> (/webtools/control/LogView), you should see which records are failing.
>>
>> Cheers
>>
>> Paul Foxworthy
>>
>>
>> On 29 May 2018 at 05:38, [hidden email] <[hidden email]>
>> wrote:
>>
>> > I am trying to upload xml data that I had exported previously form
>> ofbiz.
>> > Some of the files fail to load. But it does not give an error message.
>> >
>> > Got 1 entities from CostComponentCalc.xml
>> > Got 1 entities from WorkEffortCostCalc.xml
>> > Got 1 entities from FacilityParty.xml
>> > Failed GlAccountOrganization.xml adding to retry list for next pass
>> > Failed GlAccountTypeDefault.xml adding to retry list for next pass
>> > Got 1 entities from WorkEffortPartyAssignment.xml
>> >
>> > Pass 1 complete
>> >
>> > Failed PaymentGatewayClearCommerce.xml adding to retry list for next
>> pass
>> > Failed PaymentGatewayOrbital.xml adding to retry list for next pass
>> > Failed PaymentGatewayPayflowPro.xml adding to retry list for next pass
>> > Failed PaymentGatewaySecurePay.xml adding to retry list for next pass
>> > Failed PaymentGatewayiDEAL.xml adding to retry list for next pass
>> > Failed ShipmentGatewayDhl.xml adding to retry list for next pass
>> > Failed ShipmentGatewayUps.xml adding to retry list for next pass
>> > Failed ShipmentGatewayUsps.xml adding to retry list for next pass
>> > Failed GlAccount.xml adding to retry list for next pass
>> > Failed GlAccountOrganization.xml adding to retry list for next pass
>> > Failed GlAccountTypeDefault.xml adding to retry list for next pass
>> >
>> > Pass 2 complete
>> >
>> > ---------------------------------------
>> > Succeeded: 254 of 265
>> > Failed: 11 of 265
>> > ---------------------------------------
>> >
>> > Failed Files:
>> > /home/wp.rauchholz/ofbiz/PaymentGatewayClearCommerce.xml
>> > /home/wp.rauchholz/ofbiz/PaymentGatewayOrbital.xml
>> > /home/wp.rauchholz/ofbiz/PaymentGatewayPayflowPro.xml
>> > /home/wp.rauchholz/ofbiz/PaymentGatewaySecurePay.xml
>> > /home/wp.rauchholz/ofbiz/PaymentGatewayiDEAL.xml
>> > /home/wp.rauchholz/ofbiz/ShipmentGatewayDhl.xml
>> > /home/wp.rauchholz/ofbiz/ShipmentGatewayUps.xml
>> > /home/wp.rauchholz/ofbiz/ShipmentGatewayUsps.xml
>> > /home/wp.rauchholz/ofbiz/GlAccount.xml
>> > /home/wp.rauchholz/ofbiz/GlAccountOrganization.xml
>> > /home/wp.rauchholz/ofbiz/GlAccountTypeDefault.xml
>> >
>> > Any suggestions?
>> >
>> > Thanks for your help, WOlfgang
>> >
>> >
>>
>>
>> --
>> Coherent Software Australia Pty Ltd
>> PO Box 2773
>> Cheltenham Vic 3192
>> Australia
>>
>> Phone: [phone]
>> Web: http://www.coherentsoftware.com.au/
>> Email: [hidden email]
>>
>
>
>
> --
>
> Wolfgang Rauchholz
>
>
>
>

--

Wolfgang Rauchholz