Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OBIEE 12.2.1.4 cannot get the export_service_instance.sh command to work

Received Response
317
Views
3
Comments
User_98QEC
User_98QEC Rank 3 - Community Apprentice
edited Aug 13, 2024 7:21PM in Oracle Analytics Cloud and Server

Info:

UNIX server running RHEL 7

OBIEE 12.2.1.4

repository a Oracle 12.2 plugin database

Installation is complete and I am trying to work out the process of migrating from by TEST instance to my PROD instance

UNIX SET command tells me:

BI_PRODUCT_HOME=/opt/hrms/obiee/Oracle_Home//bi/

DOMAIN_HOME=/opt/hrms/obiee/Oracle_Home//user_projects/domains/bi/

ORACLE_HOME=/opt/hrms/obiee/Oracle_Home/

WL_HOME=/opt/hrms/obiee/Oracle_Home//oracle_common/common/bin/

running the following $DOMAIN_HOME/bitools/bin/export_service_instance.sh ssi /opt/hrms/obiee/exportDir/exportTESTBU_09262019.bar (yes I do have write permissions there)

yields: (AND I CANNOT SEEM TO GET PAST THIS ERROR) Please assist

Oracle BI ServiceLCM CLI Tools

Copyright © 2014, 2015, 2016, 2017 Oracle and/or its affiliates. All rights reserved.

Enter RPD Password:

Re-enter RPD Password:

Product Home: /opt/hrms/obiee/Oracle_Home/bi

Domain Home: /opt/hrms/obiee/Oracle_Home/user_projects/domains/bi

Service instance key: ssi

Working directory: /opt/hrms/obiee/exportDir

Application name: null

Application Description: null

Application version: null

Include Catalog Runtime Info: true

Credential Password: Supplied

Sep 26, 2019 3:00:26 PM oracle.security.jps.JpsStartup startWithRetry

INFO: Jps initializing.

Sep 26, 2019 3:00:32 PM oracle.security.jps.internal.common.util.JpsCommonUtil initPolicyProvider

INFO: Initializing OPSS Java Policy Provider.

Sep 26, 2019 3:00:32 PM oracle.security.jps.internal.common.util.JpsCommonUtil initPolicyProvider

INFO: OPSS Java Policy Provider initialized.

Sep 26, 2019 3:00:32 PM oracle.security.jps.internal.common.util.JpsCommonUtil initPolicyProvider

INFO: OPSS Java Policy Provider is set as the system-wide Policy object.

Sep 26, 2019 3:00:32 PM oracle.security.jps.JpsStartup startWithRetry

INFO: Jps started.

Sep 26, 2019 3:00:33 PM oracle.security.audit.Auditor init

WARNING: IAU:IAU-6012: Unable to determine the audit log directory. No log directory specified.

Sep 26, 2019 3:00:33 PM oracle.security.jps.util.JpsUtil disableAudit

INFO: JpsUtil: isAuditDisabled set to true

Sep 26, 2019 3:00:33 PM oracle.security.jps.internal.audit.AuditServiceImpl validateLogPossible

WARNING: No audit log directory is set. Cannot perform audit operations for component JPS.

Sep 26, 2019 3:00:33 PM oracle.bi.security.config.SecurityConfigurationFactory getSecurityConfigurationInstance

INFO: Initialising Domain BI Security Configuration...

Sep 26, 2019 3:00:33 PM oracle.bi.security.config.PropertiesFileConfigurationDelegate <init>

INFO: Initialising security configuration from properties file.

Sep 26, 2019 3:00:33 PM oracle.bi.security.config.PropertiesFileConfigurationDelegate <init>

INFO: BI config directory path=/opt/hrms/obiee/Oracle_Home/user_projects/domains/bi/config/fmwconfig/biconfig

Sep 26, 2019 3:00:33 PM oracle.bi.security.config.PropertiesFileConfigurationDelegate <init>

INFO: BI security configuration properties file should be at: /opt/hrms/obiee/Oracle_Home/user_projects/domains/bi/config/fmwconfig/biconfig/bi-security/config.properties

Sep 26, 2019 3:00:33 PM oracle.bi.security.config.PropertiesFileConfigurationDelegate <init>

INFO: BI security configuration properties loaded. Data={hashAlgorithm=SHA-256, includeGroupsInSubject=false, metricsCollectionEnabled=false, lightweightSSOEnabled=false, internalSessionTokenExpiryTime=14400, identityDomainEnabled=false, includeRoleHierarchyInfoInSubject=false, encryptionAlgorithm=AES, defaultServiceInstanceKey=ssi, encryptionAlgorithmKeySize=16, hashIterationCount=1000}

Sep 26, 2019 3:00:33 PM org.flywaydb.core.internal.util.VersionPrinter printVersion

INFO: Flyway 4.1.2 by Boxfuse

Sep 26, 2019 3:00:33 PM org.flywaydb.core.internal.dbsupport.DbSupportFactory createDbSupport

INFO: Database: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ddcssdordb23.bc.doi.net)(PORT=1555)))(CONNECT_DATA=(SERVICE_NAME=PDBFDBI))) (Oracle 12.2)

Sep 26, 2019 3:00:34 PM oracle.bi.servicelcm_v2.persistence.defaults.DefaultsReader readDefaultsIntoBuilderFromPath

WARNING: Cannot read defaults, as path does not exist: /opt/hrms/obiee/Oracle_Home/user_projects/domains/bi/config/fmwconfig/bienv/core/servicelcm/defaults/.

Sep 26, 2019 3:00:34 PM oracle.bi.servicelcm_v2.persistence.defaults.DefaultsReader readDefaultsIntoBuilderFromPath

WARNING: Cannot read defaults, as path does not exist: /opt/hrms/obiee/Oracle_Home/bi/plugins/servicelcm/defaults/.

Sep 26, 2019 3:00:34 PM oracle.bi.servicelcm_v2.persistence.AbstractPodPersistenceManager getPod

INFO: [RETRIEVED_POD_RECORD] Retrieved Pod record: Found = true; UUID = 9498062e-38cd-47ce-ad52-96871b81d1e0; Backend = Database

Sep 26, 2019 3:00:35 PM oracle.bi.servicelcm_v2.db.DatabaseServiceInstancePersistenceManager retrieveInstanceInExistingTransaction

INFO: [RETRIEVED_SERVICE_INSTANCE_RECORD] Retrieved Service Instance record: key="ssi"; backend=Database

Sep 26, 2019 3:00:35 PM oracle.bi.bar.util.DomainIntrospectUtils obtainSingletonDataDirectory

INFO: Obtained Singleton Data Directory as /opt/hrms/obiee/Oracle_Home/user_projects/domains/bi/bidata

Sep 26, 2019 3:00:35 PM oracle.bi.bar.si.ServiceInstanceContext setProductHome

INFO: BI Product Home is being initialzed in the context as  null

Sep 26, 2019 3:00:35 PM oracle.bi.bar.si.ServiceInstanceLifeCycleFactory getServiceInstanceLifeCycleImpl

INFO: Service Instance lifecyle impl version used: V1

Sep 26, 2019 3:00:35 PM oracle.bi.bar.si.ServiceInstanceContext getProductHome

SEVERE: Unable to determine BI Product Home as system property or environment variable is not set

Sep 26, 2019 3:00:35 PM oracle.bi.servicelcm_v2.operations.DefaultAnalyticApplicationOperations exportBar

SEVERE: [PROBLEM_EXPORTING_BAR_FILE] Problem exporting BAR: location=/opt/hrms/obiee/exportDir/exportTESTBU_09262019.bar

java.lang.RuntimeException: Unable to return ServiceInstanceLifeCycle implnull

        at oracle.bi.bar.si.ServiceInstLifeCycleImplVersions.getImpl(ServiceInstLifeCycleImplVersions.java:25)

        at oracle.bi.bar.si.ServiceInstanceLifeCycleFactory.getServiceInstanceLifeCycleImpl(ServiceInstanceLifeCycleFactory.java:28)

        at oracle.bi.servicelcm_v2.internal.bar.BarImportExport.exportBar(BarImportExport.java:77)

        at oracle.bi.servicelcm_v2.operations.DefaultAnalyticApplicationOperations.exportBar(DefaultAnalyticApplicationOperations.java:160)

        at oracle.bi.servicelcm_v2.domain.application.AnalyticApplicationCustomisation.exportBAR(AnalyticApplicationCustomisation.java:115)

        at oracle.bi.servicelcm.cli_v2.ExportServiceInstanceAction.run(ExportServiceInstanceAction.java:88)

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

Sep 26, 2019 3:00:35 PM oracle.bi.servicelcm_v2.operations.DefaultAnalyticApplicationOperations exportBar

SEVERE: [PROBLEM_EXPORTING_BAR_FILE] Problem exporting BAR: location=/opt/hrms/obiee/exportDir/exportTESTBU_09262019.bar

java.lang.RuntimeException: Unable to return ServiceInstanceLifeCycle implnull

        at oracle.bi.bar.si.ServiceInstLifeCycleImplVersions.getImpl(ServiceInstLifeCycleImplVersions.java:25)

        at oracle.bi.bar.si.ServiceInstanceLifeCycleFactory.getServiceInstanceLifeCycleImpl(ServiceInstanceLifeCycleFactory.java:28)

        at oracle.bi.servicelcm_v2.internal.bar.BarImportExport.exportBar(BarImportExport.java:77)

        at oracle.bi.servicelcm_v2.operations.DefaultAnalyticApplicationOperations.exportBar(DefaultAnalyticApplicationOperations.java:160)

        at oracle.bi.servicelcm_v2.domain.application.AnalyticApplicationCustomisation.exportBAR(AnalyticApplicationCustomisation.java:115)

        at oracle.bi.servicelcm.cli_v2.ExportServiceInstanceAction.run(ExportServiceInstanceAction.java:88)

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

Exception in thread "main" java.lang.RuntimeException: Unable to return ServiceInstanceLifeCycle implnull

        at oracle.bi.bar.si.ServiceInstLifeCycleImplVersions.getImpl(ServiceInstLifeCycleImplVersions.java:25)

        at oracle.bi.bar.si.ServiceInstanceLifeCycleFactory.getServiceInstanceLifeCycleImpl(ServiceInstanceLifeCycleFactory.java:28)

        at oracle.bi.servicelcm_v2.internal.bar.BarImportExport.exportBar(BarImportExport.java:77)

        at oracle.bi.servicelcm_v2.operations.DefaultAnalyticApplicationOperations.exportBar(DefaultAnalyticApplicationOperations.java:160)

        at oracle.bi.servicelcm_v2.domain.application.AnalyticApplicationCustomisation.exportBAR(AnalyticApplicationCustomisation.java:115)

        at oracle.bi.servicelcm.cli_v2.ExportServiceInstanceAction.run(ExportServiceInstanceAction.java:88)

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

The documentation is sketchy at best, since this all seemed to have all changed for 12.2.1.4

Thank you for looking at this.

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    2958425 wrote:ISEVERE: Unable to determine BI Product Home as system property or environment variable is not set

    First thing to check: Are your environment variables really set and with the correct values before you try to run the command?

  • User_NPZU3
    User_NPZU3 Rank 1 - Community Starter

    Okay - I think I may have found the answer to this, I'll test and post results. The ServiceLCM Flyway table is in lower case.

    select * from OBIEE12X4_BIPLATFORM."servicelcm_flyway"

    Yes, lower case. I created a view (create view OBIEE12X4_BIPLATFORM.servicelcm_flyway as select * from OBIEE12X4_BIPLATFORM."servicelcm_flyway" ) that I'm hoping will get me around the wlst  listBIServiceInstances('') failiures as well as failing to export bar files.

    I hope this is the case because this bug is particularly nasty.

  • Federico Venturin - Oracle
    Federico Venturin - Oracle Mod

    @User_98QEC Have you tried with the exportarchive.sh command instead of export_service_instance.sh?