topic Re: Long time for generating spool request for smartforms in Application Development and Automation Discussions

Long time for generating spool request for smartforms

rameshkumar_ramasamy2 — Sun, 04 Mar 2012 05:21:51 GMT

Hi,

I'm have designed a smartforms for printing a Receipt form. It takes about 1 minute for generating spool request after pressing the PRINT button in PRODUCTION Server only.

The Code i used is below

CALL FUNCTION lv_fname
  EXPORTING
      p_belnr                    = p_belnr
      p_bukrs                    = p_bukrs
      p_gjahr                    = p_gjahr
 EXCEPTIONS
   formatting_error           = 1
   internal_error             = 2
   send_error                 = 3
   user_canceled              = 4
   OTHERS                     = 5
            .
  IF sy-subrc <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
  ENDIF.

Please help me out to sort this issue.

Thanks,

Ramesh

Edited by: Rameshkumar Raamasamy on Mar 4, 2012 6:21 AM

Re: Long time for generating spool request for smartforms

Former Member — Sun, 04 Mar 2012 06:21:56 GMT

Try a performance analysis with ST01/ST05 to see the gap in your execution.

For reference

http://help.sap.com/saphelp_nw04/helpdata/en/d1/801f7c454211d189710000e8322d00/content.htm

Regards,

Felipe

Re: Long time for generating spool request for smartforms

Clemenss — Sun, 04 Mar 2012 15:20:58 GMT

Hi Rameshkumar,

you may look at the code sections of your smartform: If you have a lot more data in production than you have in development, it is especially important to use a fully specified primary key for any SELECTs.

You may also ask your basis people to check if any performance warnings have been recorded with database system. This happens quite frequently that growing database tables cause problems when table spaces are not properly assigned or table sizes are not maintained adequately.

Regards

Clemens

Re: Long time for generating spool request for smartforms

JJosh — Mon, 05 Mar 2012 09:21:43 GMT

HI,

Check whether your spool is getting appended to any existing spools

Re: Long time for generating spool request for smartforms

rameshkumar_ramasamy2 — Mon, 05 Mar 2012 09:28:50 GMT

Hi all,

Thanks for ur reply..

First i checked with ST05, it takes very long time to fetch data from TST03 when compared with Quality.

If there is any performance issue in my smartforms, how i will get the Print preview quick? But while printing only it takes time. 😞

I asked my basis to check this issue.

Re: Long time for generating spool request for smartforms

alex_campbell — Tue, 06 Mar 2012 18:04:10 GMT

I had a similar problem. Some of the smartforms in our company used graphics as watermarks. These graphics were 8.5"x11" (Letter sized), color, and not compressed. In other words VERY BIG. Every time the smartform was printed, the entire graphic was loaded into table TST03, meaning that the table got very large. This not only slowed down the printing of this smartform, but the printing of every other smartform in the system as well.

We solved this issue by loading a new watermark graphic into SE78 at a low DPI (100) with the Compression checkbox checked. We updated our existing smartforms to use the compressed watermark.