Issue with Lookup Table Error Affecting Multiple Users

Hi,

We’ve encountered an error when trying to use a form: “unable to find lookup table...”. The table does exist and is working for most users. So far, the only way we’ve found to resolve this is by manually performing a “force full refresh” for the affected user. However, with over 27,000 users on the system, it’s not feasible to do this individually for everyone. Is there a way to address this issue for all users at once?

Hi Andyasne,
Did you try to ask the affected users to synch with server? Lookup tables always need synchronizing the devices so it takes place and be reflected on the apps in the devices
Aslo, you can set up the auto synch frequency on the app settings to "daily"
can you try and confirm if it works?

Hi Andinet,

This issue is likely related to a bug we encountered recently. We made changes so that a lookup table is only included in a user’s restore if either:

  1. the lookup table has been updated since the user’s last restore, or
  2. the user is performing a full restore.

There were some issues with the rollout of this change, which may have caused some users to end up with missing lookup tables in their restore.

To fix this issue without needing to trigger full restores for each user, you can resave the lookup table that’s causing the issue. This will update its “last modified” timestamp and ensure it gets included in the next incremental restore for all users.

1 Like