ODS很简单也很容易坏,特别是在做Delta过程中,往往因为错误地删除某些Request导致新导入的Request无法激活。
前辈遗留了一支程序
REPORT ZDMDELTAREPAIR .
parameters: l_ods type RSDODSOBJECT.
data l_count type sytabix.
select count( distinct PARTID ) from rsdmdelta into l_count
where icname = l_ods.
if l_count > 0.
write 'Status are still set. Delta can not be repaired (note 578150)'.
exit.
endif.
data l_max type RSSID.
select max( requid ) into l_max from rsbodslog
where odsobject = l_ods.
update rsbodslogstate set active = l_max
PROCESSED_ALL = 0
PROCESSED_ONE = 0
where odsobject = l_ods.
----------------------
说实在的程序本身没有为我解决什么问题,倒是这里的表 rsbodslogstate 给了我不少帮助,好几次我直接手工去改动这里的数字,问题还真的解决了。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/554557/viewspace-630780/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/554557/viewspace-630780/