SAP note 1640759 and schema based procedures

Hi,

I have been working for several days with a schema-based procedure.

create PROCEDURE "Y7CH"."PR_D_REG_ALL"

( IN P_MANDT VARCHAR (3),

IN p_bukrs VARCHAR (4),

IN P_BRANCH VARCHAR (4),

IN P_DATE_FROM VARCHAR (8),

IN P_DATE_TO VARCHAR (8),

OUT P_D_ALL "Y7CH"."TT_D_REG_ALL"

)

language sqlscript reads sql data

with result view CV_PR_D_REG_ALL

as

every time I need to update it, I need to DROP it and then CREATE it again. This was working fine until last friday, when I got the following message:

Could not execute 'create PROCEDURE "Y7CH"."PR_D_REG_ALL" ( IN P_MANDT VARCHAR (3), IN p_bukrs VARCHAR (4), IN ...'

SAP DBTech JDBC: [2048] (at 17): column store error: [2019] failed to save calculation scenario : The following errors occured: Index name conflicts with existing index name (2019)

I look into the notes, and found 1640759, that stands that sometimes, the calculation scenario does not get deleted, which matches perfectly with my error message, and the solution was to run:

drop calculation scenario "_SYS_BIC"."package/VIEW";

so I run two different exmples

drop calculation scenario "_SYS_BIC"."PR_D_REG_ALL"; -- procedure name

drop calculation scenario "_SYS_BIC"."CV_PR_D_REG_ALL"; -- view

But, When I do so, I get the message

SAP DBTech JDBC: [2048]: column store error: fail to drop scenario: [2007] Index does not exist

does the solution works only for package-based calculation views?

is there a table or view that I can check, looking for the existing calculation scenarios, so I can find the correct name?

thanks for the help

Mauricio