分类:
2008-03-25 00:52:47
昨天安装BI 3.5 Business Content 的Addon补丁包,升级前系统自检所有依赖的补丁包都已经安装,结果升到一半显示错误,错误提示是“GETWA_NOT_ASSIGNED”,查了下资料,说要打SAP BW Patch 13补丁(怎么升级前不说清楚!)。
于是下了BW Patch 13的文件下来,发现Saint/Spam被锁住了。提示:“OCS locked by user XXX with transaction SAINT”,并且在SAINT里面不能Reset那个安装任务,无奈,这下SAINT和SPAM都不能用了。
记得sydongsun在他的一片博文中说过如何升级BI Addon(详见这里),里面详细说道如果碰到升级补丁、插件包发生错误后进退两难如何解决,用他的办法,在SE37中运行SPAM_RESET_STATUS,IV_FORCE设置为X,运行后,发现还是提示“OCS locked by user XXX with transaction SAINT”,于是从这个提示入手,Google了一下,终于找到解决方法:
原文如下:
In Se37,Use the function module OCS_RESET_QUEUE -> Single Test
with the parameters
IV_TOOL=SAINT, IV_FORCE=X
用这种方法,终于Reset了所有的OCS队列。
还有人提出另外一种解决方案,如下所示,我没有试过,不知道是否可以,大意就是删掉PAT01、PAT03、PAT10三个表里的和那个Patch相关的数据即可:
We were facing a problem in(Test Server) due to wrongly defined
queu. Basis Patches 32 and 33 were supposed to be applied
separately, but by mistake we defined a queue for Basis 32 to
Basis 41 and HR26 to HR40. Due to this que was stuck in
DDIC_IMPORT phase.
We solved this problem by deleting entries with status ='?' in
PAT01, PAT03 and PAT10 tables.
This way we were able to delete the particular queue and spam was
reset. This can be a last option to solve this problem..