When I do data source viewer on a query item from the data source list in transformer, it cannot bring any results back, instead returns the following error message:
RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.
UDA-SOR-0005 Unable to write the file.
However when I run the same sql query separately, it runs fine, although it does take over 2 hours to successfully run.
I am wondering when in transformer in times out? Any thoughts and suggestions please?
Thanks in advance.