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!!
Discussion posts and replies are publicly visible
We need much more details to be able to say anything.
hi veerag6659 are you receiving any errors while querying the data? Did you check the logs? Could you provide more context on this please
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.
Hi veerag6659 There are a few possible causes for this issue:
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.
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?
If query entity is working and query record type is not, then check whether the data in database is synced with record. If not, sync the record and try using query record type
Already tried multiple time of record sync, but still no luck.
From the docs
https://docs.appian.com/suite/help/24.1/fnc_system_queryrecordtype_20r4.html
Thanks Methieu. It seems the we need to ensure even relationship record types also needs to be synced.
Check if all the records you are using in the query and related are synced.