POST
|
We have a strange problem that has popped up after upgrading to 10.6.1. For many years, our editors have been set up with a single SDE connection, and all the data they need is pulled from this connection - this includes layers they have permission to edit, and reference layers that they don't have permission to edit. When an editor begins to edit, they are able to edit without any issues. Now in 10.6.1, intermittently, they will get the "Can't edit data in the folder you have selected" error, indicating that there is non-editable data under the SDE connection they are trying to edit. Why are we seeing this pop up now? Again, we have had this setup for years, and never had any issues editing inside an SDE connection with editable and non-editable data. When this happens (and luckily it's only a few times) we have to make them a second SDE connection, then switch all of the editable data to source from the new connection. This seems trivial, but it is not. We have more than 100 stored displays with a setup of a single SDE connection for the data, so to fix all of these would be a pain. Anyone know what's happening here? Am I missing a checkbox setting somewhere in the bowels of ArcMap to turn this check off? Any insight would be helpful.
... View more
06-14-2021
07:50 AM
|
0
|
0
|
283
|
IDEA
|
In my mind this is something of a bug, people switching from ArcCatalog are probably not going to realize that the functionality is completely different and that they could be renaming folders on the network without even realizing it. At very LEAST, stick a message in there to tell people, hey, you are actually renaming a folder on disk, are you sure you want to do this? Our pathing on the network can be very long, so even if we could see the entire path, it would still be difficult to read. Aliases are a very important piece of keeping my Catalog & folder connections cleaned up so that I can easily see what I am connected to.
... View more
10-21-2020
08:46 AM
|
1
|
0
|
2246
|
POST
|
My solution, a snippet of code, is below cursorUpd = db.cursor() #set version cursorUpd.callproc('sde.version_util.set_current_version',['MyVersion']) #start editing cursorUpd.callproc('sde.version_user_ddl.edit_version',['MyVersion',1]) #SQL for update cursorUpd.execute("UPDATE xxx set REVIEWNOTES = 'TEST " + currDay + "' WHERE ORIGGUID = " + matchGUID) #stop editing, save cursorUpd.callproc('sde.version_user_ddl.edit_version',['MyVersion',2]) db.commit() Hopefully this is helpful. I initially tried to do this through a single large execute block, with all the calls inside the execute block, but the bind variables for the update statement would not work, no matter how they were formatted. The above works for me.
... View more
10-15-2020
08:30 AM
|
2
|
0
|
691
|
POST
|
Did you make this work? My code works, except it seems to be ignoring the version I set and editing directly in the Default version which is NOT what I want.
... View more
10-14-2020
01:24 PM
|
0
|
2
|
691
|
POST
|
We have been trying to get replication in place for a few years. For Simple model replication with limited datasets, replicating to a FGDB works very well. Replicating larger datasets with the Full model and geometric networks has been tougher to manage. The hurdle we are facing now is schema changes. We are a four-service utility with a huge database, and we make changes to our schema fairly regularly. In order to avoid recreating the replicas when we have a schema change (very time-consuming) I have been trying the schema update tools - Export Replica Changes, Compare Replica Schemas, and Import Replica Changes. For some things this worked great - I dropped two fields and re-added as new fields with a different data type and the same names, and it picked up and synced the schema. In another case where I renamed a field and dropped three others, the renamed field came across in the replica as a brand new field with the new name, and the old field was still in the table. The three deleted fields never got deleted from the replica database. My question is, can I simply manually sync the field schema between the databases? If I drop a field in the parent, then manually delete the field in the child, will the data still synchronize? If I rename a field in the parent, then manually rename it to match in the child, is that going to hose anything up? I don't expect the schema tools or the manual method to work on a feature class itself (renaming or adding a new one) as I know the replica has to be recreated in those cases. I am only interested in field level updates, renaming or deleting a field. I think adding a new field would also require using the schema tools or recreating the replica.
... View more
01-16-2020
11:47 AM
|
0
|
1
|
289
|
POST
|
Thanks for the suggestions, but the second link you provided is the same link I put in my original post, which is what I need a better explanation for. The second issue has nothing to do with my particular issue, but I appreciate the thought!
... View more
10-10-2017
11:55 AM
|
0
|
0
|
535
|
POST
|
Error: Cannot copy and paste a narrow network into a dataset requiring wide networks We have a rather interesting issue with moving data between our SDE databases. We need to do a replica from SDE to SDE, so we are choosing to copy/paste data from Parent SDE database A to Child SDE database B, which is a completely new, empty database of the same version and patch level as the Parent db. We get the error below. The error is apparently a failure of an older geometric network, and the link to the explanation is above. However, the explanation at the link above makes zero sense to me at all. The ClassID (from 9.x version) is supposed to now be represented by the OBJECTID in the GDB_ITEMS table. (From ESRI blog: In ArcGIS 9.x, the ClassID field corresponds with the ClassID found in the GDB_OBJECTCLASSSES table and identifies which feature class the ObjectIDs corresponded via the Layers table ‘Layer_id’. In ArcSDE 10 using the simplified geodatabase schema, this field now refers to the ObjectID in the ‘GDB_ITEMS’ table which will also enable you to determine which feature class the error corresponds with in the same way.) As far as I can see, the database structure of the Parent GDB_ITEMS table is the same as the Child GDB_ITEMS, so I don't understand why this is happening. We cannot easily drop and rebuild our networks (we have many of them), and XML Import to get the data migrated has it's own issues. Rebuilding the network in the parent database did not have any effect. Can someone give me a better explanation of why I cannot copy a dataset with this network from a parent database to an empty child database? Thanks!
... View more
10-10-2017
09:25 AM
|
0
|
2
|
918
|
POST
|
We are on 10.2.1, so it appears it has still not been fixed. Thanks for the update! Tami
... View more
05-10-2017
03:17 PM
|
0
|
0
|
535
|
POST
|
I have noticed recently that when I run Generate Attachment Match Table from ArcCatalog, I am getting more records than I expect. For example, I have 5660 image files in my directory and all have a match back to my feature class. I would expect the same number of records to appear in the output Match table. However, I end up with about 5699. I was puzzled by this until I started looking at the Match table more closely. It looks like it is randomly creating duplicates of some of the match records. The only way to quickly fix this is to convert the match table to Excel, remove the duplicates, and export back out to a table again. I can then use the new table without dups to add attachments to the feature class. Is this a bug? I could not find anyone else who seemed to be having the same issue. Any ideas? Tami
... View more
05-10-2017
02:18 PM
|
0
|
3
|
897
|
POST
|
I figured this out, I had to be connected as the SDE user before the DESCRIBE would return any children at the root. The user I connect as normally has privileges on everything and can see everything in ArcCatalog, and Describe as this user can see all the tables/fc/rel classes inside the datasets, but once you move out to the root level that same user gets no results back on a Describe of the workspace. Interesting, and nothing in any documentation about how you need to be connected to use the Describe for the workspace level when you want to see subelements.
... View more
02-09-2017
02:23 PM
|
0
|
1
|
323
|
POST
|
I have this in Python: workspace = r'Database Connections\XXX.sde' rc_list = [c.name for c in arcpy.Describe(workspace).children if c.datatype == "RelationshipClass"] Which should give me all the relationship classes at the root of my SDE database, and I have many! However, rc_list comes up empty every single time. Works for a FGDB, does not work for SDE. I have tossed every permutation of the SDE connection workspace path at this, and nothing works. The other workspace properties like server, instance, connectionString all get returned every time, but the children are blank. Am I missing something? This is the only way I know to grab all the relationship classes at the root, so I am puzzled as to why it finds nothing. Thanks Tami
... View more
02-09-2017
01:04 PM
|
0
|
2
|
1263
|
POST
|
I have a Spatial ETL tool which is set up to create the output inside a ZIP file. This works great when run locally, and the path for the output looks like "C:\Output.Zip\Output.dwg. I end up with a nice zip file on the local drive with the DWG inside. However, when you publish, that original output path gets changed to a scratch workspace, and it removes all path info except the file name Output.dwg. The path ends up looking like '%scratch%\Output.dwg'. It removes all reference to the zip file, so it doesn't create a zip file in the output, only the DWG file. How can I set this up to create a zip file when published? Publishing a Spatial ETL does not involve ANY custom code of any kind - it relies on whatever parameters are set in the ETL tool. So, I can't play with the output path or anything like that using Python or other programming language. Has anyone tried to do this? Thanks Tami
... View more
01-25-2017
09:48 AM
|
0
|
0
|
338
|
POST
|
Thanks Robert, that's what I was afraid of. I think the archiving option might be safer for us since our version and rec/post/compress is so customized. Appreciate your input! Tami O.
... View more
10-19-2016
02:52 PM
|
0
|
1
|
413
|
POST
|
I am dealing with a somewhat similar problem, but unfortunately I did NOT sync before rec/posting all of our versions back to Default and running compress. This is a development environment so not fatal, but how do you recover from a state where you have deleted the sync versions and you now have a parent and child database without in-sync data? I assumed I could just unregister the replica (had to since I had somehow blown away the replica versions) and create a new replica. The globalid values still match between the databases, so I created the replica with existing data option. It syncs, but the changes are not being propagated to the child database. Any thoughts? There has to be a way to recover from something like this without recopying all the data back over to the child database, which could take a day or more. Tami O.
... View more
10-18-2016
09:03 AM
|
0
|
3
|
413
|
POST
|
Unfortunately I am in an Oracle environment and it is not quite that easy. From my investigation it looks like the actual XML is in a BLOB field, which is turned into readable XML (using some SDE function under the hood) in the GDB_ITEMS_VW. In the XML_DOC_1 table (stores domain info) the BLOB field XML_DOC is also translated into readable XML in the XML_DOC_VAL field, but the XML_DOC is the field that needs to be updated, and you cannot easily do that. I have tried editing the XML_DOC_VAL field in my test database, and it has no effect on what domain owner shows in ArcCatalog. ESRI really needs a tool to update the owner for situations like this. Unfortunately it is still a NEW/DEVELOPMENT level idea for them. Probably be awhile before it is implemented.. Following Enhancement has been logged earlier with respect to this issue.The status is New and the Development team is looking into it. NIM070142 Enhancement Request: Provide ability to update/change domain owner.
... View more
05-26-2016
10:03 AM
|
1
|
0
|
217
|
Title | Kudos | Posted |
---|---|---|
1 | 11-15-2013 11:50 AM | |
2 | 10-15-2020 08:30 AM | |
1 | 10-21-2020 08:46 AM | |
1 | 02-18-2015 09:50 AM | |
1 | 05-26-2016 10:03 AM |
Online Status |
Offline
|
Date Last Visited |
2 weeks ago
|