org.postgresql.util.PSQLException

El φndice de la columna estß fuer a de rango: 1, n·mero de columnas: 0.      \[java\]   SELECT C\_INVOICE.C\_INVOICE\_ID, COALESCE(M\_PRODUCT.NAME, C\_INVOICEL INE.DESCRIPTION) AS NAME\_PRODUCT, at org.postgresql.core.v3.SimpleParameterList.bind(SimpleParamet erList.java:57) m\_product.m\_product\_id, C\_INVOICELINE.QTYINVOICED, C\_UOM.NAME AS UOMNAME, at org.postgresql.core.v3.SimpleParameterList.setNull(SimplePara meterList.java:117) C\_INVOICELINE.DESCRIPTION, at org.postgresql.jdbc2.AbstractJdbc2Statement.setNull(AbstractJ dbc2Statement.java:1058)      C\_INVOICELINE.LINENETAMT, C\_INVOICELINE.PRICEACTUAL, at org.postgresql.jdbc3.AbstractJdbc3Statement.setNull(AbstractJ dbc3Statement.java:1444)      M\_INOUT.DOCUMENTNO AS INOUTNO, C\_ORDER.DOCUMENTNO AS ORDERNO ,

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1438

  • via openbravo by mary10
    , 11 months ago
    El φndice de la columna estß fuer a de rango: 1, n·mero de columnas: 0.      \[java\]   SELECT C\_INVOICE.C\_INVOICE\_ID, COALESCE(M\_PRODUCT.NAME, C\_INVOICEL INE.DESCRIPTION) AS NAME\_PRODUCT, at org.postgresql.core.v3.SimpleParameterList.bind
  • (AbstractJ dbc2Statement.java:430)      \[java\] C\_BP\_Salon\_Acct.AD\_Client\_ID,      \[java\] (CASE WHEN C\_BP\_Salon\_Acct.AD\_Client\_ID IS NULL THEN '' ELSE  (COALE SCE(TO\_CHAR(table2.Name),'') ) END) AS AD\_Client\_IDR, at org.postgresql.jdbc2
  • via adempiere by ebucher
    , 1 year ago
    ERROR: ClassNotFoundException: org.compiere.sqlj.Product SELECT p.M\_Product\_ID, p.Discontinued, p.Value, p.Name, bomQtyAvailable(p.M\_Product\_ID,?,0) AS QtyAvailable, bomPriceList(p.M\_Product\_ID, pr.M\_PriceList\_Version\_ID) AS PriceList
  • Stack trace

    • org.postgresql.util.PSQLException: El φndice de la columna estß fuer a de rango: 1, n·mero de columnas: 0.      \[java\]   SELECT C\_INVOICE.C\_INVOICE\_ID, COALESCE(M\_PRODUCT.NAME, C\_INVOICEL INE.DESCRIPTION) AS NAME\_PRODUCT, at org.postgresql.core.v3.SimpleParameterList.bind(SimpleParamet erList.java:57) m\_product.m\_product\_id, C\_INVOICELINE.QTYINVOICED, C\_UOM.NAME AS UOMNAME, at org.postgresql.core.v3.SimpleParameterList.setNull(SimplePara meterList.java:117) C\_INVOICELINE.DESCRIPTION, at org.postgresql.jdbc2.AbstractJdbc2Statement.setNull(AbstractJ dbc2Statement.java:1058)      C\_INVOICELINE.LINENETAMT, C\_INVOICELINE.PRICEACTUAL, at org.postgresql.jdbc3.AbstractJdbc3Statement.setNull(AbstractJ dbc3Statement.java:1444)      M\_INOUT.DOCUMENTNO AS INOUTNO, C\_ORDER.DOCUMENTNO AS ORDERNO , at org.openbravo.data.Sqlc.query(Unknown Source)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    You’re the first here who have seen this exception.