In SEQ search Q164


Go down to the error and look at the row before this. 


This line before the error will show the creditor code it has issues with. 

Add this code into the below SQL script run into DCS 

USE DCSLive
SELECT c.CRID, cpd.FtpServer,cpd.FtpRoot, c.CR_DMSCode FROM dbo.tblCreditorProposalDelivery cpd
JOIN dbo.tblCreditor c ON c.CRID = cpd.CRID
where CR_DMSCode = 

This will give you the creditor name to look for. 


From here 


Log on to vmcompro1app01 with StepChange credentials

· Open WinSCP and login to FTP using the information from the tblCreditorProposalDelivery table in live DCS (LDSDCSPRO1DBa01 (ftpserver = host name)

USE DCSLIVE

SELECT *
   FROM [DCSLive].[dbo].[tblCreditorProposalDelivery]

· Check to see if the folder exists, if it does check the spelling (including capital letters and spaces), if it does not exist create a new empty folder titled identically to the relevant FTP_Root

· Open Communications (Remote Desktop Connection)

· Navigate to Q164, select and press 'start' 

· When status reads 'Pending', go back to WinSCP and check that the relevant folders have been updated (check for today's date and time)