DX Operational Intelligence

Tech Tip: CCR report shows error [Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation

  • 1.  Tech Tip: CCR report shows error [Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation

    Posted 05-06-2015 12:25 PM


    Problem: One or more reports show below error instead of data.

     

    System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.Odbc.OdbcException: ERROR [HYT00] [Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at NetQoS.Portal.Integration.Odbc.OdbcService.GetData(DateTime startTime, DateTime endTime, String[] parameterNames, String[] parameterValues) at NetQoS.Portal.Integration.Odbc.OdbcService.GetTabularData(String tabularDataType, DateTime startTime, DateTime endTime, String[] parameterNames, String[] parameterValues) --- End of inner exception stack trace ---

     

     

    Solution:

     

    Bring up the Mircorsoft 32 bit ODBC Data Source Administrator (C:\Windows\SysWOW64\odbcad32.exe), click on the System DSN tab, select the System Data Source created for CCR, click on the Configure button, uncheck the 'Enable Query Timeout', click ok, click ok.

     

    Click the browser Refresh button or use the F5 button to refresh the CCR report page.