I am getting the error :
rocfm/wls_subload/in/processed_files/tel_input_additional_checked_all_mandatory.txt: 0403-057 Syntax error at
line 1 : `|' is not expected.
>>>>ALL MANDATORY FIELDS CHECKING IS SUCCESSFUL count is 0
rocfm/wls_subload/in/processed_files/tel_input_additional_checked_all_mandatory.txt: 0403-057 Syntax error at
line 1 : `|' is not expected.
>>>>ALL MANDATORY FIELDS CHECKING IS SUCCESSFUL count is 0
rocfm/wls_subload/in/processed_files/tel_input_additional_checked_product_type_mandatory.txt: 0403-057 Syntax
error at line 1 : `|' is not expected.
>>>>PRODUCT TYPE CHECKING IS SUCCESSFUL count is 0
error 1 :
0403-057 Syntax error
error 2 : count =0
That files contains 4 records
The input file is as given below
vi rocfm/wls_subload/in/pro
onal_checked_product_type_mandatory.txt <
rocfm/wls_subload/in/processed_files/tel_input_additional_checked_product_type_mandatory.txt" 4 lines, 98 ch
aracters
[Press return to continue]
7099440||A||C|1|||20091224
6043171||D||I|1|||20010601
2502467||||||||
70994421||||||||
~
script :
#!/usr/bin/ksh
# Filename: filter_subscribers_exist_only_in_tel_main.sh
# Function: to run all subscriber exist only in tel scripts
# Auther : # Location: rocfm/wls_subload/resources/step/main_scripts
#######################################
INPUT_GEN_PATH=rocfm/wls_subload/resources/syncsort/scripts/input_generation
tel_PATH=rocfm/wls_subload/resources/syncsort/scripts/phone_exist_tel
INPUT_FILE_PATH=rocfm/wls_subload/in
PR_FILE_PATH=rocfm/wls_subload/in/processed_files
echo "1. #>>>>>>REMOVING DUPLICATE SUBSCRIBERS#"
$INPUT_GEN_PATH/tel_input_remove_duplicates.sh
echo "1.finished #>>>>>>REMOVEDDUPLICATES FROM tel SUBSET# tel_input_remove_duplicates.sh"
echo "2. #>>>>>>CHECKING MANDATORY FIELDS IN SUBSET FILE#"
$INPUT_GEN_PATH/tel_input_check_all_mandatory.sh
echo "2. finished #>>>>>>CHECKED MANDATORY FIELDS IN tel SUBSET FILE# tel_input_check_all_mandatory.sh"
chmod 777 $PR_FILE_PATH/tel_input_checked_all_mandatory.txt
COUNT_MAND_SUBSET=`$PR_FILE_PATH/tel_input_checked_all_mandatory.txt | wc -l`
if [ $COUNT_MAND_SUBSET -gt 0 ]; then
echo ">>>>>MANDATORY FIELDS ARE NOT HAVING VALUES OR INVALID VALUES count is $COUNT_MAND_SUBSET"
else
echo ">>>>ALL MANDATORY FIELDS CHECKING SUCCESSFUL count is $COUNT_MAND_SUBSET"
fi
echo "3. #>>>>>>FILTERING ACTIVE AND SUSPENDED SUBSCRIBERS IN SUBSET FILE#"
$INPUT_GEN_PATH/tel_input_act_and_susp_phones.sh
echo "3. finished #>>>>FILTERED ACTIVE AND SUSPENDED SUSBCRIBERS FROM SUBSET# tel_input_act_and_susp_phones.sh"
echo "4. #>>>>>>FILTERING CANCELLED SUBSCRIBERS IN SUBSET FILE#"
$INPUT_GEN_PATH/tel_input_cancelled_phones.sh
echo "4. finished #>>>>>>FILTERED CANCELLED SUBSCRIBERS FROM SUBSET# tel_input_cancelled_phones.sh"
echo "5. #>>>>>>REMOVING DUPLICATE SUBSCRIBERS FROM FULL SET FILE#"
$INPUT_GEN_PATH/tel_input_additional_remove_duplicates.sh
echo "5. finished #>>>>>>REMOVED DUPLICATES FROM FULL SET# "
echo "6. #>>>>>>REMOVING EMPTY SUBSCRIBERS IN FULL SET FILE#"
$INPUT_GEN_PATH/tel_input_additional_remove_empty.sh
echo "6. finished #REMOVED EMPTY SUBSCRIBERS IN FULL SET# tel_input_additional_check_all_mandatory.sh"
echo "7. #>>>>>>CHECKING ALL MANDATORY FIELDS IN FULL SET FILE#"
$INPUT_GEN_PATH/tel_input_additional_check_all_mandatory.sh
echo "7. finished #>>>>CHECKED ALL MANDATORY FIELDS IN FULL SET# tel_input_additional_check_all_mandatory.sh"
echo "8. #>>>>>>CHECKING PRODUCT TYPE FIELDS IN FULL SET FILE#"
$INPUT_GEN_PATH/tel_input_additional_check_product_type_mandatory.sh
echo "8. finished #>>>>CHECKED MANDATORY PRODUCT TYPE ADDITIONAL FIELDS IN FULL SET# tel_input_additional_check_product_type_mandatory.sh"
chmod 777 $PR_FILE_PATH/tel_input_additional_checked_all_mandatory.txt
COUNT_MAND_FULLSET=`$PR_FILE_PATH/tel_input_additional_checked_all_mandatory.txt|wc -l`
if [ $COUNT_MAND_FULLSET -gt 0 ]; then
echo ">>>>>MANDATORY FIELDS ARE NOT HAVING VALUES count is $COUNT_MAND_FULLSET"
else
echo ">>>>ALL MANDATORY FIELDS CHECKING IS SUCCESSFUL count is $COUNT_MAND_FULLSET"
fi
chmod 777 $PR_FILE_PATH/tel_input_additional_checked_product_type_mandatory.txt
COUNT_MAND_PRTYPE=`$PR_FILE_PATH/tel_input_additional_checked_product_type_mandatory.txt | wc -l`
if [ $COUNT_MAND_PRTYPE -gt 0 ]; then
echo ">>>>>PRODUCT TYPE IS HAVING INVALID VALUE count is $COUNT_MAND_PRTYPE"
else
echo ">>>>PRODUCT TYPE CHECKING IS SUCCESSFUL count is $COUNT_MAND_PRTYPE"
fi
echo "9. #>>>>>>FILTERING ACTIVE AND SUSPENDED SUBSCRIBERS FROM FULL SET FILE#"
$INPUT_GEN_PATH/tel_input_additional_act_susp_phones.sh
echo "9. finished #>>>>>SELECTED ACTIVE AND SUSPENDED RECORDS FROM ADDITIONAL# tel_input_additional_act_susp_phones.sh"
echo "################## finished input file generation for tel from RCODS#################"
echo "10. #>>>>>>REMOVING DUPLICATE SUBSCRIBERS FROM ROCFM FILE#"
$INPUT_GEN_PATH/rocfm_input_remove_duplicates.sh
echo "10. finished #REMOVED DUPLICATES FROM ROCFM# rocfm_input_remove_duplicates.sh"
echo "11. #>>>>>>FILTERING ACTIVE AND SUSPENDED SUBSCRIBERS FROM ROCFM FILE#"
$INPUT_GEN_PATH/rocfm_input_act_and_susp_phones.sh
echo "11. finished #FILTERED ACTIVE AND SUSPENDED SUSBCRIBERS IN ROCFM# rocfm_input_act_and_susp_phones.sh"
echo "12. #>>>>>>FILTERING CANCELLED SUBSCRIBERS FROM ROCFM FILE#"
$INPUT_GEN_PATH/rocfm_input_cancelled_phones.sh
echo "12. finished #FILTERED CANCELLED SUBCRIBERS FROM ROCFM# rocfm_input_cancelled_phones.sh"
echo "################## finished input file generation for ROCFM from NIKKIRA DB#################"
echo "################## finished input file generation #################"
echo "13. #>>>>>>FILTERING SUBSCRIBERS THAT EXIST ONLY IN tel -RCODS DB ,NOT IN NIKKIRA/ROCFM#"
$tel_PATH/phones_only_in_tel_filter.sh
echo "13. finished #FILTERED SUBSCRIBERS THAT EXIST ONLY IN tel# phone_only_tel_filter.sh"
echo "14. #>>>>>>REMOVING DUPLICATE SUBSCRIBERS AFTER FILTERING#"
$tel_PATH/phones_only_tel_remove_duplicates.sh
echo "14. finished #REMOVED DUPLICATES AFTER FILTER SUSBCRIBERS# phones_only_tel_remove_duplicates.sh"
echo "15. #>>>>>>ADDING ADDITIONAL 43 FIELDS TO SUBSET FILE#"
$tel_PATH/phones_only_in_tel_add_additionals.sh
echo "15. finished #ADDED ADDITIONAL FIELDS TO FINAL FILE# phones_only_in_tel_additionals.sh"
echo "################## finished SUBSCRIBERS EXIST ONLY IN tel , YOU CAN FIND FINAL PRODUCT IN rocfm/wls_subload/out/phones_exist_only_in_tel_fullset_final.txt#################"
#exit $?
can you please help me
Thanks