SMUD WDN File Validation — Internal Checklist

This article provides the steps required to validate WDN files received from SMUD to ensure they are properly ingested and processed within the system.
 

1. File System Check

Directory Path:

/opt/10612_61396/sftpData/ToMB/WDN/processed/

• Verify that a folder exists for today’s date (e.g., 2025-11-20).
• Files delivered after 9:45 AM should appear inside the date-specific folder.
• If the file exists in the folder but does not appear in the database, this means it was picked up but failed to log. Escalate immediately.

2. Database Validation

Run the following query to validate file ingestion:

SELECT *
FROM custom_data
WHERE paid_int = 8002
 AND import_dt = CURDATE();

• Ensure filename_vch matches the uploaded filename.
• Ensure mbid_vch contains a value, confirming the message was created.
• If mbid_vch is NULL or empty, the file was ingested but no message was generated. Investigate further.

3. Payload Error Review (filedata_vch)

If problems are detected, inspect the parsed payload stored in filedata_vch.

{
  "filename": "activation.20251120075619_2620409_1.xml",
  "channel": "voice",
  ...
  "error": "Expiry datetime has already passed"
}

• The error 'Expiry datetime has already passed' indicates the timestamp inside the payload is earlier than the processing time. Review and correct the XML timestamp if needed.