SQL errors with "Invoice (Vendor)" window

[blacklevel]

Hi,

to reproduce just add a new record for "Invoice (Vendor)". The server log shows

===========> MLookup.getDirect: C_DocType.C_DocType_ID: SQL=SELECT C_DocType.C_DocType_ID,NULL,NVL(C_DocType_Trl.Name,'-1'),C_DocType.IsActive FROM C_DocType INNER JOIN C_DocType_TRL ON (C_DocType.C_DocType_ID=C_DocType_Trl.C_DocType_ID AND C_DocType_Trl.AD_Language='de_DE') WHERE C_DocType_ID=?; Key=0 [17]

org.postgresql.util.PSQLException: ERROR: column reference "c_doctype_id" is ambiguous

  Position: 228; State=42702; ErrorCode=0

at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)

at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)

at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)

at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:302)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)

at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:616)

at org.compiere.db.StatementProxy.invoke(StatementProxy.java:125)

at sun.proxy.$Proxy0.executeQuery(Unknown Source)

at org.compiere.model.MLookup.getDirect(MLookup.java:498)

at org.adempiere.webui.editor.WTableDirEditor.refreshList(WTableDirEditor.java:334)

at org.adempiere.webui.editor.WTableDirEditor.setValue(WTableDirEditor.java:237)

at org.adempiere.webui.editor.WTableDirEditor.propertyChange(WTableDirEditor.java:554)

at java.beans.PropertyChangeSupport.fire(PropertyChangeSupport.java:298)

at java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:291)

at java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:229)

at org.compiere.model.GridField.setValue(GridField.java:1411)

at org.compiere.model.GridTable.dataNew(GridTable.java:2532)

at org.compiere.model.GridTab.dataNew(GridTab.java:1158)

Similar errors are thrown when an existing "Invoice (Vendor)" record ist opened or refreshed. Here are some excerpts from the log:

===========> MLookup.getDirect: C_DocType.C_DocType_ID: SQL=SELECT C_DocType.C_DocType_ID,NULL,NVL(C_DocType_Trl.Name,'-1'),C_DocType.IsActive FROM C_DocType INNER JOIN C_DocType_TRL ON (C_DocType.C_DocType_ID=C_DocType_Trl.C_DocType_ID AND C_DocType_Trl.AD_Language='de_DE') WHERE C_DocType_ID=?; Key=1000005 [21]

org.postgresql.util.PSQLException: ERROR: column reference "c_doctype_id" is ambiguous

(...) 

===========> MLookup.getDirect: M_Product.M_Product_ID: SQL=SELECT M_Product.M_Product_ID,NULL,NVL(M_Product.Value,'-1') ||'_'|| NVL(M_Product_Trl.Name,'-1'),M_Product.IsActive FROM M_Product INNER JOIN M_Product_TRL ON (M_Product.M_Product_ID=M_Product_Trl.M_Product_ID AND M_Product_Trl.AD_Language='de_DE') WHERE M_Product_ID=?; Key=1000006 [19]

org.postgresql.util.PSQLException: ERROR: column reference "m_product_id" is ambiguous

  Position: 267; State=42702; ErrorCode=0

(...) 

===========> MLookup.getDirect: C_UOM.C_UOM_ID: SQL=SELECT C_UOM.C_UOM_ID,NULL,NVL(C_UOM_Trl.Name,'-1'),C_UOM.IsActive FROM C_UOM INNER JOIN C_UOM_TRL ON (C_UOM.C_UOM_ID=C_UOM_Trl.C_UOM_ID AND C_UOM_Trl.AD_Language='de_DE') WHERE C_UOM_ID=?; Key=100 [19]

org.postgresql.util.PSQLException: ERROR: column reference "c_uom_id" is ambiguous

  Position: 184; State=42702; ErrorCode=0

(...) 

===========> MLookup.getDirect: C_Tax.C_Tax_ID: SQL=SELECT C_Tax.C_Tax_ID,NULL,NVL(C_Tax_Trl.Name,'-1'),C_Tax.IsActive FROM C_Tax INNER JOIN C_Tax_TRL ON (C_Tax.C_Tax_ID=C_Tax_Trl.C_Tax_ID AND C_Tax_Trl.AD_Language='de_DE') WHERE C_Tax_ID=?; Key=1000003 [19]

org.postgresql.util.PSQLException: ERROR: column reference "c_tax_id" is ambiguous

  Position: 184; State=42702; ErrorCode=0

Best regards

Michael

[blacklevel]

This seems to be a general problem with "MLookup.getDirect". The detail tabs for the role window are broken as well. The error log also registers ambiguous column references.

[Heng Sin Low]

are you testing with the latest source ?

--
You received this message because you are subscribed to the Google Groups "iDempiere" group.
To unsubscribe from this group and stop receiving emails from it, send an email to idempiere+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[blacklevel]

yes.

[Heng Sin Low]

ah ok, my mistake. the error only popup when you login using non-english, i.e not base locale. thanks for the quick alert.

On Wed, Feb 20, 2013 at 9:37 PM, blacklevel <michael.h...@gmail.com> wrote:

--

[Heng Sin Low]

Please update your source and try again, should work now.

[blacklevel]

Yes, works great now. Thanks for the ultra-quick fix.