SQL error 1732 when accessing table "PROGDIR".

[Former Member]

Hello Colleagues,

I am in the process to install the latest support packages
via SAINT on SPG  system.

Now during the DD activation I get the dumps

Category             
ABAP Programming Error

Runtime
Errors       
COMPUTE_INT_PLUS_OVERFLOW

CX_SY_ARITHMETIC_OVERFLOW

ABAP
Program           RADIXCHK

I found a note that I need to change SDB1FHDB manually and
change the limit-secindcnt to another value.

Now when I try to do this and save the change I get another
dump:

Category             
Installation Errors

Runtime
Errors         DBIF_RSQL_SQL_ERROR

CX_SY_OPEN_SQL_DB

And it does not allow me to save the program.

Kindly suggest how to solve this issue.

Regards,

Aruna

[premsukh_bishnoi · Accepted solution]

Hi,

Please reset Oracle parameter _simple_view_merging as it is not needed
at your system.

SQL>alter system reset "_simple_view_merging";

SAP note: 1431798 - Oracle 11.2.0: Database Parameter Settings

Regards, Prem

[Former Member]

Hello,

please post your environment (e.g. DB vendor, release) and whole content of the dump.

If you are using Oracle, then following SAP note might be of your interest: 1922481 - ORA-01732: data manipulation operation not legal on this view

[Former Member]

Hi Aruna,

After changing value try taking OS restart and start again.

Regards

Pavan Nagathan