Export to an external directory (Schedule Batch)

A customer called me that he would like to know why he could not select an ‘Export’ folder in the schedule Batch option.

After some debugging I found out that we had to change some things in the ‘FRConfig.cmd’. Located here: <Middleware_home>\EPMSystem11R1\products\financialreporting\bin\FRConfig.cmd

 

Within this file you have to change the ‘Java_home’ like:

set JAVA_HOME="D:\Oracle\Middleware\jdk160_29"

But then we had the problem that we could not save the entry in the ‘Mbeans’ So I found out that you have to change also the ‘setInstance.cmd’ file (in the same directory)

set EPM_ORACLE_INSTANCE=D:\Oracle\Middleware\user_projects\epmsystem1

Now when you start the FRConfig.cmd and go to: MBeans à com.hyperion à attributes à ExportFolders you can fill in the share or disk where you want to export the reports.

 

Remember to put is as follows: Name=share
ReportShare=\\<hostname>\Export_Report_folder

Restart you EPM system and your done:

 

Essbase Error (1020011): Maximun number of rows [5000] exceeded.

Some days ago a client called with a problem in smartview.
He was making a large sheet but when retrieving he was getting a error:

The solution was ‘simple’:
In the APS  (Provider Services) there is a file that limits the maximum records that can be retrieved.

You can edit the file ‘essbase.properties’ to remove the limit.
To find the file , you can just go to the webpage of your installation:
http://localhost:9000/aps/APS (in weblogic)
http://localhost:19000/aps/APS (in OHS)

Edit the file ‘D:\Oracle\Middleware\EPMSystem11R1/common/EssbaseJavaAPI/11.1.2.0/bin/essbase.properties' so that smatview can retrieve more than 5000 records.

Go to the following line: ‘service.olap.dataQuery.grid.maxRows’
# Specifies maximum rows/columns for dataquery grid. 0 value indicates no limit.
#service.olap.dataQuery.grid.maxRows=5000
service.olap.dataQuery.grid.maxRows=0
service.olap.dataQuery.grid.maxColumns=255

Keep in mind that Excel has a limit in record that can be handled:
Excel 2003: 65536
Excel 2010: 1048576


Restart the APS and your done.

Error(1042006) Network error [10061]: Unable to connect to [hostname:port] Essbase 11.1.1.3

A couple of weeks ago a customer of mine had a strange error:

 

 

 

 

Error(1042006) Network error [10061]: Unable to connect to [xxxxxxxxxxxxx.xxxxxx.xxxxx:142]. The client timed out waiting to connect to Essbase Agent using TCP/IP. Check your network connections. Also make sure that server and port values are correct]

This error was when he wanted to add a ‘location alias’ in EAS. Also when he wanted to do a ‘Xref’ it did not work and the business rules we not working correct.

Solution

After some long digging around I found the problem: EAS and Essbase can’t function when the essbase name in EAS has more than 30 characters (incl port number).

After I removed the essbase server from EAS and added a new one (shortened) the error did go away and my customer could work again with EAS.

EAS outline won’t expand or members can’t be created.

Ever had the problem when installing EAS client that you can't expand the outline of your essbase cube/program.

Well I had to do some digging but found the problem. When users are using the EAS console the program want’s to write something in a specific directory

‘D:\Oracle\Middleware\EPMSystem11R1\products\Essbase\eas\console\temp’

You have to change the permissions of this directory in order to let the users make use of the EAS program. You need to have 'write' permissions set for the users that are using the EAS client.

 

PKI-02002: Unable to open the wallet. Check password

A few days ago, a customer called and said that he could not login in EAS anymore. But when he was using HPL (Planning) or Smartview he could connect to the essbase.

I did some basic checks, and found the problem:

• Disk where EPM was installed was 100% full (743kb free space).
• EPM was not starting up anymore, after a restart
• Log was showing:

oracle.security.jps.internal.credstore.ssp.CsfWalletManager openWallet

 WARNING: Opening of wallet based credential store failed. Reason java.io.IOException: PKI-02002: Unable to open the wallet. Check password. oracle.security.jps.service.credstore.CredStoreException: JPS-01050: Opening of wallet based credential store failed. Reason java.io.IOException: PKI-02002: Unable to open the wallet. Check password. at oracle.security.jps.internal.credstore.ssp.CsfWalletManager.openWallet(CsfWalletManager.java:177) at oracle.security.jps.internal.credstore.ssp.SspCredentialStore.doInit(SspCredentialStore.java:218) at oracle.security.jps.internal.credstore.ssp.SspCredentialStore.<init>(SspCredentialStore.java:140) at oracle.security.jps.internal.credstore.ssp.SspCredentialStore.<init>(SspCredentialStore.java:127) at oracle.security.jps.internal.credstore.ssp.SspCredentialStoreProvider.getInstance(SspCredentialStoreProvider.java:114)

 
Solution
Because the disk was complete full the file ‘cwallet.sso’ was corrupte.
Oracle states that you could place a backup or generate a new file. This could be done:

ORACLE_MW_HOME/oracle_common/bin/orapki wallet create -wallet ORACLE_MW_HOME/user_projects/domains/EPMSystem/config/fmwconfig -auto_login_only

This solution did not work for me. EPM still does not start up and EAS was unable to login essbase.
The real solution was simple:

• Rename ‘ORACLE_MW_HOME/user_projects/domains/EPMSystem/config/fmwconfig/cwallet.sso’ to ‘ORACLE_MW_HOME/user_projects/domains/EPMSystem/config/fmwconfig/cwallet.sso_corrupt’.
• Copy ‘ORACLE_MW_HOME/user_projects/domains/EPMSystem/config/fmwconfig/bootstrap/cwallet.sso’ to the directory ‘ORACLE_MW_HOME/user_projects/domains/EPMSystem/config/fmwconfig/’
• Restart EPM and your done.

Error connecting to database connection : Class not registered

Ever wondered why you get a ‘Class not registered’ when you are adding a database connection within workspace in release 11.1.2.2?

Well here is the deal: In 11.1.2.2 the HFM client is altered, and you cannot configure the DCOM user. So instead of configuring it within the client you now have to do it in the Oracle EPM itself.
• First: stop all Oracle EPM processes (stop the complete EPM suite)
• Second: install the ‘HFM Adm Driver’ if you didn’t already.
• Third: configure the DCOM in the ‘EPM Sytem Configurator’.
• Fourth: Start Oracle EPM again.


Now you could go to the workspace and add a database connection to the Financial Management.
 

Change the default Oracle HTTP server page

When you are installing Oracle EPM with an Oracle HTTP server you will see the next page.

This is the default page of the Oracle HTTP server (OHS). Several of our customers do not want to see this and asking me to change this to the default login page.

Below are the steps to change this:


1.      Login the foundation server (web server).
2.      Create a backup of the file:
$EPM_ORACLE_HOME\EPMsystem1\httpConfig\ohs\config\OHS\ohs_component\htdocs\welcome-index.html. 
3.      Edit the file and remove everything that is inside the file and replace it with:

<html><head>
   <title>Oracle EPM 11.1.2.x</title>
         <meta http-equiv="refresh" content="0; url=http://the.url.to.your.epm.server:19000/workspace/index.jsp">
   </head>
     <body>
         <p>
         Click to goto the Oracle EPM workspace: <a href=" http://the.url.to.your.epm.server:19000/workspace/index.jsp"> http://the.url.to.your.epm.server:19000/workspace/index.jsp</a>
         </p>
     </body></html>


4.      Save the file and go to the page in your web browser. If it doesn’t work please force a refresh and/or clean your temp internet files and try it again