org.postgresql.util.PSQLException

ERROR: IN types numeric and character varying cannot be matched

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web625

  • via openbravo by pangeacb
    ,
  • via openbravo by jesuscampos19
    ,
  • Stack trace

    • org.postgresql.util.PSQLException: ERROR: IN types numeric and character varying cannot be matched at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:250) at org.openbravo.data.Sqlc.query(Unknown Source) at org.openbravo.data.Sqlc.endElement(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source) at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source) at org.apache.xerces.parsers.DTDConfiguration.parse(Unknown Source) at org.apache.xerces.parsers.DTDConfiguration.parse(Unknown Source) at org.apache.xerces.parsers.XMLParser.parse(Unknown Source) at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source) at org.openbravo.data.Sqlc.parseSqlFile(Unknown Source) at org.openbravo.data.Sqlc.listDir(Unknown Source) at org.openbravo.data.Sqlc.listDir(Unknown Source) at org.openbravo.data.Sqlc.listDir(Unknown Source) at org.openbravo.data.Sqlc.listDir(Unknown Source) at org.openbravo.data.Sqlc.listDir(Unknown Source) at org.openbravo.data.Sqlc.main(Unknown Source)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    jokesterjokester
    Once,
    Unknown visitor
    Unknown visitor2 times, last one
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitor2 times, last one
    36 more bugmates