BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

4.0 Upgrade Management Tool - Tips, tricks, Discussion
2 members found this topic helpful
Goto page 1, 2  Next
 
Search this topic... | Search General Discussion... | Search Box
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Author Message
clarence
Forum Associate
Forum Associate



Joined: 18 Nov 2005

Posts: 592
Location: California



PostPosted: Tue Oct 30, 2012 11:36 am 
Post subject: 4.0 Upgrade Management Tool - Tips, tricks, Discussion

I've been working with a couple of 4.0 upgrades lately and found that in many cases the Upgrade Management Tool can introduce some significant challenges. At this point SAP support seems to have very few people on board with any expertise with the tool and the challenges associated with using the tool for an upgrade to 4.0. I've had two messages open for more than a month each and despite numerous escalations can't seem to get in touch with anyone at SAP that can help. I'm starting this thread hoping it can be a centralized location for any tips, tricks, and other discussions related to using the upgrade management tool to upgrade to 4.0.
Back to top
clarence
Forum Associate
Forum Associate



Joined: 18 Nov 2005

Posts: 592
Location: California



PostPosted: Tue Oct 30, 2012 12:06 pm 
Post subject: Re: 4.0 Upgrade Management Tool - Tips, tricks, Discussion

I'll start with one. Apparently when you use the Upgrade Management Tool you need more disk space available to your temp folder than the disk space consumed by the content you intend to move to 4.0 on both the source and target servers. For example, If you intend to perform a complete upgrade and the Filestore on your source server is 10 GB, then you need at least 10 GB free to the temp folder on both the source and target server. Actually, after speaking with several engineers at SAP I heard that it is recommended that there be free disk space available to the temp folder equal to 3x the size of the amount of content that you intend to move. Is this true? I don't have a definitive answer.

Where is the temp folder located? In Windows go to Start -> Run and key in %TEMP% to find out. Most likely it will be located on the C: drive.

So what do you do if you don't have 30 GB free on your C: drive? If you have virtual servers yo can grow the virtual disk. If not, you can change the location of the temp folder to a different drive. Do this in the Environment Variables. System Properties -> Environment Variables -> Change the value for TEMP to a new location. If virtualizing it may actually be easier to add a new virtual disk and then change the TEMP location to that new virtual disk. If you are using a physical box, hopefully you don't have to add new physical disk.

If anyone can add/clarify/correct my understanding of this process it would be appreciated.
Back to top
clarence
Forum Associate
Forum Associate



Joined: 18 Nov 2005

Posts: 592
Location: California



PostPosted: Tue Oct 30, 2012 12:20 pm 
Post subject: Re: 4.0 Upgrade Management Tool - Tips, tricks, Discussion

Here's another one. It is recommended that you increase the amount of memory that you allocate to the Upgrade Management Tool by changing the command line parameter -Xmx. So what does that mean? By default the command for running the Upgrade Mangement Tool on Windows is as follows:

Code:
C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects
Enterprise XI 4.0\win64_x64\jdk\jre\bin\javaw.exe" -Xmx2g -Djava.lib
rary.path="..\..\..\..\win64_x64" -jar upgrademanagementtool.jar


Apparently you should increase the value for Xmx to 4g.

Code:
C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects
Enterprise XI 4.0\win64_x64\jdk\jre\bin\javaw.exe" -Xmx4g -Djava.lib
rary.path="..\..\..\..\win64_x64" -jar upgrademanagementtool.jar


You can make this change by going to Start -> All Programs -> SAP BusinessObjects BI Platform 4.0 -> SAP BusinessObjects BI Platform. Right click on Upgrade Management Tool and select Properties. Look through "Target" until you find -Xmx2g. Change to -Xmx4g and close.

Again, if anyone can add to/clarify/correct that would be great.
Back to top
clarence
Forum Associate
Forum Associate



Joined: 18 Nov 2005

Posts: 592
Location: California



PostPosted: Thu Nov 01, 2012 6:37 pm 
Post subject: Re: 4.0 Upgrade Management Tool - Tips, tricks, Discussion

One more. Are you getting this error when trying to move a folder full of objects to 4.0 using the Upgrade Management Tool?

Code:
A timeout occurred.  Failed to update the object within 300 seconds.


What does that mean? In my case there were several Crystal Reports that were tied to old printer drivers on the source server. Those same printer drivers were not installed on the 4.0 server. As a result the Upgrade Management Tool was unable to move the report (as well as all instances tied to the report) to the new server.

I fixed things by going to the source server, opening the report using an older version of Crystal Reports, and saving the report to my network. I then opened the report with Crystal Reports 2011 and tried to save it out to the new 4.0 server. I was prompted to install a printer driver which was tied to the report before I could save the report. After I installed the printer driver I was able to successfully move that same folder full of reports to the new 4.0 server using the Upgrade Management Tool.

In this particular case I went from having 290 errors in the log file generated by the UMT to 0 errors generated by the UMT so something this small can have a huge impact.
Back to top
clarence
Forum Associate
Forum Associate



Joined: 18 Nov 2005

Posts: 592
Location: California



PostPosted: Fri Nov 09, 2012 4:53 pm 
Post subject: Re: 4.0 Upgrade Management Tool - Tips, tricks, Discussion

Are you getting these types of errors?
Code:
Right 71 of kind Webi has been dropped.  Install components on the destination system that can handle this kind of object to prevent rights from being dropped.
   Right that existed in XI R2 does not exist in 4.0
Right 61 of kind Webi has been dropped.  Install components on the destination system that can handle this kind of object to prevent rights from being dropped.
   Right that existed in XI R2 does not exist in 4.0
Right 62 of kind Webi has been dropped.  Install components on the destination system that can handle this kind of object to prevent rights from being dropped.
   Right that existed in XI R2 does not exist in 4.0

According to support this means that there were rights setup on certain Web Intelligence documents in XI R2. The equivalent rights do not exist in the 4.0 system because the security model changed. Therefore the rights were dropped as the content was moved into 4.0. You will want to revisit security on the 4.0 system to ensure that the rights that were dropped don't compromise the security of your system.
Back to top
dgroff
Forum Member
Forum Member



Joined: 27 Feb 2013

Posts: 15



PostPosted: Tue Mar 05, 2013 2:20 pm 
Post subject: Re: 4.0 Upgrade Management Tool - Tips, tricks, Discussion

My issue with the tool is that I can't seem to get all the objects to move to 4.0. I am moving from Crystal Enterprise 2008 (XI 3.1) and I need it to move everything especially the recurrences.
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1901
Location: Atlanta, GA


flag
PostPosted: Wed Mar 06, 2013 11:28 am 
Post subject: Re: 4.0 Upgrade Management Tool - Tips, tricks, Discussion

One of the problems I ran into recently was with a system that held only Crystal reports. There were several thousand repository objects set up in the Business View Manager (BVM) for dynamic prompts. The UMT does not like working with the objects from BVM and will throw an error if there are more than 500 - 700 of them selected for migration.

I ended up doing an incremental import using the following steps:

1. Import users and groups - UNCHECK the personal folders for the import.
2. Determine which personal folders contain reports.
3. Reimport the users whose personal folders contain reports in batches of 3-5 users, including their personal folders.
4. Import the public folders in batches of 3-5 folders, check the number of repository objects included after the UMT determines what all of the dependencies are. If the number is more than about 700, go back and remove something from the import.

-Dell

_________________
Protiviti
Data & Analytics Practice
https://www.protiviti.com/US-en/data-management-advanced-analytics
Back to top
dgroff
Forum Member
Forum Member



Joined: 27 Feb 2013

Posts: 15



PostPosted: Wed Mar 06, 2013 2:04 pm 
Post subject: Re: 4.0 Upgrade Management Tool - Tips, tricks, Discussion

I have been trying it with just one report and it won't copy the report if there is a destination associated to it. It says that there are two destination property bags so it doesn't create the object.
Back to top
raj342
Senior Member
Senior Member



Joined: 04 May 2009

Posts: 57



PostPosted: Sat Mar 23, 2013 11:21 am 
Post subject: Re: 4.0 Upgrade Management Tool - Tips, tricks, Discussion

If i go with Incremental approach, i can bring all the public folders and associated objects.. But when i select just 1 user group it is calculating around 400 K objects and then throwing errors, not sure what dependencies it is pulling..

I feel old Import Wizard was much more flexible and stable..

Regards
Raj
Back to top
hilfy
Forum Enthusiast
Forum Enthusiast



Joined: 16 Apr 2007
ASUG Icon
speaker.gif*3
Posts: 1901
Location: Atlanta, GA


flag
PostPosted: Tue Mar 26, 2013 9:06 am 
Post subject: Re: 4.0 Upgrade Management Tool - Tips, tricks, Discussion

When you're importing users, it also imports everything from their favorites folders. That's why you're getting so many objects.

-Dell

_________________
Protiviti
Data & Analytics Practice
https://www.protiviti.com/US-en/data-management-advanced-analytics
Back to top
mnarne
Principal Member
Principal Member



Joined: 17 Sep 2007
ASUG Icon
Posts: 172


flag
PostPosted: Wed Mar 27, 2013 11:09 am 
Post subject: Re: 4.0 Upgrade Management Tool - Tips, tricks, Discussion

Hi

I come up with another issue while using Upgrade Management Tool

I have 500 Reports and 10's of sub folders in One of the Public folder in 3.1. now i want 1 sub folder and 10 Reports out of them to be migrated to 4.0 SP5.
when i run Upgrade Management tool and Select Folders->Sub Folder and then right side the list of reports which i need and click on NEXT

in the next screen, it shows me all reports,folders, sub folders and everything. again, here i need to select my 10 reprots out of 500+ reports.. banghead.gif banghead.gif

am i doing right? or is there anything that can be looked at?
icon_cry.gif
did any one of you face similar issue? icon_razz.gif
Back to top
mnarne
Principal Member
Principal Member



Joined: 17 Sep 2007
ASUG Icon
Posts: 172


flag
PostPosted: Wed Mar 27, 2013 11:11 am 
Post subject: Re: 4.0 Upgrade Management Tool - Tips, tricks, Discussion

I have another one on Upgrade Management tool

We have moved all our BO Log Files to another Drive from Default logging Folder.

But, Upgrade Managent Tool logging files are still writing in Old Default location. how do i change them..

any suggestions icon_question.gif
Back to top
pcgeekus
Principal Member
Principal Member



Joined: 16 Oct 2003

Posts: 201
Location: Moline, IL


flag
PostPosted: Thu Jul 18, 2013 12:17 pm 
Post subject: Re: 4.0 Upgrade Management Tool - Tips, tricks, Discussion

We have a large repository of 48,000 users and over 100,000 reports and about 36,000 instances. Our Infoobject6 table has 437,000 rows. Following other posts, we increased the UMT timeout to 1200 then 3600 and the memory on the UMT server to 24GB and gave 16GB to the UMT. Also, allocated a lot of /TEMP space and pointed the Environment variable to it. We also made sure the FRS was not using the same drive. All services except the CMS, FRS and connection server were turned OFF on the source/dest including the Tomcats.
- Still, we were getting an Upgrade Management Tool or UMT Timeout During Receive after about 30-40 minutes into the migration (either all Users and Groups via incremental or Full Upgrade methods). We had our Oracle team capture the SQL it was sending on the source system and discovered it sends a huge SQL statement (for us it was over 21,000 lines) with a bunch of AND NOT IN (150 SI_IDs). I found these were all in the Temporary Storage folder. Running that SQL alone took over 3 hours. The really kool part was that after 5-6 minutes, it would resend the same SQL and it did that 5-6 times before it timed out.

REMEDY: In the source system CMC, go to Temporary Storage and set the limit on that folder to 100 or less BEFORE attempting the upgrade. I deleted them all. We used an off-line copy to do this because a live system will continue to create more instances in Temparary Storage. We got past the Timeout and are now testing how long it will run.

FULL CHECKLIST:There are some key things you need to do to improve your chances that the UMT will work:

- Configure your 4.1 Servers for performance before you migrate (splitting the APS), especially your Event Server. The UMT will point any File Events to it, so if it's moved later, they lose that and will not work until you edit each one and resave.
- Clean up unneeded content
-- Delete all content from Temporary Storage (causes Timeouts)
-- Remove all DeskI reports if no plans to use the Viewer integration
-- Script to clean out Inboxes of content older than 90 days
-- Users with the most GBs of content in personal folders
-- Large reports (BIAR files don't handle big files well)
-- Failed Schedules
-- If you don't use Crystal, delete any Crystal sample content

- Run the Repository repair tool and make sure it actually worked
- Update Windows AD/LDAP and disable on the source system (hopefully a staged copy of your repository and FRSes). Otherwise the UMT tries to authenticate any user it brings and causes more timeouts or failures if the user doesn't exist.
- On the machine where you run the UMT, Point %TEMP% to a Drive twice the size of your FRSes. We found it best to login with the Server User in an Admin Remote Session.
- If you have lots of users, you may need to set BatchExpiry on both CMSes to 2000 or up to 9000
- Turn off all unused Servers and tomcats (Keep CMS, FRS, & Connection and Crystal App Server if you have Crystal content).
- If you can, turn off Virus scanning
- On the UMT cmd line, increase its memory to -Xmx16g or more
HERE Is a UMT Cmd Line we used for our large deployment
Quote:
"E:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\sapjvm\bin\javaw.exe" -Xmx20g -Djava.library.path="..\..\..\..\win64_x64" -Dumt.systemVar.override.pluginTimeoutinSec=1200 -jar upgrademanagementtool.jar
- On the destination 4.x server, turn off Search, Monitoring, and Auditing while the UMT runs.
_________________
"Another day...another bug"
BO 4/5/XIR2 SP5.2, XI 3.1 SP3.5, Now on 4.1 SP5, upgrading to 4.2 SP4. 130K+ reports and 65K users.
Jon F.


Last edited by pcgeekus on Thu Sep 11, 2014 2:01 pm, edited 2 times in total
Back to top
anziano_mac
Forum Member
Forum Member



Joined: 27 Aug 2010

Posts: 13



PostPosted: Wed Aug 14, 2013 7:55 am 
Post subject: Re: 4.0 Upgrade Management Tool - Tips, tricks, Discussion

We recently migrated from XIR3 to 4. After the migration it was found that no sub folders were migrated in the users personal folders. Users therefore lost their reports in the migration.

Is this a common issue? Does something special have to be done to migrate the subfolders?

Thanks
Back to top
iancage79
Forum Member
Forum Member



Joined: 04 Jul 2007
ASUG Icon
Posts: 19


flag
PostPosted: Wed Aug 14, 2013 9:19 am 
Post subject: Re: 4.0 Upgrade Management Tool - Tips, tricks, Discussion

If you're a fan of backing up your content in BIAR files, this may be helpful:

Navigate to: Start > All Programs > SAP Business Intelligence > SAP BusinessObjects BI platform 4
Right click Upgrade Management Tool and click properties
Change the Target line as follows:

Original: "C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\jdk\jre\bin\javaw.exe" -Xmx8g -Djava.library.path="..\..\..\..\win64_x64" -jar upgrademanagementtool.jar
Change: "C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\win64_x64\jdk\jre\bin\javaw.exe" -Xmx8g -Djava.library.path="..\..\..\..\win64_x64" -jar upgrademanagementtool.jar -internal_use_only_noversioncheck

Click Apply
Click OK

The -internal_use_only_noversioncheck switch addition stops the above error from happening and allows a user to restore content within a BI4.x to BI4.x environment using the Complete or Incremental options.

This is also mentioned on the SAP Idea Place: https://ideas.sap.com/ct/ct_a_view_idea.bix?idea_id=%7b9EF2E89B-1E64-4828-A89B-5AFE65884088%7d

Hope someone finds this as useful as I did

_________________
The sole purpose of a child's middle name is so they can tell when they're really in trouble... yesnod.gif
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 2 All times are GMT - 5 Hours
Goto page 1, 2  Next
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0969 seconds using 17 queries. (SQL 0.0024 Parse 0.0640 Other 0.0305)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo