// Job ID: 6e92be6f-f503-490e-a7a3-ec497de8ef9a
using EP.BackgroundJobs.Engine.Jobs;
var lastMileStatusUpdateJob = Activate<LastMileStatusUpdateJob>();
lastMileStatusUpdateJob.ProcessLastMileStatusUpdate(
null,
FromJson<LastMileInfo>("{\"ThirdPartyId\":null,\"DelvStatus\":null,\"EndPoint\":null,\"ApiKey\":null,\"Awb\":null,\"ThirdPartyAWB\":null,\"ItemID\":null,\"postaPlusInfo\":{\"ThirdPartyId\":\"51179\",\"DelvStatus\":null,\"EndPoint\":\"https://infolink.postaplus.net/api/Xchanges/GetShipmentTracking\",\"ApiKey\":\"de82b59b1d8f4663835882b37cac5cc6\",\"Awb\":null,\"ThirdPartyAWB\":null,\"ItemID\":null,\"postaPlusInfo\":null,\"asyadInfo\":null,\"starlinksInfo\":null,\"uPSInfo\":null,\"oTSInfo\":null,\"iWInfo\":null,\"QPInfo\":null,\"jeeblyInfo\":null,\"aymakanInfo\":null,\"gebInfo\":null},\"asyadInfo\":{\"ThirdPartyId\":\"314\",\"DelvStatus\":null,\"EndPoint\":\"https://apix.asyadexpress.com/\",\"ApiKey\":\"KTIaIUra3wCNpFMDGRhKhrhb_QTz2X98\",\"Awb\":null,\"ThirdPartyAWB\":null,\"ItemID\":null,\"postaPlusInfo\":null,\"asyadInfo\":null,\"starlinksInfo\":null,\"uPSInfo\":null,\"oTSInfo\":null,\"iWInfo\":null,\"QPInfo\":null,\"jeeblyInfo\":null,\"aymakanInfo\":null,\"gebInfo\":null},\"starlinksInfo\":{\"ThirdPartyId\":\"51176\",\"DelvStatus\":null,\"EndPoint\":\"https://starlinks.app/api/v2/tracking?\",\"ApiKey\":\"6bad2bad1ef6f05eff77b4e1294853e8\",\"is_test\":\"false\"},\"uPSInfo\":{\"UPSAccessLicenseNumber\":\"DDD361781C3BED08\",\"ThirdPartyId\":\"236\",\"DelvStatus\":null,\"EndPoint\":\"https://onlinetools.ups.com/track/v1/details/\",\"ApiKey\":null,\"Awb\":null,\"ThirdPartyAWB\":null,\"ItemID\":null,\"postaPlusInfo\":null,\"asyadInfo\":null,\"starlinksInfo\":null,\"uPSInfo\":null,\"oTSInfo\":null,\"iWInfo\":null,\"QPInfo\":null,\"jeeblyInfo\":null,\"aymakanInfo\":null,\"gebInfo\":null},\"oTSInfo\":{\"userName\":\"0797415444\",\"password\":\"mMpQatyO\",\"ThirdPartyId\":\"51180\",\"DelvStatus\":null,\"EndPoint\":\"https://ots-express.olivery.io/order\",\"ApiKey\":null,\"Awb\":null,\"ThirdPartyAWB\":null,\"ItemID\":null,\"postaPlusInfo\":null,\"asyadInfo\":null,\"starlinksInfo\":null,\"uPSInfo\":null,\"oTSInfo\":null,\"iWInfo\":null,\"QPInfo\":null,\"jeeblyInfo\":null,\"aymakanInfo\":null,\"gebInfo\":null},\"iWInfo\":{\"ThirdPartyId\":\"51181\",\"DelvStatus\":null,\"EndPoint\":\"https://prd-b2b.iwexpress.com/iwexpress/iwe-integration-service/tracking/\",\"ApiKey\":\"$2a$10$qWHNeBhu4FCGoJfuv2XVbO9Yq4QBUwGSvNM0bGpYUVc3iY8jXsJwO\",\"Awb\":null,\"ThirdPartyAWB\":null,\"ItemID\":null,\"postaPlusInfo\":null,\"asyadInfo\":null,\"starlinksInfo\":null,\"uPSInfo\":null,\"oTSInfo\":null,\"iWInfo\":null,\"QPInfo\":null,\"jeeblyInfo\":null,\"aymakanInfo\":null,\"gebInfo\":null},\"QPInfo\":{\"UserName\":\"emxa7_Prod\",\"Password\":\"d4Vs20\",\"ThirdPartyId\":\"404\",\"DelvStatus\":null,\"EndPoint\":\"https://web.qatarpost.qa/PartnerAPIAWB/\",\"ApiKey\":null,\"Awb\":null,\"ThirdPartyAWB\":null,\"ItemID\":null,\"postaPlusInfo\":null,\"asyadInfo\":null,\"starlinksInfo\":null,\"uPSInfo\":null,\"oTSInfo\":null,\"iWInfo\":null,\"QPInfo\":null,\"jeeblyInfo\":null,\"aymakanInfo\":null,\"gebInfo\":null},\"jeeblyInfo\":{\"ClientKey\":\"439X230912122152Y56697368616c4d6168657368776172\",\"ThirdPartyId\":\"51182\",\"DelvStatus\":null,\"EndPoint\":\"https://demo.qatar.jeebly.com/customer/track_shipment\",\"ApiKey\":\"JjEeEeBbLlYy1200\",\"Awb\":null,\"ThirdPartyAWB\":null,\"ItemID\":null,\"postaPlusInfo\":null,\"asyadInfo\":null,\"starlinksInfo\":null,\"uPSInfo\":null,\"oTSInfo\":null,\"iWInfo\":null,\"QPInfo\":null,\"jeeblyInfo\":null,\"aymakanInfo\":null,\"gebInfo\":null},\"aymakanInfo\":{\"ThirdPartyId\":\"406\",\"DelvStatus\":null,\"EndPoint\":\"https://api.aymakan.net/v2/\",\"ApiKey\":\"c6fd85e79d5a87ae91b768408c646c02-bc8066c0-9802-45cb-a356-72858a2f6a9a-cdcfd844ec9471425987c0ddc358b96d/b5032a6138164e5a1ccdea602f38bdca/1837ed9a-d9b6-4e60-b02f-f4d924b87b39\",\"Awb\":null,\"ThirdPartyAWB\":null,\"ItemID\":null,\"postaPlusInfo\":null,\"asyadInfo\":null,\"starlinksInfo\":null,\"uPSInfo\":null,\"oTSInfo\":null,\"iWInfo\":null,\"QPInfo\":null,\"jeeblyInfo\":null,\"aymakanInfo\":null,\"gebInfo\":null},\"gebInfo\":{\"ThirdPartyId\":\"412\",\"DelvStatus\":null,\"EndPoint\":\"https://www.gebhaly.com/api/v2/\",\"ApiKey\":null,\"Awb\":null,\"ThirdPartyAWB\":null,\"ItemID\":null,\"postaPlusInfo\":null,\"asyadInfo\":null,\"starlinksInfo\":null,\"uPSInfo\":null,\"oTSInfo\":null,\"iWInfo\":null,\"QPInfo\":null,\"jeeblyInfo\":null,\"aymakanInfo\":null,\"gebInfo\":null}}"),
"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;");
| CurrentCulture | |
| CurrentUICulture | |
| RetryCount | |
An exception occurred during performance of the job.
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.LastMileStatusUpdate.ProcessEvents(PerformContext context, LastMileInfo lastMileInfo, String courierDatabaseConnectionString) in /src/EP.BackgroundJobs.Engine/BusinessLogic/Implementations/LastMileStatusUpdate.cs:line 49 at EP.BackgroundJobs.Engine.Jobs.LastMileStatusUpdateJob.ProcessLastMileStatusUpdate(PerformContext context, LastMileInfo lastMileInfo, String courierDatabaseConnectionString) in /src/EP.BackgroundJobs.Engine/Jobs/LastMileStatusUpdateJob.cs:line 66
Retry attempt 3 of 3: Connection request timed out
An exception occurred during performance of the job.
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.LastMileStatusUpdate.ProcessEvents(PerformContext context, LastMileInfo lastMileInfo, String courierDatabaseConnectionString) in /src/EP.BackgroundJobs.Engine/BusinessLogic/Implementations/LastMileStatusUpdate.cs:line 49 at EP.BackgroundJobs.Engine.Jobs.LastMileStatusUpdateJob.ProcessLastMileStatusUpdate(PerformContext context, LastMileInfo lastMileInfo, String courierDatabaseConnectionString) in /src/EP.BackgroundJobs.Engine/Jobs/LastMileStatusUpdateJob.cs:line 66
Retry attempt 2 of 3: Connection request timed out
An exception occurred during performance of the job.
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.LastMileStatusUpdate.ProcessEvents(PerformContext context, LastMileInfo lastMileInfo, String courierDatabaseConnectionString) in /src/EP.BackgroundJobs.Engine/BusinessLogic/Implementations/LastMileStatusUpdate.cs:line 49 at EP.BackgroundJobs.Engine.Jobs.LastMileStatusUpdateJob.ProcessLastMileStatusUpdate(PerformContext context, LastMileInfo lastMileInfo, String courierDatabaseConnectionString) in /src/EP.BackgroundJobs.Engine/Jobs/LastMileStatusUpdateJob.cs:line 66
Retry attempt 1 of 3: Connection request timed out
An exception occurred during performance of the job.
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.LastMileStatusUpdate.ProcessEvents(PerformContext context, LastMileInfo lastMileInfo, String courierDatabaseConnectionString) in /src/EP.BackgroundJobs.Engine/BusinessLogic/Implementations/LastMileStatusUpdate.cs:line 49 at EP.BackgroundJobs.Engine.Jobs.LastMileStatusUpdateJob.ProcessLastMileStatusUpdate(PerformContext context, LastMileInfo lastMileInfo, String courierDatabaseConnectionString) in /src/EP.BackgroundJobs.Engine/Jobs/LastMileStatusUpdateJob.cs:line 66