Community

Jackobissaac
New Contributor II
since ‎12-13-2020
6 Badges Earned
1st Kudo! 1st Post!
View All Badges Earned
‎12-15-2020
4 Posts created
6 Kudos given
0 Solutions
1 Kudos received

My Ideas

(0 Idea Submissions)

Latest Contributions by Jackobissaac

POST

XML cannot create a table with duplicate column

Hi all hope you are well, i'm trying to import XML from SDE but it gives me errors: 1- It works well with FileGDB (Schema only & Data), and also works well with Enterprise GDB (Schema only). 2- Error come with Enterprise GDB (Schema and Data) it gives me the following 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] Failed to execute (ImportXMLWorkspaceDocument)"       - Software: ArcGIS Pro 2.6.2 -Server: SQL Server ... View more
ArcGIS Pro Questions
‎12-15-2020 12:07 AM
0
0
126
POST

Re: XML Editor

Hey Joe hope you are well,  please could you kindly help me! i try to import XML into SDE (SQL server) database but it failed and give me the following error: "Underlying DBMS error [[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Violation of PRIMARY KEY constraint 'R42_pk'. Cannot insert duplicate key in object 'dbo.GISVW_SAFE_DISTANCE'. The duplicate key value is (1).] [texttXML.DBO.GISVW_SAFE_DISTANCE]" Software: ArcGIS Pro2.6.2 ... View more
Data Management Questions
‎12-14-2020 03:03 AM
0
0
95
IDEA

Re: Ability to link in-text citations to credit section in StoryMaps

Hey, could any one 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... ... View more
ArcGIS StoryMaps Ideas
‎12-13-2020 06:45 AM
0
0
198
POST

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

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... ... View more
Coronavirus disease 2019 (COVID-19) Questions
‎12-13-2020 06:36 AM
1
1
1092
Activity Feed
Contact Me
Online Status
Offline
Date Last Visited
‎12-15-2020 04:06 AM