Skip to Content
0
Former Member
Aug 08, 2013 at 11:38 PM

DBIF_RSQL_INVALID_CURSOR after secodary indexes created

31 Views

Hi Experts,

I have a generic extractor based on View table ( S031 & MARC ). There are few fields are enhanced and populated data using Customer Exit.

It is taking more than 8 hours ( for 44,000 records ) for one plant and two months data ( Full Load ).

Customer exit is looking good with select statements with specific fields and where used conditions.

After doing some analysis, created a secondary Indexes one of the table is used in the select statement.

Now I am getting dump with DBIF_RSQL_INVALID_CURSOR. Attached file is the complete details of dump.

It is running successfully, if I have small number of records like less than 25000 records.

Appreciated your quick response.

Thanks

Ganesh Reddy.

Attachments

S039 Dump.txt.zip (13.4 kB)