org.postgresql.util.PSQLException: ERROR: multiple decimal points; State=42601; ErrorCode=0

adempiere | phib | 6 years ago
  1. 0

    DB.TO_CHAR doesn't format dates and numbers

    adempiere | 6 years ago | phib
    org.postgresql.util.PSQLException: ERROR: multiple decimal points; State=42601; ErrorCode=0
  2. 0

    Concept for the payroll

    adempiere | 7 years ago | mekameka4
    org.postgresql.util.PSQLException: ERROR: syntax error at or near "null"; State=42601; ErrorCode=0
  3. 0

    Using TRIM(timestamp) in SQL not working

    adempiere | 6 years ago | mjmckay
    org.postgresql.util.PSQLException: ERROR: function pg\_catalog.btrim(timestamp without time zone) does not exist   Hint: No function matches the given name and argument types. You might need to add explicit type casts.   Position: 156; State=42883; ErrorCode=0
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Problema con Informacion de Productos

    adempiere | 6 years ago | edwinhaq
    org.postgresql.util.PSQLException: ERROR: no existe la función get\_sysconfig(unknown, unknown, numeric, integer)   Hint: Ninguna función coincide en el nombre y tipos de argumentos. Puede desear agregar conversión explícita de tipos.   Position: 138; State=42883; ErrorCode=0
  6. 0

    Error impor cuenta contable a Organización

    adempiere | 7 years ago | gedeplat
    org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; ErrorCode=0
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. org.postgresql.util.PSQLException

    ERROR: multiple decimal points; State=42601; ErrorCode=0

    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse()
  2. PostgreSQL JDBC Driver
    AbstractJdbc2Statement.executeQuery
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
    6 frames
  3. c3p0:JDBC DataSources/Resource Pools
    NewProxyPreparedStatement.executeQuery
    1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
    1 frame
  4. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    3. java.lang.reflect.Method.invoke(Method.java:597)
    3 frames
  5. org.compiere.db
    StatementProxy.invoke
    1. org.compiere.db.StatementProxy.invoke(StatementProxy.java:100)
    1 frame
  6. Unknown
    $Proxy1.executeQuery
    1. $Proxy1.executeQuery(Unknown Source)
    1 frame
  7. org.compiere.model
    MLookup.getDisplay
    1. org.compiere.model.MLookup.getDirect(MLookup.java:470)
    2. org.compiere.model.MLookup.get(MLookup.java:229)
    3. org.compiere.model.MLookup.getDisplay(MLookup.java:243)
    3 frames
  8. org.compiere.grid
    VLookup.propertyChange
    1. org.compiere.grid.ed.VLookup.setValue(VLookup.java:558)
    2. org.compiere.grid.ed.VLookup.propertyChange(VLookup.java:628)
    2 frames
  9. Java RT
    PropertyChangeSupport.firePropertyChange
    1. java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:339)
    2. java.beans.PropertyChangeSupport.firePropertyChange(PropertyChangeSupport.java:276)
    2 frames
  10. org.compiere.model
    GridTab.dataNew
    1. org.compiere.model.GridField.setValue(GridField.java:1294)
    2. org.compiere.model.GridTable.dataNew(GridTable.java:2523)
    3. org.compiere.model.GridTab.dataNew(GridTab.java:1135)
    3 frames
  11. org.compiere.apps
    APanel.stateChanged
    1. org.compiere.apps.APanel.stateChanged(APanel.java:1479)
    1 frame