web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :

Error accessing SQL data

Almas Mahfooz Profile Picture Almas Mahfooz 11,009 User Group Leader

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.

Comments

*This post is locked for comments