Date Time : 2026-09-28 08:50:26.118
StepNumber  : START 
ReferenceNumber  : b77b6dcb-c598-4c59-9ab9-0720d2f7d3ed 
MethodName:ImportUser 
Message  : API execution started 
---------*****------------
Date Time : 2026-09-28 08:50:26.118
StepNumber  : AUTH_OK 
ReferenceNumber  : b77b6dcb-c598-4c59-9ab9-0720d2f7d3ed 
MethodName:ImportUser 
Message  : JWT validated | TokenUserId=101 
---------*****------------
Date Time : 2026-09-28 08:50:26.118
StepNumber  : REQUEST 
ReferenceNumber  : b77b6dcb-c598-4c59-9ab9-0720d2f7d3ed 
MethodName:ImportUser 
Message  : Request received | UsersCount=1 | Domain=GAPL 
---------*****------------
Date Time : 2026-09-28 08:50:26.118
StepNumber  : DATA_PREP 
ReferenceNumber  : b77b6dcb-c598-4c59-9ab9-0720d2f7d3ed 
MethodName:ImportUser 
Message  : Users prepared | Valid=1 | Failed=0 
---------*****------------
Date Time : 2026-09-28 08:50:26.118
StepNumber  : Bulk Uplaod DB_CALL 
ReferenceNumber  : b77b6dcb-c598-4c59-9ab9-0720d2f7d3ed 
MethodName:ImportUser 
Message  : DB Bulk insert started | Rows=1 
---------*****------------
Date Time : 2026-09-28 08:50:26.133
StepNumber  : Bulk_Uplaod_DB_RESULT 
ReferenceNumber  : b77b6dcb-c598-4c59-9ab9-0720d2f7d3ed 
MethodName:ImportUser 
Message  : DB Bulk insert completed | Result=1 
---------*****------------
Date Time : 2026-09-28 08:50:26.133
StepNumber  : CALCULATION 
ReferenceNumber  : b77b6dcb-c598-4c59-9ab9-0720d2f7d3ed 
MethodName:ImportUser 
Message  : Total reward points calculated | TotalPoints=1 
---------*****------------
Date Time : 2026-09-28 08:50:26.133
StepNumber  : PAYABLE_AMOUT_DB 
ReferenceNumber  : b77b6dcb-c598-4c59-9ab9-0720d2f7d3ed 
MethodName:ImportUser 
Message  :  Update Payable about DB Insert Intiated  
---------*****------------
Date Time : 2026-09-28 08:50:26.133
StepNumber  : EXCEPTION 
ReferenceNumber  : b77b6dcb-c598-4c59-9ab9-0720d2f7d3ed 
MethodName:ImportUser 
Message  : Unhandled exception | Message=Conversion failed when converting the varchar value 'adrenalin@2@GAPL@AES100' to data type int. 
---------*****------------