Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Unable to execute query report in background processing.

Former Member

‎2012 Oct 24 4:16 PM

0 Likes
1,095

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.

7 REPLIES 7
Read only

Former Member

‎2012 Oct 24 4:45 PM

0 Likes
946

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

REGARDS,

GOLE

Read only

Former Member
In response to Former Member

‎2012 Oct 25 8:02 AM

0 Likes
946

Hi Gole,

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

Read only

Former Member

‎2012 Oct 24 9:02 PM

0 Likes
946

Hi,

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

Regards,

Venu

Read only

Former Member
In response to Former Member

‎2012 Oct 25 8:01 AM

0 Likes
946

Hi, Venu,

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

Read only

Former Member

‎2012 Oct 25 7:50 AM

0 Likes
945

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

Read only

Former Member
In response to Former Member

‎2012 Oct 25 8:00 AM

0 Likes
945

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.

Read only

RaymondGiuseppi
Active Contributor

‎2012 Oct 25 8:12 AM

0 Likes
945

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