INSERT smt Limit?

[Former Member]

Hello,

We have this code

      INSERT zrictctgte FROM TABLE gt_ctg.

But cx_sy_open_sql_db exception is being throwed only when gt_ctg has a big quantity on records, i mean more than 1000,

if gt_cgt is smaller ie, 150 records, the stm works perfect, does anybody know why is that? i could loop on gt_ctg and insert a work area instead, but i want to know if there is a reason for this.

10nks in advance

Gabriel P-.

[ThomasZloch]

Is there also a short dump in ST22? What does the section "error analysis" say?

Thomas

[Former Member]

Hello Tomas,

The program is handling the exception so I dont have the st22 info....any more ideas??

thanks

gabriel

[ThomasZloch]

Any info in the system log SM21?

Try to implement block processing, inserting only n records at a time, as there might be some sort of memory, roll area, redo buffer or whatever problem.

Thomas

[Former Member]

Try Changing the Size category of the database table. Give it a bigger number. It can be done in Technical Settings of the table.

[Former Member]

Hello,

The category size is 6, which is pretty big...thanks anyways!

Gabriel

[Former Member]

I will code as I said at the begining. with a loop and inserting the work area.