cancel
Showing results for 
Search instead for 
Did you mean: 

smartform activation slow on dev system

Former Member
0 Kudos

Hi expert,

We are facing issue on development system when ABAPer activating smartforms (take 2-3 min) also facing slowness issue when functional generate reports.

Below are the HW details of sap system

OS -- AIX 6.1

Database -- Oracle 11.2.0.3

Kernel -- 720 patch 401

RAM (physical) -- 16gb

Below are the tuning details as per ST02 and ST06

ST06

ST02

Profile parameter details

As per above details it is found that swap shows in RED (same in previous 10days history)

Kindly advice for what changes need to do in profile parameter to resolve issue.

Regards,

Devendra

Accepted Solutions (1)

Accepted Solutions (1)

Sriram2009
Active Contributor
0 Kudos

Hi Devendra

1. If possible enable the transaction ST12 trace check the over all ABAP & DB usage?

2. As already pointed by Sunil SM50 or SM66 any activate going in the system?

3. Could you refer the SAP KBA for smart form slowness

1897137 - Smart Form activation takes a long time

BR

SS

Former Member
0 Kudos

Hi Sriram,

As per note 1897137 I update databse statistics. but still issue not resolved

Sriram2009
Active Contributor
0 Kudos

Hi

At the time of smartform activation what is the action going on in transaction SM66 or SM50 ? or if possible share the snapshot?

BR

SS

Answers (4)

Answers (4)

Former Member
0 Kudos

HI,

After updating database statistics smartforms check time reduced from 3 min to 1 min.

As ABAPer found that there program issue which they create. Issue resolved after perform tuning of that abap program.

Now smartforms check time takes 10 to 15 sec max

Thanks All

Devendra

former_member185954
Active Contributor
0 Kudos

Great to know, however in any case your abap / program buffer is too low, have it updated.

Former Member
0 Kudos

Hi,

As the ABAPer execute tcode SMARTFORMS and put the form name and click on display.

When he click on check button it takes 2-3 min to open result. As they told it should take max 30 sec.

Why it took much time...any suggestions?

Sriram2009
Active Contributor
0 Kudos

Hi

You can do one more think just enable the abap trace using transaction code ST12 check over all time in ABAP & DB usage where its taking time? if possible you can attach the trace file as zip format.

BR

SS

former_member185954
Active Contributor
0 Kudos

Hello Devendra,

Your abap/buffersize is too small according to me, set it to higher value(double it at least). Adjust the other parameters using sapfpar command at OS level and you should be fine.

You have 16GB memory, surely you can afford to do it.

Regards,

Siddhesh

Former Member
0 Kudos

check in SM50 whats going on while activating the samrtform.

manumohandas82
Active Contributor
0 Kudos

Please post the ST02 ( Base )  screenshot

Thanks ,

Manu