Latest Contributions by AdelaideZumwalt1

‎03-13-2018

When you publish data only the first one automatically has pop-up enabled. You have to go into the online map and enable pop-ups on all tables.

‎03-07-2018

I also have this question. There are two related tables in the browser: And only one shows up in Collector: I've tried republishing using different relationship types (1:1, 1:M) I've also tried using different fields. I have another map that still has two related tables in Collector. So... what is going on?

‎02-22-2018

So I got the scheduled job to run correctly once I created the version and just had sql update it. Although the data was updated correctly, the errors included: "Not currently editing a version<c/> cannot stop edit. [SQLSTATE 42000] (Error 50000). The step failed." It would be nice to get the job to run without these errors so the job history isn't filled with red x's. Any ideas? EXEC dbo.set_current_version 'WMMUpdate'; EXEC dbo.edit_version 'WMMUpdate', 1; MERGE ElectricModel.dbo.Transformer_evw USING WMMExport.dbo.TRANSFORMER ON ElectricModel.dbo.Transformer_evw.GUID_WMM = WMMExport.dbo.TRANSFORMER.wm_ElementGuid WHEN MATCHED THEN UPDATE SET ElectricModel.dbo.Transformer_evw.esElementName= WMMExport.dbo.TRANSFORMER.wmElementName; EXEC dbo.edit_version 'WMMUpdate', 2;

‎02-15-2018

Did you ever find a solution to this? We are running into the same issue. Both users were able to sync all morning and now one user is not able to sync and is getting the same error.

‎01-25-2018

I checked the versioned view in ArcMap and there were 0 changes. The version doesn't even have a "Modified Date. I ran it as a query and got the error: Msg 50000, Level 16, State 1, Procedure edit_version, Line 144 Cannot stop edit on WMMUpdate while version id 20 is the current edit version. What is version id 20? "

‎01-24-2018

I used this script for a couple months on another database but can't seem to get it to work on the new database. I keep running into the following error: "Not currently editing a version, cannot stop edit." even though my step specifically starts and stops the edit session. What am I missing? The version is being created, I can see it in ArcMap: EXEC dbo.create_version 'dbo.DEFAULT', 'WMMUpdate', 1, 1, 'This version contains data pushed from WMMExport to ElectricModel'; EXEC dbo.set_current_version 'WMMUpdate'; EXEC dbo.edit_version 'WMMUpdate', 1; MERGE ElectricModel.dbo.Transformer_evw USING WMMExport.dbo.TRANSFORMER ON ElectricModel.dbo.Transformer_evw.GUID_WMM = WMMExport.dbo.TRANSFORMER.wm_ElementGuid WHEN MATCHED THEN UPDATE SET ElectricModel.dbo.Transformer_evw.esElementName= WMMExport.dbo.TRANSFORMER.wmElementName; EXEC dbo.edit_version 'WMMUpdate', 2;

‎10-04-2017

I'm guessing it's because there is a duplicate "ElementName" somewhere in the table that is tripping it up. Is there any way to bypass this? Or skip that particular record and move on without crashing the entire script?

‎10-04-2017

Another question, it ran fine on a couple of my tables, but on another I got this error: Violation of PRIMARY KEY constraint 'a26_rowid_ix1' Cannot insert duplicate key in object 'dbo.a26.' The duplicate key value is '1172404, 658'.... The OBJECTID is the primary key in the sql table and I'm not using it as part of the join... EXEC dbo.create_version 'dbo.DEFAULT', 'Assembliesb', 1, 1, 'This version contains data pushed from WMM to ESRI'; EXEC dbo.set_current_version 'Assembliesb'; EXEC dbo.edit_version 'Assembliesb', 1; MERGE ElectricNetwork.dbo.Assemblies_evw USING ElectricNetwork.dbo.Poles_evw ON ElectricNetwork.dbo.Assemblies_evw.MapPointName = ElectricNetwork.dbo.Poles_evw.esElementName WHEN MATCHED THEN UPDATE SET ElectricNetwork.dbo.Assemblies_evw.GUID= ElectricNetwork.dbo.Poles_evw.GlobalID; EXEC dbo.edit_version 'Assembliesb', 2;

‎10-04-2017

I found the issue... for some reason poles is plural when versioned (This must be because I changed the feature class name to singular after registering it as versioned. Thank you!!

‎10-04-2017

Yes, that appeared to be the problem. Thank you! Maybe you can help me with my next question too. Once I deleted the existing versions and re-ran it I got this error: Invalid object name 'ElectricNetwork.dbo.POLE_evw' The object name is correct and named correctly. Is the "_evw" part incorrect?

‎10-03-2017

When I run the following script, which has run successfully for me on a number of other tables I get the following error: Violation of UNIQUE KEY constraint 'versions_uk'. Cannot insert duplicate key in object 'dbo.SDE_versions'. The duplicate key value is (Poles, DBO). The primary key for the Poles table is the ObjectID. EXEC dbo.create_version 'dbo.DEFAULT', 'Poles', 1, 1, 'This version contains data pushed from WMM to ESRI'; EXEC dbo.set_current_version 'Poles'; EXEC dbo.edit_version 'Poles', 1; MERGE ElectricNetwork.dbo.POLE_evw USING WMM_Export.dbo.Pole ON ElectricNetwork.dbo.POLE_evw.esElementName = WMM_Export.dbo.Pole.wmElementName WHEN MATCHED THEN UPDATE SET ElectricNetwork.dbo.POLE_evw.GUID_WMM= WMM_Export.dbo.Pole.wm_ElementGuid; EXEC dbo.edit_version 'Poles', 2;

‎10-03-2017

I found that if I had hidden fields in ArcMap during the publishing process the attribute tables on ArcGIS Online would be empty. Once I made sure all my fields were shown in ArcMap I could publish to ArcGIS Online successfully and hide fields on the webmap. It's a pain if you frequently publish maps with hidden fields, but it works.

‎09-27-2017

Thank you Asrujit SenGupta! It was an issue with the records matching. Now that I sorted that out it works perfectly. Thank you so much for your time!! Addie

‎09-27-2017

Thank you, I had that typed up just as you sent it. Unfortunately, while it creates a version and runs successfully, when I go the open the version the data is not there...

‎09-27-2017

EXEC dbo.create_version 'dbo.DEFAULT', 'WMMtoESRI', 2, 1, 'This version contains data pushed from WMM to ESRI'; EXEC dbo.set_current_version 'WMMtoESRI'; EXEC dbo.edit_version 'WMMtoESRI', 1; UPDATE ElectricNetwork.dbo.Regulators_evw SET esPhasing = WMM_Export.dbo.REGULATOR.wmPhasing FROM WMM_Export.dbo.REGULATOR WHERE ElectricNetwork.dbo.Regulators_evw.GUID=WMM_Export.dbo.REGULATOR.wmextVoltageRegulator__GUID_ESR EXEC dbo.edit_version 'WMMtoESRI', 2;

Online Status	Offline
Date Last Visited	‎02-11-2024 04:29 PM

My Ideas

Latest Contributions by AdelaideZumwalt1

Re: Trouble viewing related tables in Collector

Re: Trouble viewing related tables in Collector

Re: SQL Error: "Not currently editing a version, cannot stop edit."

Re: Collector Sync Problem - Operation Rollback

Re: SQL Error: "Not currently editing a version, cannot stop edit."

SQL Error: "Not currently editing a version, cannot stop edit."

Re: sql violation of unique key constraint

Re: sql violation of unique key constraint

Re: sql violation of unique key constraint

Re: sql violation of unique key constraint

sql violation of unique key constraint

Re: empty attribute table on web map

Re: SQL Script runs successfully but changes not visible in Geodatabase Version

Re: SQL Script runs successfully but changes not visible in Geodatabase Version

Re: SQL Script runs successfully but changes not visible in Geodatabase Version

Re: FieldMap: Error in adding input field to field...

Re: empty attribute table on web map

Re: Update a hosted feature layer/relate class

Re: Layer definition query and symbology not updat...

Re: Feature Layer Views for non-hosted data