SAP DBTech JDBC: [2] (range 3): general error: temp index not exists: [0] No error

[pradeep_gupta]

Hi,

In my CV code, I have written

deals = SELECT quote_key,

                       deal_id,

                       deal_date AS "DEAL_DATE"

                  FROM "BASE_TABLE";

SELECT COUNT (1)

INTO x

FROM :deals;

Earlier it was running fine, but suddenly I have started to face the below error:

SAP DBTech JDBC: [2]: general error:  [2] "_SYS_BIC"."ABC/proc": line 332 col 3 (at pos 12649): [2] (range 3): general error:  [2] "_SYS_BIC"."XYZ/proc": line 87 col 3 (at pos 3631): [2] (range 3): general error: temp index not exists:  [0] No error (please check lines: 332)

After commenting out the below section, it runs fine.

SELECT COUNT (1)

INTO x

FROM :deals;

Not sure what what the issue is.

Any pointers on this would be appreciated.

Thanks,

Pradeep

[pradeep_gupta]

Hi All,

Request your expert advices on this.

Just to note:

1. The count(1) has been written to force materialize the :deals local table.
2. Also recently the HANA DB was upgraded to SP11

Thanks,

Pradeep