Essbase Error (1020051): Maximum number of rows processed[250000] exceeded [250000]

During Adhoc Analysis( Zoom in to next level) in  Smart View you may encounter the below error:
Essbase Error (1020051): Maximum number of rows processed[250000] exceeded [250000]



Issue:
Essbase is configured to restrict 250000 rows.

Fix:-

To increase the limit from 250,000 to 500,000 or above update the essbase.cfg with the below parameter.


echo "SSPROCROWLIMIT 500000" >> essbase.cfg


epmprod#>grep SSPROCROWLIMIT essbase.cfg
SSPROCROWLIMIT 500000

DRM Create new Application

How to create a DRM Application.

Open the DRM Console.

Click Add and key in the details for the data base related and test the connection.

Click the repository creation wizard.

Here you have two options,
1) You can create the repository using DB - Admin credentials.
2) Generate the SQL scripts and hand them to DBA to execute the create scripts.

I am using the 2nd option here.

Click Next and modify the details according to your needs.

Click on "BACKUP FILE"

Click Next and save the file.

Click Finish.

Have the scripts executed in the DB.

Confirm the DB connection details in the repository configuration.

Start the Application.

Test the connection via web client.
http://shaikprdapp1.shaik.com/drm-web-client/Forms/Administer/Select.aspx
Login:  Admin/Welcome!  <-- If you created the repository using scripts.

rtld: 0712-001 Symbol CreateIoCompletionPort

Issue:
/u0/app/grid/12.1.0.2/bin =>./crsctl check has
exec(): 0509-036 Cannot load program crsctl.bin because of the following errors:
rtld: 0712-001 Symbol CreateIoCompletionPort was referenced
      from module /u0/app/grid/12.1.0.2/lib/libttsh12.so(), but a runtime definition
      of the symbol was not found.
rtld: 0712-001 Symbol GetMultipleCompletionStatus was referenced
      from module /u0/app/grid/12.1.0.2/lib/libttsh12.so(), but a runtime definition
      of the symbol was not found.
rtld: 0712-002 fatal error: exiting.

Fix:

Enable the "iocp" option and  relink the oracle binaries.
To enable IOCP, set IOCP to Available using the following procedure:

Log in as root and run the following command:

# smitty iocp
Select Change / Show Characteristics of I/O Completion Ports.

Change configured state at system restart from Defined to Available.

Run the lsdev command to confirm the IOCP status is set to Available:

$ lsdev | grep iocp
iocp0 Available I/O Completion Ports


Reference:
AIX 12.1.0.2 Installation Fails with "rtld: 0712-001 Symbol CreateIoCompletionPort was referenced " (Doc ID 1949184.1)

EPM Planning shared services integration with OID/OVD

How to Integrate OID in EPM Planning 11.1.2.4:

You need:
OID/OVD Host name & Port
Base DN(distinguished name)
User DN
Password for User (OID Connection)

Step-1:

Login to your workspace:
Go go Navigate --> Administer --> Shared Services Console

Click on Administration on Top:

 From Top down "Select Configure User Directories" & New

 Select LDAP " For Open LDAP/OID/OVD"

Select the directory type as OID:


Key in the details related to OID as shown below:

Click Save and Okay:

If you still want to keep the Primary directory   as Native then move down the newly created directory.
Remember your "Admin" login belongs to only Native then have the Native directory on the top of the list.

Search for the users from the OID

Note:-  If you are using OVD Then select the directory type to "Other"  and leave the "ID Attribute" to blank.

Provision the user and try to login as that user:

EPMINS-01047: The dbclient64 assembly is missing. The assembly is required in order to install a selected component.

During EPM 11.1.2.4 install on a UNIX platform, you may get the below error when you select Oracle client option.

Oracle Database Client 64-bit

Errors:

   Blocker:

      EPMINS-01048: Cannot install a selected component. See the Troubleshooting Guide for more information.

   EPMINS-01045: One or more required assemblies are missing; cannot install one or more selected components. See the Troubleshooting Guide for more information.:

      EPMINS-01047: The dbclient64 assembly is missing. The assembly is required in order to install a selected component.

   EPMINS-01076: One or more required native installers are missing; cannot install one or more selected components. See the Troubleshooting Guide for more information.:

      EPMINS-01075: The db64 native installer is missing. The installer is required in order to install a selected component.

   EPMINS-01046: The installation checks required to run EPM System Installer did not succeed. See the Troubleshooting Guide for more information.:

      EPMINS-01051: The selected product is not available for this operating system.

Status: EPMINS-01016: Cannot install the selected component. Click Help to see possible reasons.

In fact this is not an error message and you can safely ignore this message:

There are no assemblies for the Oracle database clients on LINUX/UNIX installations.  Per the EPM Installation and Configuration Guide, the EPM System Installer installs the Oracle Database client automatically if it is required on a machine (Windows only, Performance Management Architect only). 

Deselect the options "Oracle Database Client 64-bit" & "Oracle Database Client 32-bit" from the EPM installer menu and proceed with the Installation.  

If needed, install the Database Clients separately not 

through the EPM Installer.