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

adempiere | phib | 7 years ago
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

    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 | 7 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
    1. org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(
    2. org.postgresql.core.v3.QueryExecutorImpl.processResults(
    3. org.postgresql.core.v3.QueryExecutorImpl.execute(
    4. org.postgresql.jdbc2.AbstractJdbc2Statement.execute(
    5. org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
    6. org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(
    6 frames
  3. c3p0:JDBC DataSources/Resource Pools
    1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(
    1 frame
  4. Java RT
    1. sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(
    3. java.lang.reflect.Method.invoke(
    3 frames
  5. org.compiere.db
    1. org.compiere.db.StatementProxy.invoke(
    1 frame
  6. Unknown
    1. $Proxy1.executeQuery(Unknown Source)
    1 frame
  7. org.compiere.util
    1. org.compiere.util.DB.getSQLValueStringEx(
    2. org.compiere.util.DB.getSQLValueString(
    2 frames
  8. org.compiere.model
    1. org.compiere.model.MSystem.getStatisticsInfo(
    2. org.compiere.model.MIssue.init(
    3. org.compiere.model.MIssue.<init>(
    4. org.compiere.model.MIssue.<init>(
    5. org.compiere.model.MIssue.create(
    5 frames
  9. org.compiere.util
    1. org.compiere.util.CLogErrorBuffer.publish(
    1 frame