POST
|
I wanted to add that extensions were the problem, someone had registered these standalone tables with our generic extension and that caused the permissions problem, removing extensions in SDE then creating new fgdb fixed the issue. I don't know if that is a limitation of FGDB, but you should be able to reproduce that without our data
... View more
12-04-2014
07:36 AM
|
0
|
1
|
746
|
POST
|
After removing extensions everything works fine. So if you still want to troubleshoot this I can give you a copy of the software but it will be unlicensed but you should be able to install it and extensions should register. Let me know
... View more
11-20-2014
05:28 AM
|
0
|
0
|
746
|
POST
|
Ok I’ll see if I can remove extensions and reproduce the issue
... View more
11-19-2014
01:46 PM
|
0
|
0
|
746
|
POST
|
I was going to attach the databases to the message but I'd prefer something more secure so if you can email me and provide me with a way to upload then i'll do that, total size of the files is about 12 mb so I don't think I can attach to the email: przemyslawt@futuragis.com
... View more
11-19-2014
06:09 AM
|
0
|
5
|
621
|
POST
|
So we deleted everything from the sde database except the table in question and created fgdb from it and it still failed with same error, then we created new PGDB and exported the table to that database, then delete futura_settings table from sde then copied it from pgdb to sde and then exported to fgdb then it worked fine.
... View more
11-19-2014
04:59 AM
|
0
|
7
|
621
|
POST
|
if all you're trying to see is if there is a relationship to the table then i can tell you that there is not, otherwise you'd see that in relationships tab, but below is a screenshot that is sorted by type that shows all relationships and another one showing the table
... View more
11-17-2014
11:25 AM
|
0
|
0
|
621
|
POST
|
Yea, that works, we deleted the table from FGDB, copy paste from geodatabase and it worked fine, but this FGDB is created daily by our py script so its not a solution.
... View more
11-17-2014
11:21 AM
|
0
|
2
|
621
|
POST
|
I don't think this table is involved in any of these, I've posted some screenshots.
... View more
11-17-2014
10:20 AM
|
0
|
10
|
1340
|
POST
|
If there is something else i can look at please let me know.
... View more
11-17-2014
10:20 AM
|
0
|
0
|
621
|
POST
|
Thanks for quick reply. So to answer your questions, I've been looking at different tables and i don't see anything different, of course i maybe overlooking something or not looking in the right places, BUT IsEditable is returning FALSE, so that is big hint, can you tell me what controls that flag? Code that generates this file geodatabase is a python script, it connects to geodatabase with account that has owner permissions and does this for each table: source_db = "\\\\" + hostname + "\\Deployment\\Connection.sde" arcpy.env.workspace = source_db items = arcpy.ListTables() for sourceItem in items: targetItem = string.split(sourceItem, ".")[len(string.split(sourceItem, "."))-1] target = target_db + "\\" + targetItem source = source_db + "\\" + sourceItem arcpy.Copy_management(source, target, "Table") I can add screenshots from ArcCatalog if you think its helpful
... View more
11-17-2014
08:41 AM
|
0
|
12
|
1340
|
POST
|
I'm getting this error when trying to execute table.Delete(row), the error is thrown on the first row. There are many tables in this file geodatabase so I've tried with different ones for some tables it works and for others it doesn't. These are all standalone tables, no relationships, editor tracking is not on. File geodatabase is generated from a 10.2.2 geodatabase. This table has a few fields and the only field that stands out is Settings which is defined as nvarchar(max) in geodatabase. Fields: ObjectID Name: text 255 Settings: text 1073741822 ModifiedTime: date Version: Text 255 SettingsType: Text 255 RowCollection rowCollection = table.Search("*", whereClause, RowInstance.Unique); foreach (Row row in rowCollection) { table.Delete(row); }
... View more
11-17-2014
05:08 AM
|
0
|
24
|
7177
|
POST
|
I'm not sure if this is the right forum but I need to know if anyone knows how to programmatically remove relationships from axf database. Axf can be edited with sqlserver ce drivers I can see different tables there I can drop related tables and edit AXF_Tables table and remove records from there too but that doesn't seem to be enough.
... View more
02-26-2014
09:56 AM
|
0
|
0
|
645
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|