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
Seems to be a database-side problem. Check with your DBAs.
Pls suggest what actually is required to be looked in the database so that i can check out.
Please suggest asap.
With thanks
Rajiv
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)
... or the connection dies during data retrieval due to a backup or other maintenance being scheduled.