Error in Executing dsjob: module libvmdsapi.so not found
Posted: Thu Aug 03, 2006 10:24 am
Hi
I have created a shell script to Execute Datastage job but I am getting thos error while executing it.
Please suggest what to do on my part. This is the code which I have used:
I have created a shell script to Execute Datastage job but I am getting thos error while executing it.
Code: Select all
Could not load program /appl/ascential/Ascential/DataStage/DSEngine/bin/dsjob:
Dependent module libvmdsapi.so could not be loaded.
Could not load module libvmdsapi.so.
Please suggest what to do on my part. This is the code which I have used:
Code: Select all
#!/bin/ksh
############################################################################
# Program : DSExecuteJob.ksh
#
# Input : Datastage Job Name, Datastage Project Name
#
#
# Output Parameters: 0 - For Success
# Error Description - For failure
#
# Developer : Avishek
#
# Date : August-03-2006
#
# Modification History
# Version Modified by Date Modified Modification
# --------------------------------------------------------------------------
############################################################################
############################################################################
#
# Store Input Parameters in Shell Variables
#
############################################################################
FILE_NAME=`basename $0 .ksh`
DSJOBNAME=$1
DSPROJNAME=$2
DSSERVER="schdcbss01"
DSUSERID="mukherav"
DSPASSWORD="Infy@2003"
BinFileDirectory=`cat /.dshome`/bin
PARAMLIST=0
DSLOG="DS_"$DSJOBNAME
echo $DSJOBNAME
echo $DSPROJNAME
echo $DSSERVER
echo $DSUSERID
echo $DSPASSWORD
echo $BinFileDirectory
echo $PARAMLIST
echo $DSLOG
DSLOG_FILE=/WSI/ETL/Conversion/LogFiles/Misc/$DSLOG.log
echo $DSLOG_FILE
rm $DSLOG_FILE
DT_START=`date`
echo "-----------------------------------------" >> $DSLOG_FILE
echo "Execution Started at for Datastage Job Sequencer:" $DSJOBNAME " on date:"$DT_START>>$DSLOG_FILE
echo "Datastage Project:" $DSPROJNAME >>$DSLOG_FILE
############################################################################
#
# DataStage EXECUTION of the job sequencer
#
############################################################################
CURR_DT=`date`
echo "$CURR_DT Executing DataStage dsjob program..." >> $DSLOG_FILE
echo $BinFileDirectory/dsjob -server $DSSERVER -user $DSUSERID -password $DSPASSWORD -run -wait $PARAMLIST $DSPROJNAME $DSJOBNAME 2>&1 > $DSLOG_FILE
echo
echo $BinFileDirectory/dsjob -server $DSSERVER -user $DSUSERID -password $DSPASSWORD -run -wait $PARAMLIST $DSPROJNAME $DSJOBNAME 2>&1 > $DSLOG_FILE
echo
eval $BinFileDirectory/dsjob -server $DSSERVER -user $DSUSERID -password $DSPASSWORD -run -wait $PARAMLIST $DSPROJNAME $DSJOBNAME 2>&1 >> $DSLOG_FILE
jobwaiting=`grep "Waiting for job..." $DSLOG_FILE`
if [ "$jobwaiting" != "Waiting for job..." ]; then
CURR_DT=`date`
echo $CURR_DT $DSJOBNAME "DataStage failed to start the job" >> $DSLOG_FILE
failedstart=1
else
CURR_DT=`date`
echo $CURR_DT $DSJOBNAME "DataStage successfully started the job">> $DSLOG_FILE
failedstart=0
fi
CURR_DT=`date`
echo $CURR_DT $DSJOBNAME "Retrieving job information">> $DSLOG_FILE
$BinFileDirectory/dsjob -server $DSSERVER -user $DSUSERID -password $DSPASSWORD -jobinfo $PARAMLIST $DSPROJNAME $DSJOBNAME >> $DSLOG_FILE
############################################################################
#
# Check Status for Job Execution
#
############################################################################
ERROR=`grep "ERROR" $DSLOG_FILE`
if [ "$failedstart" != 0 ]; then
CURR_DT=`date`
echo $CURR_DT $DSJOBNAME "The job failed to start" >> $DSLOG_FILE
AuditStatus="FAILURE"
Comments="MasterControl aborted"
EXIT_STATUS=1
else
if [ "$ERROR" = 1 -o "$ERROR" = 2 ]; then
CURR_DT=`date`
echo $CURR_DT $DSJOBNAME "The job completed successfully" >> $DSLOG_FILE
AuditStatus="SUCCESS"
Comments=""
EXIT_STATUS=0
else
CURR_DT=`date`
echo $CURR_DT $DSJOBNAME "The job aborted" >> $DSLOG_FILE
AuditStatus="FAILURE"
Comments="MasterControl aborted"
EXIT_STATUS=1
fi
fi
if [ ${EXIT_STATUS} -ne 0 ]
then
echo "Error in the Shell for calling the Datastage job sequencer:" $DSJOBNAME >>$DSLOG_FILE
else
echo "Successfully executed the Shell for calling the Datastage job sequencer:" $DSJOBNAME >>$DSLOG_FILE
fi
DT_END=`date`
echo "Execution Ended with Shell Status as :"$EXIT_STATUS>>$DSLOG_FILE
echo "--------------------------------------------">>$DSLOG_FILE
exit ${EXIT_STATUS}