Latest Contributions by WilliamCraft

If there is already a valid license stored in the geodatabase prior to  upgrading (Upgrade Geodatabase tool), you will not need to re-authorize your geodatabase.  If the license has expired, you will be prompted to navigate to a valid license file (in your case, a 10.1 or 10.2.x file).  Source (scroll down to Upgrading Existing Geodatabases): http://blogs.esri.com/esri/supportcenter/2012/08/09/how-to-get-an-authorization-file-or-keycodes-file-for-the-new-create-enterprise-geodatabase-tool-at-10-1/ ... View more

If there is only one connection at a time, then I have no idea why you'd be getting that error no matter how your log files are configured.  Vince is right... you need to contact Esri technical support to sort this out.  Sorry I couldn't be of assistance. ... View more

The session ids should be different between logins, so this error should not be possible. There is some characteristic of your install which is causing this error to recur.  I suggest you contact Tech Support, so they can try to discover the root problem. - V Vince, what I'm saying is that Shared log files are shared by all sessions that connect as the same user which might very well be the case here.  If you have multiple users connecting with the same user account, all those sessions insert records into the same log file data table.  The session IDs being different wouldn't matter, I don't think, because it's irrespective of session ID.  For Session-based log files, these are dedicated to a single session and that is where the session ID comes into play.  I think he is currently set up with Shared log files and the connections to his feature service all use the SDE account.  I might be misunderstanding you altogether, but I think if he switches to Session-based log files then this error would go away. ... View more

I think what is happening is that there are multiple connections to your service using the same database user account, and each of those sessions (connections) are trying to select some of the same records and insert them into the same logfile tables.  What you need to do is change your ArcSDE configuration to utilize session-based Logfiles.  My guess is that you are using the Shared logfile configuration, which is the default for Postgres databases.  Session-based logfiles are dedicated to a single session (rather than a specific user account) and may contain multiple selection sets (log files).  Each session that logs in requires a set of tables for selections.  You should use session-based log files if you have numerous concurrent connections being made to the geodatabase with the same login / user account.  You'll likely want non-pooled session-based logfiles, to be more specific.  The following links describe the various ways of configuring how logfiles are handled in ArcSDE (e.g., Shared vs. Session-Based vs. Stand-Alone): help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Log_file_table_configuration_options_for_geodatabases_in_PostgreSQL/002p0000001q000000/ http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Log_file_tables/002p00000081000000/ ... View more

Thanks for getting back to me.  I am using a PostgreSQL 9.0 database.  It was an EnterpriseDB install on a linux machine.  Will these same steps work, just changing the SQL syntax possibly? I had modified my comments above right before you posted this comment.  But, after some further review, I believe I was slightly off course with regard to the global temp tables in Postgres.  In Postgres, all temp tables will be accessible only to that session and will be deleted when that session is closed. You can have the GLOBAL in the CREATE TABLE statement as I described above but it will be ignored by the database.  Postgres requires each session to issue its own CREATE TEMPORARY TABLE command for each temporary table to be used, thus creating the temp table "on the fly" rather than ahead of time.  I apologize for mentioning the long-term solution above since it likely won't work for Postgres.  That being said, you can go with the short-term solution I mentioned above for truncating the tables (which Vince also seems to suggest) and see if that fixes your problem. ... View more

Greetings, I am running ArcGIS Server 10 on Linux using PostgreSQL 9.0.  Every time I try and update a feature service I get an error in ArcGIS Server that only says "A database error occurred.".  I looked at the PostgreSQL log files and found the following log entry: ERROR: duplicate key value violates unique constraint "sde_logfile_data_pk" DETAIL: Key (logfile_data_id, sde_row_id)=(23432, 686) already exists. STATEMENT: INSERT INTO sde.sde_logfile_data (logfile_data_id,sde_row_id) VALUES (23432, $1) These 3 lines show up numerous times and I am not sure how to fix this.  The feature service was running fine for a while, as there are over 1000 features currently in the database.  So I know things were OK for a while.  Thanks, Mark It looks like something got hosed up with your SDE_LOGFILE_DATA table, which is one of the tables involved when you make a selection of 1,000 or more features using a geodatabase connection.  While not necessarily common of an error, I can't say that I'm surprised because I've seen issues before with the cleanup of rows in that table by ArcSDE.  In my mind, there is a short-term fix and a long-term fix to this issue.  I know you're using Postgres, but I'm not as familiar with that RDBMS so I'm going to provide an Oracle-based solution.  The short-term fix is to truncate both the SDE_LOGFILE_DATA and the SDE_LOGFILES tables and start over with your session: TRUNCATE TABLE SDE.SDE_LOGFILES; TRUNCATE TABLE SDE.SDE_LOGFILE_DATA; The long-term fix is to drop those tables altogether and re-create them as Global Temporary tables (or the equivalent in Postgres): DROP TABLE SDE.SDE_LOGFILE_DATA CASCADE CONSTRAINTS; DROP TABLE SDE.SDE_LOGFILES CASCADE CONSTRAINTS; CREATE GLOBAL TEMPORARY TABLE SDE.SDE_LOGFILE_DATA    (     logfile_data_id NUMBER(*,0) NOT NULL ENABLE,     sde_row_id NUMBER(*,0) NOT NULL ENABLE    ) ON COMMIT PRESERVE ROWS / CREATE INDEX SDE.SDE_LOGFILE_DATA_IDX1     ON SDE.SDE_LOGFILE_DATA(LOGFILE_DATA_ID,SDE_ROW_ID) / CREATE INDEX SDE.SDE_LOGFILE_DATA_IDX2     ON SDE.SDE_LOGFILE_DATA(SDE_ROW_ID) / GRANT DELETE ON SDE.SDE_LOGFILE_DATA TO SDE / CREATE GLOBAL TEMPORARY TABLE SDE.SDE_LOGFILES   (     logfile_name VARCHAR2(256) NOT NULL ENABLE,     logfile_id NUMBER(*,0) NOT NULL ENABLE,     logfile_data_id NUMBER(*,0) NOT NULL ENABLE,     registration_id NUMBER(*,0) NOT NULL ENABLE,     flags NUMBER(*,0) NOT NULL ENABLE,     session_tag NUMBER(*,0) NOT NULL ENABLE,     logfile_data_db VARCHAR2(32),     logfile_data_owner VARCHAR2(32),     logfile_data_table VARCHAR2(98),     column_name NVARCHAR2(32)    ) ON COMMIT PRESERVE ROWS / CREATE UNIQUE INDEX SDE.SDE_LOGFILES_PK     ON SDE.SDE_LOGFILES(LOGFILE_ID) / CREATE UNIQUE INDEX SDE.SDE_LOGFILS_UK     ON SDE.SDE_LOGFILES(LOGFILE_NAME) / CREATE UNIQUE INDEX SDE.SDE_LOGFILES_UK2     ON SDE.SDE_LOGFILES(LOGFILE_DATA_ID) / GRANT DELETE ON SDE.SDE_LOGFILES TO SDE / Oracle Global Temporary tables, by definition, will truncate themselves when the user disconnects its session.  I believe there may be an equivalent type of table Postgres. ... View more

Is the data stored in Oracle, SQL Server, or some other data store?  From where are you issuing this query?  In the Select By Attribute dialog box of ArcMap, a database management tool, or somewhere else?  You might have better luck using a Query Layer depending on your requirements.  Here are a few potential ways that I can think of: -- Queries which can be issued from an database management tool or from a Query Layer in ArcMap: SELECT   FIELD_ID,   MAX(OBSERVATION_DATE) FROM TABLE GROUP BY FIELD_ID, OBSERVATION_DATE; SELECT * FROM   (SELECT * FROM TABLE ORDER BY OBSERVATION_DATE DESC ) table1 GROUP BY FIELD_ID '; -- Query Expression which may work from the Select By Attribute dialog box or in a Layer Definition within ArcMap: [FIELD_ID],[OBSERVATION_ID] IN (SELECT [FIELD_ID],[OBSERVATION_ID] FROM TABLE AS table1 GROUP BY [FIELD_ID] HAVING COUNT([FIELD_ID]) > 1) note: the brackets above may need to change to double quotes ... View more

I would call Esri technical support to see which link is correct for the 10.2.1 web adaptor regarding use with 2003 R1 or R2, but I don't believe that is a supported configuration.  In fact, I don't think the web adaptor OR ArcGIS for Server is supported for any 2003 OS since it's not listed among the other operating systems; I think it's simply too old.  That's the reason I think the link I provided is correct.  Even Microsoft is discontinuing support for 2003 (R1 or R2) in mid-2015.  As I already pointed out (which Janie repeated), 64-bit OS is required for ArcGIS for Sever now.  Remember to up vote helpful answers and to mark the correct answer with the green check. ... View more

I'm not sure I understand what the true question is from the statement above.  If you want to show either polygons or points for a set of map features depending on the scale, then I believe there are two ways to achieve this.  The first way is the one you touched on, which essentially involves having two layers referencing a polygon and a point feature class which turn on and off based on scale.  It involves two layers and two underlying feature classes.  While you could group them into a Group Layer so they appear as a single layer, ultimately you would still have multiple layer IDs within your map service.  The second way involves the use of Cartographic Representation, which involves one layer and one feature class.  In the case of cartographic representation, you could just add and publish your polygon feature class as part of the map document but symbolize your polygon features with points based on the scale.  The advantage here is that you don't have to maintain two feature classes of the same data.  Cartographic Representation allows you to customize the appearance of features by storing symbol information with the feature geometry inside feature classes.  These representations are a property of a feature class that are stored in system tables inside the geodatabase and in the feature class itself. ... View more

I have installed the ArcGIS Server 10.2.1 on Windows 7 without problem. Next I tried install the web adaptor 10.2.1 on windows server 2003 R2 SP2 32 bits You are working your way into an unsupported (and likely incompatible) configuration.  Windows Server 2003 (R1 or R2) is not a supported operating system for the 10.2.1 Web Adaptor.  Also, keep in mind that ArcGIS Server requires a 64-bit operating system; 32-bit operating systems are not supported.  Maybe your Win 7 OS is a 64-bit, which works I think, but just in case it's 32-bit I wanted to remind you of this.  Sources: http://resources.arcgis.com/en/help/main/10.2/index.html#//017s00000047000000 http://resources.arcgis.com/en/help/system-requirements/10.2/index.html#//015100000072000000 I suggest that you install AGS and the Web Adaptor in an environment that meets the system requirements before attempting to troubleshoot the issues you described. ... View more

So are you saying that you have changed the security settings for users and roles such that users now utilize Windows AD and roles come from the built-in store?  Also, are you wanting to enable SSL or disable it?  None of this is abundantly clear when I read your original post, so it's difficult to understand what you're actually trying to achieve.  I think you might be trying to use Windows AD for users and the built-in store for roles, all with SSL enabled.  What does your Admin Directory say for the user and role stores under Security > Config?  The error you're getting seems to point to an issue with SSL specifically.  If you want to use SSL, you need to enable it in IIS and ArcGIS for Server.  I noticed that you said IIS was 'false' despite the fact that a self-signed certificate is being used, but I'm not sure what you mean by that.  If you have a certificate binded to the website using port 443, then SSL is already enabled in IIS.  Let's take a few steps to verify certain required settings are configured for SSL with the web adaptor using Windows Active Directory for users and the built-in store for roles.  Ensure that Windows authentication is enabled and everything else is disabled in IIS under the Authentication section at the web adaptor level.  Then, enable SSL in ArcGIS for Server following the steps at the link below.  I suspect that steps 3 and 5 from the link below may be the most critical in resolving this issue: http://resources.arcgis.com/en/help/main/10.2/index.html#//015400000600000000 There are also similar threads with some good detail here and here.  Let me know if these instructions help you to resolve your error. ... View more

For the broken layers, try re-pathing them to their original source by right clicking the layer, opening the Properties, going to the Source tab, and setting the data source.  If this is not successful for whatever reason, try disabling Spybot and then re-opening and re-pathing the map document thereafter.  Based on your description of the behavior, it sounds like Spybot could have cleaned up something needed by the map document in order to connect to the layer data sources it needs but honestly doubt it.  Do you have another computer with ArcGIS Desktop where you could try opening the same map document in order to see if the external services you mentioned break or don't break?  Based on the fact that you said yours was working after running Spybot, the problem may not be Spybot at all... in fact, the user who reported this issue to you could simply have lost his internet connection which might explain why external links don't work.  Can you access the REST URL for the external services via a browser from his computer? ... View more

That is strange.  Are you creating a file or personal geodatabase using this method?  Try re-starting ArcGIS Desktop once the geodatabase is created; then re-check the properties. ... View more

Glad I could help!  I'm not with Esri though... just an average user like many others 🙂  The GIS Services setup program is one of two that comprise ArcGIS Server for the Microsoft .NET Framework, and it includes the Server Object Manager (SOM) and the Server Object Container (SOC), among other things.  These are required to publish services, so the answer is "yes, it is essential".  It sounds like, after installing the NetFx3ServerFeatures feature, you were able to install the NetFX3 feature without issue and that ArcGIS Server now installs just fine since .NET 3.5 is present.  It would be awesome if you could mark the correct answer with the green check. ... View more