Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.



My Cloud Certifications:

Certified Kubernetes Administrator (CKA)

Cloud Certified Security Professional (ISC2)

CyberSecurity Certified Professional (ISC2)

AWS Certified Solutions Architect Associate

Azure Certified Architect Expert

Azure Certified Architect

Azure Certified Administrator

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

Search This Blog

Showing posts with label essbase. Show all posts
Showing posts with label essbase. Show all posts

Wednesday, July 26, 2017

Hyperion App backups - Unix script


To backup all the apps in Hyperion:


#!/bin/ksh
####################################################################
#                                                                  #
#  Who          When            What                               #
#  ----------------------------------------------------------------#
#  shaiks       24-JUL-17       Created
#                                                                  #
#                                                                  #
####################################################################
#
#set -x

date1=`date +'%d%b%y'`
date2=`date +'%d%b%Y%H%M%S'`

#Set Parameters
if [ ${#} -ne "1" ];then
        echo " Please pass the environment name"
exit 0
else
        ENV=$(echo $1 |tr "[:lower:]" "[:upper:]" )
fi

. /home/hypadm/EPM$ENV.env
if [ $ENV == "DEV" ] || [ $ENV == "TST" ];then
SCRIPTS_DIR=/PATH/scripts
else
SCRIPTS_DIR=/PATH$1/scripts
fi
APP_BACKUP_DIR=/HYP/$ENV/APP_BKP
BACKUP_DIR=$APP_BACKUP_DIR/$date2
LOG_FILE=$BACKUP_DIR/$(basename "$0" | cut -d \. -f1)_$ENV_$date2.log

mkdir -p $BACKUP_DIR
#echo $ENV $date2 $APP_BACKUP_DIR/$date2/ $BACKUP_DIR $APP_BACKUP_DIR $SCRIPTS_DIR $LOG_FILE
Utility.sh $SCRIPTS_DIR/${ENV}_APP_BACKUP_ALL.xml -b $BACKUP_DIR/  > $LOG_FILE 2>&1

#Verify Success or Failure
status=$(tail -n1 $LOG_FILE | grep -i success | awk '{print $4}')
if [[ $status == "Success" ]];then
echo $status | mailx -s "Hyperion $ENV App Backup completed Successfully" sshaiksameer@shaiksameer.com
else
uuencode $LOG_FILE $LOG_FILE | mailx -s "Hyperion $ENV App Backup failed - verify the attached log" shaiksameer@shaiksameer.com

#Delete App backups older than 45 days.
find $APP_BACKUP_DIR -prune -type d -mtime +45 -exec rm -rf {} \;







cat APP_BACKUP_ALL.xml
<?xml version="1.0" encoding="UTF-8"?>
<Package>
    <LOCALE>en_US</LOCALE>
    <User name="admin" password="Your password here"/>
    <Task>
        <Source type="Application" product="BPMA" project="Foundation" application="EPM Architect"/>
        <Target type="FileSystem" filePath="/EPMA-EPM Architect"/>
        <Artifact recursive="true" parentPath="/" pattern="*"/>
    </Task>
    <Task>
        <Source type="Application" product="HUB" project="Foundation" application="Shared Services"/>
        <Target type="FileSystem" filePath="/HSS-Shared Services"/>
        <Artifact recursive="true" parentPath="/" pattern="*"/>
    </Task>
    <Task>
        <Source type="Application" product="HAVA" project="Reporting and Analysis" application="Reporti
ng and Analysis"/>
        <Target type="FileSystem" filePath="/RnA-Reporting and Analysis"/>
        <Artifact recursive="true" parentPath="/" pattern="*"/>
    </Task>
    <Task>
        <Source type="Application" product="ESB" project="EssbaseCluster-1" application="EssbaseCluster
-1"/>
        <Target type="FileSystem" filePath="/ESB-EssbaseCluster-1"/>
        <Artifact recursive="true" parentPath="/" pattern="*"/>
    </Task>
    <Task>
        <Source type="Application" product="HP" project="Planning" application="SHAIK"/>
        <Target type="FileSystem" filePath="/HP-SHAIK"/>
        <Artifact recursive="true" parentPath="/Configuration" pattern="*"/>
        <Artifact recursive="true" parentPath="/Global Artifacts" pattern="*"/>
        <Artifact recursive="true" parentPath="/Plan Type" pattern="*"/>
        <Artifact recursive="true" parentPath="/Security" pattern="*"/>
    </Task>
       <Task>
        <Source type="Application" product="CALC" project="Foundation" application="Calculation Manager
"/>
        <Target type="FileSystem" filePath="/CALC-Calculation Manager"/>
        <Artifact recursive="true" parentPath="/" pattern="*"/>
    </Task>
</Package>

ESSBASE DATABASE Backups scripts in Unix

#!/bin/ksh
####################################################################
#                                                                  #
#  Who          When            What                               #
#  ----------------------------------------------------------------#
#  shaiks       24-JUL-17       Created
#                                                                  #
#                                                                  #
####################################################################
#

date1=`date +'%d%b%y'`
date2=`date +'%d%b%Y%H%M%S'`

#Set Parameters
if [ ${#} -ne "1" ];then
        echo " Please pass the environment name"
exit 0
else
        ENV=$(echo $1 |tr '[:lower:][:upper:]' '[:upper:][:lower:]')
fi

. /home/hypuser/EPM$ENV.env
if [ $ENV == "DEV" ] || [ $ENV == "TST" ];then
SCRIPTS_DIR=/PATH/scripts
else
SCRIPTS_DIR=/PATH$1/scripts
fi
DATA_BACKUP_DIR=/HYP/$ENV/DATA_BKP
BACKUP_DIR=$DATA_BACKUP_DIR/$date2
LOG_FILE=$BACKUP_DIR/$(basename "$0" | cut -d \. -f1)_$ENV_$date2.log

mkdir -p $BACKUP_DIR
#echo $ENV $date2 $DATA_BACKUP_DIR/$date2/ $SCRIPTS_DIR $LOG_FILE

. /home/hypadm/EPM$ENV.env

startMaxl.sh -D ${SCRIPTS_DIR}/essbase_data_backup_all.mxls ${MAXLPVTKEY} ${MAXLENCRID} ${MAXLENCRPWD}
${ESBSERVER} ${BACKUP_DIR} ${LOG_FILE} ${date2}

#Verify Success or Failure
status=$(grep -i error $LOG_FILE | awk '{print $1}'| uniq)
if [[ $status != "ERROR" ]];then
echo "Success"  | mailx -s "ESSBASE $ENV Backup completed Successfully" shaiksameer@shaiksameer.com
else
uuencode $LOG_FILE $LOG_FILE | mailx -s "ESSBASE $ENV Backup failed - verify the attached log" shaiksameer@shaiksameer.com
fi


#Delete Data backups older than 45 days.
find $DATA_BACKUP_DIR -prune -type d -mtime +45 -exec rm -rf {} \;


cat essbase_data_backup_all.mxls
/*Purpose: Data Back-up of all Essbase Databases */
/*    Log in to Essbase    */
login $key $1 $key $2 on $3;

spool on to "$5";

/*    Disable connection to RPT database */
alter application RPT disable connects;

/*    Back-up Reporting Data   */
export database RPT.RPT data to data_file "$4/RPT_RPT_data_export_$6.txt";

/*    Enable connection to RPT database */
alter application RPT enable connects;

spool off;
logout;
exit;


Wednesday, June 7, 2017

Smartview Ad hoc grid cannot be opened as there are no valid rows of data


In smarview when trying to do the ad-hoc analysis you may see the below error message:

Ad hoc grid cannot be opened as there are no valid rows of data
















Fix:

Under Data Options:
you should clear the suppress options in the Data Options tab of the Options dialog box. Ensure that all Suppress Rows and Suppress Columns options are cleared, and that the Suppress missing blocks option is cleared



Friday, May 12, 2017

Cannot open file: [\Middleware\user_projects\epmsystem1\tmp\tempfile46694208.txt] Unexpected Essbase error 1030100


Issue:

Cannot Open/load data when Importing Data Using the Essbase Administration Services Console (EAS)

 Unexpected Essbase Error 1030100







Fix:
Rename the data file to .txt extension and then try again

An Unpublished Enhancement Request has been filed to support files with any extension: Bug 23537231

Monday, March 13, 2017

WARNING - 1040156 - SSL initialization failed with error code [1040132]..


Issue:

Copied Maxl and other components from Essbase server to Planning server in order to run scripts from the Planning server. While logging into Maxl you may see the below error:

 startMaxl.sh

 Essbase MaxL Shell 64-bit - Release 11.1.2 (ESB11.1.2.4.014B009)
 Copyright (c) 2000, 2016, Oracle and/or its affiliates.
 All rights reserved.

MAXL> login admin XXXXX on shaikprodess.shaik.com;

 WARNING - 1040156 - SSL initialization failed with error code [1040132]..
 OK/INFO - 1051034 - Logging in user [admin@Native Directory].
 OK/INFO - 1241001 - Logged in to Essbase.

MAXL> quit ;

  MaxL Shell completed


Fix:-
ewallet.p12 or cwallet.sso may be corrupted or missing.

Ensure you copied the correct ewallet.p12 & cwallet.sso files from the $ARBORPATH/bin/wallet  from the essbase server.

In my case I copied the wrong wallet from the Essbase server and after copying the correct wallet files, the error message is gone.

shaikprodplan#>scp shaikprodess.shaik.com:$ARBORPATH/bin/wallet/* wallet/


Inovke the maxl and check again.

MAXL> login admin XXXXX on shaikprodess.shaik.com;
 OK/INFO - 1051034 - Logging in user [admin@Native Directory].
 OK/INFO - 1241001 - Logged in to Essbase.

MAXL> quit ;

  MaxL Shell completed


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