PCOC CPIC Weekly Data Extract (MSFT)

Owned by Roxanne Lafleur (Unlicensed)
Last updated: Nov 08, 2023 by Hunt, Christopher

How the transfer works

This is the current information for the CPIC transfer as it is now using MSFT

  • Hetherington, Jake [mailto:Jake.Hetherington@rcmp-grc.gc.ca] - is the RCMP contact who has replaced Tracy Leung.
  • Neil Ballantyne - technical resource who set up the service to transfer the file to the MSFT pick-up location.
  • Myke Dwyer - Business representative for PCOC
  • The name of the file generated: cpic_extract_pcoc.zip
  • Script location that generates the zip file: \\ncrws548\scripts\mss-scripts\cpic-extract-weekly

The CPIC file transfer to the RCMP is now done by MSFT (Managed Secure File Transfer). Neil Ballantyne has set up a service that picks up the zip file from \\ncrws548\scripts\mss-scripts\cpic-extract-weekly and transfers it to \\10.10.40.220\cpic_out$. Access to \\10.10.40.220\cpic_out$ is restricted special permissions need to be granted via ServiceDesk to drop files here for transferring.

It's important to note that it is a transfer that occurs and not a copy and paste. One challenge we encountered was that the file was being transferred before the zipping process could occur, which truncated the file. To avoid this we extended the transfer time by 5 minutes to allow the zipping process to happen. The zip file is still generated as it was before but has a static name - cpic_extract_pcoc.zip.

The file name was changed, the date has been removed from the name as the document name needs to be the same name every week, to be recognized by the Service that will transfer it.

Troubleshooting Issues

Every so often the transfer fails and Myke Dwyer will get notified by someone at RCMP.

One reason it may have failed is due to the server getting updated hotfix patches. The server resides with SSC, therefore we don't get any notifications on the restart. 

If it does go down contact either Mike Massaad (mike.massaad@tc.gc.ca) or Youssef Kachouh (Youssef.Kachouh@tc.gc.ca) with the Endpoint security team (natendpointsecurity-securitedesterminaux@tc.gc.ca).

Request them to inspect the MSFT server situation to see if it is down. In most cases it is and they just restart it and will notify us.