OBIEE 12.2.1.1 exportServiceInstance fails

Machiel Treffers

Hi All,

I've upgraded my OBIEE 12.2.1.0 (Linux) to 12.2.1.1 (using the quick reference guide on Oracle Support).

Now when trying to export a BAR file I get following error when the export of the authorization model starts:

INFO: Plugin Found in Service Loader: oracle.bi.jazn.bar.plugin.JaznMetadataManagerGenericPluginImpl

Sep 02, 2016 3:18:55 PM oracle.bi.bar.shared.MetadataType getMetadataManagerPlugin

INFO: Loaded the plugin: oracle.bi.jazn.bar.plugin.JaznMetadataManagerGenericPluginImpl

Sep 02, 2016 3:18:55 PM oracle.bi.bar.si.framework.handler.JaznServiceInstanceHandler exportServiceInstance

INFO: Executing preExportServiceInstance for JAZN plugin oracle.bi.jazn.bar.plugin.JaznMetadataManagerGenericPluginImpl

Sep 02, 2016 3:18:55 PM oracle.bi.bar.si.framework.handler.JaznServiceInstanceHandler exportServiceInstance

INFO: Successfully run preExportServiceInstance for JAZN plugin oracle.bi.jazn.bar.plugin.JaznMetadataManagerGenericPluginImpl

Sep 02, 2016 3:18:55 PM oracle.bi.bar.si.framework.handler.JaznServiceInstanceHandler exportServiceInstance

INFO: Executing exportServiceInstance for JAZN plugin oracle.bi.jazn.bar.plugin.JaznMetadataManagerGenericPluginImpl

Sep 02, 2016 3:19:04 PM oracle.bi.jazn.bar.plugin.JaznMetadataManagerGenericPluginImpl exportServiceInstance

SEVERE: Failed in migrateing policy store from obi to file /u01/oracle/workDir/exportSICustomization/ssi/metadata/authmodel/jazn/jazn-data.xml

Sep 02, 2016 3:19:04 PM oracle.bi.bar.si.framework.handler.JaznServiceInstanceHandler exportServiceInstance

SEVERE: Failed running exportServiceInstance API of oracle.bi.jazn.bar.plugin.JaznMetadataManagerGenericPluginImpl

oracle.bi.bar.si.framework.plugin.MetadataPluginException: Failed in migrateing policy store from  obi to file /u01/oracle/workDir/exportSICustomization/ssi/metadata/authmodel/jazn/jazn-data.xml

        at oracle.bi.jazn.bar.plugin.JaznMetadataManagerGenericPluginImpl.exportServiceInstance(JaznMetadataManagerGenericPluginImpl.java:325)

        at oracle.bi.jazn.bar.plugin.JaznMetadataManagerGenericPluginImpl.exportServiceInstance(JaznMetadataManagerGenericPluginImpl.java:66)

        at oracle.bi.bar.si.framework.handler.JaznServiceInstanceHandler.exportServiceInstance(JaznServiceInstanceHandler.java:525)

        at oracle.bi.bar.si.framework.ServiceInstanceFrameWorkImpl.exportServiceInstance(ServiceInstanceFrameWorkImpl.java:368)

        at oracle.bi.bar.si.ServiceInstanceLifeCycleImpl.exportServiceInstance(ServiceInstanceLifeCycleImpl.java:644)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:498)

        at org.python.core.PyReflectedFunction.__call__(Unknown Source)

        at org.python.core.PyMethod.__call__(Unknown Source)

        at org.python.core.PyObject.__call__(Unknown Source)

        at org.python.core.PyObject.invoke(Unknown Source)

        at org.python.pycode._pyx132.exportServiceInstance$4(/u01/oracle/Oracle_Home_12.2.1.1/bi/lib/bi-bar.jar!/wlstScriptDir/ServiceInstanceLifeCycle.py:84)

        at org.python.pycode._pyx132.call_function(/u01/oracle/Oracle_Home_12.2.1.1/bi/lib/bi-bar.jar!/wlstScriptDir/ServiceInstanceLifeCycle.py)

        at org.python.core.PyTableCode.call(Unknown Source)

        at org.python.core.PyTableCode.call(Unknown Source)

        at org.python.core.PyFunction.__call__(Unknown Source)

        at org.python.core.PyObject.__call__(Unknown Source)

        at org.python.pycode._pyx148.f$0(<console>:1)

        at org.python.pycode._pyx148.call_function(<console>)

        at org.python.core.PyTableCode.call(Unknown Source)

        at org.python.core.PyCode.call(Unknown Source)

        at org.python.core.Py.runCode(Unknown Source)

        at org.python.core.Py.exec(Unknown Source)

        at org.python.util.PythonInterpreter.exec(Unknown Source)

        at org.python.util.InteractiveInterpreter.runcode(Unknown Source)

        at org.python.util.InteractiveInterpreter.runsource(Unknown Source)

        at org.python.util.InteractiveInterpreter.runsource(Unknown Source)

        at weblogic.management.scripting.utils.WLSTInterpreter.runsource(WLSTInterpreter.java:1093)

        at weblogic.management.scripting.WLST.main(WLST.java:227)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:498)

        at weblogic.WLST.main(WLST.java:47)

Sep 02, 2016 3:19:04 PM oracle.bi.bar.si.framework.ServiceInstanceFrameWorkImpl exportServiceInstance

SEVERE: Error during export service instanceoracle.bi.bar.si.exception.ServiceInstanceLifeCycleException: Failed running CreateServiceInstance API of oracle.bi.jazn.bar.plugin.JaznMetadataManagerGenericPluginImpl

Sep 02, 2016 3:19:04 PM oracle.bi.bar.si.ServiceInstanceLifeCycleImpl exportServiceInstance

SEVERE: Failed in running all the handlers during export service instance.

Traceback (innermost last):

  File "<console>", line 1, in ?

  File "/u01/oracle/Oracle_Home_12.2.1.1/bi/lib/bi-bar.jar!/wlstScriptDir/ServiceInstanceLifeCycle.py", line 84, in exportServiceInstance

        at oracle.bi.bar.si.ServiceInstanceLifeCycleImpl.exportServiceInstance(ServiceInstanceLifeCycleImpl.java:648)

        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:498)

oracle.bi.bar.si.exception.ServiceInstanceLifeCycleException: oracle.bi.bar.si.exception.ServiceInstanceLifeCycleException: BAR-00005

I'm running the command as following: wls:/offline> exportServiceInstance('/u01/oracle/fmw/user_projects/domains/bi','ssi','/u01/oracle/workDir','/u01/oracle/exportDir','','','',true,'Password')

Does anybody experience similair behaviour? Or have idea's on how to fix this?

Regards, Machiel

user10311964

We are facing exactly same issue

Did you find any solution

Machiel Treffers

No unfortunately not. However I do suspect a custom authenticator. I'll be testing this tomorrow. Do you have any custom authenticators in place in your environment?

Regards,

Machiel

Joel

Hi @Machiel Have you tried performing the export with OBIEE 11g components all shut down (Admin Server, Managed Server & OPMN)?

Machiel Treffers

Hi Joel,

I assume you mean 12c components? Yes I did, ran the stop.sh script but this returned similar result.

Regards

Joel

Hi @Michael I actually meant when you created the BAR file in your 11g instance, did you stop all 11g components beforehand?

User_8ZWKB

Joel,

I believe BAR file was introduced in 12c.  From 11g, you generate a .jar file from the migration tool.  Did I miss something?

Machiel,

Are you only experiencing this after upgrade to 12.2.1.1?  It works fine in 12.2.1.0?  We had this issue earlier with 12.2.1.0 when our administrator manually imported in RPD and webcat from 11g to 12c environment.  From the front end (or application's point of view) everything was working fine except exportServiceInstance would fail.  After reinstall 12c and imported in JAR file from 11g, this error went away.

Sean

Machiel Treffers

Hi Sean,

Thanks for you reply. Yes in 12.2.1.0 it was working fine. I've used this method to create some backups then. I did some manual modifications to the catalog. I'll try to recover a backup from the catalog I imported from 11g to see whether this makes any difference.

Regards, Machiel

Machiel Treffers

All,

This issue has been fixed. Apparently I'd have a corrupt impersonate policy which was unable to export. Replaced the policy and export finished as expected.

I would suggest everybody with similar problems to check the contents of the working directory and find jazn-data.xml. Scroll down to the last row and check where the export got stuck. Fix the corrupt policy / role and try again. (Clear the working directory before retrying.)

Regards, Machiel

user13132431

Hi Machiel,

Could you please provide detail steps?

Appreciate it.

Thanks

Akhil

Chiaranon Thimkul

Hello ,

All guy who searched about OBIEE12c export bar file failed and found this forum.

This topic pickup correct Answer from Machiel ,

I faced this also and try to fix, I had read K.Machiel carefully , and found the cause.

Step detail should be

1. Investigate your jazn-data.xml in your server

2. See the last row, you can see this file is not complete , that is problem.

3. You will see what' last step this file generate , let say this file freeze after statement about "application role"

4. That mean your system have some problem with application role setup

5. But we can't specific which problem occur with your application role, you need to find out case by case

Example maybe you create "Application Role" in Thai language

6. After fix , should backup and delete jazn-data.xml

And 7. You should perform exportServiceInstance again.

Should be okay.

Thanks a lot K.Machiel