/build/static/layout/Breadcrumb_cap_w.png

Scheduled Reports send empty zip files

Symptoms:

You have a report that runs perfectly fine and can confirm it has content.
You shedule it to run but when it arrives you have a zero kb zip file.

Solution:

Came across this today because the report name had an apostrohe in it. ex; John's Report

Cause:

When scheduling a report the name is passed as a paramater in a sql query. The ' charachter causes an end of field and terminates the report before it can run.

* I havent confirmed but suspect other charachters such as % would cause issue as well


Comments

  • Had the same issue, looks like parenthesis also cause an an empty zip file. - James_Rico 11 years ago
  • What K1000 version(s) did this happen on? - jknox 11 years ago
  • This is a 5.4 issue. Any SQL special character causes it to occur. - jdornan 11 years ago
This post is locked
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ