Fill the business partner field with "Patio" and push Tab button
Error shown to the user: ERROR: syntax error at or near ")" Position: 323
In log it records:
13:38:08.431===========> CalloutInOut.bpartner: SELECT p.AD_Language,p.C_PaymentTerm_ID,p.M_PriceList_ID,p.PaymentRule,p.POReference,p.SO_Description,p.IsDiscountPrinted,p.SO_CreditLimit-p.SO_CreditUsed AS CreditAvailable,l.C_BPartner_Location_ID,c.AD_User_ID FROM C_BPartner p, C_BPartner_Location l, AD_User c WHERE l.IsActive='Y' AND p.C_BPartner_ID=l.C_BPartner_ID(+) AND p.C_BPartner_ID=c.C_BPartner_ID(+) AND p.C_BPartner_ID=? [36]
org.postgresql.util.PSQLException: ERROR: error de sintaxis en o cerca de «)»
Position: 323; State=42601; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:106)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:353)
at jdk.internal.reflect.GeneratedMethodAccessor48.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.compiere.db.StatementProxy.invoke(StatementProxy.java:130)
at com.sun.proxy.$Proxy12.executeQuery(Unknown Source)
at org.compiere.model.CalloutInOut.bpartner(CalloutInOut.java:286)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.compiere.model.CalloutEngine.start(CalloutEngine.java:110)
at org.compiere.model.GridTab.processCallout(GridTab.java:2972)
at org.compiere.model.GridTab.processFieldChange(GridTab.java:2769)
13:38:08.474-----------> Msg.getMsg: NOT found: ERROR: error de sintaxis en o cerca de «)»
Position: 323 [36]
Test case in server https://test-postgresql.idempiere.org/webui/
as GardenWorld Admin
Open Material Receipt window on insert mode
Fill the business partner field with "Patio" and push Tab button
Error shown to the user: ERROR: syntax error at or near ")" Position: 323
In log it records:
13:38:08.431===========> CalloutInOut.bpartner: SELECT p.AD_Language,p.C_PaymentTerm_ID,p.M_PriceList_ID,p.PaymentRule,p.POReference,p.SO_Description,p.IsDiscountPrinted,p.SO_CreditLimit-p.SO_CreditUsed AS CreditAvailable,l.C_BPartner_Location_ID,c.AD_User_ID FROM C_BPartner p, C_BPartner_Location l, AD_User c WHERE l.IsActive='Y' AND p.C_BPartner_ID=l.C_BPartner_ID(+) AND p.C_BPartner_ID=c.C_BPartner_ID(+) AND p.C_BPartner_ID=? [36] org.postgresql.util.PSQLException: ERROR: error de sintaxis en o cerca de «)» Position: 323; State=42601; ErrorCode=0 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143) at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:106) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:353) at jdk.internal.reflect.GeneratedMethodAccessor48.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.compiere.db.StatementProxy.invoke(StatementProxy.java:130) at com.sun.proxy.$Proxy12.executeQuery(Unknown Source) at org.compiere.model.CalloutInOut.bpartner(CalloutInOut.java:286) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.compiere.model.CalloutEngine.start(CalloutEngine.java:110) at org.compiere.model.GridTab.processCallout(GridTab.java:2972) at org.compiere.model.GridTab.processFieldChange(GridTab.java:2769) 13:38:08.474-----------> Msg.getMsg: NOT found: ERROR: error de sintaxis en o cerca de «)» Position: 323 [36]