search table error: [2007] Index does not exist

[schfer_christian]

Hello, i created a Calculation View with  SQL_SCRIPT:

table1 = CE_COLUMN_TABLE("MA12"."TABLE9M");

     table2 = CE_AGGREGATION (:table1,[MAX (TIMES) AS "MAXTIME",MIN (TIMES) AS "MINTIME"], [L,S]);

     var_out = CE_PROJECTION(:table2, [MAXTIME, MINTIME, CE_CALC('daysbetween(date("MAXTIME"),date("MINTIME"))',int) as PTIME, L,S]);

deployment works fine and if i open the preview i got this error: "SAP DBTech JDBC: [2048]: column store error: search table error:  [2007] Index does not exist;object=......"

We have HANA on SP04 rev36

thx for your Help

[lbreddemann]

Hi Christian,

please provide the necessary commands to reproduce your issue.

I guessed your table structure and data and wasn't able to reproduce this error in rev. 48.

drop table table9m;

create column table table9m (times datetime, l integer, s integer) ;

insert into table9m values (now(), 1, 1);

insert into table9m values (now(), 2, 1);

insert into table9m values (add_days(now(), -1), 1, 1);

insert into table9m values (add_days(now(), -2), 2, 1);

grant select on table9m to _sys_repo with grant option;

calc view:

"VAR_OUT" as table ("MAXTIME" TIMESTAMP, "MINTIME" TIMESTAMP, "PTIME" INTEGER, "L" INTEGER, "S" INTEGER)

/********* Begin Procedure Script ************/

BEGIN

            table1 = CE_COLUMN_TABLE("LARS"."TABLE9M");

     table2 = CE_AGGREGATION (:table1,[MAX (TIMES) AS "MAXTIME",MIN (TIMES) AS "MINTIME"], [L,S]);

     var_out = CE_PROJECTION(:table2, [MAXTIME, MINTIME,

                        CE_CALC('daysbetween(date("MAXTIME"),date("MINTIME"))',int) as PTIME, L,S]);

END

/********* End Procedure Script ************/

- Lars