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.

Forum Statistics

Registered Users
5,125
Forums
28
Topics
9,294
Replies
34,439
Topic Tags
287
Empty Topic Tags
10