Hi,
I have a table which has 4 columns and 1st column which is name is filtered by a selection box (dropdown),
So, for each name selected from a drop down, the table is populated by querying the Database, the issue is for some selections, i get this warning
'Ora-01013 error user requested cancel of current operation'.
But nothing is done on the front end to interrupt the query operation.. this happnes quite a lot...
any idea how to fix this ...?
Helmut Barro on
This warning seems to occur when the Oracle connection runs into a timeout, as we do not interrupt queries from MashZone side. You could try to increase the query timeout parameter of your database connection in MashZone Administration.
Additionally, you should check your database connectivity. Sometimes network traffic, firewalls or simply infrastructural deficits cause database timeouts.
Maybe you could also check the SQL statements that cause that warning (if the warning is reproduceable with a specific SQL statement) - if they cause such a delay or database workload, they should be adapted.