HFM dssstartup Option in Hyperion 11.1.2.4

It is possible that sometimes Xfmdataosurce tends to get hung and will not shutdown gracefully. But it should be a rare scenario and not happening regularly. Also We need make sure DB is fine and there is no network issues or other environmental issues.

Generlly dsstartup option as 0 which is default. This means when application will be shutdown automatically when the last user logs out. Frequent shutdown and startup can also cause issues sometimes. It is better to make dsstartup option to 2 which means application datasource starts when first user tries to login and will be active until HFM Java services are stopped.

To do this open Workspace go to Navigate->Administer->Consolidation Administration->System-> Settings-> Look for DSSStartup options in the list of settings and change the value to 2 and save it, Log out and Restart HFM Services for changes to take affect.


Thanks,
Mady

Weblogic Managed server showing up as Unknown status

We have installed and configured Hyperion 11.1.2.4 Shared services in 2 servers as part of Load Balancing requirement for one of client.

We got 2 foundation services in weblogic but whenever we have started Admin Server, Foundation Services and check Managed Servers status. One server showing up as Running Status but another is showing up as Unknown.

As part of troubleshoot, initially we have restarted services, no luck, Then cleared tmp and cache, no luck. Redeployed and foundation in server2 still it is showing up as Unknown.

Here we have observed 2 things, Server Host names. Server1 showing up short name but Server2 is in fully qualified name. For this tried to add hostnames with short, fdqn with IP address. Services running in second server but Unknown status not changed.

Whenever we restarted services, we observed that Foundation is communicating with IPV6 but IPV4.

So we have disabled IPv6, then restarted foundation service on Server2. Now Status showing up as Running.

Thanks,
Mady

Auditing in Shared services

Going through some posts in OTN forums, found some information which will be useful.

Information is about who provisioned/created/deleted/updated users from shared services

CSS_IDENTITY and CSS_PROVISIONING_INFO which provide all relevant information.

Shared Services audit tables start SMA_AUDIT_* , for example SMA_AUDIT_FACT

For detailed explanation about data models, check out below link:
https://docs.oracle.com/cd/E57185_01/epm_data_models.zip

Thanks,
Mady

MSAD Configuration

Most of the clients will use Active Directory which we can integrate with Hyperion Shared Services.

We need AD server details, username, password for communication, Ports we use for connectivity.

Check out below screen shots to setup and AD in Hyperion Shared Services.

Go to Shared Services console - Native directories - Administration - Configure User directories - Click on New - Enter the details which we got or collected from AD team - Click on Finish.

Try to search/retrieve AD users now in MSAD group. 

We need to keep MSAD in Top in list, because in case of searching if we put AD in first and it will go through AD first then Native. 

Note: whenever we do setup and do changes or change order of MSAD in list, we need to bounce Services to take effect.

Thanks,

Mady

EPMA Application Library and Dimension Library not opening

Hyperion 11.1.2.4 installation and configuration completed, but when try to open Application Library and Dimension Library, we are getting below error:

; nested exception is: 
  HTTP transport error: javax.xml.soap.SOAPException: oracle.j2ee.ws.saaj.ContentTypeException: Not a valid SOAP Content-Type: text/html; charset=utf-8"

Oracle Support Article Soultion:

Accessing Application Library from Workspace Get Errors "HTTP transport error: javax.xml.soap.SOAPException: oracle.j2ee.ws.saaj.ContentTypeException: Not a valid SOAP Content-Type: text/html; charset=utf-8" (Doc ID 1932114.1)

1.  Right click on E:\Oracle\Middleware\EPMSystem11R1\products\Foundation\BPMA\AppServer\DimensionServer\WebService\web.config and click on Properties.
2.  Click on Security.
3.  Click on Edit.
4.  If SYSTEM is not listed, click on Add, Type "SYSTEM" Click on "Check Names"
5.  Click on SYSTEM and click Allow Check box for "Full Control"
6.  Click Ok
7.  Stop EPMA Services
8.  Stop Microsoft Internet Information Services (IIS)
9.  Start Microsoft Internet Information Services (IIS)
10. Start EPMA Services

One more tip from John Goodwin:

To prove whether it is an issue with the ApplicationPoolIdentity identity, you can go to the default app pool in IIS and change the identity, then restart IIS.

Changing local system will work for application library and dimension library accessing.

Thanks,
Mady

Create ODBC for Essbase in Linux - Oracle Wire Protocal

1. Browse the odbc file in the below location:
/oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/bin

2. Open odbc.ini file and go to Oracle Wire Protocal

Note: To connect to Oracle Database, here we are using Oracle Wire Protocal. If you are trying to connect other Database, search for that Protocal in the list and update DB details in that Section

3. Update Servername, SID and Port Number as shown below:
[Oracle Wire Protocol]
Driver=/oracle/Middleware/EPMSystem11R1/common/ODBC-64/Merant/7.0/lib/ARora26.so
Description=DataDirect 7.0 Oracle Wire Protocol
AlternateServers=
ApplicationUsingThreads=1
AccountingInfo=
Action=
ApplicationName=
ArraySize=60000
AuthenticationMethod=1
BulkBinaryThreshold=32
BulkCharacterThreshold=-1
BulkLoadBatchSize=1024
BulkLoadFieldDelimiter=
BulkLoadRecordDelimiter=
CachedCursorLimit=32
CachedDescLimit=0
CatalogIncludesSynonyms=1
CatalogOptions=0
ClientHostName=
ClientID=
ClientUser=
ConnectionReset=0
ConnectionRetryCount=0
ConnectionRetryDelay=3
DefaultLongDataBuffLen=1024
DescribeAtPrepare=0
EditionName=
EnableBulkLoad=0
EnableDescribeParam=0
EnableNcharSupport=0
EnableScrollableCursors=1
EnableStaticCursorsForLongData=0
EnableTimestampWithTimeZone=0
EncryptionMethod=0
FailoverGranularity=0
FailoverMode=0
FailoverPreconnect=0
FetchTSWTZasTimestamp=0
GSSClient=native
HostName=Servername
HostNameInCertificate=
InitializationString=
KeyPassword=
KeyStore=
KeyStorePassword=
LoadBalanceTimeout=0
LoadBalancing=0
LocalTimeZoneOffset=
LockTimeOut=-1
LoginTimeout=15
LogonID=
MaxPoolSize=100
MinPoolSize=0
Module=
Password=
Pooling=0
PortNumber=1521
ProcedureRetResults=0
ProgramID=
QueryTimeout=0
ReportCodePageConversionErrors=0
ReportRecycleBin=0
ServerName=<server_name in tnsnames.ora>
ServerType=0
ServiceName=
SID=Database/SID
TimestampeEscapeMapping=0
TNSNamesFile=<tnsnames.ora_filename>
TrustStore=
TrustStorePassword=
UseCurrentSchema=1
ValidateServerCertificate=1
WireProtocolMode=1

4. Now try to connect from EAS to check connectivity from EAS to Database.

Thanks,

Mady

DRM Installation

1. Run Setup.exe file and go on with screen Next -> Next -> Finish

2. Launch DRM Console -> Click on Add to create application and save configuration.

3. Start DRM Service then go Repository Wizard.

4. Give DB details admin details for example sa, check out Test Connection.

5. Next screen give user name and schema details which wants to create for DRM application, and give ADMIN password

6. Then click Next to start creating Repository.

7. Once it is done, we need to check application status and validate in web client.

Otherwise, we can run scripts below to create schema and for creating objects in schema.

Change your application schema, user, password details before running this scripts.



Thanks,
Mady