Troubleshooting Small File Size issues in daily Subscriber Data files

Overview

This article explores the issue of small file sizes during SFTP transfers and provides a methodical approach to resolving it, based on a specific case study.

Solution

1. Identify the Issue: Recognize the problem with file sizes during transfers.
2. Analyze the Source: Check the source path and the transfer script.
3. Retrieve Older Files for Comparison: Compare with older files for size discrepancies on the Source server.
4. Execute Necessary Actions on Database Server: If the Originating server is extracting data from DB, involve the DB team for another extract/investigation.
5. If a file has been regenerated, verify the size and retransfer to the required destination.

Summary

The article outlines steps to troubleshoot and resolve the issue of small file sizes during SFTP transfers, emphasizing the importance of server and database analysis.

FAQ

1. What should I do if I notice small file sizes during SFTP transfers?

Check the source script and file sizes on both source and destination servers, and investigate database server processes if discrepancies are found.

2. How can I compare the file sizes to confirm the issue?

Retrieve older, correctly transferred files for size comparison with the current file.

3. What actions can be taken on the database server to resolve this?

Actions may vary based on server setup but could involve reconfiguring file generation processes or adjusting transfer scripts.