TPT05015: Error: Cannot open the file '$SCHEMA_GEN_D_TBL001.txt' due to error 13. Permission denied
Hi. I am executing `tbuild` with a job script that makes use of templates to delete from a staging table and load data into that table from a delimited text file. When I execute this command logged in as my user it succeeds. However, when I execute it logged in as someone else, it fails with:
Teradata Parallel Transporter Version 14.10.00.00
TPT_INFRA: TPT04032: Error: Schema generation failed for table 'MY_STG_SCHEMA.MY_STG_TABLE' in DBS 'foo':
"GetDelimitedFileSchema" status: 48.
Job script preprocessing failed.
TPT_INFRA: TPT05015: Error: Cannot open the file '$SCHEMA_GEN_D_TBL001.txt' due to error 13.
Job terminated with status 12.
The error message is clear enough: logged on as the other user, tbuild does not have permission to view a schema file. But why? Isn't tbuild creating the file and reading it in the same session?