=~=~=~=~=~=~=~=~=~=~=~= PuTTY log 2021.08.06 18:48:40 =~=~=~=~=~=~=~=~=~=~=~= login as: 1csqadigital Pre-authentication banner message from server: | | |-----------------------------------------------------------------| | | This system is for the use of authorized users only. | | | Individuals using this computer system without authority, or in | | | excess of their authority, are subject to having all of their | | | activities on this system monitored and recorded by system | | | personnel. | | | | | | In the course of monitoring individuals improperly using this | | | system, or in the course of system maintenance, the activities | | | of authorized users may also be monitored. | | | | | | Anyone using this system expressly consents to such monitoring | | | and is advised that if such monitoring reveals possible | | | evidence of criminal activity, system personnel may provide the | | | evidence of such monitoring to law enforcement officials. | | |-----------------------------------------------------------------| | End of banner message from server Keyboard-interactive authentication prompts from server: | Password: End of keyboard-interactive prompts from server Last login: Fri Aug 6 09:18:23 2021 from 10.138.33.5 |-----------------------------------------------------------------| | This system is for the use of authorized users only. | | Individuals using this computer system without authority, or in | | excess of their authority, are subject to having all of their | | activities on this system monitored and recorded by system | | personnel. | | | | In the course of monitoring individuals improperly using this | | system, or in the course of system maintenance, the activities | | of authorized users may also be monitored. | | | | Anyone using this system expressly consents to such monitoring | | and is advised that if such monitoring reveals possible | | evidence of criminal activity, system personnel may provide the | | evidence of such monitoring to law enforcement officials. | |-----------------------------------------------------------------| 1csqadigital@psppcsbosapp02>/export/home/1csqadigital> pbrun -u settle switch This request will be loggged in: /var/adm/pb/pb.1csqadigital.psppcsbosapp02.switch.AHHKRWFLh0+yM4Z+ClKJsNAX |-----------------------------------------------------------------| | This system is for the use of authorized users only. | | Individuals using this computer system without authority, or in | | excess of their authority, are subject to having all of their | | activities on this system monitored and recorded by system | | personnel. | | | | In the course of monitoring individuals improperly using this | | system, or in the course of system maintenance, the activities | | of authorized users may also be monitored. | | | | Anyone using this system expressly consents to such monitoring | | and is advised that if such monitoring reveals possible | | evidence of criminal activity, system personnel may provide the | | evidence of such monitoring to law enforcement officials. | |-----------------------------------------------------------------| No match settle@psppcsbosapp02 < 1 > ls -ltr /export/home/1csqadigital/AutoAdjust/AA_inputQueue total 119 -rwxr-xr-x 1 1csqadigital appsupp 60364 Aug 6 09:18 TASK1952752_08062021_357_38713.99_7830.08.csv* settle@psppcsbosapp02 < 2 > bash /export/home/1csqadigital/AutoAdjust/AA_process.sh user is settle, good to go. INFO : START export/home/1csqadigital/AutoAdjust/AA_process.sh INFO : Log file: /export/home/1csqadigital/AutoAdjust/AAlog/logfile.080621 ############################################################################# INFO : Processing file - /export/home/1csqadigital/AutoAdjust/AA_inputQueue/TASK1952752_08062021_357_38713.99_7830.08.csv DBG : filename: TASK1952752_08062021_357_38713.99_7830.08.csv DBG : Extracted Filename is: TASK1952752 08062021 357 38713.99 7830.08 DBG : PRFT : TASK1952752 DBG : DATE : 08062021 DBG : COUNT : 357 DBG : CREDIT : 38713.99 DBG : DEBIT : 7830.08 DBG : New Filename is /export/home/1csqadigital/AutoAdjust/AA_inputQueue/08062021.csv INFO : Renamed Successfully..!! DBG : /export/home/1csqadigital/AutoAdjust/AA_inputQueue/08062021.csv INFO : Moved to SETTLEMENT/input Successfully..!! DBG : Final file for SETTLEMENT/input is: 08062021.csv INFO : Running Settlement SCRIPT Script is ksh -x /prod/app/SETTLEMENT/scripts/settle_batch_adj.sh + LOG_FACILITY=LOCAL2 + LOG_LEVEL=DEBUG + + basename /prod/app/SETTLEMENT/scripts/settle_batch_adj.sh LOG_TAG=settle_batch_adj.sh + LOG_APPL=BATCH_ADJ + + whoami LOG_USER=settle + export LOG_FACILITY LOG_LEVEL LOG_TAG LOG_APPL LOG_USER + LOGGER=/usr/ucb/logger -p LOCAL2.DEBUG -t settle_batch_adj.sh + + awk {print substr($1,1,(index($1,"app")-2))} + echo /prod/app/SETTLEMENT/scripts/settle_batch_adj.sh B_DIR=/prod + + awk {print substr($1,(index($1,"app")+4))} + echo /prod/app/SETTLEMENT/scripts/settle_batch_adj.sh APPLICATION_NAME=SETTLEMENT/scripts/settle_batch_adj.sh + + awk {print substr($1,1,(index($1,"/")-1))} + echo SETTLEMENT/scripts/settle_batch_adj.sh APPLICATION_NAME=SETTLEMENT + + basename /prod/app/SETTLEMENT/scripts/settle_batch_adj.sh PGM_NAME=settle_batch_adj.sh + /usr/ucb/logger -p LOCAL2.DEBUG -t settle_batch_adj.sh START: settle_batch_adj.sh 08062021.csv 357 38713.99 7830.08 + [ _/prod = _ ] + [ _/prod = _ ] + APPLICATION=SETTLEMENT + export APPLICATION + BIN_DIR=/prod/app/SETTLEMENT/bin + SCRIPT_DIR=/prod/app/SETTLEMENT/scripts + INPUT_DIR=/prod/data/SETTLEMENT/input + export INPUT_DIR + ARCHIVE_DIR=/prod/data/SETTLEMENT/archive + export ARCHIVE_DIR + APP_BASE_DIR=/prod/app/SETTLEMENT + CFG_DIR=/prod/app/SETTLEMENT/config + [ -r /prod/app/SETTLEMENT/config/SETTLEMENT.cfg ] + . /prod/app/SETTLEMENT/config/SETTLEMENT.cfg + LOG_APPL=SETTLEMENT + + /usr/ucb/whoami LOG_USER=settle + LOG_LEVEL=DEBUG + LOG_FACILITY=LOCAL2 + LOG_PID=[16115] + + basename /prod/app/SETTLEMENT/scripts/settle_batch_adj.sh LOG_JOB=:settle_batch_adj.sh + LOG_TAG=SETTLEMENT settle [16115] :settle_batch_adj.sh + export LOG_USER LOG_APPL LOG_FACILITY LOG_LEVEL LOG_PID LOG_TAG + export LOG_APPL LOG_FACILITY LOG_LEVEL LOG_USER + + basename /prod/app/SETTLEMENT/scripts/settle_batch_adj.sh SCRIPT=settle_batch_adj.sh + + hostname SYSCONFIG=/prod/app/config/BOS_psppcsbosapp02.cfg + [ -r /prod/app/config/BOS_psppcsbosapp02.cfg ] + . /prod/app/config/BOS_psppcsbosapp02.cfg + EFT_ENV=prod + EFT_BASE=/prod/app + ORACLE_BASE=/u01/app/oracle + ORACLE_HOME_32=/u01/app/oracle/product/11.2.0.4_lib32 + ORACLE_HOME_64=/u01/app/oracle/product/11.2.0.4 + PERL_HOME=/prod/app/perl5.8 + PERL5LIB=/prod/app/lib:/usr/local/perl58lib/oracle11/lib/site_perl + SYNCSORT_HOME=/opt/dmexpress_7.0 + export EFT_ENV EFT_BASE ORACLE_BASE ORACLE_HOME_32 ORACLE_HOME_64 PERL_HOME PERL5LIB SYNCSORT_HOME + SEGCONFIG=/prod/app/config/SEGMENT.cfg + [ -r /prod/app/config/SEGMENT.cfg ] + . /prod/app/config/SEGMENT.cfg + GLB_SEG_LIST=A,B,C,K,D,R,E + GLB_SEG_LIST_WITH_ORDER=A-1,B-2,C-3,K-4,D-5,R-6,E-7 + GLB_FIRST_SEGMENT=A + GLB_LAST_SEGMENT=E + export GLB_SEG_LIST GLB_FIRST_SEGMENT GLB_LAST_SEGMENT GLB_SEG_LIST_WITH_ORDER + export SEGCONFIG + EFIT_LINK=@efit.prod.db + ORACLE_SID_CSTJ=CSTJ + ORACLE_USER_CSTJ=ops$settle + ORACLE_SID=batch + ORACLE_USER=ops$settle + ORACLE_HOME=/u01/app/oracle/product/11.2.0.4_lib32 + export ORACLE_SID ORACLE_USER ORACLE_HOME EFIT_LINK ORACLE_SID_CSTJ ORACLE_USER_CSTJ + PERL5LIB=/prod/app/SETTLEMENT/lib:/prod/app/lib:/usr/local/perl58lib/oracle11/lib/site_perl + PERL_OPTS= + PERL_EXEC=/prod/app/perl5.8/bin/perl + export PERL_EXEC PERL5LIB + LD_LIBRARY_PATH=/opt/dmexpress_7.0/lib:/usr/lib/secure:/prod/app/SETTLEMENT/lib:/prod/app/lib:/u01/app/oracle/product/11.2.0.4_lib32/lib + LD_LIBRARY_PATH=/opt/dmexpress_7.0/lib:/usr/lib/secure:/prod/app/SETTLEMENT/lib:/prod/app/lib:/u01/app/oracle/product/11.2.0.4_lib32/lib:/opt/voltage/lib32:/usr/local/lib + export LD_LIBRARY_PATH + PATH=/prod/app/perl5.8/bin:/prod/app/lib:/opt/dmexpress_7.0/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/ucb:/u01/app/oracle/product/11.2.0.4_lib32/bin + export PATH + SHELL_DIR=/prod/app/SETTLEMENT/scripts + SPOOLFILE=/prod/app/SETTLEMENT/scripts/settle_batch_adj.sh.lst + + dirname /prod/app UTIL_DIR=/prod/utils + export SHELL_DIR UTIL_DIR SPOOLFILE + EMAIL_ADDR=eft.settlementanalysts@fiserv.com + export EMAIL_ADDR + FTPLOGIN=citftp + export FTPLOGIN + FTPHOST=eft03fs01.eft.fiserv.net + export FTPHOST + FTPPORT=21 + export FTPPORT + VOLTAGE_CONFIG_PATH=/users/settle/.voltage + VOLTAGE_UAID=UAID-F1961 + VOLTAGE_CONFIG_FILE=fiservconfig.xml + export VOLTAGE_CONFIG_PATH VOLTAGE_UAID VOLTAGE_CONFIG_FILE + VOLTAGE_CONFIG_PATH=/users/settle/.voltage + VOLTAGE_UAID=UAID-F1961 + export VOLTAGE_CONFIG_PATH VOLTAGE_UAID + FILE_NAME=08062021.csv + RECORD_COUNT=357 + CREDIT_TOTAL=38713.99 + DEBIT_TOTAL=7830.08 + INPUT_FILE=/prod/data/SETTLEMENT/input/08062021.csv + IDF_TBL=IDF + AUTO_ADJ_TBL=AUTO_ADJUST + export AUTO_ADJ_TBL + /prod/app/perl5.8/bin/perl /prod/app/SETTLEMENT/bin/settle_batch_adj.pl /prod/data/SETTLEMENT/input/08062021.csv 357 38713.99 7830.08 + RET=0 + [ 0 = 0 ] + /usr/ucb/logger -p LOCAL2.DEBUG -t settle_batch_adj.sh PROGRAM COMPLETED SUCCESSFULLY. + /usr/ucb/logger -p LOCAL2.DEBUG -t settle_batch_adj.sh END_SUCCESS: settle_batch_adj.sh + exit 0 Aug 6 9:19:22 psppcsbosapp02 settle : settle_batch_adj.pl :[16132]: INFO : START /prod/app/SETTLEMENT/bin/settle_batch_adj.pl /prod/data/SETTLEMENT/input/08062021.csv 357 38713.99 7830.08 Aug 6 9:19:22 psppcsbosapp02 settle : settle_batch_adj.pl :[16132]: INFO : The following arguments are passed to settle_batch_adj.pl : Aug 6 9:19:22 psppcsbosapp02 settle : settle_batch_adj.pl :[16132]: INFO : Input File Name = /prod/data/SETTLEMENT/input/08062021.csv Aug 6 9:19:22 psppcsbosapp02 settle : settle_batch_adj.pl :[16132]: INFO : Record Count = 357 Aug 6 9:19:22 psppcsbosapp02 settle : settle_batch_adj.pl :[16132]: INFO : Credit Total = 38713.99 Aug 6 9:19:22 psppcsbosapp02 settle : settle_batch_adj.pl :[16132]: INFO : DebitTotal = 7830.08 Aug 6 9:19:26 psppcsbosapp02 settle : settle_batch_adj.pl :[16132]: INFO : Connected to Voltage Server Aug 6 9:19:26 psppcsbosapp02 settle : settle_batch_adj.pl :[16132]: INFO : Attempting to log in to Oracle: @batch Aug 6 9:19:26 psppcsbosapp02 settle : settle_batch_adj.pl :[16132]: INFO : Connected to Oracle: @batch Aug 6 9:19:27 psppcsbosapp02 settle : settle_batch_adj.pl :[16132]: INFO : Total records inserted in AUTO_ADJUST : 357 Aug 6 9:19:27 psppcsbosapp02 settle : settle_batch_adj.pl :[16132]: INFO : Input file archived . Aug 6 9:19:27 psppcsbosapp02 settle : settle_batch_adj.pl :[16132]: INFO : END /prod/app/SETTLEMENT/bin/settle_batch_adj.pl RUN COMPLETED for TASK1952752 settle@psppcsbosapp02 < 3 >