Skip to Content
Author's profile photo James Zhang

Wrong result from SQL command editor in DBACOCKPIT

Hi Folks,

Recently we have several customers reported sql aggregation returns wrong result in sql command editor. For example, following sql returns unexpected/wrong result:

select sum(column1) from table1

This is not sql command editor “problem”, but a LIMITATION. For the details, please refer to SAP note 2426293 – SQL command editor: Purpose and limitation.

That is to say business process must not rely on sql command editor.

Technically from certain SP level, we introduced “new” SQL command editor which caues sum() (or maybe other sql functions) is not working as expected, which is the reason why “old” sql command “worked”. So this issue often occurs after basis SP level upgrade.

Best regards,

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.