SAM Esign Document Download Issue

SAM Esign Document Download Issue

Hi Team,

for Future Samasta Esign document download issue case please check the branchid added in the region table and proceed . 

select * from t_EsignToolRegion where RegionID = '1705'

SELECT COUNT(t_SYstemBranchregion.RegionID),t_SYstemBranchregion.RegionID
FROM V_EServiceRequest t_eServiceRequest WITH(NOLOCK)
INNER JOIN t_SYstemBranchregion(NOLOCK)
ON t_eServiceRequest.OurBranchID = t_SYstemBranchregion.OurBranchID 
WHERE StatusID='P'
AND DocumentID IS NOT NULL
AND ISNULL(IsDocumentDownloaded,0) = 0
GROUP BY t_SYstemBranchregion.RegionID

If all this check is ok check with IT team Legalitydocument download tool is running or not and confirm.

Regards,
kathir