RS.exe is having issue while subscription is completing the report.

Question

Post reply

RS.exe is having issue while subscription is completing the report.

anievera

SSC Enthusiast

Points: 121
More actions
December 13, 2022 at 6:10 am

#4124727

Hi We have a report that is running via rs.exe utility and it errors out, but when we execute it via subscription it is completing.
The error is below, the report is executing an oracle stored procedure

runningjobs!ReportServer_0-18!14cc!12/08/2022-08:37:28:: i INFO: RunningJobContext.IsClientConnected; found orphaned request 35ybh2mbnhiom22ugojqi52l
processing!ReportServer_0-18!14cc!12/08/2022-08:37:28:: i INFO: DataPrefetch abort handler called for Report with ID=. Aborting data sources ...
processing!ReportServer_0-18!f48!12/08/2022-08:37:28:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'DataSet1'. ---> Oracle.ManagedDataAccess.Client.OracleException: ORA-01013: user requested cancel of current operation
ORA-06512: at "SYS.DBMS_LOCK", line 215
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 45
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 390
ORA-06512: at "SYS.DBMS_PARALLEL_EXECUTE", line 418
ORA-06512: at "RPTUSER.CM_UNBILLED_DATA_P1", line 162
ORA-06512: at line 1
at OracleInternal.ServiceObjects.OracleConnectionImpl.VerifyExecution(Int32& cursorId, Boolean bThrowArrayBindRelatedErrors, SqlStatementType sqlStatementType, Int32 arrayBindCount, OracleException& exceptionForArrayBindDML, Boolean& hasMoreRowsInDB, Boolean bFirstIterationDone)
at OracleInternal.ServiceObjects.OracleCommandImpl.ExecuteReader(String commandText, OracleParameterCollection paramColl, CommandType commandType, OracleConnectionImpl connectionImpl, OracleDataReaderImpl& rdrImpl, Int32 longFetchSize, Int64 clientInitialLOBFS, OracleDependencyImpl orclDependencyImpl, Int64[] scnForExecution, Int64[]& scnFromExecution, OracleParameterCollection& bindByPositionParamColl, Boolean& bBindParamPresent, Int64& internalInitialLOBFS, OracleException& exceptionForArrayBindDML, OracleConnection connection, OracleLogicalTransaction& oracleLogicalTransaction, IEnumerable`1 adrianParsedStmt, Boolean isDescribeOnly, Boolean isFromEF)
at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)
at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.OracleCommandWrapperExtension.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.OnDemandProcessing.RuntimeLiveQueryExecutor.ExecuteReader(IJobContext jobContext, DataSourceErrorInspector errorInspector, String commandText)
--- End of inner exception stack trace ---;

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jo Pattyn SSC-Dedicated Points: 32347 More actions · Answer 1

ORA-01013: user requested cancel of current operation

Your Oracle command is likely timing out.

Have a check on RPTUSER.CM_UNBILLED_DATA_P1

Did you set the -l parameter of rs.exe? (timeout)

anievera SSC Enthusiast Points: 121 More actions · Answer 2

Yes the parameter of rs.exe is set to 0 already, I have tried executing RPTUSER.CM_UNBILLED_DATA_P1 directly on the database it is completing there.

I have executed the report also using subscription and it is completing with no issue

anievera SSC Enthusiast Points: 121 More actions · Answer 3

anievera

SSC Enthusiast

Points: 121

December 13, 2022 at 10:48 am

#4124872

2022-12-13 18_46_58-Desktop - Desktop Viewer

This is how we are executing it

Jo Pattyn SSC-Dedicated Points: 32347 More actions · Answer 4

Thanks for posting the commandline.

I can't help you further with rs.exe. We execute reports using urls. Does it stop immediately, after a fixed amount of time, ...

Any oracle timeouts set on client/server?

anievera SSC Enthusiast Points: 121 More actions · Answer 5

I have no access to see the configuration files for the reporting server, But the oracle server does not have any time out as far as I know.

Upon further inspection of the rss file that was being executed it is using the ExecutionHelper method from the Exec2005 library I think this is different than executing via URL/Subscription.