|
POST
|
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.
... View more
03-13-2018
03:28 PM
|
4
|
2
|
1815
|
|
POST
|
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?
... View more
03-07-2018
05:36 PM
|
0
|
0
|
1815
|
|
POST
|
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;
... View more
02-22-2018
07:24 AM
|
0
|
3
|
1883
|
|
POST
|
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.
... View more
02-15-2018
02:08 PM
|
0
|
1
|
717
|
|
POST
|
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? "
... View more
01-25-2018
07:17 AM
|
0
|
1
|
1883
|
|
POST
|
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;
... View more
01-24-2018
07:37 AM
|
0
|
7
|
2317
|
|
POST
|
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?
... View more
10-04-2017
08:50 AM
|
0
|
0
|
6819
|
|
POST
|
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;
... View more
10-04-2017
08:41 AM
|
0
|
1
|
6819
|
|
POST
|
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!!
... View more
10-04-2017
08:22 AM
|
0
|
2
|
6819
|
|
POST
|
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?
... View more
10-04-2017
08:06 AM
|
0
|
4
|
6819
|
|
POST
|
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;
... View more
10-03-2017
04:13 PM
|
0
|
11
|
15329
|
|
POST
|
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.
... View more
10-03-2017
03:35 PM
|
1
|
1
|
9702
|
|
POST
|
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
... View more
09-27-2017
01:17 PM
|
1
|
0
|
646
|
|
POST
|
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...
... View more
09-27-2017
10:25 AM
|
0
|
3
|
2732
|
|
POST
|
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;
... View more
09-27-2017
09:23 AM
|
0
|
6
|
2732
|
| Title | Kudos | Posted |
|---|---|---|
| 2 | 02-19-2019 03:06 PM | |
| 1 | 10-03-2017 03:35 PM | |
| 1 | 08-20-2018 05:54 PM | |
| 1 | 08-08-2018 03:46 PM | |
| 1 | 12-10-2018 01:50 PM |
| Online Status |
Offline
|
| Date Last Visited |
02-11-2024
04:29 PM
|