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:
- Stop the server
- Replace files provded below
- 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: