0045989: Error in the references of type OBUISEL_Selector Reference

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #45989		[ All Revisions ] [ Back to Issue ]
Summary	0045989: Error in the references of type OBUISEL_Selector Reference

Revision	2021-03-04 14:18 by AugustoMauch
Steps To Reproduce	Issue preparation: Follow steps 1-4 or install attached module on a Web POS environment 1. In the "Sales Order" window a. create a field in the database and in the application dictionary of type button. 2. Create a "Process Definition" with Standard interface pattern and "Client/Organization" data access. Set any handler. a.Create a "Business Partner" parameter with reference type "OBUISEL_Selector Reference". b.Create a reference of type "OBUISEL_Selector Reference", in the defined selector tab set: 1. Table: Business Partner 2. Template: Selector Template 3. Custom query: yes 4. HQL: select bp.name as name, bp.id as bpid from BusinessPartner bp where bp.employee=true 5.Entity Alias= bp 6.Display Field= name 7.Value Field= id c. assign this reference to the reference of the created parameter 3.assign the process created before to the button created in the "Sales Order" window. 4. Compile: check that no error or warning is displayed about the missing mandatory constant "@additional_filters@". Reproducing the issue: 5. Open the "Sales Order" window, click on the new orange button. 6. open the file openbravo.log 7. click on the created selector 8. view errors in the log: 2021-03-03 09:17:43,168 [http-nio-8080-exec-7] ERROR org.openbravo.service.datasource.DataSourceServlet - Could not locate named parameter [clients], expecting one of [] java.lang.IllegalArgumentException: Could not locate named parameter [clients], expecting one of [] at org.hibernate.query.internal.ParameterMetadataImpl.getNamedParameterDescriptor(ParameterMetadataImpl.java:229) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.query.internal.ParameterMetadataImpl.getQueryParameter(ParameterMetadataImpl.java:198) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.query.internal.QueryParameterBindingsImpl.resolveQueryParameter(QueryParameterBindingsImpl.java:460) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.query.internal.QueryParameterBindingsImpl.getQueryParameterListBinding(QueryParameterBindingsImpl.java:450) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.query.internal.AbstractProducedQuery.setParameterList(AbstractProducedQuery.java:614) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final]

Revision	2021-03-04 14:16 by AugustoMauch
Steps To Reproduce	Issue preparation: Follow steps 1-4 or install attached module 1. In the "Sales Order" window a. create a field in the database and in the application dictionary of type button. 2. Create a "Process Definition" with Standard interface pattern and "Client/Organization" data access. Set any handler. a.Create a "Business Partner" parameter with reference type "OBUISEL_Selector Reference". b.Create a reference of type "OBUISEL_Selector Reference", in the defined selector tab set: 1. Table: Business Partner 2. Template: Selector Template 3. Custom query: yes 4. HQL: select bp.name as name, bp.id as bpid from BusinessPartner bp where bp.employee=true 5.Entity Alias= bp 6.Display Field= name 7.Value Field= id c. assign this reference to the reference of the created parameter 3.assign the process created before to the button created in the "Sales Order" window. 4. Compile: check that no error or warning is displayed about the missing mandatory constant "@additional_filters@". Reproducing the issue: 5. Open the "Sales Order" window, click on the new orange button. 6. open the file openbravo.log 7. click on the created selector 8. view errors in the log: 2021-03-03 09:17:43,168 [http-nio-8080-exec-7] ERROR org.openbravo.service.datasource.DataSourceServlet - Could not locate named parameter [clients], expecting one of [] java.lang.IllegalArgumentException: Could not locate named parameter [clients], expecting one of [] at org.hibernate.query.internal.ParameterMetadataImpl.getNamedParameterDescriptor(ParameterMetadataImpl.java:229) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.query.internal.ParameterMetadataImpl.getQueryParameter(ParameterMetadataImpl.java:198) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.query.internal.QueryParameterBindingsImpl.resolveQueryParameter(QueryParameterBindingsImpl.java:460) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.query.internal.QueryParameterBindingsImpl.getQueryParameterListBinding(QueryParameterBindingsImpl.java:450) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.query.internal.AbstractProducedQuery.setParameterList(AbstractProducedQuery.java:614) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final]

Revision	2021-03-04 14:15 by AugustoMauch
Steps To Reproduce	1. In the "Sales Order" window a. create a field in the database and in the application dictionary of type button. 2. Create a "Process Definition" with Standard interface pattern and "Client/Organization" data access. Set any handler. a.Create a "Business Partner" parameter with reference type "OBUISEL_Selector Reference". b.Create a reference of type "OBUISEL_Selector Reference", in the defined selector tab set: 1. Table: Business Partner 2. Template: Selector Template 3. Custom query: yes 4. HQL: select bp.name as name, bp.id as bpid from BusinessPartner bp where bp.employee=true 5.Entity Alias= bp 6.Display Field= name 7.Value Field= id c. assign this reference to the reference of the created parameter 3.assign the process created before to the button created in the "Sales Order" window. 4. Compile: check that no error or warning is displayed about the missing mandatory constant "@additional_filters@". 5. Open the "Sales Order" window, click on the new orange button. 6. open the file openbravo.log 7. click on the created selector 8. view errors in the log: 2021-03-03 09:17:43,168 [http-nio-8080-exec-7] ERROR org.openbravo.service.datasource.DataSourceServlet - Could not locate named parameter [clients], expecting one of [] java.lang.IllegalArgumentException: Could not locate named parameter [clients], expecting one of [] at org.hibernate.query.internal.ParameterMetadataImpl.getNamedParameterDescriptor(ParameterMetadataImpl.java:229) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.query.internal.ParameterMetadataImpl.getQueryParameter(ParameterMetadataImpl.java:198) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.query.internal.QueryParameterBindingsImpl.resolveQueryParameter(QueryParameterBindingsImpl.java:460) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.query.internal.QueryParameterBindingsImpl.getQueryParameterListBinding(QueryParameterBindingsImpl.java:450) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final] at org.hibernate.query.internal.AbstractProducedQuery.setParameterList(AbstractProducedQuery.java:614) ~[hibernate-core-5.4.2.Final.jar:5.4.2.Final]