Error 400 Unable to add feature service definition

[DougBrowning]

I dug through the posts on this one and

No double field names

First time ever publishing

What else could it be?

Form attached.

Thanks

[JohnEvans6]

There is a log file that will give you more info on how to track down errors:

In this instance, it's tossing this error:

ToDefinition error {
  "code": 400,
  "details": [
    "Introducing FOREIGN KEY constraint 'REL_FK_service_d857e05ca59241afab7c00490723b521_POOLS2_1' on table 'service_d857e05ca59241afab7c00490723b521_POOLS2' 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."
  ],
  "message": "Unable to add feature service definition."
}

Been messing with it for a bit, and it seems to not like the fact your repeat name is Pools. Try changing it to PoolsRepeat or something else. I was able to publish it successfully with that change.

[DougBrowning]

Yep PoolsRepeat did it.  Pretty weird.  

Thanks a lot!