Error accessing SQL data
Views (716)
Issue: Custom report developed in dexterity not printing.
Error Message: Error accessing SQL data
On looking for error detail, leads to support kb article https://support.microsoft.com/en-hk/help/857827/error-message-when-you-try-to-generate-a-large-report-in-microsoft-dyn
which mention to add below lines in dex.ini file.
- SQLQueryTimeout=0
- SQLProcsTimeout=0
- SQLRprtsTimeout=0
before adding these lines I thought to check number of records in table as this article mentioned due to large report (what I understand with large report is a report having lots of data) this error came. But to my surprise table was not there in SQL. Created the table and error disappear.
This was originally posted here.
*This post is locked for comments