Troubleshooting failed scheduled reports
Troubleshooting Blank or Failed Scheduled Reports
This guide explains how to troubleshoot scheduled reports that are failing to run or appearing blank in Clarus WMS. Follow these steps before escalating the issue or requesting further assistance.
Step-by-Step Guide
1. Check the Report
Go to the report in question and run it to see if it generates data successfully. If the report runs with data, it usually means the report's parameters and variables have been changed by the user. Since 'my reports' are user-specific, you will need to speak to the client and ask for screenshots to identify these changes.
2. Review the Report Query
If the customer provides screenshots showing additional input in the parameters, check the report queries on their domain. Unlike 'my reports', report queries are the same for all users on a single domain (e.g., updating a report query for 'Warrens' on your account will update it for all 'Warrens' users).
Once you locate the report query, look through the script. If a 'delivery address name' has been added to the user's report, it should appear in the report query. If it's not visible, you will need to add it.
WARNING: Always test on your own domain first before changing a client's query!The path is simply the name of the property you want to include, along with any 'parent' objects. For example:
node.original_delivery_address.name
node.goods_out_pick_list.id
Once completed, add the parameter to the report. You will most likely need to ask the user to add this to their report.
3. Check MailChimp (if the report was successful)
If the report successfully ran, check if it was actually sent. Go into MailChimp by following this path:
Mailchimp > Automations > Transactional Email > Launch App > Outbound > 'Enter Email'
If the email status is 'Rejected', it usually means the email was filtered as spam by the recipient or was blacklisted. In both cases, this will require input from their external IT team (advise them to contact their IT department).
If the email status is 'Delivered', it suggests the email was sent without any issues. This will require further investigation on our end. In this case, check the remaining troubleshooting steps or message #support.
FAQs
What does 'my reports' mean?
'My reports' refers to reports that are specific to an individual user's settings and configurations within Clarus WMS.
What is a 'report query'?
A 'report query' is a script that defines what data is retrieved for a report. Unlike 'my reports', report queries are shared across all users on a specific domain.
What should I do if an email is 'Rejected' in MailChimp?
If an email is 'Rejected', it typically means it was blocked as spam or blacklisted. Advise the client to contact their IT department for assistance.
What should I do if an email is 'Delivered' but the user still hasn't received it?
If an email is 'Delivered' in MailChimp, it indicates successful sending. You should proceed with further investigation of other troubleshooting steps or contact #support.
Related Articles
How do I set up scheduled reports in Clarus WMS?
Automate your reports for timely updates with scheduled reports in Clarus WMS. This guide provides a simple, step-by-step process to set up these reports using pre-built templates, ensuring you always receive important information at your chosen ...Imports unsuccessful Troubleshooting
Troubleshooting Failing or Unuploaded Imports This guide helps you resolve issues where your imports are not working correctly or are not appearing in Clarus WMS. Follow these steps to diagnose and fix common problems. Step-by-Step Guide 1. Check ...Troubleshooting - Checking the FTP/SFTP Queue
Checking the FTP/SFTP Queue This guide explains how to check the FTP and SFTP queues to ensure your import files are processing correctly in Clarus WMS, especially when dealing with large datasets or potential import failures. Step-by-Step Guide 1. ...How to use Mailchimp
How to Trace Emails for Password Resets and Scheduled Reports This guide explains how to trace emails sent from Clarus WMS, such as password resets or scheduled reports, to check if they have been successfully delivered to the client's email address. ...How do I remove a Scheduled Report in Clarus WMS?
How to Remove or Delete a Scheduled Report This article provides a simple guide on how to remove individual reports from a schedule or delete an entire scheduled report in Clarus WMS. Follow these straightforward steps to manage your scheduled ...