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.util
    DB.getSQLValueString
    1. org.compiere.util.DB.getSQLValueStringEx(DB.java:1339)
    2. org.compiere.util.DB.getSQLValueString(DB.java:1382)
    2 frames
  8. org.compiere.model
    MIssue.create
    1. org.compiere.model.MSystem.getStatisticsInfo(MSystem.java:177)
    2. org.compiere.model.MIssue.init(MIssue.java:238)
    3. org.compiere.model.MIssue.<init>(MIssue.java:131)
    4. org.compiere.model.MIssue.<init>(MIssue.java:157)
    5. org.compiere.model.MIssue.create(MIssue.java:74)
    5 frames
  9. org.compiere.util
    CLogErrorBuffer.publish
    1. org.compiere.util.CLogErrorBuffer.publish(CLogErrorBuffer.java:222)
    1 frame