Error: Invalid cast of data [---] to type Date

I have just implemented lookup tables and table filtering for
Province/District questions on forms that create new cases (retailers) and
edit existing ones. I’ve used the instructions here:

https://confluence.dimagi.com/display/commcarepublic/Lookup+Tables
and here:
https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices

The system seems to be working fine to new cases but when I try an edit a
case I get the following error message after selecting a case to edit:

 Error occurred
 Invalid cast of data [---] to type Date

Note that the first question in the form is ‘Confirm date’.

I have searched on Confluence and can find no reference to this error.

I have ‘cleared user data’ but this does not solve the problem.

Help!

Hi Simon,

It sounds like the error is appearing the moment the form opens. Is this
so? If you can share the HQ link to this form, we can take a quick look.

Thanks,
Kriti

··· On Thu, Dec 17, 2015 at 8:38 AM, Simon Berry wrote:

I have just implemented lookup tables and table filtering for
Province/District questions on forms that create new cases (retailers) and
edit existing ones. I’ve used the instructions here:

https://confluence.dimagi.com/display/commcarepublic/Lookup+Tables
and here:

https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices

The system seems to be working fine to new cases but when I try an edit a
case I get the following error message after selecting a case to edit:

 Error occurred
 Invalid cast of data [---] to type Date

Note that the first question in the form is ‘Confirm date’.

I have searched on Confluence and can find no reference to this error.

I have ‘cleared user data’ but this does not solve the problem.

Help!


You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

I’m not sure how to do this but if I click on Preview Form it takes me here:

https://www.commcarehq.org/a/colalife/cloudcare/apps/view/1af5843ab31d3c76aac0aa43cf0e2361/0/1?preview=true

And this gives this error:

Unable to fetch fixture at
https://www.commcarehq.org/a/{{DOMAIN}}/cloudcare/api/fixtures/2d07d692b2008adc80807a5e4ef0e23c/item-list:province:
HTTP Error 412: PRECONDITION FAILED

So I think you are right.

I’ve downloaded the look-up tables and these are attached.

Regards

Simon
18/12/15

colalife_fixtures (4).xlsx (10.7 KB)

··· On Friday, December 18, 2015 at 4:42:21 AM UTC, Kriti Mehrotra wrote: > > Hi Simon, > > It sounds like the error is appearing the moment the form opens. Is this > so? If you can share the HQ link to this form, we can take a quick look. > > Thanks, > Kriti > > On Thu, Dec 17, 2015 at 8:38 AM, Simon Berry <si...@colalife.org > wrote: > >> I have just implemented lookup tables and table filtering for >> Province/District questions on forms that create new cases (retailers) and >> edit existing ones. I've used the instructions here: >> >> https://confluence.dimagi.com/display/commcarepublic/Lookup+Tables >> and here: >> >> https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices >> >> The system seems to be working fine to new cases but when I try an edit a >> case I get the following error message after selecting a case to edit: >> >> Error occurred >> Invalid cast of data [---] to type Date >> >> Note that the first question in the form is 'Confirm date'. >> >> I have searched on Confluence and can find no reference to this error. >> >> I have 'cleared user data' but this does not solve the problem. >> >> Help! >> >> -- >> You received this message because you are subscribed to the Google Groups >> "commcare-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to commcare-user...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > >

Hi Simon,

Couple of things.

  1. The “Preview Form” functionality does not support using lookup tables,
    hence the CloudCare error you’re seeing. You have to log in as a mobile
    user on CloudCare to use that functionality. You can read more about these
    two CloudCare modes on the Using CloudCare
    https://confluence.dimagi.com/display/commcarepublic/Using+CloudCare help
    page.

  2. Regarding the “invalid cast” error, the validation condition in question
    ID retailer_startdate in your form may be the culprit. Take a look at the
    last bullet on this help page
    https://confluence.dimagi.com/display/commcarepublic/Calculations+with+Dates+and+Times
    to
    see how comparisons with date and time values happen in CommCare.

Hope this helps.

Best,
Kriti

··· On Fri, Dec 18, 2015 at 1:49 PM, Simon Berry wrote:

I’m not sure how to do this but if I click on Preview Form it takes me
here:

https://www.commcarehq.org/a/colalife/cloudcare/apps/view/1af5843ab31d3c76aac0aa43cf0e2361/0/1?preview=true

And this gives this error:

Unable to fetch fixture at
https://www.commcarehq.org/a/{{DOMAIN}}/cloudcare/api/fixtures/2d07d692b2008adc80807a5e4ef0e23c/item-list:province:
HTTP Error 412: PRECONDITION FAILED

So I think you are right.

I’ve downloaded the look-up tables and these are attached.

Regards

Simon
18/12/15

On Friday, December 18, 2015 at 4:42:21 AM UTC, Kriti Mehrotra wrote:

Hi Simon,

It sounds like the error is appearing the moment the form opens. Is this
so? If you can share the HQ link to this form, we can take a quick look.

Thanks,
Kriti

On Thu, Dec 17, 2015 at 8:38 AM, Simon Berry si...@colalife.org wrote:

I have just implemented lookup tables and table filtering for
Province/District questions on forms that create new cases (retailers) and
edit existing ones. I’ve used the instructions here:

https://confluence.dimagi.com/display/commcarepublic/Lookup+Tables
and here:

https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices

The system seems to be working fine to new cases but when I try an edit
a case I get the following error message after selecting a case to edit:

 Error occurred
 Invalid cast of data [---] to type Date

Note that the first question in the form is ‘Confirm date’.

I have searched on Confluence and can find no reference to this error.

I have ‘cleared user data’ but this does not solve the problem.

Help!


You received this message because you are subscribed to the Google
Groups “commcare-users” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to commcare-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hi Kriti

Can you tell me how to:

“…share the HQ link to this form…”

So that you can take a look as suggested.

Many thanks

Simon
19/12/15

··· On Friday, December 18, 2015 at 10:46:07 PM UTC, Kriti Mehrotra wrote: > > Hi Simon, > > Couple of things. > > 1. The "Preview Form" functionality does not support using lookup tables, > hence the CloudCare error you're seeing. You have to log in as a mobile > user on CloudCare to use that functionality. You can read more about these > two CloudCare modes on the Using CloudCare > > help page. > > 2. Regarding the "invalid cast" error, the validation condition in > question ID retailer_startdate in your form may be the culprit. Take a look > at the last bullet on this help page > to > see how comparisons with date and time values happen in CommCare. > > Hope this helps. > > Best, > Kriti > > On Fri, Dec 18, 2015 at 1:49 PM, Simon Berry <si...@colalife.org > wrote: > >> I'm not sure how to do this but if I click on Preview Form it takes me >> here: >> >> >> https://www.commcarehq.org/a/colalife/cloudcare/apps/view/1af5843ab31d3c76aac0aa43cf0e2361/0/1?preview=true >> >> And this gives this error: >> >> Unable to fetch fixture at >> https://www.commcarehq.org/a/{{DOMAIN}}/cloudcare/api/fixtures/2d07d692b2008adc80807a5e4ef0e23c/item-list:province: >> HTTP Error 412: PRECONDITION FAILED >> >> So I think you are right. >> >> I've downloaded the look-up tables and these are attached. >> >> Regards >> >> Simon >> 18/12/15 >> >> >> On Friday, December 18, 2015 at 4:42:21 AM UTC, Kriti Mehrotra wrote: >>> >>> Hi Simon, >>> >>> It sounds like the error is appearing the moment the form opens. Is this >>> so? If you can share the HQ link to this form, we can take a quick look. >>> >>> Thanks, >>> Kriti >>> >>> On Thu, Dec 17, 2015 at 8:38 AM, Simon Berry wrote: >>> >>>> I have just implemented lookup tables and table filtering for >>>> Province/District questions on forms that create new cases (retailers) and >>>> edit existing ones. I've used the instructions here: >>>> >>>> https://confluence.dimagi.com/display/commcarepublic/Lookup+Tables >>>> and here: >>>> >>>> https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices >>>> >>>> The system seems to be working fine to new cases but when I try an edit >>>> a case I get the following error message after selecting a case to edit: >>>> >>>> Error occurred >>>> Invalid cast of data [---] to type Date >>>> >>>> Note that the first question in the form is 'Confirm date'. >>>> >>>> I have searched on Confluence and can find no reference to this error. >>>> >>>> I have 'cleared user data' but this does not solve the problem. >>>> >>>> Help! >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "commcare-users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to commcare-user...@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> You received this message because you are subscribed to the Google Groups >> "commcare-users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to commcare-user...@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > >

Hi Simon,

I was able to find your form using the CloudCare link you sent, so I was
able to take a look. Take a look at the second point in my last email
(reproduced below).

​​

  1. Regarding the “invalid cast” error, the validation condition in
    question ID retailer_startdate in your form may be the culprit. Take a look
    at the last bullet on this help page
    https://confluence.dimagi.com/display/commcarepublic/Calculations+with+Dates+and+Times to
    see how comparisons with date and time values happen in CommCare.

Best,
Kriti

··· On Sat, Dec 19, 2015 at 5:42 AM, Simon Berry wrote:

Hi Kriti

Can you tell me how to:

“…share the HQ link to this form…”

So that you can take a look as suggested.

Many thanks

Simon
19/12/15

On Friday, December 18, 2015 at 10:46:07 PM UTC, Kriti Mehrotra wrote:

Hi Simon,

Couple of things.

  1. The “Preview Form” functionality does not support using lookup tables,
    hence the CloudCare error you’re seeing. You have to log in as a mobile
    user on CloudCare to use that functionality. You can read more about these
    two CloudCare modes on the Using CloudCare
    https://confluence.dimagi.com/display/commcarepublic/Using+CloudCare
    help page.

  2. Regarding the “invalid cast” error, the validation condition in
    question ID retailer_startdate in your form may be the culprit. Take a look
    at the last bullet on this help page
    https://confluence.dimagi.com/display/commcarepublic/Calculations+with+Dates+and+Times to
    see how comparisons with date and time values happen in CommCare.

Hope this helps.

Best,
Kriti

On Fri, Dec 18, 2015 at 1:49 PM, Simon Berry si...@colalife.org wrote:

I’m not sure how to do this but if I click on Preview Form it takes me
here:

https://www.commcarehq.org/a/colalife/cloudcare/apps/view/1af5843ab31d3c76aac0aa43cf0e2361/0/1?preview=true

And this gives this error:

Unable to fetch fixture at
https://www.commcarehq.org/a/{{DOMAIN}}/cloudcare/api/fixtures/2d07d692b2008adc80807a5e4ef0e23c/item-list:province:
HTTP Error 412: PRECONDITION FAILED

So I think you are right.

I’ve downloaded the look-up tables and these are attached.

Regards

Simon
18/12/15

On Friday, December 18, 2015 at 4:42:21 AM UTC, Kriti Mehrotra wrote:

Hi Simon,

It sounds like the error is appearing the moment the form opens. Is
this so? If you can share the HQ link to this form, we can take a quick
look.

Thanks,
Kriti

On Thu, Dec 17, 2015 at 8:38 AM, Simon Berry si...@colalife.org wrote:

I have just implemented lookup tables and table filtering for
Province/District questions on forms that create new cases (retailers) and
edit existing ones. I’ve used the instructions here:

https://confluence.dimagi.com/display/commcarepublic/Lookup+Tables
and here:

https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices

The system seems to be working fine to new cases but when I try an
edit a case I get the following error message after selecting a case to
edit:

 Error occurred
 Invalid cast of data [---] to type Date

Note that the first question in the form is ‘Confirm date’.

I have searched on Confluence and can find no reference to this error.

I have ‘cleared user data’ but this does not solve the problem.

Help!


You received this message because you are subscribed to the Google
Groups “commcare-users” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to commcare-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


You received this message because you are subscribed to the Google
Groups “commcare-users” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to commcare-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hi Kriti

I have now (temporarily) removed the validation condition on
retailer_startdate in both forms (‘Retailer details (new)’ and ‘Retailer
Details (edit)’) pending getting support on the correct syntax for the
validation condition from Mofya.

Now, the ‘Retailer details (new)’ gives no errors but the 'Retailer details
(edit) form still gives the same error. I have gone back to check and
compare all date properties in both forms and seem to be set up the same.

Can you advise further please.

Many thanks

Simon
20/12/15

··· On 19 December 2015 at 23:48, Kriti Mehrotra wrote:

Hi Simon,

I was able to find your form using the CloudCare link you sent, so I was
able to take a look. Take a look at the second point in my last email
(reproduced below).

​​

  1. Regarding the “invalid cast” error, the validation condition in
    question ID retailer_startdate in your form may be the culprit. Take a look
    at the last bullet on this help page
    https://confluence.dimagi.com/display/commcarepublic/Calculations+with+Dates+and+Times to
    see how comparisons with date and time values happen in CommCare.

Best,
Kriti

On Sat, Dec 19, 2015 at 5:42 AM, Simon Berry simon@colalife.org wrote:

Hi Kriti

Can you tell me how to:

“…share the HQ link to this form…”

So that you can take a look as suggested.

Many thanks

Simon
19/12/15

On Friday, December 18, 2015 at 10:46:07 PM UTC, Kriti Mehrotra wrote:

Hi Simon,

Couple of things.

  1. The “Preview Form” functionality does not support using lookup
    tables, hence the CloudCare error you’re seeing. You have to log in as a
    mobile user on CloudCare to use that functionality. You can read more about
    these two CloudCare modes on the Using CloudCare
    https://confluence.dimagi.com/display/commcarepublic/Using+CloudCare
    help page.

  2. Regarding the “invalid cast” error, the validation condition in
    question ID retailer_startdate in your form may be the culprit. Take a look
    at the last bullet on this help page
    https://confluence.dimagi.com/display/commcarepublic/Calculations+with+Dates+and+Times to
    see how comparisons with date and time values happen in CommCare.

Hope this helps.

Best,
Kriti

On Fri, Dec 18, 2015 at 1:49 PM, Simon Berry si...@colalife.org wrote:

I’m not sure how to do this but if I click on Preview Form it takes me
here:

https://www.commcarehq.org/a/colalife/cloudcare/apps/view/1af5843ab31d3c76aac0aa43cf0e2361/0/1?preview=true

And this gives this error:

Unable to fetch fixture at
https://www.commcarehq.org/a/{{DOMAIN}}/cloudcare/api/fixtures/2d07d692b2008adc80807a5e4ef0e23c/item-list:province:
HTTP Error 412: PRECONDITION FAILED

So I think you are right.

I’ve downloaded the look-up tables and these are attached.

Regards

Simon
18/12/15

On Friday, December 18, 2015 at 4:42:21 AM UTC, Kriti Mehrotra wrote:

Hi Simon,

It sounds like the error is appearing the moment the form opens. Is
this so? If you can share the HQ link to this form, we can take a quick
look.

Thanks,
Kriti

On Thu, Dec 17, 2015 at 8:38 AM, Simon Berry si...@colalife.org wrote:

I have just implemented lookup tables and table filtering for
Province/District questions on forms that create new cases (retailers) and
edit existing ones. I’ve used the instructions here:

https://confluence.dimagi.com/display/commcarepublic/Lookup+Tables
and here:

https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices

The system seems to be working fine to new cases but when I try an
edit a case I get the following error message after selecting a case to
edit:

 Error occurred
 Invalid cast of data [---] to type Date

Note that the first question in the form is ‘Confirm date’.

I have searched on Confluence and can find no reference to this error.

I have ‘cleared user data’ but this does not solve the problem.

Help!


You received this message because you are subscribed to the Google
Groups “commcare-users” group.
To unsubscribe from this group and stop receiving emails from it,
send an email to commcare-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


You received this message because you are subscribed to the Google
Groups “commcare-users” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to commcare-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


You received this message because you are subscribed to a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/_IqEgCQxdc8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

(Taken this thread offline with Mofya.)

··· On Sun, Dec 20, 2015 at 8:42 AM, Simon Berry wrote:

Hi Kriti

I have now (temporarily) removed the validation condition on
retailer_startdate in both forms (‘Retailer details (new)’ and ‘Retailer
Details (edit)’) pending getting support on the correct syntax for the
validation condition from Mofya.

Now, the ‘Retailer details (new)’ gives no errors but the 'Retailer
details (edit) form still gives the same error. I have gone back to check
and compare all date properties in both forms and seem to be set up the
same.

Can you advise further please.

Many thanks

Simon
20/12/15

On 19 December 2015 at 23:48, Kriti Mehrotra kmehrotra@dimagi.com wrote:

Hi Simon,

I was able to find your form using the CloudCare link you sent, so I was
able to take a look. Take a look at the second point in my last email
(reproduced below).

​​

  1. Regarding the “invalid cast” error, the validation condition in
    question ID retailer_startdate in your form may be the culprit. Take a look
    at the last bullet on this help page
    https://confluence.dimagi.com/display/commcarepublic/Calculations+with+Dates+and+Times to
    see how comparisons with date and time values happen in CommCare.

Best,
Kriti

On Sat, Dec 19, 2015 at 5:42 AM, Simon Berry simon@colalife.org wrote:

Hi Kriti

Can you tell me how to:

“…share the HQ link to this form…”

So that you can take a look as suggested.

Many thanks

Simon
19/12/15

On Friday, December 18, 2015 at 10:46:07 PM UTC, Kriti Mehrotra wrote:

Hi Simon,

Couple of things.

  1. The “Preview Form” functionality does not support using lookup
    tables, hence the CloudCare error you’re seeing. You have to log in as a
    mobile user on CloudCare to use that functionality. You can read more about
    these two CloudCare modes on the Using CloudCare
    https://confluence.dimagi.com/display/commcarepublic/Using+CloudCare
    help page.

  2. Regarding the “invalid cast” error, the validation condition in
    question ID retailer_startdate in your form may be the culprit. Take a look
    at the last bullet on this help page
    https://confluence.dimagi.com/display/commcarepublic/Calculations+with+Dates+and+Times to
    see how comparisons with date and time values happen in CommCare.

Hope this helps.

Best,
Kriti

On Fri, Dec 18, 2015 at 1:49 PM, Simon Berry si...@colalife.org wrote:

I’m not sure how to do this but if I click on Preview Form it takes me
here:

https://www.commcarehq.org/a/colalife/cloudcare/apps/view/1af5843ab31d3c76aac0aa43cf0e2361/0/1?preview=true

And this gives this error:

Unable to fetch fixture at
https://www.commcarehq.org/a/{{DOMAIN}}/cloudcare/api/fixtures/2d07d692b2008adc80807a5e4ef0e23c/item-list:province:
HTTP Error 412: PRECONDITION FAILED

So I think you are right.

I’ve downloaded the look-up tables and these are attached.

Regards

Simon
18/12/15

On Friday, December 18, 2015 at 4:42:21 AM UTC, Kriti Mehrotra wrote:

Hi Simon,

It sounds like the error is appearing the moment the form opens. Is
this so? If you can share the HQ link to this form, we can take a quick
look.

Thanks,
Kriti

On Thu, Dec 17, 2015 at 8:38 AM, Simon Berry si...@colalife.org wrote:

I have just implemented lookup tables and table filtering for
Province/District questions on forms that create new cases (retailers) and
edit existing ones. I’ve used the instructions here:

https://confluence.dimagi.com/display/commcarepublic/Lookup+Tables
and here:

https://confluence.dimagi.com/display/commcarepublic/Setup+a+Question+with+Filtered+Choices

The system seems to be working fine to new cases but when I try an
edit a case I get the following error message after selecting a case to
edit:

 Error occurred
 Invalid cast of data [---] to type Date

Note that the first question in the form is ‘Confirm date’.

I have searched on Confluence and can find no reference to this
error.

I have ‘cleared user data’ but this does not solve the problem.

Help!


You received this message because you are subscribed to the Google
Groups “commcare-users” group.
To unsubscribe from this group and stop receiving emails from it,
send an email to commcare-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


You received this message because you are subscribed to the Google
Groups “commcare-users” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to commcare-user...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


You received this message because you are subscribed to the Google
Groups “commcare-users” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


You received this message because you are subscribed to a topic in the
Google Groups “commcare-users” group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/commcare-users/_IqEgCQxdc8/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


You received this message because you are subscribed to the Google Groups
"commcare-users" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-users+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.