abap TIME_OUT sequencial read of table D010INC

[Former Member]

Dear all,

I installed SAP ECC 6.0 SR3 in Linux SLES10 with Oracle 10.2.0.2.0.

Most of the SAP transactions hangs.

If I check transaction SM50 I find that SAP is making a sequential read of table D010INC.

The programs dumps with timeout in instructions like:

"insert report repname from report. "

It seams that the generation of programs, like the first time we run transaction SE16 for a table, atempts to add lines to table D010INC and generate a timeout.

Help needed, answer will be rewarded

Jorge

[markus_doehr2 · Accepted solution]

Try the following:

- run transaction SGEN for all objects in the system

- after that is finished, create optimizer statistics with brtools

- restart the instance (to clear the fragmented buffers)

This will avoid producing deadlocks and/or long wait times on tables.

Markus

[Former Member · Accepted solution]

Hi Makus,

thank you very much for your quick an high quality answer.

I believe is the correct answer for most of the cases.

I found out later that the table D010INC grows when we are generating (or compiliing) the ABAP program, for example, with transaction SGEN.

The system hanged when was executing SGEN, it was necessary to make a hard reboot, so I believe D010INC and the corresponding indexes are corrupted.

I made a backup of table D010INC with sql statment:

> create table d010inc_backup as select * from d010inc;

I deleted D010INC contents and activate and adjust database indexes 0 and 1.

I hope that D010INC will be rebuild by the system with the future program generations.

Many thanks

Jorge

[markus_doehr2 · Accepted solution]

Sounds ok - although now you don´t know the real root cause of the error.

Markus

[Former Member · Accepted solution]

I have a similar problem.

Following query returned the following results

SQL> select count(*) from SAPSR3.D010INC;

COUNT(*)

-

---

16084840

I have already executed SGEN, it took more than 20 hours to complete, but completed successfully.

Shall I "create optimizer statistics with brtools" or increase timeout duration ?

I have restarted the instance many num of times.

Kindly refer

for details

Thanks in advance

Ruhi