We are loading in sales data via ACX file manager and Adobe SFTP. Currently works in PROD. We updated the data by adding 1 more column in the file. Testing in UAT and in UAT the Data Loading activity fails every time before it processes the file. Even AC support is having trouble with it.
The file is a .gz
We are pre-processing it with gpg --decrypt <%= vars.sourceFile %> | gunzip -c <%= vars.sourceFile %>, but it doesn't even get ar enough to pick up the file.
Can you share a screenshot of the error message? What if you remove the <%= vars.sourceFile %> after the gunzip -c? Did you make sure the file name is the same ? it needs to respect the regex in your file mapping
I looked at the File Manager workflow and it was giving me the error
04/22/2019 10:33:06 AM jsxCallWorkflows Skipping '20190421_061502-INCREMENTAL-transaction_lines-000000_0.gz' because a file for this feed is currently being processed.
I was able to find in the FileMapping/File History that there is a file that is stuck in "In process" status from 10/16/2018.
This makes sense as to why the File Manager JS is telling me the most recent file is being skipped since there is another file stuck in the process. And also why the Data loading activity kept erroring out because the file provider was not providing a file to it in the JS.