Solution : https://service.sap.com/sap/support/notes/866576 (SAP Service marketplace login required)
Summary :
This SAP Note addresses multiple functional errors in ST-PI related to data collection processes for SQL Server environments. Issues include ABAP runtime errors during native SQL executions, conflicting function module calls, and permission errors impacting DBCC operations. Problems also encompass errors in object existence checks and file access errors in SQL Server directories. The note details scenarios under various SAP releases where the described errors manifest, particularly in operations involving logical function modules and their corresponding physical modules. Recommendations are provided to circumvent or resolve these issues, ensuring alignment with specified SAP release prerequisites and system configurations.
Key words :
terms sdcc sdccn xp_cmdshell error 50001 /sdf/saplri_sqlserver syscomment dbstathmss mss_get_table_size_info sap_get_table_size_info 'syscomments', function module /sdf/mss_perfhist returns abap runtime error bcd_overflow, function module /sdf/mss_perfhist returns abap runtime error call_function_conflict_leng, function module /sdf/mss_dbcc_download returns abap runtime error dbif_dsql2_sql_error, function module /sdf/mss_statement_details delivers cryptic table names, line 604r68 perform rollbackab0 run-time error, function module /sdf/mss_special_info calls function module get_tabstats_msq, function module /sdf/mss_perfhist calls function module mss_select_msqsnap, call returns abap runtime error call_function_conflict_leng, call returns abap runtime error call_function_uc_struct
Related Notes :
| 1266975 | /SDF/MSS_PERFHIST returns CALL_FUNCTION_CONFLICT_LENG |
| 1227499 | /SDF/MSS_DBCC_CHECKDB returns no results |
| 1062622 | FM SQL_MSSQL_ANALYSIS_FAST returns error COMPUTE_BCD_OVERFLO |
| 1008622 | FM /SDF/MSS_PERFHIST returns BCD_OVERFLOW in MSSQL |
| 939870 | Minor changes in MSSQL DB monitor authorization check |
| 934045 | Composite note: SDCCN modules for MS SQL Server 2005 |
| 781680 | SDCC/ SDCCN - Problems with function modules |
| 594508 | Setting up the proxy account for xp_cmdshell |