Date Time : 2026-08-04 18:58:04.388
StepNumber  : START 
ReferenceNumber  : 0b8a681b-06ea-4e26-88a1-33b7dcd0c7c0 
MethodName:ImportUser 
Message  : API execution started 
---------*****------------
Date Time : 2026-08-04 18:58:04.404
StepNumber  : AUTH_OK 
ReferenceNumber  : 0b8a681b-06ea-4e26-88a1-33b7dcd0c7c0 
MethodName:ImportUser 
Message  : JWT validated | TokenUserId=101 
---------*****------------
Date Time : 2026-08-04 18:58:04.404
StepNumber  : REQUEST 
ReferenceNumber  : 0b8a681b-06ea-4e26-88a1-33b7dcd0c7c0 
MethodName:ImportUser 
Message  : Request received | UsersCount=1 | Domain=GAPL 
---------*****------------
Date Time : 2026-08-04 18:58:04.404
StepNumber  : DATA_PREP 
ReferenceNumber  : 0b8a681b-06ea-4e26-88a1-33b7dcd0c7c0 
MethodName:ImportUser 
Message  : Users prepared | Valid=1 | Failed=0 
---------*****------------
Date Time : 2026-08-04 18:58:04.404
StepNumber  : Bulk Uplaod DB_CALL 
ReferenceNumber  : 0b8a681b-06ea-4e26-88a1-33b7dcd0c7c0 
MethodName:ImportUser 
Message  : DB Bulk insert started | Rows=1 
---------*****------------
Date Time : 2026-08-04 18:58:04.404
StepNumber  : Bulk_Uplaod_DB_RESULT 
ReferenceNumber  : 0b8a681b-06ea-4e26-88a1-33b7dcd0c7c0 
MethodName:ImportUser 
Message  : DB Bulk insert completed | Result=1 
---------*****------------
Date Time : 2026-08-04 18:58:04.404
StepNumber  : CALCULATION 
ReferenceNumber  : 0b8a681b-06ea-4e26-88a1-33b7dcd0c7c0 
MethodName:ImportUser 
Message  : Total reward points calculated | TotalPoints=1 
---------*****------------
Date Time : 2026-08-04 18:58:04.419
StepNumber  : PAYABLE_AMOUT_DB 
ReferenceNumber  : 0b8a681b-06ea-4e26-88a1-33b7dcd0c7c0 
MethodName:ImportUser 
Message  :  Update Payable about DB Insert Intiated  
---------*****------------
Date Time : 2026-08-04 18:58:19.431
StepNumber  : EXCEPTION 
ReferenceNumber  : 0b8a681b-06ea-4e26-88a1-33b7dcd0c7c0 
MethodName:ImportUser 
Message  : Unhandled exception | Message=Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached. 
---------*****------------