Skip to main content

Temp files related issues on your Essbase Server



While running an Aggregation process or a restructure in essbase have you ever encountered either of these:
  1. EAS quits accepting logins
  1. Essbase going down time and again.
  1. Failed Data load / Failed Data Export / Failed Level 0 export
  1. All of the above together :)

In all these cases, there is a huge possibility that you are facing creation of tmp files issue on your Essbase Server, specifically if you are on Linux
The Temp directory contains mostly files that are required temporarily. Many programs use this to create lock files and for temporary storage of data. Do not remove files from this directory unless you know exactly what you are doing! Many of these files are important for currently running programs and deleting them may result in a system crash. Usually it won't contain more than a few KB anyway. On most systems, this directory is cleared out at boot or at shutdown by the local system.
In MS-Dos and Windows, the temporary directory is set by the environment variable TEMP. In UNIX and LINUX, the global temporary directories are /tmp and /var/tmp.Typically, /var/tmp is for persistent files (as it may be preserved over reboots), and /tmp is for more temporary files.
Generically when the size of these temp files increases and occupies whole of your disk space (90-95%), you might run into any of the above mentioned issues.

A simple solution is in steps below:
  1. Stop the EAS server.
  1. On the box where EAS is installed, split out the two temp folders that are under Oracle\Middleware\user_projects\domains\EPMSystem\servers\EssbaseAdminServices1\tmp
  1. Next, make a sibling folder to tmp called tmpeas, and change the JVMOPtion for the io tmp to point to that tmpeas folder.
  1. In Windows, JVMOption (value is -Djava.io.tmpdir= C:\Oracle\Middleware\user_projects\epmsystem1\tmp) for each product (HKLM\Software\Hyperion Solutions) and redirect it to value where there is enough space to hold these files.
  1. Restart EAS server, test and monitor to see if the issue occurs again.

Since creation of Temp files is a regular issue, and the JVMOption is only going to redirect your temp files to another location (where you can afford to keep them!!).
Another option to avoid such kind of failures in systems will be to schedule a regular clean up of such temp files in Essbase Server.

In Linux, the below script would work usefully:

#!/bin/bash
#This script will automatically delete temporary files
rm -rf /tmp/*
rm -rf/var/tmp/*
fsck -A
exit

In Windows, you can create a batch file to delete your Temp folder on a variance of certain days (here, 5 days)

REM Remove files older than 5 days
forfiles /p "<default path to temp file location on windows\Local>\Temp" /s /m *.tmp* /c "cmd /c Del @path" /d 5
Cheers,
Anvi S.

Popular posts from this blog

Planning Admin Extension

Planning 11.1.2.3 – Smart View metadata management One of the new features in planning 11.1.2.3 is the ability to manage dimensional metadata through Smart View  • The new Hyperion Planning Admin Extension for Smart View allows Oracle Hyperion Planning administrator users to import and work with metadata in Smart View. • With this extension, Planning administrators can use Oracle Hyperion Smart View for Office applications to perform these tasks: 1. Add, edit and import existing Oracle Hyperion Planning dimensions and members, including moving members and designating members as shared in Smart View 2. Create and refresh cubes • The extension can be downloaded from the Tools menu in workspace. • This will download a file called “ PlanningSVExtension.msi ” which is 1.4mb in size and can be easily installed by running the msi . Once you Install Planning Admin Extension A Smart View Set up Wizard opens up for the extension installation. Click on Next :
Home

Shared Connection and Private Connection

You connect to data sources through shared or private connections. Shared Connections •Shared connections are stored in a central location and are available to multiple users through the Smart View Panel. You cannot add, edit, or rename shared connections, but you can save them as private connections, which you can edit and rename. Private Connections •Private connections are those that you create by saving a shared connection to your local computer or by entering a URL to a provider that is not configured for shared connections. When you create a private connection, it becomes the active connection. Shared Connections : 1. From the Smart View ribbon, click  Panel . 2. From Smart View Home or from the menu displayed when you click the arrow next to Home button, do one of the following: • Click a connection name under  Recently U sed . You can click    to pin items to this list. • Select  Shared Connections  to open the Shared Connections panel, where you s
Home

Import Security : Planning

There will be a huge number of requests to grant or remove security access for users. For one or two changes, it is simple task, click on member and then assign access and grant permission. It becomes tiresome when we need to make changes for large number of members. It involves considerable amount of time. Automating the security changes saves considerable amount of time. The ImportSecurity utility in planning loads access permissions for users or groups from a text file into Planning. Importing access permissions using Import security utility overwrites existing access assignments only for imported members, users, or groups. All other existing access permissions remain intact. The SL_CLEARALL parameter clears all existing access permissions. ImportSecurity utility is located at /Hyperion/Oracle/Middleware/user_projects/epmsystem1/Planning/planning1 on Planning server as shown in the following picture: Steps for importing access permissions: STEP1 :Create a text
Home