• State Not Answered
  • Replies 3 replies
  • Subscribers 10 subscribers
  • Views 2579 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

Error occurred while retrieving data. Troubleshooting done. What now?

naomi0001

I am receiving this error An error occurred while retrieving the data for {record} (APNX-1-4205-003) when I attempt to access a record after I deployed as an enhancement. In the original environment, there was no problem accessing the record. When deployed to another environment, the record opened once and when we changed the filter, we got the error and were not able to open the record again without clearing the cache for the browser.

  Discussion posts and replies are publicly visible

Parents
  • 0

    Hello Dear,

    First compare the number of rows on both environments usually this occur after 100k rows in the record data subset. I would suggest to try below things 

    • Try to reduce items per page.
    • Enable DB indexing on columns used in filter.
    • Check the query timeout on the server. You can find that in config file Conf.data.query.timeout property.
    • Use expression backed record if data set is large.
Reply
  • 0

    Hello Dear,

    First compare the number of rows on both environments usually this occur after 100k rows in the record data subset. I would suggest to try below things 

    • Try to reduce items per page.
    • Enable DB indexing on columns used in filter.
    • Check the query timeout on the server. You can find that in config file Conf.data.query.timeout property.
    • Use expression backed record if data set is large.
Children
No Data

© 2024 Appian. All rights reserved.