Latest Contributions by WillAllender

We are having similar issues (cannot delete a handful of .bundle files) and yes, this is new at 10.2.2.  It is very hit or miss.  Out of 50,000+ files over 16 levels of cache and 6 different services, it is usually less than 200 .bundle files that cannot be deleted. In the past we have built cache on a staging server, then xcopy into production.  Now, I am building cache on a staging server, using an os move command on the production file out to a garbage can area on the network share, then doing an os move from staging into production.  I have a sys admin working on how to delete the files that were moved out of production.  But for the moment, the directory is a garbage dump of files that cannot be deleted. Our architecture at a high level: 1) 9 caching servers building cache from local file GDBs on each server, sending to a single cache repository on a network share. 2) build in staging 3) move to production ... View more

Son of a b... that actually worked.  Converting to ST_GEOMETRY.  I would love to know how you arrived at that suggestion. It doesn't help me with my ultimate/root problem, but it does somewhat help explain what's going on.  Root problem is that I am data mining someone else's SDE and they store in SDO, which I have no control or influence over.  So my test data is now invalid, but that is another issue. Anyway, THANKS! ... View more

Adding more information to the topic Desktop 10.2 SDE 10.2, 64-bit Oracle 11.2.0.3 Using Asrujit's example of building the workflow in ArcMap, I did the following: 1) added the feature class and table to ArcMap 2) used MakeFeatureLayer from ArcToolbox 3) used AddJoin from ArcToolbox 4) Ran GetCount, which resulted in -1 5) opened the table from the Table of Contents and visually saw all of my records, with a correct join performed 6) attempted to export data to a new feature class 7) finally got a useful error message: "Error exporting data. Underlying DBMS error [ORA-25156: old style outer join (+) cannot be used with ANSI joins] [DBJoin1]" 😎 Got my DBA involved to capture the error when I ran it again 9) ArcMap is generating the following SQL, which fails (SDE 10.2): [INDENT]SELECT GIS.TESTFC.OBJECTID,        GIS.TESTFC.JOINFIELD,        GIS.TESTFC.SHAPE,        GIS.TESTTABLE.OBJECTID,        GIS.TESTTABLE.JOINFIELD,        GIS.TESTTABLE.ADDITIONALATTRIBUTES,        SHAPE.fid,        SHAPE.numofpts,        SHAPE.entity,        SHAPE.points,        SHAPE.rowid   FROM GIS.TESTFC   LEFT OUTER JOIN GIS.TESTTABLE     ON GIS.TESTFC.JOINFIELD = GIS.TESTTABLE.JOINFIELD, GIS.F1888 SHAPE where SHAPE.FID(+) = GIS.TESTFC.SHAPE;[/INDENT] 10) ran through all the same steps using data from SDE 9.3.1 11) ArcMap generates the following SQL, which succeeds (SDE 9.3.1, Oracle 10g): [INDENT]SELECT OBJECTID,        JOINFIELD,        SHAPE,        SHAPE.LEN,        SHAPE.fid,        SHAPE.numofpts,        SHAPE.entity,        SHAPE.points,        SHAPE.rowid   FROM GIS.TESTFC, GIS.F3501 SHAPE where SHAPE.FID(+) = GIS.TESTFC.SHAPE; SELECT JOINFIELD, OBJECTID, ADDITIONALATTRIBUTES   FROM GIS.TESTTABLE WHERE (JOINFIELD in (444444, 555555, 666666));[/INDENT] So, as Vince pointed out, we are a particular use case and it would appear that there is something about our implementation/environment that is causing ArcMap to generate bogus SQL (but Asrujit's works just fine). I bundled up all my notes and sent them off to tech support.  Just wanted to share in case someone else came across this issue. ... View more

Asrujit, Thank you for your assistance!  That is the same workflow I am using. Again, thank you for trying! Will ... View more

asrujit, Thank you for your assistance!  The one difference that I see in your workflow vs. mine is that you are doing it in ArcMap, after the layer and table have been added to the ArcMap session.  When I do it that way, it works for me too. For my workflow, I test in the ArcCatalog Python window, without an ArcMap session open.  Or I test in PyScripter.  Ultimately, I need to do unattended nightly batch processing, without user interaction. Again, thank you for trying.  Since you already have the data in SDE 10.2, I would be in your debt if you could try the same steps in ArcCatalog. Thank you, Will ... View more

Thank you for the reply, Vince. I opened an incident 8 days ago with esri Tech Support and stumped the first technician during his initial screen share session.  A second tech said, just today, that she will try to get to me, to do another screen share, maybe tomorrow, or next Monday.  I was a little surprised by this, considering we are on an ELA. Anyway, I thought I would throw it out there to the user community, since doing Joins is about as common as doing an Identify. ... View more

Does anyone out there have an SDE 10.2 Oracle11g setup and is willing to have a go at this?  I have attached a 3-record personal gdb with mocked up data.  3 features and 3 tabular records.  The join field is JOINFIELD. This is fresh, mocked up, completely unreal data.  If I load it into a 9.3.1 SDE instance, the AddJoin function works.  If I load it into a 10.2 database, the AddJoin fails.  It's that simple. For testing, I am copying/pasting commands into the Python window in ArcCatalog: >>> arcpy.MakeFeatureLayer_management(r'<some_sde_connection.sde>\GIS.TESTFC',"TESTLAYER") >>> arcpy.GetCount_management("TESTLAYER") >>> arcpy.AddJoin_management("TESTLAYER","JOINFIELD",r'<some_sde_connection.sde>\GIS.TESTTABLE',"JOINFIELD") >>> arcpy.GetCount_management("TESTLAYER") My ultimate goal is to export newly joined data out to a data warehouse.  The record count of -1 from ArcGIS 10.2 is producing zero records. Thanks, Will ... View more

Did you ever get any help on this? We are having issues with our state_lineages table growing out of control and am trying to determine if others are having a similar problem, or if your issue is related.  It's only the web edit side, not the desktop editing side. 80 million records in state_lineages, but our feature edit count is in the high 100's to low 1000's.  7-hour compress, then less than 100 new edits.  Now we're back up to 4.3 millions records in state_lineages. ... View more

As a follow-on to this topic, I have a multivalue list and I want to test it for the number of selections made by the user.  If the user selects just one value, I want to enable some other Boolean controls.  If the user selects more than one, I want to disable those controls. I cannot get the Boolean controls to update as soon as I make a list selection.  I must click somewhere else on the form to get the controls to change status. code where "feature_class" is my multivalue parameter and the other variables are my Boolean checkboxes. ---------------------------------------------- def updateParameters(self, parameters): [INDENT]# Get inputs[/INDENT] [INDENT]update_biweekly = parameters[0][/INDENT] [INDENT]update_monthly = parameters[1][/INDENT] [INDENT]update_adhoc = parameters[2][/INDENT] [INDENT]feature_class = parameters[3][/INDENT] [INDENT]update_gisp = parameters[4][/INDENT] [INDENT]update_gis = parameters[5][/INDENT] [INDENT]update_gisw = parameters[6][/INDENT] [INDENT]update_countystore = parameters[7][/INDENT] [INDENT]update_cache = parameters[8][/INDENT] [INDENT]if update_adhoc.value:[/INDENT] [INDENT][INDENT]feature_class.enabled=True[/INDENT][/INDENT] [INDENT]else:[/INDENT] [INDENT][INDENT]feature_class.enabled=False[/INDENT][/INDENT] [INDENT]if feature_class.values:[/INDENT] [INDENT][INDENT]if len(feature_class.values) == 1:[/INDENT][/INDENT] [INDENT][INDENT][INDENT]update_gisp.enabled=True[/INDENT][/INDENT][/INDENT] [INDENT][INDENT][INDENT]update_gis.enabled=True[/INDENT][/INDENT][/INDENT] [INDENT][INDENT][INDENT]update_gisw.enabled=True[/INDENT][/INDENT][/INDENT] [INDENT][INDENT][INDENT]update_countystore.enabled=True[/INDENT][/INDENT][/INDENT] [INDENT][INDENT][INDENT]update_cache.enabled=True[/INDENT][/INDENT][/INDENT] [INDENT][INDENT]else:[/INDENT][/INDENT] [INDENT][INDENT][INDENT]update_gisp.enabled=False[/INDENT][/INDENT][/INDENT] [INDENT][INDENT][INDENT]update_gis.enabled=False[/INDENT][/INDENT][/INDENT] [INDENT][INDENT][INDENT]update_gisw.enabled=False[/INDENT][/INDENT][/INDENT] [INDENT][INDENT][INDENT]update_countystore.enabled=False[/INDENT][/INDENT][/INDENT] [INDENT][INDENT][INDENT]update_cache.enabled=False[/INDENT][/INDENT][/INDENT] [INDENT]return[/INDENT] ---------------------------------------------- Any thoughts on how to get my enabled status to change immediately upon clicking a value in the multivalue list? Thanks, Will ... View more

As it turns out, my above posts have several incorrect statements/assumptions. a) We have not tested shp2sde at 10.1, since we are using direct connect and have not installed SDE on the unix server.  shp2sde does work at 9.3.1, and that is as far as I can confirm. b) It would appear that we are not using SDO geometry, but in fact, SDEBINARY geometry.  I am trying to confirm this but am struggling to find the definitive answer. Any help would be appreciated. Closing in on beer-thirty... 🙂 ... View more

Wayne, Thank you for the quick reply and link. I should add to my initial post that we have not migrated to st_geometry.  Our production geodatabase grew out of coverage, then Arc 8.x, and is now in 9.3.1.  Geometry storage type is SDEBINARY. ... View more