Project

General

Profile

Production Ticket(ST) #11672

Snekku - hi, pls check why collection of CCMC4000006 is missing?

Added by Muhammed Azhar Mohamed Maideen 5 months ago. Updated 4 months ago.

Status:
Ticket Resolved
Priority:
P3 - Medium
Assignee:
Muhammed Azhar Mohamed Maideen
Start date:
09/05/2024
Due date:
13/05/2024
% Done:

0%

Estimated time:
Spent time:
8.00 h
Job Remark:
Ticket Logged Date:
09/05/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
09/05/2024
SLA Delivery:
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
10/05/2024
Resolution:

1)checked in the databasein d1 table _at table and actual table there is no data inside

root cause- bug

Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:

None

Description

hi, pls check why collection of CCMS2000024 & 25 has jumping number.

SNEKKU-MC4-2024050917142249.zip (1.14 MB) SNEKKU-MC4-2024050917142249.zip Muhammed Azhar Mohamed Maideen, 09/05/2024 06:01 PM
SNEKKU-MS2-2024050915101532.zip (2.55 MB) SNEKKU-MS2-2024050915101532.zip Muhammed Azhar Mohamed Maideen, 09/05/2024 06:01 PM

History

#1 Updated by Muhammed Azhar Mohamed Maideen 5 months ago

-- MS2 user

SELECT * FROM txn_mobile_collection_header WHERE COL_NO LIKE '%CCMS2000024%'
    SELECT * FROM di_mobile_txn_collection_header WHERE doc_no LIKE '%CCMS2000024%'
        SELECT * FROM di_mobile_txn_collection_header_at WHERE doc_no LIKE '%CCMS2000024%'
SELECT * FROM di_mobile_txn_collection_header WHERE doc_no LIKE '%CCMS2000025%'
SELECT * FROM txn_mobile_collection_header WHERE COL_NO LIKE 'CCMS2000025%'
              SELECT * FROM di_mobile_txn_collection_header_at WHERE doc_no LIKE '%CCMS2000025%'
    select * from txn_type_running_no where member_id= '78419e8cd83449d6970550e56c8c08d3' and type= 'collection'
            select * from member where member_cd='ms2'
            -- MC4 User
  SELECT * FROM txn_mobile_collection_header WHERE COL_NO LIKE 'CCMC4000006%'
            SELECT * FROM di_mobile_txn_collection_header WHERE doc_no LIKE '%CCMC4000006%'
SELECT * FROM di_mobile_txn_collection_header_at WHERE doc_no LIKE '%CCMC4000006%'
            select * from txn_type_running_no where member_id= '45f5e0e9cf9543c4b16b767c51e06cc1' and type= 'collection'
select * from member where member_cd='mc4'
As we checked from di_ actual and at table the particular collection did not entered in. already checked the mobile database but still the collection already missing 
Already asked for MS2 user eother there was a error or not when they perform the collection activity

#2 Updated by Muhammed Azhar Mohamed Maideen 5 months ago

  • Status changed from Assigned To to Support In Progress

#3 Updated by Muhammed Azhar Mohamed Maideen 5 months ago

  • Status changed from Support In Progress to Pending Client Verification
  • Resolution updated (diff)

#4 Updated by Muhammed Azhar Mohamed Maideen 4 months ago

  • Status changed from Pending Client Verification to Ticket Resolved
  • Type set to Support Request
  • Actual Initial Response set to 10/05/2024

Also available in: Atom PDF