Error Message:
RQP-DEF-0177 an error occurred while performing operation sqlbulkfetch status =-9
UDA-SQL-0107 general exception has occurred during the operation fetch
Solution:
In Oracle, change the cursor sharing mode to Exact.
Steps:
In the Oracle Manager Console, choose Instance > Configuration > All initialization parameters, and set the value to Force.
My Question: Can anybody tell me how do we go about to fix this problem for DB2 database ?
Any help is appreciated...
Thanks in advance,
Vivek Mody
Hi
I am also getting the same error. May i know the cause for the same.
Also i am not having Oracle Manager Console, pls tell how to set the parameter value then.
Thanks
Rajiv Gupta
I am getting the error in the report.
Thanks
Pls update me on the same.
Regards
Rajiv
Hi,
Quote from: Vick on 29 Apr 2008 03:01:59 PM
Error Message:
RQP-DEF-0177 an error occurred while performing operation sqlbulkfetch status =-9
UDA-SQL-0107 general exception has occurred during the operation fetch
My Question: Can anybody tell me how do we go about to fix this problem for DB2 database ?
One reason could be that DB2 is forcing your application (cutting connection) because of excessive consumption of resources, e.g. CPU, IO, Rows in/Out - DB2 monitores resources with DB2-govenor.
Edit the DB2-Govenor settings, change them to a higher thresholds or temporarly disable the govenor at all to test if error is connected to these settings at all.
Let me know if this helped you.
regards,
RaRo