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 ,

openbravo | mary10 | 9 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    error al compilar!!

    openbravo | 9 years ago | mary10
    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 ,
  2. 0

    Removed Tables Causing Builds To Fail

    openbravo | 9 years ago | jcastleman
    org.postgresql.util.PSQLException: ERROR: relation "c\_bp\_salon\_acct" does not exist      SELECT C\_BP\_Salon\_Acct.License\_Number, at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse (QueryExecutorImpl.java:1512)      \[java\] COALESCE(C\_BP\_Salon\_Acct.Isactive, 'N') AS Isactive, at org.postgresql.core.v3.QueryExecutorImpl.processResults(Query ExecutorImpl.java:1297)      \[java\] C\_BP\_Salon\_Acct.C\_Bpartner\_ID, at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecuto rImpl.java:188)      \[java\] (CASE WHEN C\_BP\_Salon\_Acct.C\_Bpartner\_ID IS NULL THEN '' ELSE  (COAL ESCE(TO\_CHAR(table1.Name),'') ) END) AS C\_Bpartner\_IDR, at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ dbc2Statement.java:430)      \[java\] C\_BP\_Salon\_Acct.Licensing\_Entity, at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags( AbstractJdbc2Statement.java:346)      \[java\] C\_BP\_Salon\_Acct.AD\_Client\_ID, at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(Abst ractJdbc2Statement.java:250)      \[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,
  3. 0

    Error al compilar ventana

    openbravo | 9 years ago | palmira
    org.postgresql.util.PSQLException: ERROR: syntax error at or near ") "      SELECT CUS\_NGO\_LIVRES.Livres\_ID, at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse (QueryExecutorImpl.java:1512)      \[java\] (CASE WHEN CUS\_NGO\_LIVRES.Livres\_ID IS NULL THEN '' ELSE  () END) AS Livres\_IDR, at org.postgresql.core.v3.QueryExecutorImpl.processResults(Query ExecutorImpl.java:1297)      \[java\] CUS\_NGO\_LIVRES.Auteur, at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecuto rImpl.java:188)      \[java\] CUS\_NGO\_LIVRES.Titre, at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJ dbc2Statement.java:430)      \[java\] CUS\_NGO\_LIVRES.Editorial, at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags( AbstractJdbc2Statement.java:346)      \[java\] CUS\_NGO\_LIVRES.Langue, at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(Abst ractJdbc2Statement.java:250)      \[java\] CUS\_NGO\_LIVRES.Code,
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. org.openbravo.data
      Sqlc.query
      1. org.openbravo.data.Sqlc.query(Unknown Source)
      1 frame