SAP Knowledge Base Article - Preview

2444565 - Error 2747 is raised on Procedure sp_sysmon_appmgmt when running sp_sysmon command - SAP ASE

Symptom

You run sp_sysmon command to display performance information of SAP ASE server, but error 2747 is raised.

Msg 2747, Level 16, State 1:
Server 'SERVER', Procedure 'sp_sysmon_appmgmt', Line 241:
Incorrect position specifier in format string of PRINT command.
(1 row affected)

Check the script of creating sp_sysmon_appmgmt procedure:
232                        select @rptline = "    Engine " + convert(char(3),@i) +
233                                        space(16) +
234                                        str(@tmp_int / (@NumElapsedMs / 1000.0),12,1)
235                                        + space(2) +
236                                        str(@tmp_int / convert(real, @NumXacts),12,1)
237                                        + space(1) +
238                                        str(@tmp_int, 11) + space(5) +
239                                        str(100.0 * @tmp_int / @tmp_total,5,1)
240                                        + @psign
241                        print @rptline       <<< here


Read more...

Environment

SAP Adaptive Server Enterprise 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

Error 2747, Msg 2747, sp_sysmon_appmgmt, sp_sysmon, print , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.