OBIEE 12.2.1.1 import BAR issue

Machiel Treffers

Hi All,

I've upgraded my OBIEE 12c environment to the latest 12.2.1.1 version. All is working fine but when attempting to import a BAR file using the new "import_bar.cmd" the proces throws following error when trying to import the catalog:

jul 13, 2016 4:51:04 PM oracle.bi.bar.si.framework.handler.WebcatServiceInstanceHandler importServiceInstance

SEVERE: Failed in running importServiceInstance for plugin oracle.bi.migration.webcat.WebcatMetadataManagerGenericPluginImpl

java.util.logging.ErrorManager: 5

java.lang.NullPointerException

        at java.util.ListResourceBundle.handleGetObject(ListResourceBundle.java:133)

        at java.util.ResourceBundle.getObject(ResourceBundle.java:441)

        at java.util.ResourceBundle.getString(ResourceBundle.java:407)

        at java.util.logging.Formatter.formatMessage(Formatter.java:118)

        at java.util.logging.SimpleFormatter.format(SimpleFormatter.java:151)

        at java.util.logging.StreamHandler.publish(StreamHandler.java:211)

        at java.util.logging.ConsoleHandler.publish(ConsoleHandler.java:116)

        at java.util.logging.Logger.log(Logger.java:738)

        at java.util.logging.Logger.doLog(Logger.java:765)

        at java.util.logging.Logger.log(Logger.java:788)

        at oracle.bi.bar.si.framework.handler.ServiceInstanceHandlerHelper.logErrorMessages(ServiceInstanceHandlerHelper.java:290)

        at oracle.bi.bar.si.framework.handler.ServiceInstanceHandlerHelper.logWarningAndErrorAndLogfileMessages(ServiceInstanceHandlerHelper.java:267)

        at oracle.bi.bar.si.framework.handler.WebcatServiceInstanceHandler.importServiceInstance(WebcatServiceInstanceHandler.java:381)

        at oracle.bi.bar.si.framework.ServiceInstanceFrameWorkImpl.importServiceInstance(ServiceInstanceFrameWorkImpl.java:314)

        at oracle.bi.bar.si.ServiceInstanceLifeCycleImpl.importServiceInstance(ServiceInstanceLifeCycleImpl.java:428)

        at oracle.bi.servicelcm.cli_v2.ImportBarAction.run(ImportBarAction.java:70)

        at oracle.bi.servicelcm.cli_v2.LcmCli.main(LcmCli.java:23)

jul 13, 2016 4:51:04 PM oracle.bi.bar.si.framework.ServiceInstanceFrameWorkImpl importServiceInstance

SEVERE: Error during import service instance for handler oracle.bi.bar.si.framework.handler.WebcatServiceInstanceHandler

jul 13, 2016 4:51:04 PM oracle.bi.bar.si.ServiceInstanceLifeCycleImpl importServiceInstance

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

jul 13, 2016 4:51:10 PM oracle.bi.bar.si.framework.ServiceInstanceFrameWorkImpl restoreServiceInstanceFromBackup

INFO: Handler oracle.bi.bar.si.framework.handler.JaznServiceInstanceHandler is not executed.

jul 13, 2016 4:51:10 PM oracle.bi.bar.si.ServiceInstanceLifeCycleImpl importServiceInstance

INFO: Run of all the handlers finished successfully for restore of Service Instance.

jul 13, 2016 4:51:10 PM oracle.bi.bar.si.ServiceInstanceLifeCycleImpl importServiceInstance

INFO: Updated modified time in \Oracle\Middleware12\user_projects\domains\bi_NEW\bidata\service_instances\ssi\metadata\services.xml after completion of restore Service Instance.

I'm running the command as following:

     import_bar.cmd ssi /Oracle/Middleware12/ExportDir/20160712_103145/ssi.bar noauthorization

I've also tried the "old" way using WLST as following:

     wlst offline > importServiceInstance('D:/Oracle/Middleware12/user_projects/domains/bi_NEW','ssi','D:/Oracle/Middleware12/ExportDir/20160712_103145/ssi.bar',true,true,false,'PASSWORD')

Which is giving me the same result, but is working fine in my "old" 12c environment.

Is this a 12.2.1.1 "feature" or did anyone else managed to import a BAR file in the new OBI version? Thanks!

Regards, Machiel

OracleUser_MUC6U

I'm have the same issue using the importServiceInstance command

Where you able to resolve this?

osama.

You need to provide same password while importing bar file, as you provided when u exported the bar file. This password is used to encrypt/decript rpd passwords, if the password is not the same the rpd import will fail.