So, how often have you tried to figure out the step and status order for a particular workflow and you’re left dazed and confused trying to figure it out on the front end? Possibly never but if you have this will help a ton.

Create and empty file named: CSWWorkflowExport_sq.xml

So it turns out if you try to alias any projection with “Number” it will expect something and you’ll get the SAX error, in the profiler you’ll get this:

<Code>ServerError</Code>
<Subcode>itk:ExportQueryExecutionError</Subcode>
<Reason>An error occurred during the query execution: ORA-00936: missing expression</Reason>

Not sure if that error is thrown for anything else but this was the fix to my issue.