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.