• No replies
150 Posts

Pinned topic Transformer time outs

‏2013-09-27T12:39:23Z |


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.