[jira] [Comment Edited] (OFBIZ-10898) ofbizsetup ends with en error message / https://localhost:8443/ofbizsetup/control/main

[Nicolas Malin (Jira)]

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

Jacques Le Roux edited comment on OFBIZ-10898 at 4/17/19 4:30 PM:
------------------------------------------------------------------

OK then I crossed another error while creating the 1st client:


{noformat}
2019-04-17 18:22:10,980 |jsse-nio-8443-exec-7 |UtilProperties                |I| ResourceBundle SecurityextUiLabels (fr) created in 0.068s with 68 properties
2019-04-17 18:22:10,980 |jsse-nio-8443-exec-7 |LoginServices                 |I|  password.change.history.limit is set to 0
2019-04-17 18:22:10,987 |jsse-nio-8443-exec-7 |TransactionUtil               |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening:
java.lang.Exception: Error in simple-method [Create User [file:/C:/projectsASF/ofbiz/applications/party/minilang/user/UserEvents.xml#createUser]]: ; [Mot de passe absent, Le mot de passe ou la vérification de mot de passe manque]
        at org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:358) [ofbiz.jar:?]
[...]

2019-04-17 18:22:10,989 |jsse-nio-8443-exec-7 |SimpleEventHandler            |E| null
org.apache.ofbiz.entity.transaction.GenericTransactionException: Roll back error, could not commit transaction, was rolled back instead because of: Error in simple-method [Create User [file:/C:/projectsASF/ofbiz/applications/party/minila
ng/user/UserEvents.xml#createUser]]: ; [Mot de passe absent, Le mot de passe ou la vérification de mot de passe manque]
[...]

2019-04-17 18:22:10,989 |jsse-nio-8443-exec-7 |RequestHandler                |I| Ran Event [simple:component://commonext/minilang/setup/SetupEvents.xml#createCustomer] from [request], result is [error]
2019-04-17 18:22:10,991 |jsse-nio-8443-exec-7 |RequestHandler                |E| Request createCustomer caused an error with the following message: [Mot de passe absent, Le mot de passe ou la vérification de mot de passe manque]
{noformat}

It does not make much sense to me as there are no field to enter a password but a sentence after the user name field (in French in my case) saying:
bq. The person will receive a temporary password by email
I guess we need to change this form too... I mean NewCustomer in SetupForms.xml. The Yak has a lot of long hairs!




was (Author: jacques.le.roux):
OK then I crossed another error while creating the 1st client:


{noformat}
2019-04-17 18:22:10,980 |jsse-nio-8443-exec-7 |UtilProperties                |I| ResourceBundle SecurityextUiLabels (fr) created in 0.068s with 68 properties
2019-04-17 18:22:10,980 |jsse-nio-8443-exec-7 |LoginServices                 |I|  password.change.history.limit is set to 0
2019-04-17 18:22:10,987 |jsse-nio-8443-exec-7 |TransactionUtil               |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening:
java.lang.Exception: Error in simple-method [Create User [file:/C:/projectsASF/ofbiz/applications/party/minilang/user/UserEvents.xml#createUser]]: ; [Mot de passe absent, Le mot de passe ou la vérification de mot de passe manque]
        at org.apache.ofbiz.entity.transaction.TransactionUtil.setRollbackOnly(TransactionUtil.java:358) [ofbiz.jar:?]
[...]

2019-04-17 18:22:10,989 |jsse-nio-8443-exec-7 |SimpleEventHandler            |E| null
org.apache.ofbiz.entity.transaction.GenericTransactionException: Roll back error, could not commit transaction, was rolled back instead because of: Error in simple-method [Create User [file:/C:/projectsASF/ofbiz/applications/party/minila
ng/user/UserEvents.xml#createUser]]: ; [Mot de passe absent, Le mot de passe ou la vérification de mot de passe manque]
[...]

2019-04-17 18:22:10,989 |jsse-nio-8443-exec-7 |RequestHandler                |I| Ran Event [simple:component://commonext/minilang/setup/SetupEvents.xml#createCustomer] from [request], result is [error]
2019-04-17 18:22:10,991 |jsse-nio-8443-exec-7 |RequestHandler                |E| Request createCustomer caused an error with the following message: [Mot de passe absent, Le mot de passe ou la vérification de mot de passe manque]
{noformat}

It does not make much sense to me as there are no field to enter a password but a sentence after the user name field (in French in my case) saying:
bq. The person will receive a temporary password by email
I guess we need to change this form too... I mean NewCustomer in SetupForms.xml. The Yak has long hair!

> ofbizsetup ends with en error message / https://localhost:8443/ofbizsetup/control/main
> --------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-10898
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-10898
>             Project: OFBiz
>          Issue Type: Bug
>          Components: accounting
>    Affects Versions: 17.12.01
>            Reporter: Wolfgang Rauchholz
>            Priority: Major
>         Attachments: GlAccount.xml, OfbizSetupGlAccountData.xml
>
>
> At the end of the setup procedure (Shop, Website, Customer, ... Product created) when hitting the button 'Set to complete', the error message as depicted underneath is shown:
> Catalog, Category and Shop, Website and Product were created.
> The financial side of Ofbiz was not created.
> The Following Errors Occurred:
> 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,2019-03-31 19:41:20.655(java.sql.Timestamp)][createdTxStamp,2019-03-31 19:41:20.247(java.sql.Timestamp)][fromDate,2019-03-31 19:41:20.623(java.sql.Timestamp)][glAccountId,100000(java.lang.String)][lastUpdatedStamp,2019-03-31 19:41:20.655(java.sql.Timestamp)][lastUpdatedTxStamp,2019-03-31 19:41:20.247(java.sql.Timestamp)][organizationPartyId,Company(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,2019-03-31 19:41:20.655(java.sql.Timestamp)][createdTxStamp,2019-03-31 19:41:20.247(java.sql.Timestamp)][fromDate,2019-03-31 19:41:20.623(java.sql.Timestamp)][glAccountId,100000(java.lang.String)][lastUpdatedStamp,2019-03-31 19:41:20.655(java.sql.Timestamp)][lastUpdatedTxStamp,2019-03-31 19:41:20.247(java.sql.Timestamp)][organizationPartyId,Company(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,2019-03-31 19:41:20.655(java.sql.Timestamp)][createdTxStamp,2019-03-31 19:41:20.247(java.sql.Timestamp)][fromDate,2019-03-31 19:41:20.623(java.sql.Timestamp)][glAccountId,100000(java.lang.String)][lastUpdatedStamp,2019-03-31 19:41:20.655(java.sql.Timestamp)][lastUpdatedTxStamp,2019-03-31 19:41:20.247(java.sql.Timestamp)][organizationPartyId,Company(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,2019-03-31 19:41:20.655(java.sql.Timestamp)][createdTxStamp,2019-03-31 19:41:20.247(java.sql.Timestamp)][fromDate,2019-03-31 19:41:20.623(java.sql.Timestamp)][glAccountId,100000(java.lang.String)][lastUpdatedStamp,2019-03-31 19:41:20.655(java.sql.Timestamp)][lastUpdatedTxStamp,2019-03-31 19:41:20.247(java.sql.Timestamp)][organizationPartyId,Company(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.))))
> Collapse

--
This message was sent by Atlassian JIRA
(v7.6.3#76005)