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
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:  (at 17): column store error:  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: : column store error: fail to drop scenario:  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