RSDRI_INFOPROV_READ

[former_member253923]

All;

I am using RSDRI_INFOPROV_READ function module to get the cube details. I am getting data in chunks of package size of 10 and calling the function module in a WHILE_ENDWHILE till end of data is reached. Total of 18 records should be returned.

First run gives 10 records. but the second run fails with an exception. I tried debugging but it gives error from CALL FUNTION "C_.. " which cannot be debugged further.

Any pointers to this would be greatly appreciated.

Thanks!!

Edited by: Srivathsan Padmanabhan on Jun 12, 2009 4:59 PM

[Former Member]

Hi Srivathsan - are you correctly passing/retrieving the following parameters:

c_first_call (X only for the first call set outside of WHILE)

i_save_in_table = space

i_save_in_file = space

Also the error is truncated - can you provide the full error?

Andy

[former_member253923]

Andy,

The first call is set as "X" outside the while and the save parameters are set as space only. The error comes from the method FETCH_DATA_ADBC in class CL_RSDRS_SQL_QUERY in line number 51

l_lines = p_r_result->next_package( i_pkgsize ).

The exact source of error comes from the call CALL 'C_DB_FUNCTION' in the "next package method". There is an exception raised and the message isnt clear. This is the message being thrown. unknown error in dbsl or sql interface. Also, sets the Internal Error to "9" and Invalid Cursor to "X".

Any help on this would be greatly appreciated!!

Thanks for looking into this!!

Edited by: Srivathsan Padmanabhan on Jun 15, 2009 12:55 PM

[former_member253923]

There was a "COMMIT WORK" which i was doing in the loop. After i removed that, data is fetched properly.