While installing OBIEE11g in Windows os 10 Perform below steps to avoid bipublisher settings issue:
for setup.exe file in "....\OBIEE\11g_Installables\obi_WINDOWSX64_11.1.1.9.0_disk1of5\bishiphome\Disk1"
change the Compatibility Mode as "Run this programe in compatibility mode for "Windows 7" and Click "run as Administartor on setup.exe file
Install Loopbackadaptor and change the hostsfile as mentioned below:
http://gerardnico.com/wiki/windows/loop_back_adaptater
##########################################################################################################################################################################################
1) To Create OCI while importing data from Database in OBIEE RPD, we need to place entire admin folder from "....\product\11.2.0\dbhome_1\NETWORK\ADMIN" to "<<ORACLEBIHOME>>\network"
##########################################################################################################################################################################################
##########################################################################################################################################################################################
2) If RCU gets failed due to below error then run sql "revoke connect from dev_mds";
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
RCU-6083:Failed - Check prerequisites requirement for selected component:MDS
Please refer to RCU log at ....\OBIEE\RCU\rcuHome\rcu\log\logdir.2017-01-15_14-01\rcu.log for details.
The schema owner 'DEV_MDS' is connected to the database. Please disconnect and try again.
RCU-6092:Component Selection validation failed. Please refer to log at ....\OBIEE\RCU\rcuHome\rcu\log\logdir.2017-01-15_14-01\rcu.log for details.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
##########################################################################################################################################################################################
3) If login page is working and unable to login to application with weblogic user and if BIserver logs and presentation server logs says below:
BI Server:
ISSUE:
Error retrieving user/group data from Oracle BI Server’s User Population API.
Unable to create a system user connection to BI Server while running user population queries
[2017-02-15T18:47:53.228+05:30] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 5480fcdc22ba98bf:35c9780b:15a41c710ef:-8000-00000000000003fd,0:1:1:6] [tid: 12a4] [nQSError: 13057] Error From BI Security Service: SecurityService::execute [OBI-SEC-00048] Identity store provider error. [[
********** Task: 1. Running for (mls): 21047 **********
Description: Authenticate
RPID: Star; user: weblogic; AppType: 0; Offline: false
[2017-02-15T19:08:36.94+05:30] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00idmWJQjAOFw0zknV0DVz5NPoU2zmYwD00033400001_,0] [tid: 2010] [nQSError: 13057] Error From BI Security Service: SecurityService::execute [OBI-SEC-00048] Identity store provider error. [[
********** Task: 1. Running for (mls): 21094 **********
Description: Authenticate
RPID: Star; user: BISystemUser; AppType: 0; Offline: false
Resolution for Above Issue:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
https://lorddisk.wordpress.com/2014/12/12/unable-to-create-a-system-user-connection-to-bi-server-while-running-user-population-queries/
To confirm that the password is correct:
Log into Oracle WebLogic Server Administration Console.
Go to Domain Structure and click Security Realms, and select myrealm. The Settings for myrealm page displays.
Click the Users and Groups tab, and then the Users subtab.
In the Users table, locate and select the user that has the BISystem role assigned to it. The settings page displays.
Click the Passwords tab and reset the user password. Click Save.
Log into Fusion Applications Control.
Open the WebLogic Domain node and right-click BIDomain.
Select Security, and then select Credentials.
Select oracle.bi.system and the select system.user.
Edit the password to match the user password that you set in Oracle WebLogic Server.
Restart the Oracle BI Administration Server, Oracle Managed Server, and Oracle Process Manager and Notification Server
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Presentation Server:
-------------------------------------------
ISSUE1:
[OBIPS] [WARNING:1] [] [saw.catalog.local.checkforcatalogupgrade] [ecid: ] [tid: ] Upgrade is recommended to the latest catalog version.[[
Resolution for Above Issue:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Upgrade OBIEE 11g catalog
http://obieelearner.blogspot.in/2012/07/upgrade-obiee-11g-catalog.html
http://obieeil.blogspot.in/2014/06/obiee-cant-open-catalog-offline-or.html
I have been getting a warning in the OBIPS log:
OBIEE 11g: Warning: "Upgrade is recommended to the latest 11.1.1.6.0 (Build 120104.0800 64-bit) catalog version" After Upgrading to OBIEE 11.1.1.6
so i decided to upgrade the catalog:
Here are the steps:
Note: RPD should be consistent and take a backup of catalog before starting
Step 1: Stop OBIPS
cd ORACLE_INSTANCE/bin
opmnctl stopproc ias-component=coreapplication_obips1
Step 2: find and set the tag UpgradeAndExit to true from false in instanceconfig.xml
<UpgradeAndExit>true<UpgradeAndExit>
Step 3: Start OBIPS
cd ORACLE_INSTANCE/bin
opmnctl startproc ias-component=coreapplication_obips1
Step 4:
After the catalogs are updated, edit the instanceconfig.xml file again and change the upgradeAndExit option back to false.
Step 5: Restart all services.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
ISSUE2:
[2017-02-15T18:19:49.000+05:30] [OBIPS] [ERROR:31] [] [saw.rpc.client.impl.verify] [ecid: 00idmT_^XCnFw0zknV0DVz5NPoU2zmYwD0002yo000004,0] [tid: 9108] An error occurred during connect to "10.10.10.10:9810". No connection could be made because the target machine actively refused it.
Resolution for Above Issue:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
https://community.oracle.com/thread/3519959?db=5
Try the following to see if it helps
Check in Database where rcu is installed , Check User is Locked
"SELECT username, account_status FROM dba_users;"
List of Locked Users
"SELECT username,account_status,lock_date from dba_users where lock_date IS NOT NULL;"
Unlock User
"ALTER USER user_name IDENTIFIED BY password ACCOUNT UNLOCK;"
RESOLUTION:
Connect to WebLogic Server (WLS) Console -> Deployments. Ensure that all deployed components are in ‘Active’ state.
Use the command prompt to verify the opmn status, as the EM console will not always reflect the correct status.
If any of the components is in ‘Prepared’ state, select that application and then click on “start servicing all requests”.
Restart BI Server and Presentation Services
If this does not resolve the issue please follow the steps below:
In some cases, the following additional step might be needed to resolve the issue.
Access the Enterprise Manager Fusion Middleware control: http://<host.domain>:port/em
Navigate to Business Intelligence -> coreapplication
‘Capacity Management’ tab -> ‘Scalability’ sub-tab
Click on ‘Lock and Edit Configuration’ button
Enter the IP address in the ‘Listen Address’ field
Click on ‘Activate Changes’ followed by ‘Release Configuration’ buttons.
Restart BI Server and Presentation Services
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
ISSUE3:
[2017-02-15T18:43:38.000+05:30] [OBIPS] [ERROR:31] [] [saw.connectionPool.getConnection] [ecid: 5480fcdc22ba98bf:35c9780b:15a41c710ef:-8000-000000000000026b,0:1:1] [tid: 8196] Authentication Failure.
Odbc driver returned an error (SQLDriverConnectW).
State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 43126] Authentication failed: invalid user/password.
Resolution for Above Issue:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
https://lorddisk.wordpress.com/2014/12/12/unable-to-create-a-system-user-connection-to-bi-server-while-running-user-population-queries/
To confirm that the password is correct:
Log into Oracle WebLogic Server Administration Console.
Go to Domain Structure and click Security Realms, and select myrealm. The Settings for myrealm page displays.
Click the Users and Groups tab, and then the Users subtab.
In the Users table, locate and select the user that has the BISystem role assigned to it. The settings page displays.
Click the Passwords tab and reset the user password. Click Save.
Log into Fusion Applications Control.
Open the WebLogic Domain node and right-click BIDomain.
Select Security, and then select Credentials.
Select oracle.bi.system and the select system.user.
Edit the password to match the user password that you set in Oracle WebLogic Server.
Restart the Oracle BI Administration Server, Oracle Managed Server, and Oracle Process Manager and Notification Server
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
##########################################################################################################################################################################################
for setup.exe file in "....\OBIEE\11g_Installables\obi_WINDOWSX64_11.1.1.9.0_disk1of5\bishiphome\Disk1"
change the Compatibility Mode as "Run this programe in compatibility mode for "Windows 7" and Click "run as Administartor on setup.exe file
Install Loopbackadaptor and change the hostsfile as mentioned below:
http://gerardnico.com/wiki/windows/loop_back_adaptater
##########################################################################################################################################################################################
1) To Create OCI while importing data from Database in OBIEE RPD, we need to place entire admin folder from "....\product\11.2.0\dbhome_1\NETWORK\ADMIN" to "<<ORACLEBIHOME>>\network"
##########################################################################################################################################################################################
##########################################################################################################################################################################################
2) If RCU gets failed due to below error then run sql "revoke connect from dev_mds";
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
RCU-6083:Failed - Check prerequisites requirement for selected component:MDS
Please refer to RCU log at ....\OBIEE\RCU\rcuHome\rcu\log\logdir.2017-01-15_14-01\rcu.log for details.
The schema owner 'DEV_MDS' is connected to the database. Please disconnect and try again.
RCU-6092:Component Selection validation failed. Please refer to log at ....\OBIEE\RCU\rcuHome\rcu\log\logdir.2017-01-15_14-01\rcu.log for details.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
##########################################################################################################################################################################################
3) If login page is working and unable to login to application with weblogic user and if BIserver logs and presentation server logs says below:
BI Server:
ISSUE:
Error retrieving user/group data from Oracle BI Server’s User Population API.
Unable to create a system user connection to BI Server while running user population queries
[2017-02-15T18:47:53.228+05:30] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 5480fcdc22ba98bf:35c9780b:15a41c710ef:-8000-00000000000003fd,0:1:1:6] [tid: 12a4] [nQSError: 13057] Error From BI Security Service: SecurityService::execute [OBI-SEC-00048] Identity store provider error. [[
********** Task: 1. Running for (mls): 21047 **********
Description: Authenticate
RPID: Star; user: weblogic; AppType: 0; Offline: false
[2017-02-15T19:08:36.94+05:30] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 00idmWJQjAOFw0zknV0DVz5NPoU2zmYwD00033400001_,0] [tid: 2010] [nQSError: 13057] Error From BI Security Service: SecurityService::execute [OBI-SEC-00048] Identity store provider error. [[
********** Task: 1. Running for (mls): 21094 **********
Description: Authenticate
RPID: Star; user: BISystemUser; AppType: 0; Offline: false
Resolution for Above Issue:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
https://lorddisk.wordpress.com/2014/12/12/unable-to-create-a-system-user-connection-to-bi-server-while-running-user-population-queries/
To confirm that the password is correct:
Log into Oracle WebLogic Server Administration Console.
Go to Domain Structure and click Security Realms, and select myrealm. The Settings for myrealm page displays.
Click the Users and Groups tab, and then the Users subtab.
In the Users table, locate and select the user that has the BISystem role assigned to it. The settings page displays.
Click the Passwords tab and reset the user password. Click Save.
Log into Fusion Applications Control.
Open the WebLogic Domain node and right-click BIDomain.
Select Security, and then select Credentials.
Select oracle.bi.system and the select system.user.
Edit the password to match the user password that you set in Oracle WebLogic Server.
Restart the Oracle BI Administration Server, Oracle Managed Server, and Oracle Process Manager and Notification Server
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Presentation Server:
-------------------------------------------
ISSUE1:
[OBIPS] [WARNING:1] [] [saw.catalog.local.checkforcatalogupgrade] [ecid: ] [tid: ] Upgrade is recommended to the latest catalog version.[[
Resolution for Above Issue:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
Upgrade OBIEE 11g catalog
http://obieelearner.blogspot.in/2012/07/upgrade-obiee-11g-catalog.html
http://obieeil.blogspot.in/2014/06/obiee-cant-open-catalog-offline-or.html
I have been getting a warning in the OBIPS log:
OBIEE 11g: Warning: "Upgrade is recommended to the latest 11.1.1.6.0 (Build 120104.0800 64-bit) catalog version" After Upgrading to OBIEE 11.1.1.6
so i decided to upgrade the catalog:
Here are the steps:
Note: RPD should be consistent and take a backup of catalog before starting
Step 1: Stop OBIPS
cd ORACLE_INSTANCE/bin
opmnctl stopproc ias-component=coreapplication_obips1
Step 2: find and set the tag UpgradeAndExit to true from false in instanceconfig.xml
<UpgradeAndExit>true<UpgradeAndExit>
Step 3: Start OBIPS
cd ORACLE_INSTANCE/bin
opmnctl startproc ias-component=coreapplication_obips1
Step 4:
After the catalogs are updated, edit the instanceconfig.xml file again and change the upgradeAndExit option back to false.
Step 5: Restart all services.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
ISSUE2:
[2017-02-15T18:19:49.000+05:30] [OBIPS] [ERROR:31] [] [saw.rpc.client.impl.verify] [ecid: 00idmT_^XCnFw0zknV0DVz5NPoU2zmYwD0002yo000004,0] [tid: 9108] An error occurred during connect to "10.10.10.10:9810". No connection could be made because the target machine actively refused it.
Resolution for Above Issue:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
https://community.oracle.com/thread/3519959?db=5
Try the following to see if it helps
Check in Database where rcu is installed , Check User is Locked
"SELECT username, account_status FROM dba_users;"
List of Locked Users
"SELECT username,account_status,lock_date from dba_users where lock_date IS NOT NULL;"
Unlock User
"ALTER USER user_name IDENTIFIED BY password ACCOUNT UNLOCK;"
RESOLUTION:
Connect to WebLogic Server (WLS) Console -> Deployments. Ensure that all deployed components are in ‘Active’ state.
Use the command prompt to verify the opmn status, as the EM console will not always reflect the correct status.
If any of the components is in ‘Prepared’ state, select that application and then click on “start servicing all requests”.
Restart BI Server and Presentation Services
If this does not resolve the issue please follow the steps below:
In some cases, the following additional step might be needed to resolve the issue.
Access the Enterprise Manager Fusion Middleware control: http://<host.domain>:port/em
Navigate to Business Intelligence -> coreapplication
‘Capacity Management’ tab -> ‘Scalability’ sub-tab
Click on ‘Lock and Edit Configuration’ button
Enter the IP address in the ‘Listen Address’ field
Click on ‘Activate Changes’ followed by ‘Release Configuration’ buttons.
Restart BI Server and Presentation Services
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
ISSUE3:
[2017-02-15T18:43:38.000+05:30] [OBIPS] [ERROR:31] [] [saw.connectionPool.getConnection] [ecid: 5480fcdc22ba98bf:35c9780b:15a41c710ef:-8000-000000000000026b,0:1:1] [tid: 8196] Authentication Failure.
Odbc driver returned an error (SQLDriverConnectW).
State: 08004. Code: 10018. [NQODBC] [SQL_STATE: 08004] [nQSError: 10018] Access for the requested connection is refused.
[nQSError: 43113] Message returned from OBIS.
[nQSError: 43126] Authentication failed: invalid user/password.
Resolution for Above Issue:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
https://lorddisk.wordpress.com/2014/12/12/unable-to-create-a-system-user-connection-to-bi-server-while-running-user-population-queries/
To confirm that the password is correct:
Log into Oracle WebLogic Server Administration Console.
Go to Domain Structure and click Security Realms, and select myrealm. The Settings for myrealm page displays.
Click the Users and Groups tab, and then the Users subtab.
In the Users table, locate and select the user that has the BISystem role assigned to it. The settings page displays.
Click the Passwords tab and reset the user password. Click Save.
Log into Fusion Applications Control.
Open the WebLogic Domain node and right-click BIDomain.
Select Security, and then select Credentials.
Select oracle.bi.system and the select system.user.
Edit the password to match the user password that you set in Oracle WebLogic Server.
Restart the Oracle BI Administration Server, Oracle Managed Server, and Oracle Process Manager and Notification Server
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
##########################################################################################################################################################################################
