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 <[email protected]> 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, [email protected] <[email protected]> > 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: [email protected] > -- Wolfgang Rauchholz
