Manually I can enter the GL accounts without a problem. Wolfgang
On Tue, May 29, 2018 at 9:26 AM, Wolfgang Paul Rauchholz < [email protected]> 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 <[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 > > > > -- Wolfgang Rauchholz
