调整Hyperion Planning 作业控制台日志保留期限

Hyperion Planning默认仅保留4天作业日志,要查看更早日志需修改JOB_STATUS_MAX_AGE参数。该参数值以毫秒计,例如,保留15天日志应设为1296000000。修改步骤包括在应用程序属性中添加参数并重启服务。过期日志会从HSP_JOB_STATUS转移到HSP_HISTORICAL_JOB_STATUS表。详情可参考相关文档链接。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

默认情况下,作业控制台只保留最近4天的作业日志。

如果需要查看15天前的日志,就没法查看了,可以通过调整 JOB_STATUS_MAX_AGE来更改这个设置。

JOB_STATUS_MAX_AGE参数值的单位是毫秒,如果想保留最近15天的,则需要设置为15*24*60*60*1000=1296000000

具体修改方法如下:

打开需要修改的planning应用,然后点击"管理"-“应用程序”-“属性”

然后在“应用程序属性”中添加 JOB_STATUS_MAX_AGE参数,值为1296000000


然后保存,并重启应用服务即可。


扩展知识:

默认情况下,当日志过期之后,日志记录会被从HSP_JOB_STATUS表中删除,并移入HSP_HISTORICAL_JOB_STATUS表中。

我们可以通过如下sql来查询

select HSP_HISTORICAL_JOB_STATUS.JOB_ID,
HSP_HISTORICAL_JOB_STATUS.PARENT_JOB_ID,
HSP_HISTORICAL_JOB_STATUS.JOB_NAME,
HSP_HISTORICAL_JOB_STATUS.JOB_TYPE,
HSP_Object.OBJECT_NAME,
HSP_HISTORICAL_JOB_STATUS.START_TIME,
HSP_HISTORICAL_JOB_STATUS.END_TIME,
HSP_HISTORICAL_JOB_STATUS.RUN_STATUS,
HSP_HISTORICAL_JOB_STATUS.DETAILS,
HSP_HISTORICAL_JOB_STATUS.ATTRIBUTE_1,
HSP_HISTORICAL_JOB_STATUS.ATTRIBUTE_2,
HSP_HISTORICAL_JOB_STATUS.PARAMETERS,
HSP_HISTORICAL_JOB_STATUS.JOB_SCHEDULER_NAME

from HSP_HISTORICAL_JOB_STATUS
INNER JOIN HSP_Object
ON HSP_Object.OBJECT_ID=HSP_HISTORICAL_JOB_STATUS.USER_ID

ORDER BYHSP_HISTORICAL_JOB_STATUS.END_TIME



参考链接:https://docs.oracle.com/cd/E57185_01/AGOHP/ch02s08s08.html

其他参数说明:https://docs.oracle.com/cd/E57185_01/AGOHP/properts.html



第 1 章. 使用 Planning ................................................................................................................... 19 关于 Planning .............................................................................................................................. 19 Planning 功能 .............................................................................................................................. 19 关于新增功能的重要信息 ............................................................................................................... 20 Smart View .................................................................................................................................. 20 Planning Web 客户端 ................................................................................................................... 20 Performance Management Architect ............................................................................................. 20 EPM Workspace .......................................................................................................................... 20 生命周期管理 ............................................................................................................................... 21 Essbase ...................................................................................................................................... 21 Financial Reporting ...................................................................................................................... 21 Business Rules ............................................................................................................................ 22 Web Analysis ............................................................................................................................... 22 预测性规划 .................................................................................................................................. 22 第三方软件的用户许可授权 ........................................................................................................... 22 Planning 使用方案 ........................................................................................................................ 22 部署 .................................................................................................................................... 23 设置应用程序 ....................................................................................................................... 23 构建规划 .............................................................................................................................. 27 启动业务规则 ....................................................................................................................... 27 启动预算审核流程 ................................................................................................................. 28 规划后活动 .......................................................................................................................... 29 第 2 章. Planning 入门 ................................................................................................................... 31 关于 Planning 应用程序 ................................................................................................................ 31 启动 Essbase .............................................................................................................................. 32 使用 Essbase 时的注意事项 ......................................................................................................... 32 了解 Planning 表单中的隐式共享 ................................................................................................... 33 连接到 Essbase 的多个实例 ......................................................................................................... 33 启动关系数据库 ............................................................................................................................ 34 优化 SQL 关系数据库 ................................................................................................................... 34
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值