www.ibm.com/support/docview.wss?uid=swg21902318
IEM SUA / ILMT 9.2 import failing on running out of transaction log space
Technote (troubleshooting)
Problem(Abstract)
IBM Endpoint Manager for Software Use Analysis or IBM License Metric Tool imports analysis and scanning data from configured datasource. The import might result in lack of transaction log space when many analyses are activated (i.e. IBM Endpoint Manager for Patch Management analyses).
Symptom
The SUA / ILMT import fails on RawDatasourceFixletResult step with error SQLCODE “-964”, SQLSTATE “57011”
i.e.
2015-04-28 05:35:04 (+0:00:00.003) INFO: ETL from Data Source - RawDatasourceFixletResult (0x0000000000000000 - N/A): Start
2015-04-28 09:17:30 (+3:42:26.424) ERROR: SQL: {call DBO.ETL_RAW_DATASOURCE_FIXLET_RESULTS(?,?,?,?,?)}
2015-04-28 09:17:30 (+0:00:00.003) ERROR:
Batch execution error: Error for batch element #111: An error occurred
in a triggered SQL statement in trigger
"DBO.RAW_DATASOURCE_FIXLET_RESULTS_TRIGGER_INSERT".
Information returned for the error includes SQLCODE “-964”, SQLSTATE “57011” and message tokens “”… SQLCODE=-723, SQLSTATE=09000, DRIVER=3.64.104
2015-04-28 09:17:37 (+0:00:06.458) INFO: ETL from Data Source - RawDatasourceFixletResult (0x0000000000000000 - 0x00000014CFD63E91): Failed
2015-04-28 09:36:26 (+0:18:49.344) ERROR: Sequel::DatabaseError:
Java::ComIbmDb2JccAm::BatchUpdateException:
[jcc][t4][102][10040][3.64.104] Batch failure. The batch was
submitted,but at least one exception occurred on an individual member of
the batch. Use getNextException() to retrieve the exceptions for
specific batched elements. ERRORCODE=-4229, SQLSTATE=null
com.ibm.db2.jcc.am.bd.a(com/ibm/db2/jcc/am/bd.java:407)
com.ibm.db2.jcc.am.Agent.endBatchedReadChain(com/ibm/db2/jcc/am/Agent.ja
va:399)
…
java.lang.Thread.run(java/lang/Thread.java:863)
2015-04-28 09:36:26 (+0:00:00.077) INFO: Import failed in 4:35:26
2015-04-28 09:36:26 (+0:00:00.000) INFO: Import contains 3 errors.
Resolving the problem
To workaround the problem you must apply following procedure on SUA / ILMT server.
Procedure
1 Stop the SUA/ILMT server.
Linux:
/etc/init.d/SUAserver stop
/etc/init.d/LMTserver stop
Windows
a. Go to the License Metric Tool installation directory.
b. Open cli.
c. Run srvstop.bat.
2 Replace raw_datasource_fixlet_result.rb with raw_datasource_fixlet_result.rb
( download from technote: http://www-01.ibm.com/support/docview.wss?uid=swg21902318&aid=1 )
The file raw_datasource_fixlet_result.rb is in the following directory:
Linux:
install_dir/wlp/usr/servers/server1/apps/tema.war/WEB-INF/app/models
Windows:
install_dir\wlp\usr\servers\server1\apps\tema.war\WEB-INF\app\models
3 Start the SUA/ILMT server.
Linux:
/etc/init.d/SUAserver start
/etc/init.d/LMTserver start
Windows:
a. Go to the License Metric Tool installation directory.
b. Open cli.
c. Run srvstart.bat.
4 Run a data import (ETL) to Software Use Analysis.
This problem will be permanently addressed in the next SUA/ILMT release.