[jira] [Commented] (OFBIZ-12228) Setup instructions don't work

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-12228?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17331929#comment-17331929 ]

Jacques Le Roux commented on OFBIZ-12228:
-----------------------------------------

It gets further, but crossed another issue:

Erreur :ERREUR : Lors de l'analyse du fichier (ERROR parsing Entity Xml file: org.xml.sax.SAXException: A transaction error occurred reading data<br/>org.xml.sax.SAXException: Error performing action CREATE_UPDATE<br/>org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while updating: [GenericEntity:InvoiceItemType][defaultGlAccountId,410000(java.lang.String)][invoiceItemTypeId,INVOICE_ADJ(java.lang.String)][lastUpdatedStamp,2021-04-26 11:16:35.345(java.sql.Timestamp)][lastUpdatedTxStamp,2021-04-26 11:16:34.911(java.sql.Timestamp)] (SQL Exception while executing the following:null (UPDATE on table 'INVOICE_ITEM_TYPE' caused a violation of foreign key constraint 'INVOICE_ITM_DGLAC' for key (410000). The statement has been rolled back.)) (Error while updating: [GenericEntity:InvoiceItemType][defaultGlAccountId,410000(java.lang.String)][invoiceItemTypeId,INVOICE_ADJ(java.lang.String)][lastUpdatedStamp,2021-04-26 11:16:35.345(java.sql.Timestamp)][lastUpdatedTxStamp,2021-04-26 11:16:34.911(java.sql.Timestamp)] (SQL Exception while executing the following:null (UPDATE on table 'INVOICE_ITEM_TYPE' caused a violation of foreign key constraint 'INVOICE_ITM_DGLAC' for key (410000). The statement has been rolled back.))) (org.apache.ofbiz.entity.GenericEntityException: Error while updating: [GenericEntity:InvoiceItemType][defaultGlAccountId,410000(java.lang.String)][invoiceItemTypeId,INVOICE_ADJ(java.lang.String)][lastUpdatedStamp,2021-04-26 11:16:35.345(java.sql.Timestamp)][lastUpdatedTxStamp,2021-04-26 11:16:34.911(java.sql.Timestamp)] (SQL Exception while executing the following:null (UPDATE on table 'INVOICE_ITEM_TYPE' caused a violation of foreign key constraint 'INVOICE_ITM_DGLAC' for key (410000). The statement has been rolled back.)) (Error while updating: [GenericEntity:InvoiceItemType][defaultGlAccountId,410000(java.lang.String)][invoiceItemTypeId,INVOICE_ADJ(java.lang.String)][lastUpdatedStamp,2021-04-26 11:16:35.345(java.sql.Timestamp)][lastUpdatedTxStamp,2021-04-26 11:16:34.911(java.sql.Timestamp)] (SQL Exception while executing the following:null (UPDATE on table 'INVOICE_ITEM_TYPE' caused a violation of foreign key constraint 'INVOICE_ITM_DGLAC' for key (410000). The statement has been rolled back.)))))

In log:

2021-04-26 11:16:35,330 |jsse-nio-8443-exec-4 |EntitySaxReader               |I| Beginning import from URL: file:/C:/projectsASF/Git/ofbiz-framework/applications/accounting/data/OfbizSetupChartOfAccountsData.xml
2021-04-26 11:16:35,333 |jsse-nio-8443-exec-4 |EntitySaxReader               |I| Transaction Timeout set to 2 hours (7200 seconds)
2021-04-26 11:16:35,360 |jsse-nio-8443-exec-4 |TransactionUtil               |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening:
java.lang.Exception: rollback called in Entity Engine SQLProcessor
[...]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_202]

2021-04-26 11:16:35,367 |jsse-nio-8443-exec-4 |GenericDelegator              |E| Failure in store operation for entity [InvoiceItemType]: org.apache.ofbiz.entity.GenericEntityException: Error while updating: [GenericEntity:InvoiceItemTyp
e][defaultGlAccountId,410000(java.lang.String)][invoiceItemTypeId,INVOICE_ADJ(java.lang.String)][lastUpdatedStamp,2021-04-26 11:16:35.345(java.sql.Timestamp)][lastUpdatedTxStamp,2021-04-26 11:16:34.911(java.sql.Timestamp)] (SQL Exception
 while executing the following:null (UPDATE on table 'INVOICE_ITEM_TYPE' caused a violation of foreign key constraint 'INVOICE_ITM_DGLAC' for key (410000).  The statement has been rolled back.)). Rolling back transaction.
org.apache.ofbiz.entity.GenericEntityException: Error while updating: [GenericEntity:InvoiceItemType][defaultGlAccountId,410000(java.lang.String)][invoiceItemTypeId,INVOICE_ADJ(java.lang.String)][lastUpdatedStamp,2021-04-26 11:16:35.345(
java.sql.Timestamp)][lastUpdatedTxStamp,2021-04-26 11:16:34.911(java.sql.Timestamp)] (SQL Exception while executing the following:null (UPDATE on table 'INVOICE_ITEM_TYPE' caused a violation of foreign key constraint 'INVOICE_ITM_DGLAC'
for key (410000).  The statement has been rolled back.))
        at org.apache.ofbiz.entity.datasource.GenericDAO.singleUpdate(GenericDAO.java:295) ~[main/:?]

There was also this commit: https://markmail.org/message/pka4u3cp3hnqcsii But it should not have any impact on this issue

> Setup instructions don't work
> -----------------------------
>
>                 Key: OFBIZ-12228
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-12228
>             Project: OFBiz
>          Issue Type: Bug
>          Components: Documentation, setup, start
>    Affects Versions: 17.12.06
>         Environment: {{$ uname -srvimpo }}
> {{Linux 5.8.0-50-generic #56-Ubuntu SMP Mon Apr 12 17:18:36 UTC 2021 x86_64 x86_64 x86_64 GNU/Linux }}
> {{$ java -version  }}
> {{openjdk version "1.8.0_282" }}
> {{OpenJDK Runtime Environment (build 1.8.0_282-8u282-b08-0ubuntu1~20.10-b08) }}
> {{OpenJDK 64-Bit Server VM (build 25.282-b08, mixed mode)}}
>            Reporter: Szabolcs Szekelyi
>            Assignee: Jacques Le Roux
>            Priority: Major
>
> Followed the setup instructions on [https://ci.apache.org/projects/ofbiz/site/trunk/ofbizdoc/html5/user-manual.html#_quick_start] but I'm unable to create the initial organization.
> I'm getting the following error:
> {quote}Error:ERROR: parsing file: ERROR parsing Entity Xml file: org.xml.sax.SAXException: A transaction error occurred reading data<br/>org.xml.sax.SAXException: Error performing action CREATE_UPDATE<br/>org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:GlAccountOrganization][createdStamp,2021-04-25 01:51:26.095(java.sql.Timestamp)][createdTxStamp,2021-04-25 01:51:25.884(java.sql.Timestamp)][fromDate,2021-04-25 01:51:26.07(java.sql.Timestamp)][glAccountId,100000(java.lang.String)][lastUpdatedStamp,2021-04-25 01:51:26.095(java.sql.Timestamp)][lastUpdatedTxStamp,2021-04-25 01:51:25.884(java.sql.Timestamp)][organizationPartyId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.GL_ACCOUNT_ORGANIZATION (GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'GL_ACCOUNT_ORGANIZATION' caused a violation of foreign key constraint 'GLACCT_ORG_GLA' for key (100000). The statement has been rolled back.)) (Error while inserting: [GenericEntity:GlAccountOrganization][createdStamp,2021-04-25 01:51:26.095(java.sql.Timestamp)][createdTxStamp,2021-04-25 01:51:25.884(java.sql.Timestamp)][fromDate,2021-04-25 01:51:26.07(java.sql.Timestamp)][glAccountId,100000(java.lang.String)][lastUpdatedStamp,2021-04-25 01:51:26.095(java.sql.Timestamp)][lastUpdatedTxStamp,2021-04-25 01:51:25.884(java.sql.Timestamp)][organizationPartyId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.GL_ACCOUNT_ORGANIZATION (GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'GL_ACCOUNT_ORGANIZATION' caused a violation of foreign key constraint 'GLACCT_ORG_GLA' for key (100000). The statement has been rolled back.))) (org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:GlAccountOrganization][createdStamp,2021-04-25 01:51:26.095(java.sql.Timestamp)][createdTxStamp,2021-04-25 01:51:25.884(java.sql.Timestamp)][fromDate,2021-04-25 01:51:26.07(java.sql.Timestamp)][glAccountId,100000(java.lang.String)][lastUpdatedStamp,2021-04-25 01:51:26.095(java.sql.Timestamp)][lastUpdatedTxStamp,2021-04-25 01:51:25.884(java.sql.Timestamp)][organizationPartyId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.GL_ACCOUNT_ORGANIZATION (GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'GL_ACCOUNT_ORGANIZATION' caused a violation of foreign key constraint 'GLACCT_ORG_GLA' for key (100000). The statement has been rolled back.)) (Error while inserting: [GenericEntity:GlAccountOrganization][createdStamp,2021-04-25 01:51:26.095(java.sql.Timestamp)][createdTxStamp,2021-04-25 01:51:25.884(java.sql.Timestamp)][fromDate,2021-04-25 01:51:26.07(java.sql.Timestamp)][glAccountId,100000(java.lang.String)][lastUpdatedStamp,2021-04-25 01:51:26.095(java.sql.Timestamp)][lastUpdatedTxStamp,2021-04-25 01:51:25.884(java.sql.Timestamp)][organizationPartyId,10000(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.GL_ACCOUNT_ORGANIZATION (GL_ACCOUNT_ID, ORGANIZATION_PARTY_ID, ROLE_TYPE_ID, FROM_DATE, THRU_DATE, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'GL_ACCOUNT_ORGANIZATION' caused a violation of foreign key constraint 'GLACCT_ORG_GLA' for key (100000). The statement has been rolled back.))))
> {quote}
> Steps to reproduce:
>  # Download and unzip distrubution package
>  # Open a terminal, go to extracted directory
>  # Run {{./gradle/init-gradle-wrapper.sh}}
>  # Run {{./gradlew cleanAll loadAll}}
>  # Start OFBiz, run{{ ./gradlew ofbiz}}, log in, make sure it works
>  # Run {{./gradlew cleanAll}}
>  # Run {{./gradlew "ofbiz --load-data readers=seed,seed-initial"}}
>  # Run {{./gradlew loadAdminUserLogin -PuserLoginId=admin}}
>  # Start OFBiz, run {{./gradlew ofbiz}}
>  # Go to [https://localhost:8443/ofbizsetup]
>  # Log in, change password
>  # Fill out 'Create New Organization' form
>  # On the appearing page, click 'Set to complete'

--
This message was sent by Atlassian Jira
(v8.3.4#803005)