Latest Contributions by BugPie

I'm trying to get a few models to run via python after being initialized from Windows Scheduler. (Windows Server 2008 r2, acrmap 10.1.1, python 2.7.2) I have been able to get two of my models to run this way after exporting to python and setting windows scheduler to execute the python script. however, there is still one model that is failing, but only when run via python. Runs successful from the model / toolbox in our Enterprise GDB, no problems at all. I'm, not very versed in python so I can't really decipher what this error (below) means outside of the error code = append issue with mis-matched fields.  The model that runs successfully, is using a table view, geocoding, appending points to a feature class in our Enterprise GDB. The model that fails is using a table view, plotting x/y, appending points to a feature class in our Enterprise GDB.This one seems to fail on the append. BUT only when run from python. Runs successful from the model / toolbox in our Enterprise GDB, just not from python shell. What is going on here, what ? anyone have insight? Please let me know if you need additional info from this tool or error. Fail message::   File "C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy\arcpy\management.py", line 3560, in Append     raise e ExecuteError: ERROR 000224: Cannot insert features Failed to execute (Append). ... View more

Does anyone else see issues with the Delete Rows GP tool hanging at 10.1? We are using this GP tool within a model that updates records within a polygon SDE feature class. Our model uses a view which is a table of of new projects. We are creating a temp layer with "Make Feature Layer" using a little SQL query so that the new temp layer has only the records that are in the new project view. We are then utilizing the delete rows to delete all records matching the view in the SDE feature by way of the temp layer>delete rows. The records are removed from our SDE feature class just fine. Our issue is in the time it takes to delete these records. Even when there are only 12 records to delete, it can take upwards of 7 minutes to run. Our SDE feature class is quite large (400K records) but they are indexed.  We did not have this type of lag with our 9.2 env running on SQL 2000, so I was wondering if anyone had an idea whether or not this is related to 10.1 or maybe the way our SDE has been setup in the 10.1 env. Which is running on a SQL 2008r2 release. Cheers! ... View more

Good morning, We have run into an issue within a model we have built to update a point file with new projects. We are using a table view to capture new projects. We use the table view as the input to a geocoding tool, we then take the output and "make feature layer" which then gets appended to our sites table. This worked just fine in beta and in production for months now. A few days ago this stopped working in production and we have no idea what the culprit is.  The view is still functioning and the append is still working in beta. We have a separate model that uses a different table view to capture x,y of differing new sites. We then run this through a plot x,y and "make feature layer" and then append to the same sites table as mentioned above. This works FINE! It seems to be only the output from the geocoding tool and subsequent make feature layer and append that is failing. The error we receive is 000224. Which if you look at the error all it says is that there are possible mis-matched fields. I have reviewed this model multiple times and the fields are correct, and like I said, it was working fine the other day. I have delete and rebuilt the model, I have rebuilt the geocoding tool as well. Anyone with a littel insight into other aspects I can review, maybe a way to dig deeper into this error as it's pretty bland as is. Is there a way to more closely monitor the append function to see what the real error is? The sites table we are appending to is on a SQL server 2008 r2 instance. In both prod and beta. Screen shots can be posted if needed. Thank you. ... View more