AnsweredAssumed Answered

Operation rolled back error

Question asked by j.biendaraconterra-de-esridist Employee on Nov 21, 2018
Latest reply on Jan 14, 2019 by Philip.Wilson-esristaff

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

Outcomes