Latest Contributions by TimLangner

‎09-26-2011

Hi there Sorry I rewrote my message when I read though it again. It seems I can call something else but I don't do it in the same place as the error exception handling, In PL/SQL I could call a procedure a raise but in Python, you call an exception and then do something else after the exception has been called. So they are separate parts of code. Kind regards Tim

‎09-26-2011

Hi there I've read through various web sites and Stacys helpful reply. However if I implement Stacys code then only an error message is displayed. However whilst I need an error message, I also need some code to run that brings up the map services after the error message is displayed or just before, if it can't be after. I've got the code to bring up the map services but I am not sure how I call this via an exception as all the exceptions I've seen, seem to just print an error message and do nothing else afterwards. I know how to do this in PL/SQL but this is different way of working to that and I can't figure it out. Kind regards Tim

‎09-26-2011

Thanks for your reply Stacy. I will study what you have written closely. I'm trying to handle all my exceptions in their own procedure. So each type of error goes to the procedure, which is a standard procedure that prints an error message and then restarts all the map services. I'm not 100% certain how the class and def __init__ works. I've seen various bits of code but I guess the issue is I don't understand what __init__ means theoretically for Python and thus I don't understand how to use it. Lots of places give the theoretical code for exceptions and then an example but not necessarily the meaning behind the code. However I'm now browsing the term __init__ and that should greatly help me. I wasn't expecting to get into this area so quickly. I'll probably buy a book on python but right now I don't have time to wait for one to turn up. Would be great if ESRI published one. The section in ModelBuilder is far to short. They need something like the Apress book for Oracle Spatial, which I own and found extremely useful when completing my masters dissertation. Expect when I wanted to add an obsolete Ordnance Survey project into Oracle that is...... Kind regards Tim

‎09-23-2011

Hi there I'm attempting to run a script in Python 2.6 referencing ArcGIS 10. I got the script to run but then I decided to use the try and except method and handle multiple exceptions. However as soon as I started doing this I'm getting the following error: except EXCEPTION: NameError: global name 'EXCEPTION' is not defined I think I need to define a class but I'm not sure how that would relate to then running an additional procedure. The idea of the programme is to create a backup of 3 feature classes and if errors occur, pass them to the error exception procedure. This then prints an error message and calls the procedure to restart the map services. The section of code is as follows: print "\n5. Now renameing " + TABLE_OWNER + SDE_FC_CURRENT + " to " + TABLE_OWNER + SDE_FC_BACKUP + " providing no lock exists" try: try: if arcpy.Exists(TABLE_OWNER + SDE_FC_CURRENT) ==1: arcpy.Rename_management (TABLE_OWNER + SDE_FC_CURRENT, TABLE_OWNER + SDE_FC_BACKUP) print "test " + EXCEPTION except EXCEPTION: if arcpy.TestSchemaLock(TABLE_OWNER + SDE_FC_CURRENT) ==0: EXCEPTION(LOCK_ERROR_TEXT, SDE_FC_CURRENT) except LOCK_ON_BACKUP: if arcpy.TestSchemaLock(TABLE_OWNER + SDE_FC_BACKUP) ==0: EXCEPTION(LOCK_ERROR_TEXT, SDE_FC_BACKUP) except UNKNOWN_ERROR2: if arcpy.Exists(TABLE_OWNER + SDE_FC_CURRENT) ==0: EXCEPTION(UNKNOWN_ERROR, SDE_FC_CURRENT + " and " + SDE_FC_BACKUP) I hope that is enough code. I can supply more if required. Kind regards Tim

‎09-23-2011

Hi Tim, If changes need to be tracked over time, a feature class must be registered as versioned without the option of moving edits to base and archiving must be enabled. If archiving is not enabled, one cannot connect to a historical version to track the changes. Please review the following help links and verify if it paints a clearer picture. Enable archiving ------------------- http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#//0093000015z6000000 Disable archiving ------------------ http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#/Disabling_archiving/0093000015z7000000/ Thanks Thank you for your reply. I have already registered the tables as versioned without moving the edits to base so the archive could be enabled. I read the two help documents but they make no reference to feature class to feature class copying with regards to archiving, which is what I am trying to figure out. Would archiving achieve a similar result to creating a back up? Although the database itself gets backed up, I am wishing to have a day old backup of the table encase the table corrupts. As this is easier to get hold of. Could a table corrupting cause an archive to corrupt more easily than a day old back up? I am going to raise a support call with ESRI UK and I when I get a moment I will post back what they suggest and/or say. Kind regards Tim

‎09-22-2011

Hi there I am using ArcMap 10.0.2 connected to ArcSDE 9.3.1, with the database hosted in Oracle 9i. I have a feature class which is registered as version with no edits moved to base. This is so I can track it over time. If I then do a feature class to feature class conversion, in order to create a backup, will it still contain the same history, as in archiving? The current logic is like this: 1. Using feature class to feature class, Take current <feature class name> and generate one with the name <feature class>_new 2. rename current <feature class name> to <feature class name> backup 3. rename <feature class name>_new to <feature class name> 4. Register <feature class name> as versioned Kind regards Tim

‎09-20-2011

Data modelling diagrams and flow charts are extremly useful and importamt when designing a database. Equally I feel they are also useful and important in this case.

‎07-28-2011

I got the same Reshape error working in ArcGIS 10 personal geodatabase. I saved the mxd in 9.3 to troubleshoot the problem and didn't get the error. After couple of hour of struggle, I exported the file from personal geodatabase to Shapefile format and tried Reshaping again in ArcGIS 10, that seem to work. I am having wierd issues with ArcGIS 10, hope these issues will get resolved in next version (or service pack). I have started another thread enquiring what situations a reshape task may not be completed. It may be that it is linked to this issue. Perhaps if ESRI can post situations where it would occur, it may help us users. If they can't then it may be that users can post, providing ESRI with more information for them to figure out why it occurs. http://forums.arcgis.com/threads/35648-Edit-spatial-data-with-quot-ArcGIS-for-Desktop-10.1-quot-in-non-SDE-RDBMS-systems Kind regards Tim

‎07-14-2011

Hello there, I am editing in ArcMap 10.0.2. I have created some features, one of which is an ellipse. I have clipped a larger feature using this. How I am trying to reshape a feature which adjoins this but when I do so I get the following: "The Reshape task could not be completed. An internal error has occurred in the geometry system." Is this a bug or just the way ArcMap works? I'm also find that edges of polygons clipped using ellipses and circles do not edge match. Kind regards Tim

‎06-09-2011

Hi Tim, This turns out to be a bug. Here's the nim. You can contact support if you need more info on it: NIM067949: Switching back and forth between another application and ArcMap can cause the table to fail to load while editing. Thanks! Thanks FJ for doing that. It's not the only issue I have with the attribute tables losing the link until save is hit but it's the one I could replicate every time because I knew all steps that would cause it. Others occur randomly enough for me not to be able to identify the steps that cause them. However that fixing that issue might resolve other issues with the attribute table. Kind regards Tim

‎05-17-2011

Dear all I am trying to create a view on an SDE using the make query table tool. However I keep getting: ORA-00972: identifier is too long when I type in the SQL expression. so "SDE.XXX_XXXX_XXXX_XXX_XXXXXX.XXXX" = "SDE.XXXXXXX_XXXXXXX_XXXXXXX_XXX.XXXXXX_XXXX". If I don't put the names in " " then I get ORA-00904: "field name in here": invalid identifier. I realise that the identify name has to be under 31 characters but even when I enter an alias beside the fields names in the make query table, it doesn't make use of those for the SQL expression. I am using ArcMap 10.0.2 and connecting to ArcSDE 9.3 running I believe Oracle 10g Kind regards Tim

‎05-06-2011

Dear all I am currently experiencing an issue when editing an attribute table and I was wondering if any one else can replicate the same issue? I am using ArcGIS 10 SP2 and the data is held in an SDE which is 9.3.1. 1. I have Select by attributes up; 2. I run a select query; 3. I have show only selected rows in my attribute table; 4. This may just bring up a single row of data; 5. I edit a value in one field the single row of the attribute table; 6. Without clicking outside of the field I've edited, I press ALT+TAB and switch to Excel 7. In Excel I read the next value I need to change 8. Using ALT+TAB I switch back to ArcGIS 9. I amend the SQL in the select by attribute window and hit apply 10. This then brings up the following error message: "Loading table data Could not load data from the data source. If you can correct the problem, press the refresh button to reload data. Possible problems can include bad network connection, invalid field, etc." The records then appear but with nothing showing in the fields. If I switch back to view all records they appear with all the other records but not when I then switch back to show selected fields only. The only way to resolve the issue is to save the database and then they appear. This doesn't occur if I click out of the attribute field after editing a value or if I go straight from editing a value to using the Select by attribute window. Only if I go away from ArcGIS in-between doing both tasks when still within an attribute field.

‎04-20-2011

In ArcCatalogue 10 when trying to reorder the type column for display I get the following message: "Cannot move Name or Type columns". It would be helpful if the type column could be moved because after the name I wish to display the feature type which is more detailed, rather than the more board type, which is less detailed.

‎03-14-2011

Thank you for your reply spag911. That is really helpful as I couldn't find the answer when I tried searching for it. Kind regards Tim

‎03-03-2011

Dear all, I have a file geodatabase that has come from a shape file. Shape files don't offer null values and puts a space in such fields. I would like to update these columns that have spaces so that they are null. How do I do this? Kind regards Tim

Online Status	Offline
Date Last Visited	‎11-04-2024 05:38 PM

My Ideas

Latest Contributions by TimLangner

Re: How do I handle my own exceptions and get the excetion to run another prodcure?

Re: How do I handle my own exceptions and get the excetion to run another prodcure?

Re: How do I handle my own exceptions and get the excetion to run another prodcure?

How do I handle my own exceptions and get the excetion to run another prodcure?

Re: History of versioned data after feature class to feature class

History of versioned data after feature class to feature class

Re: arcgisscripting and arcpy object model diagrams

Re: Reshaping a feature gives an internal error with the geometry system

Reshaping a feature gives an internal error with the geometry system

Re: Staying in an attribute field when switch to & from ArcGIS causes a load table er

ORA-00972: identifier is too long when using Make Query table tool

Staying in an attribute field when switch to & from ArcGIS causes a load table error

Allow reordering of all diplay columns in ArcCatalogue 10 inc. Type and Name

Re: How do I update a column in a file geodatabase to be null?

How do I update a column in a file geodatabase to be null?

Packaging of ArcGIS Pro project taking an hour - s...

Re: can ArcGIS Pro use cartographic representation

Re: can ArcGIS Pro use cartographic representation

Re: Offsetting lines without using representations...

Re: Enable Repair Geometry tool for ArcSDE geodata...