Hi - I'm also facing this strange issue with a workflow. I analyzed and figured that this error occurs only when we have output file as "Flat ASCII File (*.Flat)".
This works fine in designer and even in the server designer, but when I upload it into gallery- Validation is passed, when Run gives an error as below
" Oops!
The job Sample Flat File did not complete successfully and resulted in the following errors:
•There was an unknown error executing the application. The engine reported status Error "
The output flat File is created successfully but the job ends with error - not success status.
I created a simple workflow with a text input and output as .flat file. Still error with run in gallery.
Is the .Flat file not compactable in gallery? Can you help me with this one. Thanks much.
When you upload to the Gallery, are you attaching the FLAT file and the file that defines it's fields?
The FLAT file is output of my workflow. Can you explain what you meant attach FLAT file?
A sample workflow is simple as I have a text Input with 2 columns and output as FLAT file - *.FLAT as Output.
It works fine in designer but fails in Gallery.
Also the same workflow (open from Gallery), if I change the output to any other format say Excel and save back to gallery it works fine.
I have also encountered this problem. Did you find a solution for this?
I think that what @patrick_mcauliffe was referring to is that a FLAT file is actually a data file together with another file that defines the format.
If you try to write a flat file (or read one for that matter) without also having the file that defines the format, you'll run into problems.