Troubleshooting
Problem
The SE_CLEANUPDATA removes a required field from the database.
Therefore, starting with FP version 7.1.0-TIV-NCI-FP0019, the use of the SE_CLEANUPDATA policy is not recommended.
Symptom
If the SE_CLEANUPDATA policy is run, then subsequent Seasonality Configurations will show a status of "Finished with Errors" and the <server>_policylogger_seasonalityProcess.log log file will show the following error:
[seasonalityProcess][pool-4-thread-5049]Parser log: WARNING: unable to delete previous data before processing, continue processing : com.micromuse.common.datasource.SQLDataSourceException: Exception while executing database operation after trying twice. First exception: 'IS_FROM_OLD_CONFIG_RUN' is not a column in table or VTI 'SEASONALITY.SEASONALITY_RESULTS_DATA'. Second exception: 'IS_FROM_OLD_CONFIG_RUN' is not a column in table or VTI 'SEASONALITY.SEASONALITY_RESULTS_DATA'. This may be caused by an invalid schema or an inaccessible database. Please verify the actual database schema.
Cause
APAR IJ23798 delivered in 7.1.0-TIV-NCI-FP0019 added the field IS_FROM_OLD_CONFIG_RUN to SEASONALITY.SEASONALITY_RESULTS_DATA.
Resolving The Problem
The use of the SE_CLEANUPDATA policy has been discontinued. This script was sometimes required in the past, to clean data left over from old Seasonality runs. This is no longer the case.
The policy will be removed starting with 7.1.0-TIV-NCI-FP0021.
If the policy is run on a FP19 or FP20 system, then run the following SQL on the Derby database to resolve the issue:
ALTER TABLE SEASONALITY.SEASONALITY_RESULTS_DATA ADD IS_FROM_OLD_CONFIG_RUN BOOLEAN DEFAULT false;
ALTER TABLE SEASONALITY.SEASONALITY_RESULTS_DATA ADD IS_FROM_OLD_CONFIG_RUN BOOLEAN DEFAULT false;
Document Location
Worldwide
[{"Line of Business":{"code":"LOB45","label":"Automation"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSSHYH","label":"Tivoli Netcool\/Impact"},"ARM Category":[{"code":"a8m500000008a6mAAA","label":"Impact->NOI Netcool Operations Insights->Seasonality"}],"ARM Case Number":"TS004863440","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1.0"}]
Was this topic helpful?
Document Information
Modified date:
26 February 2021
UID
ibm16417353