IBM Support

Data import fails with "Exception occurred during clob conversion - ERRORCODE=-4220, SQLSTATE=null"

Troubleshooting


Problem

Data import fails with a CLOB conversion error:
INFO: ETL from Data Source - SAM::RawComputerHealthValue        (0x00000003BAD4DC70 - N/A): Start
INFO: ETL from Data Source - SAM::RawComputerHealthValue        (0x00000003BAD4DC70 - 0x00000003BD23F1D9): Failed
ERROR: Sequel::DatabaseError: DBNAME: BFENT - Java::ComIbmDb2JccAm::SqlException: [jcc][1037][12036][4.32.28] Exception occurred during clob conversion.  See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null
com.ibm.db2.jcc.am.b7.a(com/ibm/db2/jcc/am/b7.java:794)
com.ibm.db2.jcc.am.b7.a(com/ibm/db2/jcc/am/b7.java:66)
com.ibm.db2.jcc.am.b7.a(com/ibm/db2/jcc/am/b7.java:98)
(...)
    org.jruby.RubyProc.call(org/jruby/RubyProc.java:309)
    java.lang.Thread.run(java/lang/Thread.java:825)
2024-03-06 10:57:14 (+0:00:00.072) INFO: Import failed in 0:01:04
2024-03-06 10:57:14 (+0:00:00.001) INFO: Import contains 1 warnings.
2024-03-06 10:57:14 (+0:00:00.000) INFO: Import contains 1 errors.

Cause

The JCC driver throws the exception when data in a character column that it queries is not a valid string in the database code page.

Invalid data potentially could be retrieved from files from the endpoint which contain character data that is not in the code page of the client machine, so the appropriate code page conversion was not done. 

Resolving The Problem

Run the following steps:

  1. Stop the IBM License Metric Tool Server.
  2. Add the following line to <ILMT installation directory>\wlp\usr\servers\server1\jvm.options file:
    -Ddb2.jcc.charsetDecoderEncoder=3
  3. Start IBM License Metric Tool Server.
  4. Run the data import. 

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB67","label":"IT Automation \u0026 App Modernization"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS8JFY","label":"IBM License Metric Tool"},"ARM Category":[{"code":"a8m3p000000LQq1AAG","label":"Data ETL"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
17 April 2024

UID

ibm17148360

Page Feedback