nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Error message of 'Arithmetic overflow error converting expression to data type int' but for only 3 of 70 field staff

Lisa_G

Hello,

I have a complex form that is used for field data collection. There is a team of about 70 users. 3 of those users are experiencing problems when sending a report. The error message is the same for all 3 users. I researched this error and it seems to be a text question with an int return, or something like that. I checked over the xls and can't find a text question with an int field type, or an int question with a text field type. But why are there only 3 users are being affected by this, and not all field staff? Also, those 3 users can send other reports without any issue. All 3 of them have a record stuck in the Outbox with this error message.

It is a large form, so maybe I missed something in the xls, I have reviewed multiple times. The most recent update was to the instance_name. I used concat when constructing the statement. Could this instance_name update cause this error? The error references the instance_name. Here is the instance_name statement:

concat(${Review_Approval}, " || ", ${ECI_ResubmissionReview}, " || ", concat('CaseNo: ', ${Case_Number}, " || ", concat('ECI: ' , ${Lead_ECI_Name}, " || ", ${Incident_ST_Address}, ", ", ${City_State_Zip}, " || ", concat('CD: ', ${CouncilDistrict}, " || ", concat('OpsDate: ', format-date(${Operation_Date}, '%m-%d-%Y'))))))

Thank you for any advice/help on this!

LisaG

Arithmetic error.JPG

Find more posts tagged with

Accepted answers

All comments

Lisa_G

Hi Raul,

the Case_Number field is field type string, Length 500 bind type is string and it is a question type of text

Raul

What data type is the 'Case_Number' field? I'm thinking that if you're storing values i that field as an integer, (esriFieldTypeInteger) the value for your particular case is larger than the amount the datatype can store.

According to this thread, the maximum number esriFIeldTypeInteger can store is 2,147,483,647.

abureaux

I tried out the equation I had above and it worked:

I was wondering if there was a string length issue (e.g., 255) that you may be running into, so I tested that as well and got the standard "database error" (see below). There is a good change you will run into this issue since you are combining so many fields. Either way though, I wasn't able to recreate your error.

abureaux

Another minor thing, but try to not mix and match quotes. Use either all single or all double quotes. Generally it doesn't matter which you use for operations like this (I tend to go with single quotes because I'm lazy).

What does your new equation look like? I got this after normalizing quotes and removing the nesting:

concat(${Review_Approval}, ' || ', ${ECI_ResubmissionReview}, ' || CaseNo: ', ${Case_Number}, ' || ECI: ' , ${Lead_ECI_Name}, ' || ', ${Incident_ST_Address}, ', ', ${City_State_Zip}, ' || CD: ', ${CouncilDistrict}, ' || OpsDate: ', format-date(${Operation_Date}, '%m-%d-%Y'))

Lisa_G

Update: I did restructure the instance name and removed the nested concat. Published the form, and no change on the stuck record in the Outbox. The original error is still happening. I am open to any ideas to find a solution to this. Thank you!

Lisa_G

Hi Doug,

Thanks for your email. I had problems getting the syntax correct and this seemed to be the only way I could get it to work. You're right, nested concats aren't really needed. I will try out one concat for the instance name. Do you think this would have caused the error? Many thanks, Lisa

dougbrowning

Is there a reason you are nesting all those concats and not just using one? I see no reason for all of those just do one big one. I would try that.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.