OBIEE 12.2.1.4 cannot get the export_service_instance.sh command to work

User_98QEC · Sep 26, 2019 5:10PM

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

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)