Migrate objects from BOE 4.1 to BOE 4.2 new install

system · February 8, 2017, 2:08pm

Hi all,

SO here what I am needing todo. our current production enviroment is SAP BOE 4.1 sp4. We have a new system BOE 4.2sp3. We are needing to migrate access Levels, Groups, Folders, Reports, and Users ( Enterprise Users) and the users favorite folders content. In the old days we could use the Upgrade management tool.

Problem is UMT that comes with 4.2 is only designed to upgrade from 3.x to 4.2.

I have attempts to use promotion manager but there are thousands of objects and when you get more than a couple hundred object in it it tends to freeze. also when more than a couple dozen objects getting security to move is hard.

My question is the an easier way to migrate the Users Objects and Security from one system to the other. If I have to use the Promotion manager this is gong o take weeks to move everything and I think there will be things missed and Current Prod is a Live system.

BOE 4.1 sp4 Win 2008 r2 Orcle 12c
BOE 4.2 sp3 Win 2012r2 MSSQL 2014

JonnySpec

JonnySpec (BOB member since 2008-08-01)

system · February 8, 2017, 3:26pm

I am using Promotion manger as we have only a mid size BI environment.

I am only moving around 50+ reports at a time. Also I am not migrating security to 4.2 SP03 environment, redefining it there.

shekar25 (BOB member since 2004-05-11)

system · February 8, 2017, 5:10pm

hmm 50+ at a time would take forever, heck I’ve already moved over 1300+ user groups over. Wish the Upgrade management Tool would work for moving between 4.1 to 4.2.

JonnySpec (BOB member since 2008-08-01)

system · February 8, 2017, 5:51pm

Try increasing the memory on your APS. This will allow you to migrate more objects in one job. I’ve gone through this recently, and it worked fine, but I couldn’t do it all in one job. It took dozens of jobs to get it all done.

MichaelWelter (BOB member since 2002-08-08)

system · February 8, 2017, 7:35pm

In the Idea page there is a post that mentions BI4.1 content can be exported to BIAR and then imported into a 4.2 system if the -internal_use_only_enablebiartolivetesting switch is used. I haven’t tried it myself, but it might help you.

joepeters (BOB member since 2002-08-29)

system · February 9, 2017, 9:59am

Does the no_version_check(what ever the exact format is) switch still work on UMT in BO4.2?

I know it isn’t supported officially, but I never hit any problems with it between 4.x systems

David

nwdb (BOB member since 2005-10-26)

system · February 9, 2017, 12:45pm

No, it doesn’t. See the link I posted above.

joepeters (BOB member since 2002-08-29)

system · February 9, 2017, 2:34pm

Sorry joepeters I didn’t go into the link. Mea culpa.

I really do despair of the repeated failures by SAP to understand how their product is used, and their stubbornness in not accepting that the BO community might actually know more sometimes

David

nwdb (BOB member since 2005-10-26)

system · February 9, 2017, 2:39pm

Yes, that’s one area that has been significantly worse off since Business Objects was independent. The feedback loop isn’t what it used to be.

Connection Overrides come to mind…

joepeters (BOB member since 2002-08-29)

system · February 10, 2017, 7:31am

https://bobj-board.org/t/241814

RikDeclercq (BOB member since 2006-09-28)

system · February 23, 2017, 9:12am

Did you try to use LCM CLI tool? Perhaps this could help you to migrate your contents in a better way.

Check this out:

https://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=376570501

~SPY

Swapnil_Yavalkar (BOB member since 2012-03-15)

system · July 7, 2017, 2:15pm

We are currently on 4.1 SP5 moving to 4.2 SP3. After discussion with our consultant, here is the approach we are using.

Installing 4.1 SP5 on the new hardware.
Using the internaluseonly_no_version_check switch in the UMT to move content.
Upgrading to 4.2 SP3 after the move.

Have no idea what we will do next time.

fsalamon (BOB member since 2005-10-05)

system · July 18, 2017, 2:13pm

OK I notice you will be moving to a new Server…So I am in a similar boat. 4.1 SP6 on 2008 R2 Servers and going to 4.2 SP4 on 2012 R2 servers. We are moving to SP4 for the SQL Server 2016 compatibility.

So here is our plan.

Update current Server to 4.1 SP9 This allows us to move the CMS and Audit DB’s to the new 2016 SQL Server.
We install 4.1 SP9 onto the new 2012 server in Expanded mode which adds the new server to the cluster.
We remove the 2008 server(s) from the Cluster and place the new server in control of the cluster.
Install the 4.2 SP4 Upgrade on the 2012 Server

It is helping us as far as not needing to make a ton of BIAR files and we rely more on Server snapshots and CMS/Audit Backups…Currently we have just added our severs to the cluster and are testing and optimizing the settings.

It sounds like you have already installed 4.2 on your new machine…So this may not help you much… Sorry if that is the case…

PETE314 (BOB member since 2017-03-13)

system · November 7, 2017, 11:01am

You can have a look to Version Manager if you want to avoid headache each time you upgrade.

EBIEXPERTS (BOB member since 2008-09-05)