Delay in XML message Processing in SRM

[baskaran_k2]

Hi,

We are using standard interface 'PurchaseOrderRequest_In'

from 'http://sap.com/xi/SRM/SupplierEnablement/Global' from SCV 'SRM

SERVER 7.01' for our SUS application.

In that, we facing issue during XML message processing in SRM system.

Its taking more than 30 mins inorder to process the message.

Before upgrade it took only max. of 2 to 3 mins to complete flow of

message processing. But now its taking more than 30 mins to process.

All the queues are registered properly as per note # 1118297.

During this scheduling period, I could find some of the DIA work

process are running for the report ZCL_IM_BBP_SAPXML1_IN_BADI====CP and

SAPLBBP_PD. I have attached the screen shot of the document for your

reference.

We have just upgraded from SRM 4.0 to SRM 7.0 EHP1. After upgrade we

have applied PI content for SRM 7.01. We are finding long processing

time for PO create/change message in SUS.

Anyone can help me on this.

Regards,

Baskaran

[former_member209705]

Hi,

Do you find any messages in SM58?

Regards,

Ravi shankar

[baskaran_k2]

Hi Ravi,

No entries on SM58. In SMQ2, one queue is in state 'Running'.

I think, its because of report ZCL_IM_BBP_SAPXML1_IN_BADI====CP and SAPLBBP_PD. These are the entries present in SM50 and occupy DIA WP for long time.

I'm not sure why these program running long time. Could you please advice on this.

This issue occured only for PO create and changes messages. But PO Confirmation messages are flowing normally from SRM.

Regards,

Baskaran K

[former_member209705]

Hi,

I looks like a program error, please take a look at SAP Note 1553107.

It might help you.

Regards,

Ravi shankar

[baskaran_k2]

HI Ravi,

Sorry for the delay.

SAP Note 1553107 already applied in our system.

We dubuged the proxy and found that the delay is while reading the table 'BBP_PDVIEW_LIST'.

This table used in 2 or 3 places to read different values. Do you have any idea, why this table taking time to return the values.

Regards,

Baskaran K

[former_member209705]

Hi ,

I hope [852365|https://websmp230.sap-ag.de/sap%28bD1lbiZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=852365] should shed some light.

Regards,

Ravi Shankar

[baskaran_k2]

Hi Ravi,

Thanks for your update. SAP note 852365 deals with custom index creation for field REF_OBJECT_ID.

Indes for this field is delievered as SAP standard content (ROI) as part of SRM 7.0 EHP1 (SRM_SERVER 701).

And I found one more SAP note (Note 925814 - Accesses to bbp_pdview_list take a very long time). It saying that this is because of program error. But this note applicable till SRM_SERVER 700. Since we are in higher level, this note will not be applicable.

One more thing, this system is copied from Production and upgraded to SRM 7.0. This system contains lots of data in the table BBP_PDVIEW_LIST. Will it affect the performance of the data processing?

Could you please advise on this.

Regards,

Baskaran K

Edited by: Baskarank85 on Aug 8, 2011 3:39 PM

[baskaran_k2]

Hi,

One more update, we have found one forum regrding this issue,

[|]

********************************

when copying production system to development, we usually have a lot of data on a server that was not sized for this volume.

So the performance is degraded, and you don't have the same behavior between prod & dev system.

That's quite normal and should be avoided (except if your dev server is sized to support it), otherwise you penalize your dev environment.

You can try to optimize your dev system:

- compute statistics (DB20) for tables used in this view

- if your tables have lots of extends, reorganize your DB table space (ask your DBA)

Last solution: purge the data via archiving to lighten the dev, and gain performance.

*********************************

Could anyone please help me out, how to check whether statistic is available or not for this view. Or how to create Statistics?

Regards,

Baskaran K