BBP_VENDOR_SYNC - Time limit error

[kaus_desh]

Hello All We have schedule the batch job BBP_VENDOR_SYNC to pull new ECC vendors and updates on existing vendor in SRM system we are on Classic scenario with SRM version as 7.13.

Issue is that Job is taking more time more than 2500 sec in production to complete and also after finishing in SLG1 we can see TIME LIMIT EXCEEDED error , and also its observed that no vendor master is got updated in SRM.

Job is schedule with variant  for "FROM LAST UPDATE ".

We have reffered the blog from SDN _ Comon issues

Common Issues handling Organization and Business Partner Administration - Supplier Relationship Mana...

but this also didnt helped much to us.

Kaustubh

[ivy_li]

Hi Kaustubh,

I review the whole story, and suggest you do as follows:
==

The TIME_OUT is caused by the select SQL of table CDHDR due to a large
number of entries.

Please check whether you could reduce the size of tables CDHDR and CDPOS
and CDCLS. You could refer to note 1591251 and 1257133 for more details.

And please check if you can create a secondary index for table CDHDR:
For fields:MANDANT,OBJECTCLAS, UDATE and USERNAME. Please see the note
573864 for the instructions.

==

BR,
Ivy

[Former Member]

Kaustubh,

What is the frequency of the job - is it on a daily basis or ?

Also, could you please post the screen shot of the variant of the program that is being exec.

Br,

Raghu

[kaus_desh]

raghu

batch job is scheduled to run after every hour in system.

Not able to attached screen shot but its same and standard as shown here in below blog first screen.

BBP_VENDOR_SYNC - Supplier Relationship Management - SCN Wiki

[Former Member]

Since the standard variant is resulting in the dump, I can think of two options:

- Create a new variant, to populate current date and subtract one hour from the current time as you are running on an hourly basis and use it for the batch job.

- As a last option you can debug to verify if the RFC connection to the backend system is working as expected and the sync program is able to retrieve the list of vendors which have been changed in the ECC system.

Br,

Raghu

[kaus_desh]

Raghu

Thanks we did some techinical changes and time limit exceeded error is not there , but we are not able to see just ECC created vendors in SRM.

That means program is still not working.

Kaustubh

[Former Member]

Kaustubh,

Could you please provide a screen shot of the settings in SPRO in the following path:

SPRO...> SAP Supplier Relationship Management -> SRM Server -> Technical Basic Settings ->  Settings for Supplier Synchronization -> Information on Automatic Download from

Marketplace -> Define Global Settings

Under this, along with the right root node of PPOMV_BB (Vendor Org. Structure), you should select the checkbox to allow new vendors to be replicated from ECC to SRM. (I do not have access to SRM system, hence I’m unable to provide a screen shot).

Br,

Raghu

[kaus_desh]

Hello Raghu

Please find below screen shot

We know this setting and we have entered the correct org node from PPOMV_BBP for vendor root org.

[Former Member]

Thanks for the screen shot, settings are correct.

Even after this if the new vendors are not getting replicated from ECC, please check the SLG1 logs for any errors in SRM system with object as "BBP_VENDOR_SYNC".

Also, please verify if the number of the new vendors created in ECC system are already used for other business partners in the tables BUT000.

Br,

Raghu

[kaus_desh]

Hello Raghu

I can see no RED or error entries in SLG1 now

If my newly created suppliers are not coming in SRM how can i able to check BUT000 ??

Kaustubh

[Former Member]

Verify if the Vendor number that has been created newly is already in BUT000 table, meaning it has been used before the vendor itself is replicated to your system.

We had this issue during vendor replication and after the analysis, we noticed that the vendor number was already assigned to an organizational element.

Br,

Raghu

[kaus_desh]

No raghu

We dont have vendor number created in ECC at all in SRM BUT000 nor in ECC BUT000.

KD

[Former Member]

Thanks for making all the checks Kaustubh.

As a last resort, please execute BBPGETVD only for the new vendor and if it is successful, the problem should be the SYNC program.

So, please raise an OSS as all the settings to replicate new/modified vendors from ECC are in place and vendor changes are getting replicated to SRM.

Br,

Raghu

[kaus_desh]

Hey Raghu

Thanks but i think OSS is final solution on this issue

BBPGETVD for same vendor is working fine.

Thanks for help 🙂

[Former Member]

Kasutubh,

Please keep us posted about the response from SAP to your OSS for this issue.

Br,

Raghu.

[kaus_desh]

Hello Raghu

Issue is solved - Batchjob user authorisation was not there we added few authorisations and it has working fine now.

[Former Member]

Was the batch user missing SAP_ALL and SAP_NEW profiles ?

Br,

Raghu