topic INSERT smt Limit? in Application Development and Automation Discussions

INSERT smt Limit?

Former Member — Wed, 01 Jul 2009 14:44:06 GMT

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-.

Re: INSERT smt Limit?

ThomasZloch — Wed, 01 Jul 2009 15:01:53 GMT

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

Thomas

Re: INSERT smt Limit?

Former Member — Wed, 01 Jul 2009 15:03:29 GMT

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

Re: INSERT smt Limit?

Former Member — Wed, 01 Jul 2009 15:03:38 GMT

Hello Tomas,

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

thanks

gabriel

Re: INSERT smt Limit?

Former Member — Wed, 01 Jul 2009 15:08:04 GMT

Hello,

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

Gabriel

Re: INSERT smt Limit?

ThomasZloch — Wed, 01 Jul 2009 15:18:08 GMT

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

Re: INSERT smt Limit?

Former Member — Wed, 01 Jul 2009 15:46:17 GMT

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