Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

HugoDisselApr 20 2017 — edited May 5 2017

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:

pastedImage_1.png

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!

Comments

The rule you have described will work if "the order total" is an attribute on the Line Items entity, which is the parent of the PartsDetails relationship. If you are getting the error message described you should do the following:

1. check that the relationship text for Line ITems --> PartDetails is "the PartDetails"

2. check that you have a number or currency attribute with the text "the order total" on the Line Items entity.

3. If you are rely on an automatically created attribute, you should change the attribute to "the Line Items order total". If you include the text of an entity in an attribute, the automatically created attribute will be placed in the correct entity, and then the InstanceSum statement will be correct for the attribute.

Cheers

Frank

ParthibHW

Hi Frank, It is not working. If I flatten the structure keep 1 entity (line item details) under global, InstanceSum works fine. For nested datamodel relationship, instanceSum not working.

PathhibHW,

This is almost certainly becuase the rule is trying to create the attribute "the order total" on the global entity, in this case it cannot sum across all line items, all part details.

Have a look at my suggestions 2. and 3. make either of those changes and your rule should work.

Cheers

Frank

ParthibHW

Hi Frank, Thanks a lot. It is working now. Can you please share the scenario for "Reasoning across entity instances" ForScope statement. Thanks.

Answer

Glad to hear you got it working.

Due to quirks of our rule parser, you can't sum across a deep relationship structure in one rule using scope operations. However with a few itermediate attributes it becomes pretty simple.

To sum all the PartDetails of a quote. I would use the following two rules:

the line item's total = instancesum(the PartDetails, the PartDetails ItemPrice)

the quote's total = instancesum(the line items, the line item's total)

You have to sum the totals across one relationship at a time.

Cheers

Frank

Marked as Answer by ParthibHW · Sep 27 2020
1 - 5
Locked Post
New comments cannot be posted to this locked post.

Post Details