VM-WIP SAP Migration Procedure

Owned by Jean-Philippe Golay
Last updated: Oct 12, 2021 by Jaabir Ho
2 min read

COMMON

 

 

Prior to Migration

  • Make a backup of the existing database

  • Delete all files, Environments, Repository and packages not needed

  • Undo checkout for any files that are in checkout

  • Stop all processing item by the processor by running the command (update vmprocess set ProcStatus =0) . Do a commit if on oracle

 

ORACLE Database

  1. Pass the Upgrade SCRIPT VMCLASSROOTGUID

insert into "VMCLASSROOTGUID" ("BOLD_ID","BOLD_TYPE","CREATEDATE","CREATEUSER","MODIFDATE","MODIFUSER","OBJSTATUS","STOREDGUID") select "BOLD_ID","BOLD_TYPE",SYSDATE,' ',SYSDATE,' ','1',' ' --SELECT * from "ABSECUREITEM" where BOLD_ID NOT IN (SELECT DISTINCT BOLD_ID FROM "VMCLASSROOTGUID") commit;

SQLServer Database

 

INSERT INTO [dbo].[VmClassRootGUID]([BOLD_ID],[BOLD_TYPE],[CreateDate],[CreateUser],[ModifDate],[ModifUser],[ObjStatus],[StoredGUID]) SELECT [BOLD_ID],[BOLD_TYPE],'1900-01-01 00:00:00.000','','1900-01-01 00:00:00.000','','1','' FROM [dbo].[AbSecureItem] WHERE BOLD_IDNOT IN (SELECT DISTINCT BOLD_ID FROM [dbo].[VmClassRootGUID])

Migrate old VM Installation

 

If you chose to migrate your old data you need WIP to convert existing VM Folder structure to WIP and split folders containing Universes to another folder structure [Universes], SAP-BI documents will be moved to [Files] section. Note you will not be able to see any documents in the [SAP-BI Files] and [SAP-BI Universes] sections and folders till migration is done

Migrate VM folder structure to WIP

 

  • Login WIP With VMMANAGER (Access as User / Admin)

  • Select Files Section

  • You need to migrate to SAP, select any root folder and Press Migrate to SAP ( All folders will be migrated not only the selected one)

 

VM .UNX universes

WIP will not migrate old VM unx universes as the way to store them and process them have totally changed in WIP. You need to import they latest versions from the SAP-Servers.

Once all your SAP Servers connected,

  • login using a SAP-BI Administrator into WIP

  • select or create a Universe Folder in the Universes Section

  • press the SAP-BI Explorer button

  1. Select a folder

  2. Press explorer Check-in

  3. Select only the .unx

  4. Press the check-in button

WIP will create all explorer folder structure inside selected WIP folder recursively

Â