[jira] [Commented] (OFBIZ-12193) Cant search ViewEntity InventoryItemDetailForSum
[ https://issues.apache.org/jira/browse/OFBIZ-12193?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17295823#comment-17295823 ] Sebastian Berg commented on OFBIZ-12193: Previously when delegator.find() was called one parameter was fieldsToSelect which is relevant for ViewEntities. In the new FindGeneric.groovy the performFind Service is missing this information. > Cant search ViewEntity InventoryItemDetailForSum > > > Key: OFBIZ-12193 > URL: https://issues.apache.org/jira/browse/OFBIZ-12193 > Project: OFBiz > Issue Type: Bug >Affects Versions: Release Branch 18.12, Release Branch 17.12, Trunk >Reporter: Sebastian Berg >Assignee: Sebastian Berg >Priority: Major > > Go to Entity Engine - > search entity InventoryItemDetailForSum (view entity) > -> search for entries -> an error message is shown. > A SQL exception occurred running the service executeFind -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (OFBIZ-12193) Cant search ViewEntity InventoryItemDetailForSum
[ https://issues.apache.org/jira/browse/OFBIZ-12193?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sebastian Berg updated OFBIZ-12193: --- Affects Version/s: Release Branch 17.12 > Cant search ViewEntity InventoryItemDetailForSum > > > Key: OFBIZ-12193 > URL: https://issues.apache.org/jira/browse/OFBIZ-12193 > Project: OFBiz > Issue Type: Bug >Affects Versions: Release Branch 18.12, Release Branch 17.12, Trunk >Reporter: Sebastian Berg >Assignee: Sebastian Berg >Priority: Major > > Go to Entity Engine - > search entity InventoryItemDetailForSum (view entity) > -> search for entries -> an error message is shown. > A SQL exception occurred running the service executeFind -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (OFBIZ-12153) Error in deleting Financial Account
[ https://issues.apache.org/jira/browse/OFBIZ-12153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17295778#comment-17295778 ] Jacques Le Roux commented on OFBIZ-12153: - I reverted in R17 and R18 because there is no AutoAcctgFinAccountTests.groovy there. So something else must be done in AutoAcctgFinAccountTests.xml > Error in deleting Financial Account > --- > > Key: OFBIZ-12153 > URL: https://issues.apache.org/jira/browse/OFBIZ-12153 > Project: OFBiz > Issue Type: Bug > Components: accounting >Reporter: Lalit Dashora >Assignee: sourabh jain >Priority: Major > Attachments: FinAccountDelete.png, OFBIZ-12153.patch, > OFBIZ-12153.patch, OFBIZ-12153.patch, OFBIZ-12153.patch, OFBIZ-12153.patch > > > 1. Navigate to URL: accounting/control/FindFinAccount > 2. Click on Find button. List of fin account will be displayed. > 3. Click on delete button near available balance column. > The Following Errors Occurred: > Error doing entity-auto operation for entity FinAccount in service > deleteFinAccount: org.apache.ofbiz.entity.GenericEntityException: > org.apache.ofbiz.entity.GenericDataSourceException: Exception while deleting > the following entity: > [GenericEntity:FinAccount][finAccountId,SC_CHECKING(java.lang.String)] (SQL > Exception while executing the following:null (DELETE on table 'FIN_ACCOUNT' > caused a violation of foreign key constraint 'FINACT_STTS_FNA' for key > (SC_CHECKING). The statement has been rolled back.)) (Exception while > deleting the following entity: > [GenericEntity:FinAccount][finAccountId,SC_CHECKING(java.lang.String)] (SQL > Exception while executing the following:null (DELETE on table 'FIN_ACCOUNT' > caused a violation of foreign key constraint 'FINACT_STTS_FNA' for key > (SC_CHECKING). The statement has been rolled back.))) -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (OFBIZ-12153) Error in deleting Financial Account
[ https://issues.apache.org/jira/browse/OFBIZ-12153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17295774#comment-17295774 ] ASF subversion and git services commented on OFBIZ-12153: - Commit a5d921efb81a5c4d7b997e1d264353a21282c9ba in ofbiz-framework's branch refs/heads/release18.12 from Jacques Le Roux [ https://gitbox.apache.org/repos/asf?p=ofbiz-framework.git;h=a5d921e ] Revert "Fixed: Error in deleting Financial Account (OFBIZ-12153)" This reverts commit 04ec3b3e9e3bb83a38c88c34e6559e5ef3166c72. > Error in deleting Financial Account > --- > > Key: OFBIZ-12153 > URL: https://issues.apache.org/jira/browse/OFBIZ-12153 > Project: OFBiz > Issue Type: Bug > Components: accounting >Reporter: Lalit Dashora >Assignee: sourabh jain >Priority: Major > Attachments: FinAccountDelete.png, OFBIZ-12153.patch, > OFBIZ-12153.patch, OFBIZ-12153.patch, OFBIZ-12153.patch, OFBIZ-12153.patch > > > 1. Navigate to URL: accounting/control/FindFinAccount > 2. Click on Find button. List of fin account will be displayed. > 3. Click on delete button near available balance column. > The Following Errors Occurred: > Error doing entity-auto operation for entity FinAccount in service > deleteFinAccount: org.apache.ofbiz.entity.GenericEntityException: > org.apache.ofbiz.entity.GenericDataSourceException: Exception while deleting > the following entity: > [GenericEntity:FinAccount][finAccountId,SC_CHECKING(java.lang.String)] (SQL > Exception while executing the following:null (DELETE on table 'FIN_ACCOUNT' > caused a violation of foreign key constraint 'FINACT_STTS_FNA' for key > (SC_CHECKING). The statement has been rolled back.)) (Exception while > deleting the following entity: > [GenericEntity:FinAccount][finAccountId,SC_CHECKING(java.lang.String)] (SQL > Exception while executing the following:null (DELETE on table 'FIN_ACCOUNT' > caused a violation of foreign key constraint 'FINACT_STTS_FNA' for key > (SC_CHECKING). The statement has been rolled back.))) -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (OFBIZ-12153) Error in deleting Financial Account
[ https://issues.apache.org/jira/browse/OFBIZ-12153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17295772#comment-17295772 ] ASF subversion and git services commented on OFBIZ-12153: - Commit 69f00cff7876f698c57be1ed6af5befe49acf629 in ofbiz-framework's branch refs/heads/release17.12 from Jacques Le Roux [ https://gitbox.apache.org/repos/asf?p=ofbiz-framework.git;h=69f00cf ] Revert "Fixed: Error in deleting Financial Account (OFBIZ-12153)" This reverts commit 2876adf26cb3c4f9c9a2ffebeec501322cb0d0d7. > Error in deleting Financial Account > --- > > Key: OFBIZ-12153 > URL: https://issues.apache.org/jira/browse/OFBIZ-12153 > Project: OFBiz > Issue Type: Bug > Components: accounting >Reporter: Lalit Dashora >Assignee: sourabh jain >Priority: Major > Attachments: FinAccountDelete.png, OFBIZ-12153.patch, > OFBIZ-12153.patch, OFBIZ-12153.patch, OFBIZ-12153.patch, OFBIZ-12153.patch > > > 1. Navigate to URL: accounting/control/FindFinAccount > 2. Click on Find button. List of fin account will be displayed. > 3. Click on delete button near available balance column. > The Following Errors Occurred: > Error doing entity-auto operation for entity FinAccount in service > deleteFinAccount: org.apache.ofbiz.entity.GenericEntityException: > org.apache.ofbiz.entity.GenericDataSourceException: Exception while deleting > the following entity: > [GenericEntity:FinAccount][finAccountId,SC_CHECKING(java.lang.String)] (SQL > Exception while executing the following:null (DELETE on table 'FIN_ACCOUNT' > caused a violation of foreign key constraint 'FINACT_STTS_FNA' for key > (SC_CHECKING). The statement has been rolled back.)) (Exception while > deleting the following entity: > [GenericEntity:FinAccount][finAccountId,SC_CHECKING(java.lang.String)] (SQL > Exception while executing the following:null (DELETE on table 'FIN_ACCOUNT' > caused a violation of foreign key constraint 'FINACT_STTS_FNA' for key > (SC_CHECKING). The statement has been rolled back.))) -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (OFBIZ-12153) Error in deleting Financial Account
[ https://issues.apache.org/jira/browse/OFBIZ-12153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17295766#comment-17295766 ] ASF subversion and git services commented on OFBIZ-12153: - Commit 1bf977ae0719c7d7b742107d1eb3d132d15a13c6 in ofbiz-framework's branch refs/heads/trunk from Jacques Le Roux [ https://gitbox.apache.org/repos/asf?p=ofbiz-framework.git;h=1bf977a ] Fixed: Error in deleting Financial Account (OFBIZ-12153) 1. Navigate to URL: accounting/control/FindFinAccount 2. Click on Find button. List of fin account will be displayed. 3. Click on delete button near available balance column. Thanks: Lalit Dashora for report, Sourabh Jain for the initial fix, Pawan Verma for the defintive fix > Error in deleting Financial Account > --- > > Key: OFBIZ-12153 > URL: https://issues.apache.org/jira/browse/OFBIZ-12153 > Project: OFBiz > Issue Type: Bug > Components: accounting >Reporter: Lalit Dashora >Assignee: sourabh jain >Priority: Major > Attachments: FinAccountDelete.png, OFBIZ-12153.patch, > OFBIZ-12153.patch, OFBIZ-12153.patch, OFBIZ-12153.patch, OFBIZ-12153.patch > > > 1. Navigate to URL: accounting/control/FindFinAccount > 2. Click on Find button. List of fin account will be displayed. > 3. Click on delete button near available balance column. > The Following Errors Occurred: > Error doing entity-auto operation for entity FinAccount in service > deleteFinAccount: org.apache.ofbiz.entity.GenericEntityException: > org.apache.ofbiz.entity.GenericDataSourceException: Exception while deleting > the following entity: > [GenericEntity:FinAccount][finAccountId,SC_CHECKING(java.lang.String)] (SQL > Exception while executing the following:null (DELETE on table 'FIN_ACCOUNT' > caused a violation of foreign key constraint 'FINACT_STTS_FNA' for key > (SC_CHECKING). The statement has been rolled back.)) (Exception while > deleting the following entity: > [GenericEntity:FinAccount][finAccountId,SC_CHECKING(java.lang.String)] (SQL > Exception while executing the following:null (DELETE on table 'FIN_ACCOUNT' > caused a violation of foreign key constraint 'FINACT_STTS_FNA' for key > (SC_CHECKING). The statement has been rolled back.))) -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (OFBIZ-12153) Error in deleting Financial Account
[ https://issues.apache.org/jira/browse/OFBIZ-12153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17295280#comment-17295280 ] Jacques Le Roux commented on OFBIZ-12153: - Works for me, thanks Pawan. > Error in deleting Financial Account > --- > > Key: OFBIZ-12153 > URL: https://issues.apache.org/jira/browse/OFBIZ-12153 > Project: OFBiz > Issue Type: Bug > Components: accounting >Reporter: Lalit Dashora >Assignee: sourabh jain >Priority: Major > Attachments: FinAccountDelete.png, OFBIZ-12153.patch, > OFBIZ-12153.patch, OFBIZ-12153.patch, OFBIZ-12153.patch, OFBIZ-12153.patch > > > 1. Navigate to URL: accounting/control/FindFinAccount > 2. Click on Find button. List of fin account will be displayed. > 3. Click on delete button near available balance column. > The Following Errors Occurred: > Error doing entity-auto operation for entity FinAccount in service > deleteFinAccount: org.apache.ofbiz.entity.GenericEntityException: > org.apache.ofbiz.entity.GenericDataSourceException: Exception while deleting > the following entity: > [GenericEntity:FinAccount][finAccountId,SC_CHECKING(java.lang.String)] (SQL > Exception while executing the following:null (DELETE on table 'FIN_ACCOUNT' > caused a violation of foreign key constraint 'FINACT_STTS_FNA' for key > (SC_CHECKING). The statement has been rolled back.)) (Exception while > deleting the following entity: > [GenericEntity:FinAccount][finAccountId,SC_CHECKING(java.lang.String)] (SQL > Exception while executing the following:null (DELETE on table 'FIN_ACCOUNT' > caused a violation of foreign key constraint 'FINACT_STTS_FNA' for key > (SC_CHECKING). The statement has been rolled back.))) -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (OFBIZ-12153) Error in deleting Financial Account
[ https://issues.apache.org/jira/browse/OFBIZ-12153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17295227#comment-17295227 ] Pawan Verma commented on OFBIZ-12153: - Ahh yes, conflicts. Updated here: [^OFBIZ-12153.patch] > Error in deleting Financial Account > --- > > Key: OFBIZ-12153 > URL: https://issues.apache.org/jira/browse/OFBIZ-12153 > Project: OFBiz > Issue Type: Bug > Components: accounting >Reporter: Lalit Dashora >Assignee: sourabh jain >Priority: Major > Attachments: FinAccountDelete.png, OFBIZ-12153.patch, > OFBIZ-12153.patch, OFBIZ-12153.patch, OFBIZ-12153.patch, OFBIZ-12153.patch > > > 1. Navigate to URL: accounting/control/FindFinAccount > 2. Click on Find button. List of fin account will be displayed. > 3. Click on delete button near available balance column. > The Following Errors Occurred: > Error doing entity-auto operation for entity FinAccount in service > deleteFinAccount: org.apache.ofbiz.entity.GenericEntityException: > org.apache.ofbiz.entity.GenericDataSourceException: Exception while deleting > the following entity: > [GenericEntity:FinAccount][finAccountId,SC_CHECKING(java.lang.String)] (SQL > Exception while executing the following:null (DELETE on table 'FIN_ACCOUNT' > caused a violation of foreign key constraint 'FINACT_STTS_FNA' for key > (SC_CHECKING). The statement has been rolled back.)) (Exception while > deleting the following entity: > [GenericEntity:FinAccount][finAccountId,SC_CHECKING(java.lang.String)] (SQL > Exception while executing the following:null (DELETE on table 'FIN_ACCOUNT' > caused a violation of foreign key constraint 'FINACT_STTS_FNA' for key > (SC_CHECKING). The statement has been rolled back.))) -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (OFBIZ-12153) Error in deleting Financial Account
[ https://issues.apache.org/jira/browse/OFBIZ-12153?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Pawan Verma updated OFBIZ-12153: Attachment: OFBIZ-12153.patch > Error in deleting Financial Account > --- > > Key: OFBIZ-12153 > URL: https://issues.apache.org/jira/browse/OFBIZ-12153 > Project: OFBiz > Issue Type: Bug > Components: accounting >Reporter: Lalit Dashora >Assignee: sourabh jain >Priority: Major > Attachments: FinAccountDelete.png, OFBIZ-12153.patch, > OFBIZ-12153.patch, OFBIZ-12153.patch, OFBIZ-12153.patch, OFBIZ-12153.patch > > > 1. Navigate to URL: accounting/control/FindFinAccount > 2. Click on Find button. List of fin account will be displayed. > 3. Click on delete button near available balance column. > The Following Errors Occurred: > Error doing entity-auto operation for entity FinAccount in service > deleteFinAccount: org.apache.ofbiz.entity.GenericEntityException: > org.apache.ofbiz.entity.GenericDataSourceException: Exception while deleting > the following entity: > [GenericEntity:FinAccount][finAccountId,SC_CHECKING(java.lang.String)] (SQL > Exception while executing the following:null (DELETE on table 'FIN_ACCOUNT' > caused a violation of foreign key constraint 'FINACT_STTS_FNA' for key > (SC_CHECKING). The statement has been rolled back.)) (Exception while > deleting the following entity: > [GenericEntity:FinAccount][finAccountId,SC_CHECKING(java.lang.String)] (SQL > Exception while executing the following:null (DELETE on table 'FIN_ACCOUNT' > caused a violation of foreign key constraint 'FINACT_STTS_FNA' for key > (SC_CHECKING). The statement has been rolled back.))) -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (OFBIZ-12153) Error in deleting Financial Account
[ https://issues.apache.org/jira/browse/OFBIZ-12153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17295167#comment-17295167 ] Jacques Le Roux commented on OFBIZ-12153: - Sorry Pawan, the patch does not apply on trunk HEAD > Error in deleting Financial Account > --- > > Key: OFBIZ-12153 > URL: https://issues.apache.org/jira/browse/OFBIZ-12153 > Project: OFBiz > Issue Type: Bug > Components: accounting >Reporter: Lalit Dashora >Assignee: sourabh jain >Priority: Major > Attachments: FinAccountDelete.png, OFBIZ-12153.patch, > OFBIZ-12153.patch, OFBIZ-12153.patch, OFBIZ-12153.patch > > > 1. Navigate to URL: accounting/control/FindFinAccount > 2. Click on Find button. List of fin account will be displayed. > 3. Click on delete button near available balance column. > The Following Errors Occurred: > Error doing entity-auto operation for entity FinAccount in service > deleteFinAccount: org.apache.ofbiz.entity.GenericEntityException: > org.apache.ofbiz.entity.GenericDataSourceException: Exception while deleting > the following entity: > [GenericEntity:FinAccount][finAccountId,SC_CHECKING(java.lang.String)] (SQL > Exception while executing the following:null (DELETE on table 'FIN_ACCOUNT' > caused a violation of foreign key constraint 'FINACT_STTS_FNA' for key > (SC_CHECKING). The statement has been rolled back.)) (Exception while > deleting the following entity: > [GenericEntity:FinAccount][finAccountId,SC_CHECKING(java.lang.String)] (SQL > Exception while executing the following:null (DELETE on table 'FIN_ACCOUNT' > caused a violation of foreign key constraint 'FINACT_STTS_FNA' for key > (SC_CHECKING). The statement has been rolled back.))) -- This message was sent by Atlassian Jira (v8.3.4#803005)