IB database issues

  • Creator
    Topic
  • #50366
    Richard Hart
    Participant

      Has anyone seen this in the IB ‘wrapper.log’ file?

      I’m migrating a webservice from my personal development Cloverleaf site to the ‘real’ dev site and it is still looking at the ports I originally used and not the ports in the ‘dev’ range.

      Any ideas on how to clean the derby database?

      Thanks.

      jvm 1    | ERROR 17:12:38.054 [Worker#7] IB | SQL Error

      jvm 1    | ERROR 22018: Invalid character string format for type INTEGER.

      jvm 1    |      at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)

      jvm 1    |      at org.apache.derby.iapi.types.DataType.invalidFormat(Unknown Source)

      jvm 1    |      at org.apache.derby.iapi.types.SQLInteger.setValue(Unknown Source)

      jvm 1    |      at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setString(Unknown Source)

      jvm 1    |      at com.quovadx.bpms.db.CWPreparedStatement.setString(CWPreparedStatement.java:69)

      jvm 1    |      at com.quovadx.bpms.api.CWForm.bindSQLParameter(CWForm.java:2800)

      jvm 1    |      at com.quovadx.bpms.api.CWForm.insertIntoFDT(CWForm.java:2310)

      jvm 1    |      at com.quovadx.bpms.api.CWForm.insertOrUpdateFDTs(CWForm.java:1961)

      jvm 1    |      at com.quovadx.bpms.api.CWObject.objectTag(CWObject.java:447)

      jvm 1    |      at com.quovadx.bpms.api.HXML.evalHXMLTag(HXML.java:1624)

      jvm 1    |      at com.quovadx.bpms.api.HXML.executeNode(HXML.java:1484)

      jvm 1    |      at com.quovadx.bpms.api.HXML.executeNode(HXML.java:1316)

      jvm 1    |      at com.quovadx.bpms.api.HXML.loopTag(HXML.java:2896)

      jvm 1    |      at com.quovadx.bpms.api.HXML.executeNode(HXML.java:1306)

      jvm 1    |      at com.quovadx.bpms.api.HXML.executeNode(HXML.java:1316)

      jvm 1    |      at com.quovadx.bpms.api.HXML.loopTag(HXML.java:2896)

      jvm 1    |      at com.quovadx.bpms.api.HXML.executeNode(HXML.java:1306)

      jvm 1    |      at com.quovadx.bpms.api.HXML.executeNode(HXML.java:1316)

      jvm 1    |      at com.quovadx.bpms.api.HXML.doExecuteNode(HXML.java:491)

      jvm 1    |      at com.quovadx.bpms.api.HXML.executeProc2(HXML.java:991)

      jvm 1    |      at com.quovadx.bpms.api.HXML.resultDocFromExecuteProc(HXML.java:786)

      jvm 1    |      at com.quovadx.bpms.api.HXML.executeProc(HXML.java:835)

      jvm 1    |      at com.quovadx.bpms.api.HXML.executeHXML(HXML.java:553)

      jvm 1    |      at com.quovadx.bpms.api.RequestProcessor.executeRequest(RequestProcessor.java:107)

      jvm 1    |      at com.quovadx.bpms.api.RequestProcessor.processRequest(RequestProcessor.java:182)

      jvm 1    |      at com.quovadx.bpms.api.CWTransactionalJob.handleRequest(CWTransactionalJob.java:231)

      jvm 1    |      at com.quovadx.bpms.api.CWTransactionalJob.run(CWTransactionalJob.java:140)

      jvm 1    |      at com.quovadx.bpms.core.WorkerPool$Worker.run(WorkerPool.java:67)

      jvm 1    | ERROR 17:12:38.055 [Worker#7] IB | caught exception processing action ‘IBgetNetConfig.xsp’

      jvm 1    | com.quovadx.bpms.core.CWException: (HXML_072) Error processing XSP “IBgetNetConfig.xsp”

      jvm 1    |      at com.quovadx.bpms.api.HXML.executeHXML(HXML.java:558)

      jvm 1    |      at com.quovadx.bpms.api.RequestProcessor.executeRequest(RequestProcessor.java:107)

      jvm 1    |      at com.quovadx.bpms.api.RequestProcessor.processRequest(RequestProcessor.java:182)

      jvm 1    |      at com.quovadx.bpms.api.CWTransactionalJob.handleRequest(CWTransactionalJob.java:231)

      jvm 1    |      at com.quovadx.bpms.api.CWTransactionalJob.run(CWTransactionalJob.java:140)

      jvm 1    |      at com.quovadx.bpms.core.WorkerPool$Worker.run(WorkerPool.java:67)

      jvm 1    | ERROR 17:12:38.101 [Worker#7] IB | Error detected:

      jvm 1    | ERROR 17:12:38.101 [Worker#7] IB |   (MISC_1) Exception: Invalid character string format for type INTEGER.

      jvm 1    | ERROR 17:12:38.101 [Worker#7] IB |   (DBMS_030) Native error code: 20,000, exception:

      jvm 1    | ERROR 17:12:38.101 [Worker#7] IB |   (DBMS_036) Failed to insert rows for form “IBMapping”

      jvm 1    | ERROR 17:12:38.101 [Worker#7] IB |   (HXML_063) Error processing tag “

      jvm 1    | ERROR 17:12:38.101 [Worker#7] IB |   (HXML_072) Error processing XSP “IBgetNetConfig.xsp”

    Viewing 0 reply threads
    • Author
      Replies
      • #65782
        Richard Hart
        Participant

          I have solved the issues.

          1. …. format for type INTEGER.

          The port to connect to the IB MUST be an integer,  this error is produced if you use a ‘services’ value!

          2.  I tried a few things unsuccessfully, but fixed this when I used the SQuirreL utility to delete the entries from the IB tables (we are in dev mode still).

      Viewing 0 reply threads
      • The forum ‘Intelligent Health Broker’ is closed to new topics and replies.