Operation rolled back error

[JürgenBiendara1]

Hello,

I get an "Operation rolled back" error with my survey. The survey was working in Connect version 3.0.127. Now I have updated to version 3.1.126, copied the survey and published it anew. The excerpt from the log file reads:

<15>1 2018-11-21T15:52:10Z DUROWA Survey123forArcGIS 32648 - [AppStudio@11205 category="qml" function="onSuccess" filename="XFormFeatureService.qml" line="726"] qml: applyEdits:errors: [
{
"code": 1003,
"description": "Operation rolled back.",
"tableId": 0
},
{
"code": 1000,
"description": "The INSERT statement conflicted with the FOREIGN KEY constraint \"REL_FK_service_c64e490357c146a98212a0ee53a91a7d_R_CRS_1\". The conflict occurred in database \"db_4886\", table \"user_4886.service_c64e490357c146a98212a0ee53a91a7d_R_TNK_TANK\", column 'globalid'.\r\nThe statement has been terminated.",
"tableId": 3
}
]
<15>1 2018-11-21T15:52:10Z DUROWA Survey123forArcGIS 32648 - [AppStudio@11205 category="qml" function="onFailed" filename="SubmitSurveysPage.qml" line="351"] qml: Feature service error: [
{
"code": 1003,
"description": "Operation rolled back.",
"tableId": 0
},
{
"code": 1000,
"description": "The INSERT statement conflicted with the FOREIGN KEY constraint \"REL_FK_service_c64e490357c146a98212a0ee53a91a7d_R_CRS_1\". The conflict occurred in database \"db_4886\", table \"user_4886.service_c64e490357c146a98212a0ee53a91a7d_R_TNK_TANK\", column 'globalid'.\r\nThe statement has been terminated.",
"tableId": 3
}
]
<15>1 2018-11-21T15:52:10Z DUROWA Survey123forArcGIS 32648 - [AppStudio@11205 category="qml" function="" filename="XFormsDatabase.qml" line="363"] qml: updateStatus: {
"rowsAffected": 1,
"insertId": "14",
"rows": {}
}
<15>1 2018-11-21T15:52:10Z DUROWA Survey123forArcGIS 32648 - [AppStudio@11205 category="qml" function="onFeatureServiceInfoChanged" filename="XFormFeatureService.qml" line="936"] qml: featureServiceInfo: null
<14>1 2018-11-21T15:52:10Z DUROWA Survey123forArcGIS 32648 - [AppStudio@11205 category="ArcGIS.AppFramework.Network"] ArcGIS.AppFramework.Network: NetworkNotifier: con: 66
<14>1 2018-11-21T15:52:10Z DUROWA Survey123forArcGIS 32648 - [AppStudio@11205 category="ArcGIS.AppFramework.Network"] ArcGIS.AppFramework.Network: NetworkNotifier: con: 66
<15>1 2018-11-21T15:52:10Z DUROWA Survey123forArcGIS 32648 - [AppStudio@11205 category="qml" function="update" filename="FilteredListModel.qml" line="62"] qml: Empty filterText
<12>1 2018-11-21T15:52:10Z DUROWA Survey123forArcGIS 32648 - [AppStudio@11205 category="default" filename="XFormWebhooks.qml" line="102"] qrc:/qml/XForms/XFormWebhooks.qml:102: TypeError: Cannot read property 'itemId' of null
<15>1 2018-11-21T15:52:13Z DUROWA Survey123forArcGIS 32648 - [AppStudio@11205 category="qml" function="editSubmitError" filename="SurveysListPage.qml" line="622"] qml: error: {
"code": 1003,
"description": "Operation rolled back.",
"tableId": 0
}
<15>1 2018-11-21T15:52:27Z DUROWA Survey123forArcGIS 32648 - [AppStudio@11205 category="qml" function="expression for onStateChanged" filename="Portal.qml" line="214"] qml: Application state changed: 2

Can someone hint to where might be the problem?

Thank you very much, best regards,

Jürgen

[JW_Mapguy]

I'm still getting that error message and I've extensively done some testing and debugging. I narrowed it down to two select multiple questions, this survey does not like having two, despite the fact that I removed the constraint on them, removed all spaces and special characters in the names list in the choices tab, and basically trimmed my survey down to almost nothing. Still not sure why I am getting this error. James Tedrick‌ any ideas?

[JamesTedrick]

Hi John,

Just to check, did you alter the field length in the form after initial publishing (what does the feature service report as the field length)?  Unfortunately, altering the field length in the form after initial field creation cannot alter the field length - you would need to delete the fields in the feature service and have added again (either through Survey123 Connect or manually).