Question

Query Record Type not fetching the data from database

Forum|Forum|2 years ago
May 27, 2024
10 replies
1 view

Unable to fetch the data from database through a!queryrecordtype in High Availablity environment set up and its always returning null value eventhough data is present in the table.

Kindly revert to me if anyone aware of the fix.

Thanks for your help in advance!!

stefanhelzle0001

We need much more details to be able to say anything.

karumurua531442

hi [mention:366bca2607124a4181ecd853dced499d:e9ed411860ed4f2ba0265705b8793d05] are you receiving any errors while querying the data? Did you check the logs? Could you provide more context on this please

V

veerag6659Author

Recently we migrated our environment setup from standalone to High Availability. When we try to fetch the data through a!queryrecordtype resulting null value. There is no any specific log related to this. In the data seeing this Error APNX-1-4205-039.

karumurua531442

Hi [mention:366bca2607124a4181ecd853dced499d:e9ed411860ed4f2ba0265705b8793d05] There are a few possible causes for this issue:

There is a lock on the database.
There is too much data being pulled back.
The query timed out.

You can check with your DBA on removing the lock on the database. Reconsider if the amount of data being pulled back is reasonable and possibly redesign/optimize the query.

V

veerag6659Author

Query entity and Query rule are working as expected able to fetch data from database. If there is any issue with database, will query entity and query rule work?

Sign up

Login with SSO

Login to the community

Login with SSO