Error: Filename could not be created. Output file is scratch directory. - when running Query and Output

Query and Output may end without creating the output file and the job may have the following error on the output:

Filename {filename} could not be created.  Output file is {$HOME/scratch}

In the above, {filename} represents the full output path, and {$HOME/scratch} represents the scratch directory on the database.

For example:

Filename /export/home/app/ta/[database]/output/users/[username]/1211_purl_alt_id_test could not be created. Output file is /export/home/app/ta/[database]/scratch/

Article Number: 86289

Products:

Team_Approach

The root cause is the output path is invalid or going someplace that does not exist.

To resolve, you can either

Confirm the folder path (in any FTP utility) and rerun the output to that folder
Create the missing folder and rerun the output. If you are unable to create the folder, contact Team Approach Support.