Emirates Post Background Jobs

OFD Report Process Courier / All

// Job ID: fea3ce6c-15bc-4d00-a1f1-4e1447f6e6f7
using EP.BackgroundJobs.Engine.Jobs;

var oFDReportJob = Activate<OFDReportJob>();
oFDReportJob.ProcessOFDReport(
    null,
    "Courier",
    "All",
    FromJson<OFDBranch>("{\"branchCode\":\"All\",\"branchName\":\"Courier\",\"Emails\":[\"[email protected]\",\"[email protected]\",\"[email protected]\",\"[email protected]\",\"[email protected]\",\"[email protected]\",\"[email protected]\",\"[email protected]\",\"[email protected]\",\"[email protected]\",\"[email protected]\",\"[email protected]\",\"[email protected]\",\"[email protected]\",\"[email protected]\",\"[email protected]\",\"[email protected]\"],\"Active\":true}"),
    FromJson<CommonReportData>("{\"ConnectionString\":\"DATA SOURCE=(DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=ocprdexavm-fefsa-scan.epgprdb.epgvcn.oraclevcn.com) (PORT=1521)) (CONNECT_DATA= (SERVER=DEDICATED) (SERVICE_NAME=OPSPRD_OPSPDB01.paas.oracle.com) (FAILOVER_MODE= (TYPE=select) (METHOD=basic))));USER ID=BOC_RUN;Password=B0#8nn$C;Pooling=true;Min Pool Size=0;Connection Lifetime=180;Max Pool Size=50;Incr Pool Size=5;\",\"url\":\"https://notification.epapps.ae/services/sms/api/EmailNotifications\",\"fromEmail\":\"[email protected]\",\"emailtemplateId\":\"d-91d711500100470d98d1bac3480399d5\",\"smsApiKey\":\"309818c2759f475ab7b44fb35555270c:768d4067bc9c4581b52b3df2b54a3d8d\",\"subject\":null}"));

Parameters

CurrentCulture 
""
CurrentUICulture 
""
RetryCount 
3

State

10/07/2026 00:04:04 (+15.003s) Failed

An exception occurred during performance of the job.

Oracle.ManagedDataAccess.Client.OracleException

Connection request timed out

Oracle.ManagedDataAccess.Client.OracleException (0x80004005): Connection request timed out
   at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, OracleConnection connRefForCriteria)
   at Oracle.ManagedDataAccess.Client.OracleConnection.Open()
   at EP.BackgroundJobs.Engine.BusinessLogic.Implementations.ReportJob.GenerateOFDReport(PerformContext context, OFDBranch branch, CommonReportData commonReportData) in /src/EP.BackgroundJobs.Engine/BusinessLogic/Implementations/ReportJob.cs:line 174
   at EP.BackgroundJobs.Engine.Jobs.OFDReportJob.ProcessOFDReport(PerformContext context, String customerName, String accountNumber, OFDBranch branch, CommonReportData commonReportData) in /src/EP.BackgroundJobs.Engine/Jobs/OFDReportJob.cs:line 65

+ <1ms Processing

Server:
ep-hangfire-svc-55f796dcbf-fpxvr:1
Worker:
2c317701

+1m 15.016s Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+ <1ms Scheduled

Retry attempt 3 of 3: Connection request timed out

Enqueue at:
10/07/2026 00:03:38

+15.004s Failed

An exception occurred during performance of the job.

Oracle.ManagedDataAccess.Client.OracleException

Connection request timed out

Oracle.ManagedDataAccess.Client.OracleException (0x80004005): Connection request timed out
   at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, OracleConnection connRefForCriteria)
   at Oracle.ManagedDataAccess.Client.OracleConnection.Open()
   at EP.BackgroundJobs.Engine.BusinessLogic.Implementations.ReportJob.GenerateOFDReport(PerformContext context, OFDBranch branch, CommonReportData commonReportData) in /src/EP.BackgroundJobs.Engine/BusinessLogic/Implementations/ReportJob.cs:line 174
   at EP.BackgroundJobs.Engine.Jobs.OFDReportJob.ProcessOFDReport(PerformContext context, String customerName, String accountNumber, OFDBranch branch, CommonReportData commonReportData) in /src/EP.BackgroundJobs.Engine/Jobs/OFDReportJob.cs:line 65

+1ms Processing

Server:
ep-hangfire-svc-55f796dcbf-fpxvr:1
Worker:
25d37eee

+30.008s Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+ <1ms Scheduled

Retry attempt 2 of 3: Connection request timed out

Enqueue at:
10/07/2026 00:02:05

+15.003s Failed

An exception occurred during performance of the job.

Oracle.ManagedDataAccess.Client.OracleException

Connection request timed out

Oracle.ManagedDataAccess.Client.OracleException (0x80004005): Connection request timed out
   at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, OracleConnection connRefForCriteria)
   at Oracle.ManagedDataAccess.Client.OracleConnection.Open()
   at EP.BackgroundJobs.Engine.BusinessLogic.Implementations.ReportJob.GenerateOFDReport(PerformContext context, OFDBranch branch, CommonReportData commonReportData) in /src/EP.BackgroundJobs.Engine/BusinessLogic/Implementations/ReportJob.cs:line 174
   at EP.BackgroundJobs.Engine.Jobs.OFDReportJob.ProcessOFDReport(PerformContext context, String customerName, String accountNumber, OFDBranch branch, CommonReportData commonReportData) in /src/EP.BackgroundJobs.Engine/Jobs/OFDReportJob.cs:line 65

+15.001s Processing

Server:
ep-hangfire-svc-55f796dcbf-fpxvr:1
Worker:
e36b162e

+30.014s Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+ <1ms Scheduled

Retry attempt 1 of 3: Connection request timed out

Enqueue at:
10/07/2026 00:01:18

+15.004s Failed

An exception occurred during performance of the job.

Oracle.ManagedDataAccess.Client.OracleException

Connection request timed out

Oracle.ManagedDataAccess.Client.OracleException (0x80004005): Connection request timed out
   at OracleInternal.ConnectionPool.PoolManager`3.Get(ConnectionString csWithDiffOrNewPwd, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OraclePoolManager.Get(ConnectionString csWithNewPassword, Boolean bGetForApp, OracleConnection connRefForCriteria, String affinityInstanceName, Boolean bForceMatch)
   at OracleInternal.ConnectionPool.OracleConnectionDispenser`3.Get(ConnectionString cs, PM conPM, ConnectionString pmCS, SecureString securedPassword, SecureString securedProxyPassword, OracleConnection connRefForCriteria)
   at Oracle.ManagedDataAccess.Client.OracleConnection.Open()
   at EP.BackgroundJobs.Engine.BusinessLogic.Implementations.ReportJob.GenerateOFDReport(PerformContext context, OFDBranch branch, CommonReportData commonReportData) in /src/EP.BackgroundJobs.Engine/BusinessLogic/Implementations/ReportJob.cs:line 174
   at EP.BackgroundJobs.Engine.Jobs.OFDReportJob.ProcessOFDReport(PerformContext context, String customerName, String accountNumber, OFDBranch branch, CommonReportData commonReportData) in /src/EP.BackgroundJobs.Engine/Jobs/OFDReportJob.cs:line 65

+30.005s Processing

Server:
ep-hangfire-svc-55f796dcbf-fpxvr:1
Worker:
6a3109cb

+193ms Enqueued

Triggered by DelayedJobScheduler

Queue:
default

+ <1ms Scheduled

Enqueue at:
10/07/2026 00:00:04

10/07/2026 00:00:04 Created