Insert DB query: user requested cancel of current operation

Help Activities
, ,
1

Select queries are working fine but
My oracle db insert query is not working well.
Query: “Insert into STG_OWNER_”+uid+“.STG_CASE_RDS (CASE_ID,CASE_PRIORITY,BATCH_NO,TREATMENT_ROUTE) values (‘1’, TO_CHAR(round(DBMS_RANDOM.value(1,5))),DBMS_RANDOM.string(‘x’,10), ‘Test Route’);”

It is throwing an error as below:

Source: Execute non query

Message: ERROR [HYT00] [Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation

Exception Type: System.Data.Odbc.OdbcException

RemoteException wrapping System.Data.Odbc.OdbcException: ERROR [HYT00] [Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation

2

@pushkar.singh

Did you try a hardcoded insert first?

Then to check errors use log message and check the syntax

But the error suggests a timeout…Check the exception details from Locals panel in debug mode

Check the timeouts and increase…you can have timeout in the connection string as well

cheers