Issue Analyses For Moving Records for Print Slowness

Owned by Kavya VN, created
Aug 23, 2022
1 min read

Date: 08 August 2022

Description:

packets are moving as expected to the credentials transaction table is slowness

Steps: Check the DB Report from the query

Note: The date is changed according to the requirement

select count(*) from credential.credential_transaction where status_code='ISSUED' and issuancedate>='2022-08-22 16:00:00' and issuancedate <= '2022-08-23 15:59:59' and request like '%msp-printers%';

The result will show according to the configuration

Solution:

1)We have Recreated the composite credentials transaction for the mosip_credentils schema

before it was individual (saparate index)

 

 

2)There 2 junk Records which has a length of 41, it supposes that they have a maximum length of is Uu id column has 36

We had removed those 2 junk records from the credentil_transaction table

then packets moving as expected with constant speed