topic Re: Reg Blocked Export Documents Runtime Error in Application Development and Automation Discussions

Reg Blocked Export Documents Runtime Error

Former Member — Mon, 29 Dec 2008 05:51:09 GMT

Hi..

I am using the transaction '/SAPSLL/BL_DOC_SD_R3' to see blocked export documents.......

Now when i run it for a plant and about 40 thousand sales orders... it is going for a runtime error.....

I need to know for how many records can i run this transaction at one time.. ......

Regards.

Re: Reg Blocked Export Documents Runtime Error

Former Member — Mon, 29 Dec 2008 06:20:14 GMT

I guess, You have executed in foreground, try to execute in background.

Regards

Sasi

Re: Reg Blocked Export Documents Runtime Error

Former Member — Mon, 29 Dec 2008 06:21:49 GMT

Well... my problem is.. i am using the function modules used within this transaction in my report programs....and that also is going for runtime error... so i need to know.. how many records can this transaction process at one time.. in foreground........

Re: Reg Blocked Export Documents Runtime Error

GauthamV — Mon, 29 Dec 2008 06:25:54 GMT

hi,

what kind of error you are getting.

Also check this in that transaction.In menu , goto - selection screen help.

Re: Reg Blocked Export Documents Runtime Error

Former Member — Mon, 29 Dec 2008 06:29:38 GMT

Gautham..

The selection screen stuff did not help....

This is the error which i am getting...


Runtime errors         DBIF_RSQL_INVALID_RSQL
Exception              CX_SY_OPEN_SQL_DB

Possible errors:
 o The maximum size of an SQL statement has been exceeded.
 o The statement contains too many input variables.
 o The space needed for the input data exceeds the available memory.

Re: Reg Blocked Export Documents Runtime Error

GauthamV — Mon, 29 Dec 2008 06:33:23 GMT

Here you have two options.

1. Inform your basis people to increase the memory so that you can execute

data for more records.

2. Try to run that transaction with minimum data and check how much amount

of data you can execute with avilable memory.

Re: Reg Blocked Export Documents Runtime Error

Former Member — Mon, 29 Dec 2008 07:14:16 GMT

Actually, We can't say how may records can be able to display with this program, The options could be

1. Either the basis people can extend the buffer size/any other settings

2. You can change the selection criteria range to minimize the record counts

3. Schedule in background

Regards

Sasi