VM-WIP SAP Migration Procedure
COMMON
Install WIP Web Server : https://ebiexpert.atlassian.net/wiki/spaces/WUM/pages/2132410369
Install SAP Plugin : https://ebiexpert.atlassian.net/wiki/spaces/WUM/pages/2132410535
Install WIP Addon on the client machines : https://ebiexpert.atlassian.net/wiki/spaces/WUM/pages/70254593
Purge WIP Repositroy
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
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
Select a folder
Press explorer Check-in
Select only the .unx
Press the check-in button
WIP will create all explorer folder structure inside selected WIP folder recursively