topic Re: Cannot insert duplicate key row in object '...cases.REPORTING AREAS' in Coronavirus disease 2019 (COVID-19) Questions

Cannot insert duplicate key row in object '...cases.REPORTING AREAS'

JenniferBorlick — Fri, 27 Mar 2020 20:43:01 GMT

I'm trying to get the Case Reporter up and going. I have followed this workflow, except I did a copy and paste to get the boundary in there. I did make sure there was a Name in the Name field. No matter what I set as the name, I get the same error. The only difference is that the duplicate key value changes to whatever the name is that I have changed it to.

Tabulate Coronavirus Cases - Coronavirus Response | ArcGIS Solutions for Local Government

Re: Cannot insert duplicate key row in object '...cases.REPORTING AREAS'

MikeDagle — Mon, 30 Mar 2020 17:30:40 GMT

Hi Jennifer Borlick,

Apologies for the delay on this thread. I'd recommend re-deploying the solution (make sure you uncheck the Use Existing Items In The Organization in the Options menu of the Deploy an ArcGIS Solution step). Then test to see if you still receive the insert duplicate error.

I'll keep an eye on this thread so feel free to ask follow up questions.

Mike

Re: Cannot insert duplicate key row in object '...cases.REPORTING AREAS'

JenniferBorlick — Mon, 30 Mar 2020 18:32:34 GMT

I'm not seeing "Use Existing Items"?

Re: Cannot insert duplicate key row in object '...cases.REPORTING AREAS'

JenniferBorlick — Mon, 30 Mar 2020 18:35:48 GMT

Found it.

Re: Cannot insert duplicate key row in object '...cases.REPORTING AREAS'

MikeDagle — Mon, 30 Mar 2020 18:36:10 GMT

Hi Jennifer - It's in the hamburger Options menu to the right of the search box. Just above the scroll bar.

Mike

Re: Cannot insert duplicate key row in object '...cases.REPORTING AREAS'

JenniferBorlick — Mon, 30 Mar 2020 18:56:13 GMT

Got it. Thanks. When I attempted to re-deploy, it said that it finished, but instead of a green check mark, I got a red X.
I went into the organization and nothing had been overwritten. I deleted the Cases feature layer and the survey (The survey from Survey123 Connect) and tried it again. It worked the second time. My guess is that there was a schema lock. Let's hope I don't have to do that again.

Re: Cannot insert duplicate key row in object '...cases.REPORTING AREAS'

Anonymous User — Sun, 13 Dec 2020 14:36:43 GMT

Hey Mike, could you kindly help me!!!
i try to import XML to database, it works well for FileDB (Schema and Data), but for SDB give me this error "Underlying DBMS error [[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Violation of PRIMARY KEY constraint 'R108_pk'. Cannot insert duplicate key in object 'dbo.GISVW_SAFE_DISTANCE'. The duplicate key value is (1).] [XML.DBO.GISVW_SAFE_DISTANCE] "
it works well for schema only but for schema and data the previous error appears...

Re: Cannot insert duplicate key row in object '...cases.REPORTING AREAS'

MikeDagle — Tue, 22 Dec 2020 17:57:30 GMT

Hi @Anonymous User - Can you give a few more details on what you're trying to do?

Mike