OBIEE 12.2.1.1 exportServiceInstance fails — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 12.2.1.1 exportServiceInstance fails

Received Response
101
Views
10
Comments
Machiel Treffers
Machiel Treffers Rank 3 - Community Apprentice

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

Answers

  • user10311964
    user10311964 Rank 1 - Community Starter

    We are facing exactly same issue

    Did you find any solution

  • Machiel Treffers
    Machiel Treffers Rank 3 - Community Apprentice

    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
    Joel Rank 8 - Analytics Strategist

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

  • Machiel Treffers
    Machiel Treffers Rank 3 - Community Apprentice

    Hi Joel,

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

    Regards

  • Joel
    Joel Rank 8 - Analytics Strategist

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

  • User_8ZWKB
    User_8ZWKB Rank 3 - Community Apprentice

    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
    Machiel Treffers Rank 3 - Community Apprentice

    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
    Machiel Treffers Rank 3 - Community Apprentice

    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
    user13132431 Rank 1 - Community Starter

    Hi Machiel,

    Could you please provide detail steps?

    Appreciate it.

    Thanks

    Akhil

  • Chiaranon Thimkul
    Chiaranon Thimkul Rank 3 - Community Apprentice

    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