error UDA-SQL-0114

[rajivgupta1107]

Hi

I am getting the below error in many of my reports.

UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. UDA-SQL-0107 A general exception has occurred during the operation "fetch". Unable to retrieve result from data source <query>

Pls suggest , its very urgent.

thanks a tonn

[Darek]

Seems to be a database-side problem. Check with your DBAs.

[rajivgupta1107]

Pls suggest what actually is required to be looked in the database so that i can check out.

Please suggest asap.


With thanks
Rajiv

[blom0344]

I could be something like an out-of-rage datetime. If a date exists in the database that is invalid, then a calculation on the date could lead to this type of error.
Check date values for all dates used in the reports (especially those associated with prompts)

[Darek]

... or the connection dies during data retrieval due to a backup or other maintenance being scheduled.