Error occurred during deployment, although there were no errors during previewing

bayu_skm · February 10, 2025, 3:32am

Hi,

I am facing an error during deployment, even though there are no errors when previewing the form. The error seems to occur because I created rules for 10 select_one questions:

The options are limited to one: Choose.
The option will disappear in the other 9 questions if one question has already been selected.
Mandatory for all 10 questions if none of the questions have been selected.
This mandatory requirement will disappear in the other 9 questions if one question has already been selected.

type	name	required	choice_filter
select_one ya	calon1	${calon2}=‘’ and ${calon3}=‘’ and ${calon4}=‘’ and ${calon5}=‘’ and ${calon6}=‘’ and ${calon7}=‘’ and ${calon8}=‘’ and ${calon9}=‘’ and ${calon10}=‘’	not(selected(${calon2},name)) and not(selected(${calon3},name)) and not(selected(${calon4},name)) and not(selected(${calon5},name)) and not(selected(${calon6},name)) and not(selected(${calon7},name)) and not(selected(${calon8},name)) and not(selected(${calon9},name)) and not(selected(${calon10},name))
select_one ya	calon2	${calon1}=‘’ and ${calon3}=‘’ and ${calon4}=‘’ and ${calon5}=‘’ and ${calon6}=‘’ and ${calon7}=‘’ and ${calon8}=‘’ and ${calon9}=‘’ and ${calon10}=‘’	not(selected(${calon1},name)) and not(selected(${calon3},name)) and not(selected(${calon4},name)) and not(selected(${calon5},name)) and not(selected(${calon6},name)) and not(selected(${calon7},name)) and not(selected(${calon8},name)) and not(selected(${calon9},name)) and not(selected(${calon10},name))
select_one ya	calon3	${calon1}=‘’ and ${calon2}=‘’ and ${calon4}=‘’ and ${calon5}=‘’ and ${calon6}=‘’ and ${calon7}=‘’ and ${calon8}=‘’ and ${calon9}=‘’ and ${calon10}=‘’	not(selected(${calon1},name)) and not(selected(${calon2},name)) and not(selected(${calon4},name)) and not(selected(${calon5},name)) and not(selected(${calon6},name)) and not(selected(${calon7},name)) and not(selected(${calon8},name)) and not(selected(${calon9},name)) and not(selected(${calon10},name))
select_one ya	calon4	${calon1}=‘’ and ${calon2}=‘’ and ${calon3}=‘’ and ${calon5}=‘’ and ${calon6}=‘’ and ${calon7}=‘’ and ${calon8}=‘’ and ${calon9}=‘’ and ${calon10}=‘’	not(selected(${calon1},name)) and not(selected(${calon2},name)) and not(selected(${calon3},name)) and not(selected(${calon5},name)) and not(selected(${calon6},name)) and not(selected(${calon7},name)) and not(selected(${calon8},name)) and not(selected(${calon9},name)) and not(selected(${calon10},name))
select_one ya	calon5	${calon1}=‘’ and ${calon2}=‘’ and ${calon3}=‘’ and ${calon4}=‘’ and ${calon6}=‘’ and ${calon7}=‘’ and ${calon8}=‘’ and ${calon9}=‘’ and ${calon10}=‘’	not(selected(${calon1},name)) and not(selected(${calon2},name)) and not(selected(${calon3},name)) and not(selected(${calon4},name)) and not(selected(${calon6},name)) and not(selected(${calon7},name)) and not(selected(${calon8},name)) and not(selected(${calon9},name)) and not(selected(${calon10},name))
select_one ya	calon6	${calon1}=‘’ and ${calon2}=‘’ and ${calon3}=‘’ and ${calon4}=‘’ and ${calon5}=‘’ and ${calon7}=‘’ and ${calon8}=‘’ and ${calon9}=‘’ and ${calon10}=‘’	not(selected(${calon1},name)) and not(selected(${calon2},name)) and not(selected(${calon3},name)) and not(selected(${calon4},name)) and not(selected(${calon5},name)) and not(selected(${calon7},name)) and not(selected(${calon8},name)) and not(selected(${calon9},name)) and not(selected(${calon10},name))
select_one ya	calon7	${calon1}=‘’ and ${calon2}=‘’ and ${calon3}=‘’ and ${calon4}=‘’ and ${calon5}=‘’ and ${calon6}=‘’ and ${calon8}=‘’ and ${calon9}=‘’ and ${calon10}=‘’	not(selected(${calon1},name)) and not(selected(${calon2},name)) and not(selected(${calon3},name)) and not(selected(${calon4},name)) and not(selected(${calon5},name)) and not(selected(${calon6},name)) and not(selected(${calon8},name)) and not(selected(${calon9},name)) and not(selected(${calon10},name))
select_one ya	calon8	${calon1}=‘’ and ${calon2}=‘’ and ${calon3}=‘’ and ${calon4}=‘’ and ${calon5}=‘’ and ${calon6}=‘’ and ${calon7}=‘’ and ${calon9}=‘’ and ${calon10}=‘’	not(selected(${calon1},name)) and not(selected(${calon2},name)) and not(selected(${calon3},name)) and not(selected(${calon4},name)) and not(selected(${calon5},name)) and not(selected(${calon6},name)) and not(selected(${calon7},name)) and not(selected(${calon9},name)) and not(selected(${calon10},name))
select_one ya	calon9	${calon1}=‘’ and ${calon2}=‘’ and ${calon3}=‘’ and ${calon4}=‘’ and ${calon5}=‘’ and ${calon6}=‘’ and ${calon7}=‘’ and ${calon8}=‘’ and ${calon10}=‘’	not(selected(${calon1},name)) and not(selected(${calon2},name)) and not(selected(${calon3},name)) and not(selected(${calon4},name)) and not(selected(${calon5},name)) and not(selected(${calon6},name)) and not(selected(${calon7},name)) and not(selected(${calon8},name)) and not(selected(${calon10},name))
select_one ya	calon10	${calon1}=‘’ and ${calon2}=‘’ and ${calon3}=‘’ and ${calon4}=‘’ and ${calon5}=‘’ and ${calon6}=‘’ and ${calon7}=‘’ and ${calon8}=‘’ and ${calon9}=‘’	not(selected(${calon1},name)) and not(selected(${calon2},name)) and not(selected(${calon3},name)) and not(selected(${calon4},name)) and not(selected(${calon5},name)) and not(selected(${calon6},name)) and not(selected(${calon7},name)) and not(selected(${calon8},name)) and not(selected(${calon9},name))

I need help please.

Kal_Lam · February 10, 2025, 12:23pm

Welcome to the community, @bayu_skm! Have you validated your XLSForm through this online validator? The online validator should help you identify syntax issues if any are present that are affecting your deployment.

bayu_skm · February 10, 2025, 12:43pm

Hi @Kal_Lam
sorry, I cannot attach the file because I am a new user.
Here is the error that occurred:

Error: ODK Validate Errors:
>> XForm is invalid.
: Cycle detected in form’s relevant and calculation logic!
The following nodes are likely involved in the loop:
${calon1}
${calon8}
${calon3}
${calon6}
${calon5}
${calon7}
${calon4}
${calon2}
${calon9}
${calon10}

The following files failed validation:
${election}.xml

Result: Invalid

I still do not understand where the error lies.

Kal_Lam · February 10, 2025, 1:55pm

@bayu_skm, you should now be able to attach.

wroos · February 10, 2025, 6:04pm

Welcome @bayu_skm,
Could you explain verbally, please, what you want to implement?

bayu_skm · February 10, 2025, 11:09pm

Hi @Kal_Lam and @wroos ,

election.xlsx (10.7 KB)

As mentioned in my first post, I want to create a 10 candidates election form with the following rules:

a) The answer option is limited to one: Choose; b) Mandatory for all 10 questions if none of the questions have been selected

image1276×639 22.1 KB
The answer option and mandatory requirement will disappear in the other 9 questions if one question has already been selected

image1283×629 18.7 KB

During the form preview, everything went smoothly with no issues.

However, during deployment, an error message appeared, and I still do not understand where the error lies.

Xiphware · February 11, 2025, 7:10am

You appear to have (multiple) mutual dependencies between the relevant calculations. For example

This says that calon1 is dependent on ... and ${calon10}=''

But at the same time, calon10 is dependent on ${calon1}='' and...

hence the required dependency cycle error. It is not possible to determine whether calon1 or calon10 are required because they are essentially mutually co-dependent. XForms doesn’t permit that (ie, its not a matter of who-got-answered-first…).

bayu_skm · February 11, 2025, 12:38pm

Hi @Xiphware ,

are there any alternative ways to implement this rule?:
a) Mandatory for all 10 questions if none of the questions have been selected.
b) Mandatory requirement will disappear in the other 9 questions if one question has already been selected

Xiphware · February 12, 2025, 1:31am

This sounds exactly like a mandatory select_one question; ie you must select something, but you may only select a single one. Is there a specific reason you cannot do something (far) simpler, like

SimpleSelect.xlsx (18.1 KB)

[before trying to get your specific form to work, I first want to check you haven’t considered a simpler approach to achieve the same result]