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.
Document Location
Worldwide
[{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSSHYH","label":"Tivoli Netcool\/Impact"},"ARM Category":[{"code":"a8m500000008a6mAAA","label":"Impact-\u003ENOI Netcool Operations Insights-\u003ESeasonality"}],"ARM Case Number":"TS004863440","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1.0"}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
Modified date:
08 May 2025
UID
ibm16417353