topic Re: Unable to execute query report in background processing. in Application Development and Automation Discussions

Unable to execute query report in background processing.

Former Member — Wed, 24 Oct 2012 15:16:50 GMT

Dear all,

I made a report in T-code SQ01 (query).

Because the duration of report execution is very high (about 2 hours) I decided to execute in background processing.

5 minutes after executing report in background processing , I looked at own jobs and saw that the the job has status "Finished". I went to T-code SM37 to check spool and found out that the spool number ___ has red status "Waiting", the status text is "frontend unavailable".

Could you please tell me why this happens?

Best regards,

Linh.

Re: Unable to execute query report in background processing.

Former Member — Wed, 24 Oct 2012 15:45:19 GMT

Frontend unavailable usually pops when you are printing/spooling to a printer from a location where the definition is simply unavailable.

REGARDS,

GOLE

Re: Unable to execute query report in background processing.

Former Member — Wed, 24 Oct 2012 20:02:53 GMT

Hi,

This might be printer settings problem. Check your printer settings first.

Regards,

Venu

Re: Unable to execute query report in background processing.

Former Member — Thu, 25 Oct 2012 06:50:48 GMT

Do you have pop up screen when you executing report in foreground?

Usually pop up doesn't work in background ..Please try to run in foreground with some filter and see if its running fine in foreground.

Regards,

Deepti

Re: Unable to execute query report in background processing.

Former Member — Thu, 25 Oct 2012 07:00:30 GMT

Hi Deepti,

It works well if I execute the report in foreground.

The problem is it takes a lot of time to execute the report, so I want to execute it at night to see results the next morning. That's why I think about background processing.

Re: Unable to execute query report in background processing.

Former Member — Thu, 25 Oct 2012 07:01:35 GMT

Hi, Venu,

It works well in background processing with other transactions. So I think the printer is working right.

Re: Unable to execute query report in background processing.

Former Member — Thu, 25 Oct 2012 07:02:14 GMT

Hi Gole,

I checked the printer. With other T-codes it works well.

Re: Unable to execute query report in background processing.

RaymondGiuseppi — Thu, 25 Oct 2012 07:12:42 GMT

Check you user parameters (SU3) is your default printer a local printer (LOCL or like) ?

...frontend unavailable...

This printer is attached to your gui/windows session, and is not available in background, so when you submit the query change the printer (I don't remember if SQ01 -Execute in background allows to change the printer for the submitted job only)

If you doubt this, call SM37 and find your background job which executed the query, display the (only one) step, and check the print specifications.

Regards,

Raymond