REMIT Troubleshooting Guide

K8s Logs Check

Pods to check: remit, safewatch, flexsoap

cont1601650
source ug-msb-prod
pods | grep -E 'remit|safe|flexsoap'

Logs to check (with cont160150)

Pods to check: remit, flexsoap, safewatch

Combined commands

kubectl logs pod-name
kubectl logs <pod-name> -n <namespace> --tail=200

Pod commands & tips

application logs check

kubectl get pods -n <namespace> | grep <pod-name>
kubectl describe pod <pod-name> -n <namespace>
kubectl logs -f <pod-name> -n <namespace> --all-containers

API calls (copyable)

TRPY

curl -sk -X POST 'https://10.137.129.57:8443/apizone-gateway/PRODUCTION-DTBU/AZRemittanceServices/1.0/remittance/TRPY/query-account' \
--header 'Content-Type: application/json' \
--header 'X-API-Key: 454d601a-7e15-4c3e-bbdb-448340c4cf5e' \
--header 'Authorization: Bearer eyJhbGciOiJSUzI1NiIsInR5cCIgOiAiSldUIiwia2lkIiA6ICI2bGhzZ1RMUFJUNHE3RUNjQXBOaVpDNC1ranVTV0lQbmpPQ2lodlNSWTc0In0.eyJqdGkiOiI3Yzk5MTkzMC0xY2EyLTRkYWYtYTQ0MS02MDc2NTkzNmRmNzMiLCJleHAiOjE3NjAxMDY3NDcsIm5iZiI6MCwiaWF0IjoxNzI4NTcwNzQ3LCJpc3MiOiJodHRwOi8vMTAuMTM3LjEyOS44Nzo4MDgwL2F1dGgvcmVhbG1zL0RUQkFQSUdXIiwiYXVkIjoiRFRCQVBJQ2xpZW50Iiwic3ViIjoiNDQ0ZDQzNTktYmQ4YS00MjU2LTk5M2UtYzQxNThmNDU3YjE0IiwidHlwIjoiQmVhcmVyIiwiYXpwIjoiRFRCQVBJQ2xpZW50IiwiYXV0aF90aW1lIjowLCJzZXNzaW9uX3N0YXRlIjoiNzI4NGU5MjEtODYwMy00ZGJhLTg4YjctMTQ1ZmQ5NGY5ZDVhIiwiYWNyIjoiMSIsImNsaWVudF9zZXNzaW9uIjoiMWViNDdkMjQtMjA5ZS00OTI3LThjOTEtOWE2NjYzNjUwODNjIiwiYWxsb3dlZC1vcmlnaW5zIjpbXSwicmVhbG1fYWNjZXNzIjp7InJvbGVzIjpbIlVHVGVycmFwYXlBcHBSb2xlIiwidW1hX2F1dGhvcml6YXRpb24iXX0sInJlc291cmNlX2FjY2VzcyI6eyJhY2NvdW50Ijp7InJvbGVzIjpbIm1hbmFnZS1hY2NvdW50Iiwidmlldy1wcm9maWxlIl19fSwibmFtZSI6IlVHIFRlcnJhcGF5IFVzZXIiLCJwcmVmZXJyZWRfdXNlcm5hbWUiOiJ1Z190ZXJyYXBheV9hcHBfdXNlciIsImdpdmVuX25hbWUiOiJVRyBUZXJyYXBheSIsImZhbWlseV9uYW1lIjoiVXNlciIsImVtYWlsIjoidWdfdGVycmFwYXlfYXBwX3VzZXJAZHRiYWZyaWNhLmNvbSJ9.f0Qr9jZZEzGiRdDXIUjH32FpPvykyOZUEO5NdvabZitBveNtCHyAdbCRFIhL9f93YkB6msgvH_NQaSJ5zxf_Q3AqqgOQualaSc4nO-ah3t2e-8R4S0OKBqHnacb6O_ekOp9hhKR3821BIdQxvhc-pVOXf1PUEUHfq9IO9CavHBKrR_4tTFCzBA3-GLW29vhqKWvBxzNHyKURqV3zRH6gg4qj7CdXLNKW_Xxn-OwBkJwXky1DxP6OuLNR68edGRMKjAdyYhQ0jA-yuZLDxQdnN3v682xWfnMxYL2GuAU6Iyj5zXpeE_IB0Syk2Jv6jsKm51W2h2yYwOC98SQGRNaR1A' \
--data '{
    "request_identifier": {
        "xref": "100010000101",
        "user_id": "API_TRPYUSER",
        "password": "5mmFExeSHT813/DgpQ==",
        "channel": "API"
    },
    "request_data": {
        "account_number": " 0326145001"
    }
}'

UPSI

curl -sk -X POST 'https://10.137.129.57:8443/apizone-gateway/PRODUCTION-DTBU/AZRemittanceServices/1.0/remittance/UPSI/query-account' \
--header 'Content-Type: application/json' \
--header 'X-API-Key: fb33db80-ebde-4ff6-8010-87fb60ea4112' \
--header 'Authorization: Bearer eyJhbGciOiJSUzI1NiIsInR5cCIgOiAiSldUIiwia2lkIiA6ICI2bGhzZ1RMUFJUNHE3RUNjQXBOaVpDNC1ranVTV0lQbmpPQ2lodlNSWTc0In0.eyJqdGkiOiI2MGE4MDZlMS0zYzg0LTQxN2ItYTQyNy1kMjZkMTUwYzM5YWYiLCJleHAiOjE3NzcwMTI0NzMsIm5iZiI6MCwiaWF0IjoxNzQ1NDc2NDczLCJpc3MiOiJodHRwOi8vMTAuMTM3LjEyOS44Nzo4MDgwL2F1dGgvcmVhbG1zL0RUQkFQSUdXIiwiYXVkIjoiRFRCQVBJQ2xpZW50Iiwic3ViIjoiNjUxMGUxM2QtMTMwMS00Mzk0LTk0MjgtMGE1YjM5Zjg4Mjc3IiwidHlwIjoiQmVhcmVyIiwiYXpwIjoiRFRCQVBJQ2xpZW50IiwiYXV0aF90aW1lIjowLCJzZXNzaW9uX3N0YXRlIjoiNzllYjQ2OTEtMDk0Yy00MDNjLTg1MDMtZmExNDAyYWE4ZTkxIiwiYWNyIjoiMSIsImNsaWVudF9zZXNzaW9uIjoiMDRmYjBhNWUtOGIzNy00NTQzLTliOWEtZDZhNmI3NTQ0OTY2IiwiYWxsb3dlZC1vcmlnaW5zIjpbXSwicmVhbG1fYWNjZXNzIjp7InJvbGVzIjpbInVtYV9hdXRob3JpemF0aW9uIiwiVUdVUEVTSUFwcFJvbGUiXX0sInJlc291cmNlX2FjY2VzcyI6eyJhY2NvdW50Ijp7InJvbGVzIjpbIm1hbmFnZS1hY2NvdW50Iiwidmlldy1wcm9maWxlIl19fSwibmFtZSI6IlVHIFVQRVNJIEFwcCBVc2VyIiwicHJlZmVycmVkX3VzZXJuYW1lIjoidWdfdXBlc2lfYXBwX3VzZXIiLCJnaXZlbl9uYW1lIjoiVUcgVVBFU0kiLCJmYW1pbHlfbmFtZSI6IkFwcCBVc2VyIiwiZW1haWwiOiJ1Z191cGVzaV9hcHBfdXNlckBkdGJhZnJpY2EuY29tIn0.TZKoVl6rnLyKhvqmF-wU57z_rSLjrTEhf8cRvl0zf6gT5e7KWb5NJVateCwT8E3hO_hSx2aI2tSyM0czEb7mYa8ZwGAC2vme2N-b36Zt9mZQsCUruP2hX3l985YC8ibnsbzagOGDAXGYPuAGE8JySZWpU4azajqHB5jQO9iOjxOeG5gySnPsDQN3QBhMNO5bJNaQLC2FZsVbTIiSoa_6jsxgw1Zk3-T1fBUGx_38waQnW3RhPk6_e7Jw5veLTz6lpFqn0FxmFjbhCQoRHuRTSUoaOnm4WcfcDiD_dLLghRk6KoDZYVgw_fZUBQpO_scIKWuzqJ8V4gvMbRdfd_7efQ' \
--data '{
    "request_identifier": {
        "xref": "100010000101",
        "user_id": "API_TRPYUSER",
        "password": "5mmFExeSHT813/DgpQ==",
        "channel": "API"
    },
    "request_data": {
        "account_number": "0326145001"
    }
}'

DB queries

All Queries

select * from ug_az_prc_remittance_b2w uaprbw where institution_code ='UPSI' and mno_code ='MTNE'and record_status ='SUCCESS' and cast("timestamp" as date)=current_date order by "timestamp" desc limit 1;

select * from ug_az_prc_remittance_b2w uaprbw where institution_code ='UPSI' and mno_code ='MTNE'and record_status <> 'SUCCESS' and cast("timestamp" as date)=current_date order by "timestamp" desc limit 1;

select * from ug_az_prc_remittance_b2w uaprbw where institution_code ='UPSI' and mno_code ='MTNE'and record_status ='SUCCESS' and cast("timestamp" as date)=current_date order by "timestamp" desc limit 1;

select * from ug_az_prc_remittance_b2w uaprbw where institution_code ='UPSI' and mno_code ='MTNE'and record_status <> 'SUCCESS' and cast("timestamp" as date)=current_date order by "timestamp" desc limit 1;


select cast("timestamp" as date) ,record_status, count(*)  from ug_az_prc_remittance_b2w uaprbw where cast("timestamp" as date)=current_date and institution_code ='UPSI' and mno_code ='ARTL' group by record_status,cast("timestamp" as date) ;

select record_status, count(*)  from ug_az_prc_remittance_b2w uaprbw where cast("timestamp" as date)=current_date  and institution_code ='UPSI' and mno_code ='ARTL' group by record_status;

select cast("timestamp" as date) ,record_status, count(*)  from ug_az_prc_remittance_b2w uaprbw where cast("timestamp" as date)=current_date and institution_code ='UPSI' and mno_code ='MTNE' group by record_status,cast("timestamp" as date) ;

select record_status, count(*)  from ug_az_prc_remittance_b2w uaprbw where cast("timestamp" as date)=current_date  and institution_code ='UPSI' and mno_code ='MTNE' group by record_status;

Troubleshooting flow

Check pod health
Tail logs
Reproduce API call
Check DB
Inspect deploys/config changes

Notes & tips

Sanitize tokens before sharing
Use env vars for secrets