Security Hardening of Hyperion 11.1.2.4 Part 1

There have been a few recurring requests from various clients to make Hyperion Workspace URL, SmartView URL available on TLS 1.2 and then pass all the penetration tests conducted by various software. We setup OHS 11.1.1.9 (instead of the default OHS 11.1.1.7) to support TLS 1.1 onwards. On conducting...

Read More

Groups are not displayed after configuring SQL Authenticator with OBIEE 12C

On a newly installed OBIEE 12c server, we configured the SQL Authenticator but we were unable to list the Groups though there were no errors initially as the datasource was unable to connect to the database itself. Once we fixed below warning we got a few errors which showed that the tables were messed up. Here is how we fixed the first warning. Nov 16, 2017 3:45:21 PM oracle.bi.security.provider.wls.authentication.dbms.SQLGroupProviderDelegateImpl...

Read More

JDBC Version with EPM 11.1.2.4

Did you ever wonder which version of JDBC we use with Hyperion 11.1.2.4 ? Here is how you find out. 1. Go to E:\Oracle\Middleware\jdk160_35\bin 2. java -jar E:\Oracle\Middleware\wlserver_10.3\server\lib\odbc6.jar -getversion 3. Hyperion 11.1.2.4 uses JDBC 4.0 version and ODBC 6.0 ...

Read More

Importing wildcard certificates into a java keystore

Weblogic managed servers support java keystores (.jks) but you have received signed wildcard certificates(.crt) which cannot be directly imported into the keystore. You may get below error: Error keytool error: java.lang.Exception: Input not an X.509 certificate java.lang.Exception: Input not...

Read More

HPCM 11.1.2.4.123

Error: Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "ENABLED_FLG": invalid identifier Symptoms: Launching HPCM application from Workspace gives above error post patching HPCM with 11.1.2.4.123 patch. Solution: Manually run this step from the Read Me: Run the following database update script in the Profitability and Cost Management product schema/user using Oracle SQL Developer: <EPM_ORACLE_HOME>\products\Profitability\database\Common\Oracle\create_11.1.2.4.120.sql This...

Read More