IB database issues

[Richard Hart]

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”

Topic

[Richard Hart]

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).

[Author]

Replies