Failed to publish Error 400

644
2
03-30-2021 01:09 PM
TonyDaSilva1
Occasional Contributor

Hi,
Having issues publishing with repeats in Survey123 Connect 3.12.230 & 3.12.232.

I tested with a basic repeat, nothing special. looks like it is having problems creating the relationship table.

code": 400,
"details": [
"Introducing FOREIGN KEY constraint 'REL_FK_service_999999999999999999999999999_DEFICIENCIES2_1' on table 'service_999999999999999999999999999999_DEFICIENCIES2' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. Could not create constraint or index. See previous errors.

Cheers,

Tags (1)
0 Kudos
2 Replies
ZacharySutherby
Esri Regular Contributor

Hello @TonyDaSilva1

Are you trying to publish to ArcGIS Online or an ArcGIS Enterprise Organization? 

Thank you, 

Zach

Thank you,
Zach
0 Kudos
TonyDaSilva1
Occasional Contributor

Hi Zach, ArcGIS Online.

0 Kudos