Latest Contributions by WilliamCraft

Which version of ArcGIS Server and ArcGIS Desktop are you using?  It's always helpful to provide the software versions when you post an issue in the forums.  Anyways, it sounds like you're using cached tiles for your service and that the tiles don't show the right result that you're hoping for despite the fact that your map document does.  If using 10.0, are you publishing from an MSD or an MXD?  If MSD, are you positive that you've replaced your MSD with your modified MXD before republishing the service and re-caching?  For 10.1 and 10.2, I believe the software're publishing mechanism forces you to re-save the SD before republishing anyways.  That being said, if you are using ArcGIS Server 10.0, have you tried clearing the REST cache by chance?  This can be done using the http://hostname/ArcGIS/rest/admin URL along with an administrator account.  For 10.1 and 10.2, the REST cache is supposed to be managed/cleared automatically by the application.  I'm not sure how well that works though.  If you're using 10.1 or 10.2, can you try clearing the cache manually using a URL similar to this one: http://<admin-url>/system/handlers/rest/cache/clear ?  I don't think you should have to do this, but it might be a quick and painless first attempt at addressing the issue. ... View more

Is this a custom geoprocessing service that you created?  To improve/modify error handling and their associated error messages, you may be able to modify the Python script that gets executed by the GP service.  Sometimes Esri error messages appear when a tool simply fails; the resulting error message is something that is embedded into the Esri code for that tool and it can't be changed.  I think most of the time, we're all at the mercy of the Esri error reportnig that is part of the application code.  We've all seen the dreaded "General System Failure" or "99999" error message from Esri tools that haunt us from day to day.  Other times, if there is a failure in your own script somewhere, you may be able to provide a clearer error message by inserting the arcpy.AddWarning or arcpy.AddError module throughout the code.  Depending on the version of ArcGIS you are using, these links may be helpful for you: http://help.arcgis.com/en%20/arcgisdesktop/10.0/help/index.html#/AddError/000v00000003000000/ http://resources.arcgis.com/en/help/main/10.1/index.html#/AddError/018v0000005w000000/ http://resources.arcgis.com/en/help/main/10.2/index.html#/AddError/018v0000005w000000/ Think of these as custom error reporting where you, as the script programmer, anticipate which issues may occur based on script input and then modify your code to better communicate those issues to the end user.  I'm not sure if this answers your question, but I understand that error reporting can be frustrating. ... View more

Are you talking about creating a FDGB and then moving into an RDBMS, or are you talking about "converting" an Oracle GDB to a SQL Server GDB (or vice versa)?  ArcGIS Diagrammer is a free tool that allows you to craft your geodatabase model in an environment agnostic to a specific RDBMS.  I've had good luck with this tool from time to time from a basic design standpoint where I can create tables, feature classes, rasters, relationship classes, and other Esri-related objects.  It's a handy tool for quickly modifying the order of fields and their names, too.  Once you save your project file, you'll be able to export a schema XML document which can then be imported into an enterprise geodatabase in SQL Server or Oracle (or a FGDB if you chose).  This really isn't "converting" the database from SQL Server to Oracle or vice versa (that is, keeping your data intact), but it does give you flexibility to manufacture a data model and load its empty schema wherever you desire.  That being said, if you need a way to move your data from one RDBMS to another (which may not be what you're trying to do, I can't be sure), you may be able to simply use a manual copy and paste the objects from one geodatabase (let's say, Oracle) into another geodatabase (SQL Server) if you establish connections to both in ArcCatalog.  (Note: The Copy Data tool won't work in the case where relationship classes are involved whereby one object class is related to more than one other object class.)  You undoubtedly will have to work through granting your permissions on the target afterward, though. ... View more

Well, I've gone back and re-run the script I wrote using both the example.txt and the example2.txt files as input.  Not only are my CSV files correct, but so are my output shapefiles.  Below is a screenshot of what I am getting: [ATTACH=CONFIG]29895[/ATTACH] As you can see in my output, I don't get any NULL or truncated values.  I have, however, highlighted the differences that I can see between what I'm getting and what you're getting.  First, you have an OBJECTID field and I have an FID field.  My guess is that you may have adopted Caleb's code or some modification of it; but I don't think this difference is relevant in the context of the issue you're describing with the output.  Nonetheless, it's a difference so I noted it.  Secondly, and probably more importantly, the field that seems to be giving you trouble is left justified in my output and right justified in yours.  That led me to check the field type; in my output, the field was created as a string.  Can you check yours to see if it's getting created as numeric (i.e., Long Integer, Double)?  Based on the fact that COUSOU becomes NULL and 88F4 becomes 884 makes me think that the letters aren't recognized as part of the value because the field is not getting created as a string like it should be for you.  So, what's different in our environments?  Our script is basically the same.  our inputs are the same.  Yet our results are different.  I'm using 10.1 SP1 build 3143 with Python 2.7... can you check the exact build number of ArcGIS and version number of Python on your machine?  For ArcMap, you can use the About ArcMap from the Help menu or run Patchfinder. EDIT: One last difference in our outputs (yet minor, I think) is that my output is M aware in addition to being Z aware.  Yours seems to be only Z aware. ... View more

For whatever reason, the field containing the altered values looks like may be getting created as numeric.  I'll take another look at my output to see if I'm seeing similar behavior in the data type for the field, but when I checked the results from converting the example.txt you provided all of the values were outputted correctly.  That is, I didn't see any NULL of truncated values as you're seeing. ... View more

I don't think anyone really knows; hence the length of this thread.  I will reiterate my questions... Can you check your ArcGIS Server log to see if there are any errors that might point to an issue? Can you also check your Windows Event Viewer for problems right after the machine boots up? ... View more

In 10.1 or higher, usage statistics for ArcGIS Server services can be derived via the ArcGIS Server Administrator API.  This site contains a sample script on how to parse the AGS logs to get the stats you might want: http://resources.arcgis.com/en/help/main/10.1/index.html#//0154000005vw000000.  I'm not sure what you mean by accounts; are you talking about database accounts or AGS accounts?  One product I'd recommend checking out is GeoSystems Monitor from Vestra.  It's a sysadmin tool that monitors your environment and alerts you when issues arise; additionally, it also records the status of web applications, GIS services, web services, databases, etc.  We'll be testing it in early 2014 to understand the full scope of capabilities.  What I liked about the demo of the software is that it's GIS-focused.  They showed us charts, graphs, and tabular views of usage stats for individual services and were able to generate reports.  Give them a call or send them an email to ask you specific questions... their product may provide what you need and then some.  The person you should talk to at Vestra is Heather Croom.  I'm not 100% sure how it all behaves, but it looked promising from the demo.  Here's a direct link for some basic product info: http://www.vestra.com/products/software/geosystems-monitor.html ... View more

If you're able to connect to AGS in ArcCatalog or in Server Manager alright (which, from your screenshots it appears as such), then in my mind the "SOM" or the ArcGIS Server service is running just fine.  That being said, I think the only reason a service might stop or never start is if there is an issue connecting to the underlying data sources.  Since your data sources are file geodatabases local to the server, it's hard to believe that would be an issue but you never know.  Can you check your ArcGIS Server log to see if there are any errors that might point to an issue?  Can you also check your Windows Event Viewer for problems right after the machine boots up? ... View more

Great, thanks for providing the file.  Give me a short bit of time and I'll reply with a 10.1 solution for you.  I'm going to assume that all of your source files follow this format, too. ... View more

Please confirm that you are using SQL Server and, if so, the version of the RDBMS software.  Is �??basemap�?� the name of your DATABASE within your SQL Server instance? Is �??SUFFOLKGIS" the name of the SCHEMA within your database? Is �??COGO_Linework�?� a valid feature class within ArcSDE?  Which user account are you logged in with while attempting to add Global IDs?  Check the permissions of that user account within the basemap database itself.  Which roles are assigned to it?  Do you see any roles checked that might point to a denial of privileges, such as db_denydatareader?  It is possible that the user account being used in your connection string doesn�??t have the right permissions to perform this type of operation.  Can that account at least see the features within the feature class during a Preview in ArcCatalog?  Try assigning the db_owner role to that user account and then try to add Global IDs again.  Otherwise, try connecting with the SDE or DBO account to do this and see if that works. ... View more

Which version of ArcGIS are you using?  If you're using 10.1 or higher, you can leverage the SetLogHistory function in arcpy to turn on logging for your GP tools.  As such, you'd do something like this: import arcpy arcpy.SetLogHistory(True) This will create a History Log File of the Results window and the parameters passed for each GP tool.  The file will be an XML file named with a timestamp and typically stored at C:\Users\<user name>\AppData\(Local or LocalLow or Roaming)\ESRI\Desktop10.1\ArcToolbox\History (if Windows 7 is being used).  The Esri online help for the 10.1 function is here: http://resources.arcgis.com/en/help/main/10.1/index.html#//018v00000087000000 This method is much more of a verbose type of logging.  If you want your own custom logging (i.e., messages that you insert into your Python script to be displayed when a certain point in the script is reached) then you'd want to use something like arcpy.AddMessage.  There are several other types of messaging and error handling functions beside AddMessage, and they can be found here: http://resources.arcgis.com/en/help/main/10.1/index.html#/AddMessage/018v00000007000000/ You can output these types of messages to the Python window using the AddMessage function, or you can output them directly to a text file (i.e., your own custom log file) during the script using a non-arcpy method like this: f = open('outputlog', 'a') parseLines = f.readlines() f.write('The process failed due to this custom error.\n') f.close() In either case, you can email the custom log file or the XML History Log File using the smtplib module in Python.  Here's an example: # import the modules from email.MIMEMultipart import MIMEMultipart from email.MIMEText import MIMEText from email.MIMEImage import MIMEImage import smtplib # prepare the message and attachment msg = MIMEMultipart() msg.attach(MIMEText(file("CustomLogFile.txt").read())) msg.attach(MIMEText(file("HistoryLogFile.xml").read())) msg.attach(MIMEImage(file("image.png").read())) # your email SMTP server connection information mailer = smtplib.SMTP() mailer.connect() mailer.sendmail(from_, to, msg.as_string()) mailer.close() ... View more

That error indicates something related to state lineages.  You object class in SQL Server is versioned, and the particular state ID (43899) being referenced in the error is no longer valid.  Have you performed a reconcile/post followed by a Compress lately?  If not, I would recommend doing that and then trying what you're doing again.  If that doesn't solve the issue, you'll need to consider using SDE command line to identify the problem.  This is first done by diagnosing issues with the state lineages using the command line: SDEGDBREPAIR -O DIAGNOSE_TABLES -V ALL (refer to the Esri online help for the rest of the parameters required) SDEGDBREPAIR -O DIAGNOSE_METADATA -V ALL (refer to the Esri online help for the rest of the parameters required) If issues are returned by these commands, you'll want to run the following commands to address the issue(s): SDEGDBREPAIR -O REPAIR_TABLES -V ALL (refer to the Esri online help for the rest of the parameters required) SDEGDBREPAIR -O REPAIR_METADATA -V ALL (refer to the Esri online help for the rest of the parameters required) Before doing this, please make a backup of your SQL Server database. ... View more

How taxed is your server when you're generating the cache?  Is CPU and RAM maxed out or is the server still generally healthy?  How's your disk space; is there enough storage capacity for the anticipated tiles?  When you say that sometimes it works and sometimes it doesn't, for the times where it doesn't work are you certain that the previous attempt to create the cache tiles has been completely terminated?  There may still be ArcSOC processes running on your machine that have not been released properly, thus preventing subsequent cache processes to never complete or start properly.  Between cache creation attempts, try restarting the ArcGIS Server service or SOM first. ... View more

Once the feature classes get created correctly in Oracle, why not extract the DDL for the indexes, drop them, and re-create them after modifying them with the desired names?  It's not an ideal workflow, perhaps due to the number of indexes involved but you could do it technically.  This can be done via SQL Plus if you don't have a nicer tool like DBArtisan or TOAD: SELECT dbms_metadata.get_ddl('INDEX', 'IDX_NAME', 'SCHEMA') FROM dual; DBMS_METADATA.GET_DDL('INDEX','IDX_NAME','SCHEMA'); What is the reason why you absolutely have to retain the exact same index names from your Diagrammer XML file when importing it into Oracle? ... View more