Tuning for a Large LCM BIAR job

[Former Member]

I am attempting to create a large LCM BIAR job but the job fails towards the end of final creation.

The total job creation time is around 20min and when I go to promote the job, it says failure. I re-executed my workflow this time watching the system resources and the only CPU intensive process was Tomcat 7 averaging around 15-20% CPU and Tomcat memory going to 2.2gb out of 3gb allocated. The LCM APS was around 300MB.

System has 8core xeon with 30GB on a SAP standard Large APS (9) split with LCM being in its own APS @ 750MB.

Any suggestions?

If I can get this job to create successfully then eventually I would like to schedule it daily at night during off-peak system hours.

Thanks!

[Former Member · Accepted solution]

Hi Carter,

How many objects your are trying to include it in the job. Refer the below document?

What is the BO version?

Refer the below notes, they may help you.

1969259 - LCM CLI Master Note - How to promote thousands of objects across BI4 environments ?

1833932 - Adding a large amount of objects to a promotion job is slow and takes a long time to rend...

[Former Member · Accepted solution]

Sorry for the delay. I am on BOBJ 4.1 SP1P1.

I will review those notes.

Thanks!

[Former Member · Accepted solution]

I will work with BASIS to attempt the CLI bat options.

Thanks again!

[Former Member]

Hi,

The recommendation for PM is to have it on it's own environment. That's to say to have a dedicated PM/VM system. One of the reasons is exactly what you are talking about. Tomcat is used for most of the promotion management workflows and can be CPU and memory intensive "robbing" those resources from your users which are trying to run reports, etc.

The other thing is as JRK Prasad mentioned - the LCM CLI tools is usually the recommended way for promoting content, especially if it's 100s or 1000s of objects. The main reason being that if you use PM on the CMC you are likely to encounter timeouts which will affect your promotion. And if you say your job takes around 20 minutes, then it's likely you're reaching those timeouts.

Now the question I have is what are you trying to do? There might be better ways of doing it and/or you might actually be using Promotion Management in a way it was not intended to be used which could cause other issues down the road. (For example, I hope this isn't a "backup" of your environment.)

--

Kind regards,

Patrick Bulteel

[Former Member]

Patrick:

I want to back up valuable daily content that the business uses as well as end-user's My Favorites. LCM BIAR is the fastest way to recover corrupt or deleted content.

We also execute daily and weekly BOBJ environment (servers etc.) backups but it takes too long to recover a couple of pieces of content. With LCM, there is practically no downtime and significantly faster.

Thanks!

[Former Member]

Hi Carter,

Can you explain to me how you restore the corrupted/erased content? Currently any exported LCMBIAR file will restore ALL the files in the LCMBIAR file. This is why I was saying that I hoped this wasn't a "backup" solution for you. Therefore it would overwrite any files that have been modified by a user that are part of your LCMBIAR backup and haven't been deleted or corrupted.

Yes, you could potentially restore it in another system and promote from there the single backup.

You could potentially just do an LCMBIAR file of each file individually, separately, independently of all the others... so if you have 300 files change during the day, you export 300 LCMBIAR files, one for each file... not a practical solution in my eyes.

--

Kind regards,

Patrick Bulteel

[Former Member]

Yes, I am hoping that in the near future we will be able to select individual objects from a LCM job.

As of right now, we might select 50 highly valuable business reports then create LCM jobs for them individually.

Do you recommend a specific solution that would enable for a quick restore point outside of all- encompasing environment server backups?

[Former Member]

Hi Carter,

Yes, you are right, in the future this is possible. I know it's in the works, but I don't know when right now.

I can tell you that unfortunately SAP doesn't have a product that could actually do what you want (and what I think a lot of customers want) out of the box. You have to do quite a bit of fidgeting and configuring to get things close to what you want.

However, I do know we have Partners that have actually created software that will do exactly what you want. That said, it means an extra investment and I don't know what the prices are for this software.

I've seen demos and it looks quite impressive and I wish we "added" something like that to BI. You can restore individual objects and do backups of your entire BI landscape (meaning multiple clusters.)

I'm not sure if I am allowed to actually mention this products by name since that might make our Partners think we prefer one over another or are endorsing one product over another ... But a G...search should return some results.

Sorry about being vague there.

Anyway, I hope that this at least gives you an idea of the issues you could encounter and that there is a very effective solution which might require some additional investment - but depending on the criticality of those reports and your company, it might be worth making.

--

Kind regards,

Patrick Bulteel