[jira] [Updated] (OFBIZ-12370) InvoiceRole: impossible combination of party and role selectable: leads to error

2021-12-09 Thread Pierre Smits (Jira) 


 [ 
https://issues.apache.org/jira/browse/OFBIZ-12370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pierre Smits updated OFBIZ-12370:
-
Parent: OFBIZ-12445
Issue Type: Sub-task  (was: Bug)

> InvoiceRole: impossible combination of party and role selectable: leads to 
> error
> 
>
> Key: OFBIZ-12370
> URL: https://issues.apache.org/jira/browse/OFBIZ-12370
> Project: OFBiz
>  Issue Type: Sub-task
>  Components: accounting
>Affects Versions: Trunk, 17.12.08, 18.12.01
>Reporter: Pierre Smits
>Priority: Major
>  Labels: roles
>
> On the invoice role page in accounting (see e.g. 
> [https://demo-stable.ofbiz.apache.org/accounting/control/invoiceRoles?invoiceId=demo10001]
>  ) it is possible to select an impossible combination of a party and a role. 
> After the submit an error is shown:
> {code:java}
> The Following Errors Occurred:Exception thrown while creating the "newEntity" 
> GenericValue: org.apache.ofbiz.entity.GenericEntityException: Error while 
> inserting: [GenericEntity:InvoiceRole][createdStamp,2021-11-09 
> 10:21:14.073(java.sql.Timestamp)][createdTxStamp,2021-11-09 
> 10:21:14.02(java.sql.Timestamp)][datetimePerformed,2021-11-09 
> 10:21:14.073(java.sql.Timestamp)][invoiceId,demo10001(java.lang.String)][lastUpdatedStamp,2021-11-09
>  10:21:14.073(java.sql.Timestamp)][lastUpdatedTxStamp,2021-11-09 
> 10:21:14.02(java.sql.Timestamp)][partyId,DemoLead(java.lang.String)][percentage,null()][roleTypeId,INTERNAL_ORGANIZATIO(java.lang.String)]
>  (SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE_ROLE 
> (INVOICE_ID, PARTY_ID, ROLE_TYPE_ID, DATETIME_PERFORMED, PERCENTAGE, 
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) 
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE_ROLE' caused a 
> violation of foreign key constraint 'INVCE_RLE_PTRL' for key 
> (DemoLead,INTERNAL_ORGANIZATIO). The statement has been rolled back.)) (Error 
> while inserting: [GenericEntity:InvoiceRole][createdStamp,2021-11-09 
> 10:21:14.073(java.sql.Timestamp)][createdTxStamp,2021-11-09 
> 10:21:14.02(java.sql.Timestamp)][datetimePerformed,2021-11-09 
> 10:21:14.073(java.sql.Timestamp)][invoiceId,demo10001(java.lang.String)][lastUpdatedStamp,2021-11-09
>  10:21:14.073(java.sql.Timestamp)][lastUpdatedTxStamp,2021-11-09 
> 10:21:14.02(java.sql.Timestamp)][partyId,DemoLead(java.lang.String)][percentage,null()][roleTypeId,INTERNAL_ORGANIZATIO(java.lang.String)]
>  (SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE_ROLE 
> (INVOICE_ID, PARTY_ID, ROLE_TYPE_ID, DATETIME_PERFORMED, PERCENTAGE, 
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) 
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE_ROLE' caused a 
> violation of foreign key constraint 'INVCE_RLE_PTRL' for key 
> (DemoLead,INTERNAL_ORGANIZATIO). The statement has been rolled back.))) {code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

[jira] [Updated] (OFBIZ-12370) InvoiceRole: impossible combination of party and role selectable: leads to error

2021-11-09 Thread Pierre Smits (Jira) 


 [ 
https://issues.apache.org/jira/browse/OFBIZ-12370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pierre Smits updated OFBIZ-12370:
-
Labels: roles  (was: )

> InvoiceRole: impossible combination of party and role selectable: leads to 
> error
> 
>
> Key: OFBIZ-12370
> URL: https://issues.apache.org/jira/browse/OFBIZ-12370
> Project: OFBiz
>  Issue Type: Bug
>  Components: accounting
>Affects Versions: Trunk, 17.12.08, 18.12.01
>Reporter: Pierre Smits
>Priority: Major
>  Labels: roles
>
> On the invoice role page in accounting (see e.g. 
> [https://demo-stable.ofbiz.apache.org/accounting/control/invoiceRoles?invoiceId=demo10001]
>  ) it is possible to select an impossible combination of a party and a role. 
> After the submit an error is shown:
> {code:java}
> The Following Errors Occurred:Exception thrown while creating the "newEntity" 
> GenericValue: org.apache.ofbiz.entity.GenericEntityException: Error while 
> inserting: [GenericEntity:InvoiceRole][createdStamp,2021-11-09 
> 10:21:14.073(java.sql.Timestamp)][createdTxStamp,2021-11-09 
> 10:21:14.02(java.sql.Timestamp)][datetimePerformed,2021-11-09 
> 10:21:14.073(java.sql.Timestamp)][invoiceId,demo10001(java.lang.String)][lastUpdatedStamp,2021-11-09
>  10:21:14.073(java.sql.Timestamp)][lastUpdatedTxStamp,2021-11-09 
> 10:21:14.02(java.sql.Timestamp)][partyId,DemoLead(java.lang.String)][percentage,null()][roleTypeId,INTERNAL_ORGANIZATIO(java.lang.String)]
>  (SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE_ROLE 
> (INVOICE_ID, PARTY_ID, ROLE_TYPE_ID, DATETIME_PERFORMED, PERCENTAGE, 
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) 
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE_ROLE' caused a 
> violation of foreign key constraint 'INVCE_RLE_PTRL' for key 
> (DemoLead,INTERNAL_ORGANIZATIO). The statement has been rolled back.)) (Error 
> while inserting: [GenericEntity:InvoiceRole][createdStamp,2021-11-09 
> 10:21:14.073(java.sql.Timestamp)][createdTxStamp,2021-11-09 
> 10:21:14.02(java.sql.Timestamp)][datetimePerformed,2021-11-09 
> 10:21:14.073(java.sql.Timestamp)][invoiceId,demo10001(java.lang.String)][lastUpdatedStamp,2021-11-09
>  10:21:14.073(java.sql.Timestamp)][lastUpdatedTxStamp,2021-11-09 
> 10:21:14.02(java.sql.Timestamp)][partyId,DemoLead(java.lang.String)][percentage,null()][roleTypeId,INTERNAL_ORGANIZATIO(java.lang.String)]
>  (SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE_ROLE 
> (INVOICE_ID, PARTY_ID, ROLE_TYPE_ID, DATETIME_PERFORMED, PERCENTAGE, 
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) 
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE_ROLE' caused a 
> violation of foreign key constraint 'INVCE_RLE_PTRL' for key 
> (DemoLead,INTERNAL_ORGANIZATIO). The statement has been rolled back.))) {code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

[jira] [Updated] (OFBIZ-12370) InvoiceRole: impossible combination of party and role selectable: leads to error

2021-11-09 Thread Pierre Smits (Jira) 


 [ 
https://issues.apache.org/jira/browse/OFBIZ-12370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Pierre Smits updated OFBIZ-12370:
-
Summary: InvoiceRole: impossible combination of party and role selectable: 
leads to error  (was: Invoice: impossible combination of party and role 
selectable: leads to error)

> InvoiceRole: impossible combination of party and role selectable: leads to 
> error
> 
>
> Key: OFBIZ-12370
> URL: https://issues.apache.org/jira/browse/OFBIZ-12370
> Project: OFBiz
>  Issue Type: Bug
>  Components: accounting
>Affects Versions: Trunk, 17.12.08, 18.12.01
>Reporter: Pierre Smits
>Priority: Major
>
> On the invoice role page in accounting (see e.g. 
> [https://demo-stable.ofbiz.apache.org/accounting/control/invoiceRoles?invoiceId=demo10001]
>  ) it is possible to select an impossible combination of a party and a role. 
> After the submit an error is shown:
> {code:java}
> The Following Errors Occurred:Exception thrown while creating the "newEntity" 
> GenericValue: org.apache.ofbiz.entity.GenericEntityException: Error while 
> inserting: [GenericEntity:InvoiceRole][createdStamp,2021-11-09 
> 10:21:14.073(java.sql.Timestamp)][createdTxStamp,2021-11-09 
> 10:21:14.02(java.sql.Timestamp)][datetimePerformed,2021-11-09 
> 10:21:14.073(java.sql.Timestamp)][invoiceId,demo10001(java.lang.String)][lastUpdatedStamp,2021-11-09
>  10:21:14.073(java.sql.Timestamp)][lastUpdatedTxStamp,2021-11-09 
> 10:21:14.02(java.sql.Timestamp)][partyId,DemoLead(java.lang.String)][percentage,null()][roleTypeId,INTERNAL_ORGANIZATIO(java.lang.String)]
>  (SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE_ROLE 
> (INVOICE_ID, PARTY_ID, ROLE_TYPE_ID, DATETIME_PERFORMED, PERCENTAGE, 
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) 
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE_ROLE' caused a 
> violation of foreign key constraint 'INVCE_RLE_PTRL' for key 
> (DemoLead,INTERNAL_ORGANIZATIO). The statement has been rolled back.)) (Error 
> while inserting: [GenericEntity:InvoiceRole][createdStamp,2021-11-09 
> 10:21:14.073(java.sql.Timestamp)][createdTxStamp,2021-11-09 
> 10:21:14.02(java.sql.Timestamp)][datetimePerformed,2021-11-09 
> 10:21:14.073(java.sql.Timestamp)][invoiceId,demo10001(java.lang.String)][lastUpdatedStamp,2021-11-09
>  10:21:14.073(java.sql.Timestamp)][lastUpdatedTxStamp,2021-11-09 
> 10:21:14.02(java.sql.Timestamp)][partyId,DemoLead(java.lang.String)][percentage,null()][roleTypeId,INTERNAL_ORGANIZATIO(java.lang.String)]
>  (SQL Exception while executing the following:INSERT INTO OFBIZ.INVOICE_ROLE 
> (INVOICE_ID, PARTY_ID, ROLE_TYPE_ID, DATETIME_PERFORMED, PERCENTAGE, 
> LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) 
> VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'INVOICE_ROLE' caused a 
> violation of foreign key constraint 'INVCE_RLE_PTRL' for key 
> (DemoLead,INTERNAL_ORGANIZATIO). The statement has been rolled back.))) {code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)