Symptoms:
User tried viewing jobs which ran 15 days ago but he was not able to view it.
Analysis :
When we checked the table HSP_JOBSTATUS it did not have the data in its table itself so it was not a functionality issue but something to do with the database or behaviour of planning application itself.
Cause:
For all other parameters read the doc id Hyperion Planning System Properties (Doc ID 1327171.1) from Knowledge base.
User tried viewing jobs which ran 15 days ago but he was not able to view it.
Analysis :
When we checked the table HSP_JOBSTATUS it did not have the data in its table itself so it was not a functionality issue but something to do with the database or behaviour of planning application itself.
Cause:
Hyperion Planning application by
default stores only 4 days of jobs with status “COMPLETED”. It purges the DB
table HSP_JOBSTATUS with anything older than 4 days and job_status=COMPLETED.
Solution:
In application , manage properties
Add a parameter JOB_STATUS_MAX_AGE for 15 days (1296000000 milisec) so it will store data
for 15 days in properties of the application.
For all other parameters read the doc id Hyperion Planning System Properties (Doc ID 1327171.1) from Knowledge base.
0 comments:
Post a Comment