UNIX for Beginners Questions & Answers

which: no Data_Export.sh in (.)

#source /u01/Hyperion_Batch/Scripts/Batch/_env.sh

#::-- Set Script Name --::#
_SN=${0##*/}

#::-- Set Path Variables --::

cd $HOME

_MAINPATH=$(pwd)/Hyperion_Batch/
_LOGPATH=Logs/
_ERRORPATH=Errors/
_SCRIPTPATH=Scripts/
_MAXLPATH=Scripts/MaxL/
_FILEPATH=Files/
_EXPORTPATH=Exports/

#::-- Set Log & Error subdirectory pertaining to specific process --::#

_PLOGPATH=Data_Export_Logs/
_PERRORPATH=Data_Export_Errors/

#::-- Set Date and Time Variable --::#
_DAY=$(date +%d)
_MONTH=$(date +%m)
_YEAR=$(date +%Y)
_DATESTAMP=${_YEAR}${_MONTH}${_DAY}
_HOUR=$(date +%H)
_MINUTE=$(date +%M)
_SECOND=$(date +%S)
_TIME=${_HOUR}${_MINUTE}
_DATETIMESTAMP=${_DATESTAMP}_${_TIME}

#::-- Establish STDOUT and STDERROR repositories --::
_ARC_LP=${_MAINPATH}${_LOGPATH}${_PLOGPATH}${_YEAR}_${_MONTH}${_DAY}
_ARC_EP=${_MAINPATH}${_ERRORPATH}${_PERRORPATH}${_YEAR}_${_MONTH}${_DAY}
    
mkdir -p ${_ARC_LP}
mkdir -p ${_ARC_EP}

#::-- Prepare File Name Format --::#
_FN=${_TIME}_${_SN%%.sh*}

#::-- Establish STDOUT and STDERROR files --::#
_LF=${_ARC_LP}/${_FN}.log
_EF=${_ARC_EP}/${_FN}.err
_MLF=${_ARC_LP}/${_FN}_MAXL.log

#::-- Direct STDOUT and STDERROR to repositories --::# 
exec 2>${_EF} > ${_LF}

#::-- Set MaxL Specific Variables --::#
_ESSB_USER=admin
_ESSB_PSWD=welcome1
_ESSB_SRVR=exalytics-madc-01.peloton.lan
_ESSB_APP=AUTODEMO
_ESSB_DB=FIN_PLAN

_DATA_EXPORTPATH=${_MAINPATH}${_FILEPATH}${_EXPORTPATH}
_EXPORTTYPE=ALL_DATA

_STARTMAXL=/u02/EssbaseServer/essbaseserver1/bin/startMaxl.sh

#::-- Export Script Variables --::#

export _MAINPATH _LOGPATH _ERRORPATH _SCRIPTPATH _MAXLPATH _FILEPATH _EXPORTPATH _ESSB_USER _ESSB_PSWD  
export _MAXLLOGFILE _DATA_EXPORTPATH _EXPORTTYPE _STARTMAXL _ESSB_SRVR _ESSB_APP _ESSB_DB 
 
#:: Begin Script Processing --::#
echo ---------------------------------------------------------
echo "Begin ${_SN%%.sh*} Process at ${_TIME}"                           
echo                                                                                                        
echo "Execute All Data Export against ${_ESSB_APP}"                                         
echo ---------------------------------------------------------

. ${_STARTMAXL} ${_MAINPATH}${_MAXLPATH}All_Data_Export.mxl ${_ESSB_USER} ${_ESSB_PSWD} ${_ESSB_SRVR} ${_ESSB_APP} ${_ESSB_DB} ${_DATA_EXPORTPATH} ${_EXPORTTYPE} ${_YEAR}${_MONTH}${_DAY} ${_MLF}

if [ $? -eq 0 ]
then
  echo ---------------------------------------------------------
  echo "Essbase All Data Export Successful"                           
  echo ---------------------------------------------------------
  exit 0
  
else
  echo ---------------------------------------------------------
  echo "Essbase All Data Export Unsuccessful"                      
  echo ---------------------------------------------------------
  exit 1
  fi

---------------------------------------------------------
Begin Data_Export Process at 1638

Execute All Data Export against AUTODEMO
---------------------------------------------------------

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

MAXL> login admin welcome1 on exalytics-madc-01.server;

 OK/INFO - 1051034 - Logging in user [admin@Native Directory].
 OK/INFO - 1241001 - Logged in to Essbase.

MAXL> export database AUTODEMO.FIN_PLAN all data to data_file "/home/oracle/Hyperion_Batch/Files/Exports/20161208_AUTODEMO_FIN_PLAN_ALL_DATA.txt";

 OK/INFO - 1005031 - Parallel export completed for this export thread. Blocks Exported: [347]. Elapsed time: [0.25]..
 OK/INFO - 1005002 - Ascii Backup Completed. Total blocks: [347]. Elapsed time: [0.25]..
 OK/INFO - 1005049 - Export completed. Total blocks: [347] Empty blocks: [22] Total empty cells: [3025952] Elapsed time: [0.25] secs.
 OK/INFO - 1013270 - Database export completed ['AUTODEMO'.'FIN_PLAN'].

MAXL> logout;

      User admin is logged out


  MaxL Shell completed

---------------------------------------------------------
Essbase ll Data Export Successful
---------------------------------------------------------