将EBS主页的worklist错误告警删除
来源:互联网 发布:三星ml1641清零软件 编辑:程序博客网 时间:2024/06/06 09:36
参考:How To Remove Error Notifications From The Worklist (Doc ID 357904.1)
1.1. Use one of the error notifications to get an item_type from the following select:
select message_type from wf_notifications where notification_id = <NID>;
select message_type from applsys.wf_notifications where notification_id=93885;
--WFERROR
2. Use the following script to abort all error workflows that has currently notifications with status OPEN:
Declare
cursor c_item_keys is
select act.item_type , act.item_key
from wf_item_activity_statuses act
,wf_notifications n
,wf_items itm
where act.notification_id = n.notification_id
and act.item_type = itm.item_type
and act.item_key = itm.item_key
and itm.end_date is null
and act.item_type = '<message_type>' -- value returned in step 1
and act.activity_status in ('ERROR','NOTIFIED')
and n.status = 'OPEN'
and act.assigned_user = 'SYSADMIN';
counter number;
Begin
counter := 1 ;
for item in c_item_keys loop
wf_engine.abortprocess(item.item_type,item.item_key);
counter := counter + 1 ;
if counter > 1000 then
counter := 1 ;
commit;
end if;
end loop;
commit;
End;
NOTE:
- Replace the <message_type> by the message_type value returned in step 1.
- This script will remove error notifications from sysadmin. Replace sysadmin by the end user needed or comment the line to run the script for all end users.
3. Run the concurrent request: "Purge Obsolete Workflow Runtime Data".
NOTE:
- In some cases the error workflow may have a child workflow, for example, POERROR workflow may fail to send a notification to a certain user, so that it will generate a WFERROR notification to sysadmin. In that case one has to run the script in step 2 first for WFERROR workflow.
An item_key is not required to run the Purge Obsolete Workflow Runtime Data request. Running it without use of an item_key, all eligible data will be purged.
0 0
- 将EBS主页的worklist错误告警删除
- EBS登陆后的第一页面恢复成默认都显示WorkList
- EBS R12.1.3 主页调整(恢复R12.1.1的样子)
- 删除实体主页上的‘新建’按钮
- FLEX实践:自定义弹出窗口与主页面的交互(仿造EBS的LOV窗口)
- 将自己的项目主页设为tomcat的默认主页方法
- 删除主页卫士流氓软件
- Sitesled.com的主页又被删除了,麻烦!
- 关于一些强制将主页设置为XXX的解决方法~
- 将自己的主页地址设置为OpenID
- 是否将网址设置为主页 的代码实现?
- 将tomcat欢迎页面修改为自己项目的主页
- 将tomcat欢迎页面修改为自己项目的主页
- 一个告警的算法
- 告警的处理
- 使用dcmtk进行worklist服务的测试方法
- 使用dcmtk进行worklist服务的测试方法
- 用HL7创建含多个code item的modality worklist
- Linux JDK安装与配置
- 根据CLID查找缺少的组件
- IOS::流状态
- 万年历设计
- 【iOS开发-43】万能的transform注意事项,以及viewWithTag以及.png后缀可以省略的一些知识
- 将EBS主页的worklist错误告警删除
- 大学规划
- C++设计模式-Adapter适配器模式
- SQLite_SQL语句教程
- C++编程趣题1 在1~9中间填符号使运算结果等于100
- 【Algorithm】小小递归函数的执行过程
- deep learning Softmax分类器(L-BFGS,CG,SD)
- 记录: hack marytts
- OACORE内存设定