SAP Business Objects 4.2 SP9 - Version management Issue

 This blog is to share how to fix the VMS issue when we upgrade Business objects enterprise from previous versions to BI 4.2 SP9 or any other VMS issue, you can use the following steps.

ERROR MESSAGE - AFTER UPGRADE 

When you try to add resource you may get the below error , also you may find existing reports in vms are with CMS 0 and VMS 0 

com.businessobjects.vms.VMSException: Add Resource Error:: svn: E155036: Please see the 'svn upgrade' Command

svn; E155036: The working copy at ' ' 

Next Possible Steps

Try with the SAP Note

1839318 - How to upgrade the subversion content to the latest version?

Then restart the LCM from services in windows server and also promotion management server

Then go to CMC - VMS and check if that is resolved, if its still not resolved then follow the below steps

Login to each app server and update the repository ( ignore if this is already exist) 

Run command - Type Regedit and then update the red highlighted as follows

 Update Registry in both Nodes

     Navigate to HKEY_LOCAL_MACHINE -> System -> CurrentControlSet -> Services -> SVNSubversion
     Update ImagePath Data as "D:\Program Files\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\subversion\svnserve.exe" --service -r "\Root \Root data\BOFOLDER\LCM_repository" --listen-port 3690

Then take backup of the LCM REPOSITORY OF your bo application to be on safer side

Login in to anyone of the app server and do the following 

Open command prompt and navigate to the below folder

 Install folder\Program Files\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\subversion

Then execute the following one by one 

     svnadmin.exe upgrade "\root folder\app\bo\data\svn_repository"
     svn.exe upgrade "\root folder\app\bo\data\CheckOut\BO_PROD\WORKSPACE"

Then do restart SIA and test the Version management issue must be resolved, ( you can do full restart means restarting windows server itself to see if that works ) 

Kindy share your feedback - Happy to help you out more on resolving this issue