TECHNOTE: IEM FOR SUA / ILMT 9.2 GA List of technotes

Hello,

Below you will find all technotes that were released for 9.2 GA.
I wouldn’t recommend every customer to apply everything, but one in particular I do recommend.

http://www-01.ibm.com/support/docview.wss?uid=swg21902714 (In my opinion this is a must have)

http://www-01.ibm.com/support/docview.wss?uid=swg21701253

http://www-01.ibm.com/support/docview.wss?uid=swg21701078

http://www-01.ibm.com/support/docview.wss?uid=swg21882935

http://www-01.ibm.com/support/docview.wss?uid=swg21902318

http://www-01.ibm.com/support/docview.wss?uid=swg21883112

On top of technotes above, there is one more known issue.

If import fails with following error seen in import log:

2015-05-07 19:16:37 (+0:00:22.231) INFO: ETL from Data Source - SAM::AppUsagePropertyValue (0x0000000092342C29 - 0x00000000925CD38E): Failed
2015-05-07 19:16:39 (+0:00:01.774) ERROR: Sequel::UniqueConstraintViolation: Java::ComIbmDb2JccAm::SqlIntegrityConstraintViolationException: One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by “2” constrains table “SAM.APP_USAGE_PROPERTY_VALUES_SCD” from having duplicate values for the index key… SQLCODE=-803, SQLSTATE=23505, DRIVER=4.14.111

Procedure:

  1. Stop the server
  2. Replace files provded below
  3. Start the server

Paths:
Win:
c:\Program Files\ibm\SUA\wlp\usr\servers\server1\apps\tema.war\WEB-INF\lib\etl\strategy\simplified_work_table.rb
c:\Program Files\ibm\SUA\wlp\usr\servers\server1\apps\tema.war\WEB-INF\domains\sam\app\models\sam\app_usage_property_value.rb

Linux:
/opt/ibm/SUA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/lib/etl/strategy/simplified_work_table.rb
/opt/ibm/SUA/wlp/usr/servers/server1/apps/tema.war/WEB-INF/domains/sam/app/models/sam/app_usage_property_value.rb

Files:

ftp://ftp.ecurep.ibm.com/fromibm/tivoli/appsuage.zip

1 Like

All above were included in ILMT/SUA 9.2.0.1 (Patch 1)

Hi, michalpaluch.

I’m facing this problem with import failure, but on the Version: 9.2.0.2.

Log information:

2015-10-30 00:46:23 (+0:00:01.451) INFO: Inserting new 534521 rows into SAM::AppUsagePropertyValue. This operation may take a long time
2015-10-30 00:48:08 (+0:01:45.160) INFO: ETL from DS-EDU - SAM::AppUsagePropertyValue (0x0000000056BDFAC7 - 0x000000005780C8D7): Failed
2015-10-30 00:52:10 (+0:04:02.334) ERROR: Sequel::DatabaseError: Java::ComMicrosoftSqlserverJdbc::SQLServerException: Cannot insert duplicate key row in object ‘sam.app_usage_property_values_scd’ with unique index ‘sam_app_usage_property_values_scd_app_usage_property_id_computer_id_process_valid_to_index’.
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(com/microsoft/sqlserver/jdbc/SQLServerException.java:216)
com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(com/microsoft/sqlserver/jdbc/tdsparser.java:254)
com.microsoft.sqlserver.jdbc.TDSParser.parse(com/microsoft/sqlserver/jdbc/tdsparser.java:84)
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:1510)
com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:792)
com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(com/microsoft/sqlserver/jdbc/SQLServerStatement.java:68

Environment:
Software Use Analysis 9.2.0.2 on MS SQL Server 2008 R2.

Hello,
First thing I suggest, is to update to 9.2.1 and try again.

Hi, michalpaluch

You don’t need to update the application version. Only execute ‘reorg’ on temadb database. I cannot to update the application version on this moment.

Thanks.

1 Like