ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wolfgang Paul Rauchholz <wp.rauchh...@gmail.com>
Subject Re: Error messages when uploading xml files
Date Tue, 29 May 2018 07:26:47 GMT
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 <paul@cohsoft.com.au> 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, wp.rauchholz@gmail.com <wp.rauchholz@gmail.com>
> 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: +61 3 9585 6788
> Web: http://www.coherentsoftware.com.au/
> Email: info@coherentsoftware.com.au
>



-- 

Wolfgang Rauchholz

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