Latest Contributions by EricMahaffey1

Craig, Did you ever resolve this?  I'm having the same issue.  WinServer 2019 w/ArcGIS Server 10.8.1.  The second server won't join the existing site and getting the "..../arcgis/admin' is not accessible" error ... View more

James, You're an absolute lifesaver!  The try except statement allows me to see what records are having an issue, and it allows the process to continue through the errors.  As suspected, it's pretty much being caused by one value that has an extra comma in it which throws the whole thing off.  Fortunately I'm able to omit this value due to only needing to use the majority of the data in each table.  Now I can move on and process all the other tables that I have to do.  Again, I can't you enough! ~Eric   ... View more

Joshua, I believe you're right.  This data has been nothing but problems.  I managed to force it by adding the usecols paramater within the prd.read_csv function.  Then I started having "bad value" errors.  So I converted all of my target fields to text with a large width just the data to go in.  This worked.   However, when I changed a couple of columns (i.e. LAT and LONG) back to Double type fields it caused a "RuntimeError: The value type is incompatible with the field type error". I can't seem to catch a break. ... View more

James, Thank you so much for the quick response.  I've integrated your solution into my script, and I'm getting an error "CParserError: Error tokenizing data. C error: Expected 22 fields in line 68, saw 23".  I believe it's because the CSV file does not have an OBJECTID field.  How do I tell the InsertCursor function to either skip the first field, or identify the specific fields to insert to? ~Eric ... View more

Looks like this is still an issue at version 10.5.  Not sure if it's been fixed at any version higher.  Thanks to Fred Spataro for catching it, and sharing the resolution. ... View more

Update: I was able to get it to work.  Although I'm not sure why. Follow the same workflow as I stated above. RDP into the server running ArcGIS Server Copy the SD file to that server Launch ArcGIS Server Manager through the RDP session Publish the SD file that was copied locally.  Success! In my case I have one ArcGIS Server environment that is on the same domain as my client (this is our Development architecture).  We have a Test environment on a separate network that is accessible only by using a Citrix web portal which provides RDP access.  Our Production environment is accessed by a VPN and provides RDP as well.  So basically this allows us to move files onto the server, and the ability to run AGS Manager in a local browser on the server.  I have a case started in with Esri Support (#02092400 Help publishing an SD file to an disconnected environment).  I'll post any solutions when they are resolved. ... View more

Haha.  Yeah I'm a child of the 70's so I remember those commercials.  In my case I have to be able to fool Mother Nature (a.k.a. ArcGIS Server).  There has to be a work flow for developing map configuration files using a database connection, and transferring them over to multiple environments (i.e. Development, Test, Production).  I'm sure there is something small that I'm missing I just can't figure out what it is. ... View more

Vince, I finally got a chance to create the SDE file using Python.  I decided to test the workflow on an instance of ArcGIS Server that is reachable from my client ArcGIS Desktop.  So I'm able to create the SDE file, and use it to register the database.  It validates, so I'm assuming all is well.  I've also configured the host file on both my client running ArcGIS Desktop, and the server running ArcGIS Server to use the same reference to the database server.  In this case the IP addresses are the same, and the server name declared in the host file is the same as well.  I'm trying to use the host file to trick ArcGIS Server once I move the SDE, and SD file over to the disconnected network (different IP address, but same server name).  From ArcGIS Desktop I've made my database connection using the server name, loaded one layer (SQL Server view with geometry data type), and have generated and SD file choosing "No Available Connection" for the ArcGIS Server connection.  The file generates, however, when I try to publish it through ArcGIS Server Manager, it fails with this message, "The contents of the selected service definition file is invalid.  Please contact the author of the file."  The ArcGIS Server logs don't really tell me anything, nor do the OS event logs.  The odd thing is I can publish the SD file in ArcCatalog to the same ArcGIS Server connection.  It just won't publish through the ArcGIS Server Manager browser app.  Any thoughts? ... View more

Thanks Vince.  I'll see if I can generate the connection file using Python. ... View more

Not sure if anyone will see this response, but I'm having similar difficulties as Chris.  I'm trying to register a database connection within ArcGIS Server that is on a different domain than my client (with no trusted bridge).  I can make an admin GIS Server connection from ArcGIS Desktop on my client.  When I then try to register a database connection, I enter the connection information to my "Publisher Database" (on same domain as my client), and that succeeds, however when I try to enter the "Server Database" connection information it fails.  ArcGIS Desktop on my client is trying to validate the connection to a server that it can't see.  Knowing this would be a likely issue, why can we not manually type the connection information in.  That way we can create the .SDE file that's needed to import the connection within ArcGIS Server Manager.  Within the AGS Manager web page, there is only an option to import a connection to the database your trying to register.  If your server environment does not have ArcGIS Desktop, you cannot create a valid file to import.  Can anyone shed some light on this, and help me out? ... View more

Thanks Tina.  We ended up using the same solution that you mentioned.  We created a series of DB Views to get around the field type issue with joining.  Once that was done, it didn't matter how ArcMap perceived the field types. ... View more

I'm glad you were able to reproduce what I'm experiencing, and I'm also glad to hear (as you mentioned below) that the issue seems to be resolved above v10.5.1.  Answers to your questions: I was hoping to only have to add spatial tables from SQL Server as layers within ArcMap and then join any additional tables by connecting to them within the database rather than adding them as a data source within ArcMap.  It keeps things cleaner and more light weight. Thanks for your help in all of this. ... View more

You are correct.  This is not a Esri geodatabase, it is a SQL Server database using the geometry data type. I wish I could share some screen shots of what I'm seeing, but unfortunately content sensitivity will not allow it.  I think if you follow these steps, you'll see what I'm talking about. Add a table from SQL Server that has geometry within it (as well as a GUID field) to ArcMap Right click on the layer you just added>Joins and Relates>Join Choose the GUID field for this input layer For table to join to, navigate to another table with the same database that has a GUID that you'd like to join to Choose a GUID field to base the join on You should see that the GUID fields are not listed as an option to choose from in the drop down.  Only Text fields show up as options. Now try the same join except this time add the table directly to Arcmap so that it's listed in the table of contents.  Add a table from SQL Server that has geometry within it (as well as a GUID field) to ArcMap Add another table to ArcMap that has a GUID field Right click on the layer you just added>Joins and Relates>Join Choose the GUID field for this input layer For table to join to, select the table from step 2 in the drop down Choose a GUID field to base the join on You should see the GUID field/s as an option to choose from I'm hoping this workflow makes sense and that you can repeat it on your end.  If not let me know. ... View more