APAR status
Closed as program error.
Error description
Data Imports are failing with 2014-10-20 19:51:03 (+0:00:00.007) INFO: ETL from Data Source - SAM::RawAppUsagePropertyValue (0x00000000D34D44AE - N/A): Start 2014-10-20 19:51:05 (+0:00:01.697) DEBUG: (1.326000s) select ComputerID AS computer_remote_id, ResultsText AS value, IsPlural AS plural, IsFailure AS failure from dss.property_results where SiteID = 13014 and AnalysisID = 10 and PropertyID = 1 and Sequence > 0x00000000d34d44ae . 2014-10-20 19:51:32 (+0:00:27.598) ERROR: SQL: {call DBO.ETL_SAM__RAW_APP_USAGE_PROPERTY_VALUES(?,?,?,?)} 2014-10-20 19:51:32 (+0:00:00.008) ERROR: Batch execution error: Error for batch element #634: The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.. SQLCODE=-302, SQLSTATE=22001, DRIVER=4.17.28 2014-10-20 19:51:33 (+0:00:00.093) INFO: ETL from Data Source - SAM::RawAppUsagePropertyValue (0x00000000D34D44AE - 0x00000000D5432D68): Failed 2014-10-20 19:51:33 (+0:00:00.419) ERROR: Sequel::DatabaseError: Java::ComIbmDb2JccAm::BatchUpdateException: [jcc][t4][102][10040][4.17.28] 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 The above query returns a large amount of data (eg. 2.5 million rows). Customer checked the contents of C:\Program Files (x86)\BigFix Enterprise\BES Client\__BESData\__Global\UsageData on that computer and you found about 9,000 ccm*.stat files.
Local fix
L3 has a test fix which is an update to file <SUA_dir>/wlp/usr/servers/server1/apps/tema.war/WEB-INF/domains/ sam/app/models/sam/raw_app_usage_property_value.rb
Problem summary
**************************************************************** * Data import fails because of large amounts of data that is * uploaded as a result of software use scan. **************************************************************** * RECOMMENDATION: Apply appropriate update when available. ****************************************************************
Problem conclusion
The fix for this APAR is contained in the following maintenance packages: | Update | SUA 9.2 site version 44 | Update | ILMT 9.2 site version 58
Temporary fix
Comments
APAR Information
APAR number
IV67974
Reported component name
IEM SW USE ANL
Reported component ID
5725F57MT
Reported release
910
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2014-12-17
Closed date
2015-03-23
Last modified date
2015-03-23
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
IEM SW USE ANL
Fixed component ID
5725F57MT
Applicable component levels
R910 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSKLLW","label":"IBM BigFix Inventory"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"910","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]
Document Information
Modified date:
23 March 2015