Friday, October 1, 2010

T77UU table for structural Authorization

Again we faced the issue, where all the OpCos were getting smoother response times from ESS in portal but only the newer ones (VGS) were not able to get the good response times when the employees checked there salaries /personal info/Bank Info from portal (29 secs) on an average.

First line of investigation was with BASIS Team only where we need to check the response times in Portal but we need WILY access for the same but indeed we checked from our side the CPU/Memory utilization for all application servers and we involved the Proxy Team as well to check the times.

We checked VAdmin Performance Tuning to check the stats but it was somewhere between 8ms -800ms not more than that.

Finally we did the trace of users getting the issue in ST05 (SQL and RFC trace) and sent the same to implementation partner for analysis. SAP also analyzed the same and came to conclusion that the client needs to maintain structural authorization data in table T77UU and T77PR.

This is the second post where structural Authorization again came to forefront in terms of issue resolution

No comments: