Latest Contributions by AlexanderBrown5

John,  Are you running the code snippet directly in the Python window in ArcMap or as a stand a lone script?  You are going to need the full path to the dissBuffs_lyr if you are not running it in the ArcMap python window. You can try this as well (Only if your field is an integer): arcpy.SelectLayerByAttribute_management("dissBuffs_lyr", "NEW_SELECTION", "sumPoint_2 > 2") ‍‍‍ If you are running it in ArcMap (can you paste the additional messages shown below the console window).   Example: ERROR 000358: Invalid expression An invalid SQL statement was used. An invalid SQL statement was used. [dissBuffs_lyr] An invalid SQL statement was used. [SELECT OBJECTID FROM dissBuffs_lyr WHERE 'sumPoint_2' > 2] Failed to execute (SelectLayerByAttribute). Failed at Mon Sep 12 11:31:55 2016 (Elapsed Time: 0.01 seconds‍‍‍‍‍‍‍‍‍‍‍‍ ~Alex ... View more

John, Try this: arcpy.SelectLayerByAttribute_management("dissBuffs_lyr", "NEW_SELECTION", '"sumPoint_2" > 1')‍ Since you are trying to select from a file geodatabase and not a full RDMS, you cannot put the field name in brackets.  They need to be in quotes. ~Alex ... View more

Meengla, As Mark Bramer points out in this post: New GeoEvent Setup  "GeoEvent clustering has not worked out like we hoped and we no longer recommend using it.  If you have a throughput rate greater than what can be handled by a single real-time server, it is certainly possible to set up multiple real-time servers to handle throughput, but you need to really think about things like how to split up your incoming messages, how to handle any stateful scenarios like 'enter' or 'exit' geofence operations or monitoring ongoing incidents, and how to handle event outputs appropriately (i.e. can you afford outputting messages in a non-chronological order?  ...not necessarily an issue if they're time-stamped)?" We recommend to stand up a dedicated ArcGIS Server box with GeoEvent for real-time deployments.  We don't recommend attaching GeoEvent to part of an ArcGIS Server cluster. ~Alex ... View more

Dev, You can set mixed protocol (http/https) or https only. ~Alex ... View more

Dev, You must have ArcGIS Server configured for https protocol.  There are various options, whether that is utilizing a self signed certificate, domain certificate, or a CA certificate.   Configuring HTTPS using an existing certificate—Documentation (10.4) | ArcGIS for Server  Configuring HTTPS using a new CA-signed certificate—Documentation (10.4) | ArcGIS for Server  Configuring HTTPS using a self-signed certificate—Documentation (10.4) | ArcGIS for Server  Optional: Replacing the ArcGIS GeoEvent Extension for Server self-signed certificate—Installation Guides (10.4.1) | A…  Optional: Marking the self-signed ArcGIS GeoEvent Extension for Server certificate as trusted by Internet Explorer—Insta…  You must go to http://gisserver.domain.com:6443/arcgis/admin and switch security to http and https or https only for your ArcGIS Server site.  For example, if you create a domain certificate in IIS, you can then import that into ArcGIS Server and GeoEvent.   Read over the documentation above and it should point you in the right direction.  ~Alex ... View more

Kelvin, Are you reinstalling ArcGIS Desktop only, or are there additional products?  If Desktop only, single use licensing? Can you provide a little more detail? ~Alex ... View more

Mark, As George indicated, most of your data is not versioned.  It will not impact performance if you only have one or two feature classes registered as versioned; unless you have an enormous number of edits.  If you are only doing dozens of edits per week for each feature class, it should not be difficult to reconcile, post, delete versions, and compress weekly.   After doing your reconcile/post and deleting all versions after Default, I would suggest utilizing the ArcPy commands to complete your process.  In simple form: import arcpy import time from arcpy import env # Set the workspace workspace = r'Database Connections\SDE_CONNECTION_TO_DATABASE.sde' env.workspace = workspace database_name = str(workspace.split('\\')[1]) # Block new connections to the database. try:     print 'Blocking connections in %s' % database_name     arcpy.AcceptConnections(workspace, False) except (arcpy.ExecuteError, arcpy.ExecuteWarning) as e:     print e # wait 120 seconds time.sleep(120) # Disconnect all users from the database. try:     print 'Disconnecting all users from %s...' % database_name     arcpy.DisconnectUser(workspace, "ALL") except (arcpy.ExecuteError, arcpy.ExecuteWarning) as e:     print e # Run the compress tool. try:     print 'Compressing database...'     arcpy.Compress_management(workspace) except (arcpy.ExecuteError, arcpy.ExecuteWarning) as e:     print e # Allow the database to begin accepting connections again try:     print 'Accepting Connections from %s...' % database_name     arcpy.AcceptConnections(workspace, True) except (arcpy.ExecuteError, arcpy.ExecuteWarning) as e:     print e‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ AcceptConnections—Help | ArcGIS for Desktop  DisconnectUser—Help | ArcGIS for Desktop  ListUsers—Help | ArcGIS for Desktop  You can of course also script your reconcile and post, but many organizations like to go through that process manually to verify/determine any conflicts. In short, a few versioned feature classes will not adversely affect your databases performance; I would advise against creating a user schema geodatabase for this use case. ~Alex ... View more

Drew, Have you also upgraded your GeoEvent extension to 10.4.1 as well?  Are your data stores validated properly after your upgrade? ~Alex ... View more

Marcin, That clarifies things.   Exactly, your feature service is created automatically when you checked "Keep Latest"; I wanted to understand if you were referencing another feature layer that you created prior or not.  You have your own enterprise database if you utilized "Create Enterprise Geodatabase" tool.  In this case, you do not need ArcGIS Data Store. Also, you do not need Portal for ArcGIS and ArcGIS Data Store to have feature service archiving from a Stream Service (especially for tutorials/testing).  However, we typically recommend larger scaled configurations of ArcGIS Server, Portal for ArcGIS, and Spatiotemporal Big Data Store for Production utilization of GeoEvent.   I would go into ArcGIS Server Manager and delete your stream services/feature services and go back a few steps. Try again and let me know if you experience the same issue. Alex ... View more

Mark, Okay that clarifies things, I thought it was referring to your fail over but wanted to make sure.   I suggest for future upgrades: 1. Update your TNSNAMES.ora to something simpler, directly against your production database.  Since you have DataGuard, once you upgrade your production database, the upgrade will push to your DataGuard on your next scheduled backup.  I would double check with your Oracle DBA for exact methodology, could be different than how Philadelphia utilized DataGuard. RMCDB =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = TCP)(HOST = rmcdb1.dpipwe.tas.gov.au)(PORT = 1521))      (CONNECT_DATA =        (SERVER = DEDICATED)        (SERVICE_NAME = rmcdb.dpipwe.tas.gov.au)      )    )   )‍‍‍‍‍‍‍‍‍ ‍‍‍‍‍‍‍‍‍ 2. Create a new ArcCatalog connection utilizing just: 3. Attempt your upgraded Just for clarification, when you said: "Fixing the tnsnames.ora file, and creating a new ArcMap database connection - and it worked."  indicating the upgrade did work for you, right? ~Alex ... View more

Mark, I have experienced this type of problem before.  The solution here at the end of this post helped me upgrade from 10.1 SDE to 10.3.1 when I worked at the City of Philadelphia. Problem in Upgrading Geodatabase from 9.3.1 to 10.2  If it is possible, I would simplify your TNS alias to one word: RMCDB =    (DESCRIPTION =      (LOAD_BALANCE = off)      (ADDRESS = (PROTOCOL = TCP)(HOST = rmcdb1.dpipwe.tas.gov.au)(PORT = 1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = rmcdb2.dpipwe.tas.gov.au)(PORT = 1521))      (CONNECT_DATA =        (SERVER = DEDICATED)        (SERVICE_NAME = rmcdb.dpipwe.tas.gov.au)      )    )   ) This wouldn't affect your databases, but it would make it easier to connect: Also, is your database on both servers?  I see you have two addresses in your TNS names file.  Do you have two databases (production/staging), does the second refer to a fail over? I would connect using the instructions from the link above.  If possible limit the TNS connection to your production database server only. Let me know if this helps. ~Alex ... View more

Marcin, Can you provide a little more detail?  Did you publish a feature layer prior to the publishing of your stream service or during the publishing of the stream service.  For example, in the screenshot below did you enter a URL under 'advanced' or just publish.   Also, when you refer to PostgreSQL managed database are you referring to the ArcGIS Data Store?   ~Alex ... View more

Awesome! Glad it worked for you. ~Alex ... View more