月影 Rocky 的笔记

昨天安装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..