SAP Note 1044023 - Repair tool for Note 1014129 ( PARTNO = 9999 )

Component : BW Microsoft SQL Server - Persistent Staging Area

Solution : https://service.sap.com/sap/support/notes/1044023 (SAP Service marketplace login required)

Summary :
SAP Note addresses an issue where deleting requests from the PSA table in MSSQL systems results in error messages DA 093 and RSM 1156 due to a program error. The problem occurs when requests are logged in the overflow partition '9999'. A corrective program, 'RSAR_PSA_CLEANUP_DIRECTORY_MS', is introduced offering enhanced check and repair features compared to its predecessor. The program includes various user-controlled parameters to guide the analysis and potential corrections in PSA tables. SAP NetWeaver 7.0 BI users are recommended to import Support Package 14 for comprehensive fixes.

Key words :
object        = 'rsar'subobject   = 'metadata'ext, analyzing incorrect psa tables, program offers additional check, selected means check mode, selected means repair mode, 0 bi            import support package 14, 'mssql' database systems, persistent staging area, terms process chain, active psa tables

Related Notes :

1150724Consolidated note on the check & repair reports for PSA
1063105Program 'RSAR_PSA_CLEANUP_DIRECTORY /_MS'
1014129