Hi,
I am using method infoprovider_read in my end routine to read data from another infocube. I have copied a standard approach to use this method, so it looks like this:
while (end_of_data <> x).
call method...
..
package_size = 50000
endwhile.
So it reads the data in packages of 50000 and I understand it sets a cursor to get the next 50000 records until end of data has been reached. When I am running a DTP with several data packages it sometimes happens that the DTP ends in a short dump with "invalid cursor" but this does not happen in the method but after a data package has been processed. It seems randomnly to me, because some DTPs run fine and others not.
Does anyone have any idea what to do? I was thinking about using a commit in the endroutine after the method so that the cursor would get released, but I read that it should be avoided to use a commit in a routine.
any help is appreciated.
Thanks,
Tim