I'm getting an error when trying to save a PDF to file:
.... Could not create local cache for data from your Database. Your Database reported the following error:
Error 1000 - An attempt was made to move the file pointer before the beginning of the file.
a5_bemp_5807970d-258c-494a-92ad
while converting ResultSet to DBF table
Some observations:
- This app uses MS SQL 2012, report is all SQL data source
- The error only shows when I try to save report to file (using a5w_report_saveAs() )
- The same report prints fine to the browser
- Other reports save just fine to file
- In Live or Working Preview mode, A5 just freezes when we hit a5w_report_saveAs(). Only solution is to end task
- I've simplified the filter and number of records (Myfieldname = 5), hardcoded in the most simple manner I can each of the parameters in an attempt to find the culprit
- If I specify saving to a folder that does not exist, I get a message from the A5 server that the file cannot be created. So it's trying something
- The error message doesn't show up right away -- it's many minutes after the attempt.
- One characteristic that's a little different for this report vs. others is that this is against a View that contains about 4 million records. Yet we print other reports to browser and file against that table and/or view.
- This has been a problem for about 3 months now, unsolved, which means I've gone through an official build or two - currently on a pre-release from last week.
Anyone have ideas or run into this/solved this?
.... Could not create local cache for data from your Database. Your Database reported the following error:
Error 1000 - An attempt was made to move the file pointer before the beginning of the file.
a5_bemp_5807970d-258c-494a-92ad
while converting ResultSet to DBF table
Some observations:
- This app uses MS SQL 2012, report is all SQL data source
- The error only shows when I try to save report to file (using a5w_report_saveAs() )
- The same report prints fine to the browser
- Other reports save just fine to file
- In Live or Working Preview mode, A5 just freezes when we hit a5w_report_saveAs(). Only solution is to end task
- I've simplified the filter and number of records (Myfieldname = 5), hardcoded in the most simple manner I can each of the parameters in an attempt to find the culprit
- If I specify saving to a folder that does not exist, I get a message from the A5 server that the file cannot be created. So it's trying something
- The error message doesn't show up right away -- it's many minutes after the attempt.
- One characteristic that's a little different for this report vs. others is that this is against a View that contains about 4 million records. Yet we print other reports to browser and file against that table and/or view.
- This has been a problem for about 3 months now, unsolved, which means I've gone through an official build or two - currently on a pre-release from last week.
Anyone have ideas or run into this/solved this?