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

adempiere | phib | 7 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    DB.TO_CHAR doesn't format dates and numbers

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

    Concept for the payroll

    adempiere | 8 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 | 7 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