Error fetching choices

Support
1

Hi everyone.
I have an issue with ODK-X survey. When i want to create a new instance in ODK-X survey and press next, i got the error Error fetching choices -- no ajax query or choices defined. I saw this topic but my choices sheet is in the file. I don’t know what can produce this error

2

Hi @Francky_NGUEMA, are you able to share your xlsx for the survey form?

3

Hello. Thanks for responding so quickly.
There is the xlsx, i use linked table.
sudesa.xlsx (16.9 KB)
sudesa_members.xlsx (12.5 KB)

4

Where is the error happening? Is it when you create a new instance for the sudesa form or try to make a new member (members tab–>sudesa_members)

5

The error is hapenning when i try to create new instance for the sudesa form. I can make a new member without any issue

6

It looks like you have in the sudesa form, household section, some select_one prompts without a values list. You need to have both a name and a values_list from the choices sheet for select_ones. This might be the issue.

1 Like
7

Effectively. I didn’t pay attention. thank you very much for your time

1 Like
8

After uploading the files in my device i always got the same error, nothing changed.

9

Have you checked the logs to see if there are any particular errors? Logging Capabilities of Apps — ODK-X Docs documents how to check the logs.

11 
04-02 17:58:30.296  9480 10195 W odkCommon: Using this.mdl.formDef.specification.choices instead of Table properties for choice definitionsundefined
04-02 17:58:30.297  9480 10195 W odkCommon: atEnd.outstandingContext seqNo: 20 (seq: 21 [screenManager:commonDrawScreen - buildRenderContext] timestamp: 1712077110297)un...
04-02 17:58:30.298  9480 10195 E odkCommon: failure! Error fetching choices -- no ajax query or choices defined contextType: callback (seq: 21[screenManager:commonDrawSc...
04-02 17:58:30.316  9480 10195 I odkCommon: controller._doActionAtLoop: path: household/0 action: begin_screen (seq: 20 [screenManager.gotoNextScreen] timestamp: 1712077...
04-02 17:58:30.321  9480 10195 E MainMenuActivity: setSectionScreenState( household/0, null)
04-02 17:58:30.324   626   626 E SurfaceFlinger: Attempt to update InputPolicyFlags without permission ACCESS_SURFACE_FLINGER
04-02 17:58:30.331  9480 10195 I odkCommon: screens.screen._whenTemplateIsReady.success.setTimeout (seq: 22 [screenManager:commonDrawScreen - buildRenderContext] timesta...
04-02 17:58:30.341   626   626 E SurfaceFlinger: Attempt to update InputPolicyFlags without permission ACCESS_SURFACE_FLINGER
04-02 17:58:30.351  9480 10195 W odkCommon: atEnd.outstandingContext seqNo: 20 (seq: 22 [screenManager:commonDrawScreen - buildRenderContext] timestamp: 1712077110350)un...
04-02 17:58:30.351  9480 10195 I odkCommon: success! contextType: callback (seq: 22[screenManager:commonDrawScreen - buildRenderContext] timestamp: 1712077110322) seqAtE...
04-02 17:58:30.353   626   626 E SurfaceFlinger: Attempt to update InputPolicyFlags without permission ACCESS_SURFACE_FLINGER
04-02 17:58:30.366  9480 10195 W odkCommon: atEnd.outstandingContext seqNo: 23 (seq: 20 [screenManager.gotoNextScreen] timestamp: 1712077110366)undefined
04-02 17:58:30.367  9480 10195 I odkCommon: success! contextType: click (seq: 20[screenManager.gotoNextScreen] timestamp: 34636 guid: 73 curTgt:  <span class="glyphicon ...
04-02 17:58:30.370   626   626 E SurfaceFlinger: Attempt to update InputPolicyFlags without permission ACCESS_SURFACE_FLINGER
04-02 17:58:30.388  9480 10195 E odkCommon: failure! Error fetching choices -- no ajax query or choices defined contextType: callback (seq: 23[controller._synthesizePopu...
04-02 17:58:30.394   626   626 E SurfaceFlinger: Attempt to update InputPolicyFlags without permission ACCESS_SURFACE_FLINGER
04-02 17:58:30.444   626   626 E SurfaceFlinger: Attempt to update InputPolicyFlags without permission ACCESS_SURFACE_FLINGER

This is a portion of the logs

12

Ah-ha! The error says there’s no callback column in your queries sheet, and indeed it is missing. You can see the required columns here: Using ODK-X XLSX Converter — ODK-X Docs which include the callback one.

13

Thanks for your answer. I look the documentation and i noticed that the callback column is required only for getting external data but i use linked_table queries and this column is not among those required.