OBIEE 12.2.1.2 Migration Tool (JAR) Failed On Running Migrate Policy Store

HugoDissel

Situation

We are migrating from OBIEE 11.1.1.7.1 to OBIEE 12.2.1.2, both are Microsoft Windows based servers. Installation and configuration of OBIEE 12c is done. The new OBIEE environment is fully functional. We are migrating BI content using the Oracle Documentation on this subject. We have succesfully generated the bi-migration-tool.jar file on the OBIEE 12c environment and have copied it to the OBIEE 11G environment.

Issue

After succesfully constructing the command and its output parameters, we ran into the issue a first time. After reading Oracle Doc ID 2126027.1 we have set the _JAVA_OPTIONS envrionment variable, as you can see:

The issue remains: the migration tool fails, providing the following error: "Failed on running migrate policy store". In the log files we can actually see the tool pick up the RPD, catalog and msgdb files succesfully. It seems to have issues with our system-jazn-data.xml file.

Question

How to get past this point? What workarounds can we try to create an export archive, which we can import into our new environment? Many thanks in advance!

BrianH-Oracle

Having just done this in-house, the log file has a lot more information and can help in debugging.

If you open this and look for "SEVERE", there should be an indication of why this failed. You can either debug this or add the log to the thread highlighting the errors in your post.

Brian