Latest Contributions by WilliamCraft

And on line 15 it switches from 'Database Connections\GISAdmin@SBMPERDBS003.sde' to 'Database Connections\SDE@SBMPERDBS003.sde' The "Database Connections" part of the path that you are seeing is normal behavior.  This is Esri's way to abbreviating the default location where SDE connection files are stored on the machine when creating them under Database Connections in ArcCatalog or ArcMap.  So, "Database Connections\..." really refers to the user profile directory.  For example in Windows 7 or Windows Server 2008 R2, C:\Users\userID\AppData\Roaming\ESRI\ArcCatalog\SDE@SBMPERDBS003.sde ...would be represented by Esri software as... Database Connections\SDE@SBMPERDBS003.sde ... View more

Quite similar to what Jake proposed, you may be able to grab the bounding box of the dataframe's extent this way: map_document = arcpy.mapping.MapDocument("current") dataframe = arcpy.mapping.ListDataFrames(map_document, map_document.activeView)[0] extent = dataframe.extent You can then pass the extent's bounding box as parameters to the next geoprocessing tool in your Python script. ... View more

You need to verify which transactional version to which you are connecting when making edits using the tools you mention as well as when editing via ArcGIS Desktop.  You may be seeing edits appear in the base tables because you're editing SDE.DEFAULT directly, which is bad practice in any editing environment.  Regarding what you said for a scheduled compress operation, yes I agree that you should run a compress regularly.  Create a batch file that does this and emails you the current state ID from before and after the compress so that you know what is going on with your geodatabase each day/week depending on your compress frequency. ... View more

Just out of curiosity, are you using HTTPS or HTTP when configuring everything and making request?  From one of your previous posts, I see that you say these are your URLs: http://mycity.houstontx.gov/ArcGIS10...s_dd/MapServer --> (this URL is for external use) http://10.1.4.206/ArcGIS10/rest/serv...s_dd/MapServer --> (this URL is for internal use) However, you also later mentioned that you captured HTTPS traffic.  That leads me to ask how you have configured Portal and ArcGIS for Server despite not federating them together.  My questions at this point are: 1. Within Portal under My Organization --> Edit Settings, do you have the box checked to only use SSL?  2. Within the Administrator Directory of ArcGIS for Server, under the Security section have you specified HTTP Only, HTTPS Only, or HTTP and HTTPS?  Additionally, under the Machines section have you imported the same security certificate and specified it for your AGS machine (if not using self-signed in IIS)?  3. Within IIS, do you have a security certificate bound to the website under which your web adaptor(s) exist?  Are you using a web adaptor for ArcGIS for Server whatsoever?  4. If you are using a CA-signed certificate (i.e., not self signed), does the NAME property for the certificate use the Fully-Qualified Name (FQN) of the host? On another note, are you running the ArcGIS for Server Windows Service as a local account or a domain account?  Does that account have full permissions on the 'arcgisserver' directories? ... View more

Can you provide a complete list of the fields and their data types for the particular table in question? ... View more

Typically, a -162 error occurs when an invalid database name has been supplied in the connection string.  The specified database name is either not recognized or does not exist on your server.  Can you be sure that the database name is spelled correctly and is valid for the server to which you are connecting?  Were you getting different behavior with the first database instance using the same type of connection string? ... View more

What you're describing is something we are considering, which as you probably know requires you to set all MXDs and other connection points to use the DNS entry rather than the primary server host name.  We have also discussed using a load balancer in active-passive mode and using its name in the same way as the use of the DNS entry I just described.  Are edits taking place on your primary?  If so, are edits expected to resume on the secondary or is read-only mode acceptable for the secondary?  If the answer to these is 'yes', you'll need to think heavily about the type of replication you want to achieve and the tools to do it.  RDBMS replication in SQL Server may work best over Esri replication if you have un-versioned data that needs to exist in both places.  Another possibility is hardware-based replication using SAN technology if your organization uses anything like that. ... View more

Does the URL you are inputting actually resolve correctly from the same client that is running Excel?  Please verify that is the case via your web browser.  Within IIS for the web adaptor, under Authentication is Windows Integrated Authentication set to 'enabled' and Anonymous Authentication set to 'disabled'?  Are you certain that your Windows AD account is set up within Portal to begin with?  To verify, go to Portal with either your initial administrator account or your own AD account and click on My Organization to see if your AD account got set up.  The AD accounts get added to Portal upon the first initial login request from an AD account.  Try EMO again to see if it works under these conditions. ... View more

Are you using the Portal web adaptor?  Are you certain that the URL you are inputting during installation and/or configuration of the tool is valid?  Try that exact link from the PC you are running Excel from to make sure that it resolves correctly.  I seem to remember that the URL for EMO should not be the home page URL for Portal or AGO.  For example, with Portal the typical home page URL via the web adaptor would be something like http://gisserver.domain.int/arcgis/home where 'arcgis' is the default name of the web adaptor but the URL you would configure for EMO during installation would be something like http://gisserver.domain.int/arcgis without the 'home' part of the URL. ... View more

I experienced the same behavior... to verify this even past what our IT department provided, I used JXplorer (a free tool which allows you to browse your internal LDAP / AD configuration) to see what the full name attribute is as opposed to the user ID.  Sure enough, it was what IT provided... but for whatever reason, altering the value in the properties file and restarting the Portal service does not change the behavior.  I could only ever get the ID to appear, not the full name attribute. ... View more

I know this may be a silly question, but have you made sure that your LDAP section in the properties file is NOT commented out and that the built-in section IS commented out before restarting the service?  If you've modified the domain user account password (either at the domain level or within the properties file itself), please reset the encrypted value to 'false' before restarting the service.  It will be automatically changed to 'true' and the password encrypted once the service starts back up. ... View more

So even through the web adaptor, where you are seeing this issue occur, it only happens 10 minutes out of every hour?  Is something running on the server once per hour for about 10 minutes?  Check your scheduled tasks to see if something is set to run regularly that may be consuming resources on your server (check both servers).  Also, take a look at the processes tab under Task Manager on both machines when the issue occurs... sort despondingly by the memory column so that you can try to isolate any particular process that may be bogging down the server(s).  Is it also possible that you antivirus software, if any, is running a full scan every hour? ... View more

Glad you got things working, no matter which step or set of steps made it happen!  The behavior you described seems odd, but then again I've seen other odd things happen in the Esri stack that seems to be corrected with a simple reboot or service restart.  You may want to consider reporting this behavior as a potential bug; I'm not sure if you are able to open a ticket but it may help others in the future who encounter something like this.  Also, welcome to the Esri forums... when posting in future threads, please remember to vote up helpful responses and mark answers as correct when applicable! ... View more

The same behavior occurs in 9.3.1, 10.0, and 10.2... that is, you cannot register a feature class as versioned within a feature dataset but not register the other feature classes within that same feature dataset.  If you only want to register a single feature class as versioned, you will need to consider moving it out of the feature dataset.  However, if you do that then the feature class can't participate in things like geometric networks, parcel fabrics, or topologies. As for the first part of your post, I'm not sure if this is your production database or how much data you have, but might it be possible to create new feature datasets and feature classes... then load those feature classes with the data from your existing feature classes?  Otherwise, it may be cleaner to simply create a new geodatabase entirely... although more time consuming. ... View more

I agree with Ravi; you'll need to run Fiddler to capture some traffic as a first step.  On another note, this sounds like it could be a browser issue, specifically a Javascript or extension problem when loading Portal.  Which browser and version are you using?  Is it possible for you to start your browser in safe mode or with extensions disabled and try to request the Portal site again? ... View more