Unable to run a new commcare app , Unable to find lookup table "jr://fixture/commcare:reports". Make sure it exists and this user has access to it

Developers
1

I moved a working app from another domain to a new one. I recreated the UCR report that the app needs. When I try running the app , I am getting this error message "Unable to find lookup table "jr://fixture/commcare:reports". Make sure it exists and this user has access to it."

Can anybody please explain to me what the problem is and how to fix this issue?

image
image2999×1624 398 KB

2

it's looking for a lookup table called reports that you don't have in your project space

3

https://dimagi.atlassian.net/wiki/spaces/commcarepublic/pages/2143955074/Lookup+Tables

4

Thanks for the reply @Mazz ,

That app do not access a lookup tabled called Reports. I checked and there is no Report Lookup on the domain where I copied the app from.

This error only occurs when I added Report Menu to the application, which should display a web report on the mobile.

5

ah I see, I am not familiar with this feature, so maybe it's looking for a report called reports?

6

Yes , I changed the menu name to a different name but its displaying the same error. We also don`t have any web or mobile reports named 'reports'.

FYI : All UCR related feature flags are turned on.

image
image2943×1669 396 KB

7

sounds like a support request then probably

8

On a simulator, it opens the app successfully but clicking the menu, it displays the error.

image
image2313×1414 113 KB

Error Message

image
image2136×1229 136 KB

9

Hi @andyasne ,

Wanted to quickly check after recreating the UCR report, did you also perform the sync (through the Sync Icon) ?
I recently had this message popped up and it was resolved after sync. This is because report fixtures are made available after user sync/restore .

10

Thank you @ayadav , It worked on the real device after syncing.
Form player is still displaying that error after clearing user data and syncing.

11

@andyasne this looks to me like a compatibility issue between mobile UCR v1 and v2. In v1 all reports were under a single fixture called commcare:reports, but in v2 each report is a standalone fixture.

Essentially it sounds like your app is referencing v1, but the restore probably has v2 reports. There should be a "Mobile UCR Restore Version" setting on the app settings tab, depending on what flags you have enabled. Do you see this? What is it set to? I'd guess if you switch it to ensure it's the same as the original app, this should work.

12

look the question where it uses lookup table. Create the lookup table in you new domain/space. Link the table again. on the app simulator click setting and click done.

13

I faced a similar issue before — the error "Unable to find lookup table ‘jr://fixture/commcare:reports’" usually means the required fixture (lookup table) hasn’t been synced properly to the mobile device or isn’t available to the current user.

Here are a few things you can check:

  1. Lookup Table Exists: Go to Data > Lookup Tables in your CommCare HQ project and confirm that commcare:reports exists.
  2. User Has Access: Ensure that the mobile worker or user you're testing with has access to the location or data that the fixture is assigned to. If you're using location-based data, check the user’s location assignment.
  3. Sync Issues: Try forcing a full sync on the mobile device (from the app's settings) or log out and log back in.
  4. App Build: Make sure your latest changes are saved and deployed by rebuilding and installing the latest version of the app.

Let me know if you've already checked these, and I’ll be happy to help dig further!