SAP Fiori performance lowered by REPOSRC sequential read

[Former Member]

Hi,

We have installed SAP Fiori Purchase Order application on top of ERP EHP6 on a embedded NW Gateway inside ERP

Since we start the Fiori Launchpad, the report /IWBEP/CL_MGW_ABS_MODEL========CP triggers many SQL sentences to

REPOSRC table with sequential read which takes a long processing time. When we select a Fiori Application, the

system performance is worst because those reports.

We have followed the instructions given in notes/documents:

1889090 - SYB: Activating smartform is taking too much time - TRDIR

1749935 - SYB Configuration Guide for SAP ASE 15.7

DBA Cockpit: Automatic Table Maintenance for SAP Sybase Adaptative Server

The table's statistics are updated.

We have Sybase Ase 15.7.0.101 on NW 7.31/Windows Server.

How can we solve this issue?

Thanks in advance.

[Wolfgang_Mayer · Accepted solution]

Hi Rodrigo, Masayuki,

did you find a solution for this?

W're facing the same issue. We're on IW_BEP 200 SP8. The SELECT on REPOSRC is performed in /IWBEP/CL_MGW_ABS_MODEL->GET_LAST_MODIFIED where the following statement is executed (line 30):

    SELECT cdat udat utime FROM reposrc
    INTO TABLE lt_change_info
    WHERE progname LIKE lv_program_name
      AND r3state  =    'A'
    ORDER BY cdat udat utime.

Both fields progname and r3state are key fields, we've got about 4,5 million entries in REPOSRC. The select lasts about 60secs, when you perform the same select in SE16, it lasts < 10 secs.

You can test the issue by using the gateyway client to test a service, e.g. GBAPP_POAPPROVAL.

Regards

Wolfgang

[masa_139 · Accepted solution]

Hi Wolfgang,

Please look at this note.

2023100 - New Metadata not loaded after changes

Regards, Masa

SAP Customer Experience Group - CEG

[Wolfgang_Mayer · Accepted solution]

Hi Masa,

thanks, the note solved the issue!

Regards

Wolfgang

[Former Member · Accepted solution]

Thanks Masa, solved the issue for me too.

[masa_139]

Hi Rodrigo,

What is the support package level for IW_BEP?

Regards, Masa

SAP Customer Experience Group - CEG

[Former Member]

Hi Masa, thank you for your response, the current support package for IW_BEP is 9.

[masa_139]

Hi Rodrigo,

Could you find which OData call is related with this issue?

SAP Fiori LL11 - Consultants should know about OData troubleshooting

Regards, Masa

SAP Customer Experience Group - CEG