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

EAL Data Sync Server is not showing as Available and Data Sync Server Data is not Available

We had a situation like EAL services are running in Service Panel but still EAL Data sync not showing up in EAS console.

Some points we can check in EAL while trouble shooting:

1. If you see any socket errors and Data sync not available in EAS console, you can restart EAL services. It will fix the issue in maximum chances.

2. We need to check schema passwords used for HFM and EAL.

3. We need to check Target and Source. If it is HFM to Essbase, we can check Essbase connections, and HFM regions.

4. If source and target is schema and HFM, we need to check schema connectivity and HFM regions.

5. Check out password for dss_admin (default admin username for EAL, while doing configuration we will give this username and password) in EAL setup correct or not.

6. Check out schema passwords connect or not.

7. Chec the log files in below location:
D:\Oracle\EAL_Home\EssbaseAnalyticsLink\Work\dss.log
D:\Oracle\EAL_Home\EssbaseAnalyticsLink\Work\eal.log

8. Port numbers are reachable or not:
   -   Verify ports 5024, 5423 ports are open.
   -   Check for any recent security updates or anti virus updates that happened?

In our case, EAL Data sync not showing up as available in EAS console. So, We tried to reconfigure EAL and code.xml file got corrupted and showing up as 1 KB where as in other Environment it is more than that size.

So, we restored files from backup and restarted services. Ran Region default for Testing. It ran successfully and Data sync is available now and Data sync Data is now On.

Oracle update on the same for our future reference:

Analysis and follow up done by Kamalanathan Prabhakaran.

Thanks,
Mady

Single Sign On Authentication Failed. You Are Not Authorized To Use System, Contact Your Administrator

While accessing SSO enabled Workspace, we were facing the below issue, as we need to allow SSO in Registry.

Solution:
- To update a component property, go to EPM_ORACLE_INSTANCE/bin and run the following command:

- epmsys_registry updateproperty WORKSPACE/LOGICAL_WEB_APP/@AllowDirectLogonAfterSSO true;

Thanks,

Mady

Commands for HFM Maintenance

HFM Maintenance commands:

select count(*) from hfm_errorlog;

select count(*) from <Application Name>_task_audit;

To clear HFM userparams:

select * from <Application Name>_userparams where username = 'username@Native Directory'

delete from <Application Name>_userparams where username = 'username@Native Directory'


Thanks,
Mady

ODI - File to Planning Metadata

Thanks,

Mady