PROBLEM DESCRIPTION


Please refer this article if the Teradata TPT ingestion is stuck while running the below TPT command


Running TPT command source /home/hadoop/infoworks/infoworks/conf/tpt.sh ; tbuild -h 10M -j 
b010c3b214e589e065baafa8_922d91ee7900478dbdd265770249c9fbDUR_RESPONSE_PRESCRIBER -f 
/home/hadoop/infoworks/infoworks//temp/tpt/scripts/b010c3b214e589e065baafa8_922d91ee7900478dbdd265770249c9fbDUR_RESPONSE_PRESCRIBER.txt -r 
/home/hadoop/infoworks/infoworks//temp/tpt/checkpoints/ -L 
/home/hadoop/infoworks/infoworks//temp/tpt/logs/ -R 2


CAUSE


This issue occurs if the infoworks user doesn't have write permissions on the log file ( In this scenario it is: b010c3b214e589e065baafa8_922d91ee7900478dbdd265770249c9fbDUR_RESPONSE_PRESCRIBER.out ) to which the TPT command is trying to write its output/log. Due to this the job would not fail but it would be running forever.


WORKAROUND/ RESOLUTION


Cancel the ingestion job. Make infoworks user the owner of the log file and then run the TPT ingestion again.