Runtime error:SQL error "SQL code: 340" occurred while accessing table "QALS".

ramesh_mahankali — Thu, 21 Jul 2016 20:46:48 GMT

Hi Experts,

Recently we have upgraded to to HANA DB version 1.0 SP11 revision 110. Now I am getting runtime error on one of our custom code for QALS table.

Below are the details:

The same query used work fine in old DB.

Can you please help me understand what could be the reason for this error?

Thanks in advance,

Ramesh

Re: Runtime error:SQL error "SQL code: 340" occurred while accessing table "QALS".

ramesh_mahankali — Mon, 25 Jul 2016 14:46:55 GMT

Hi Experts,

On further analysis we found that following SQL statement is failing when LR_OWN internal table is empty.


SELECT   charg
              matnr
              werk
              prueflos
              stat35
              objnr
              enstehdat
              entstezeit
         APPENDING TABLE fp_i_batch_ud
         FROM qals
          FOR ALL ENTRIES IN li_shadow
        WHERE charg = li_shadow-charg
          AND matnr = li_shadow-matnr
          AND ( werk  = li_shadow-werks
 OR werk IN lr_own ).

But the same query does not fail in old DB even LR_OWN is empty. If anyone has faced similar issue or know any limitations of HANA DB in cases like these, please share.

Thanks,

Ramesh

topic Re: Runtime error:SQL error "SQL code: 340" occurred while accessing table "QALS". in Application Development and Automation Discussions

Runtime error:SQL error "SQL code: 340" occurred while accessing table "QALS".

Re: Runtime error:SQL error "SQL code: 340" occurred while accessing table "QALS".