Latest Contributions by QuinnFrancis

Hi Rawan,  We'll need some additional information to better understand the factors that could potentially be affecting the performance you're witnessing. - What version of SQL Server are you using? - What is your ArcGIS Desktop/Enterprise geodatabase version(s)? - Is the client machine that you are making these edits on located on the same machine as the database server?  - What type of geometry are your feature classes stored in? - Is the performance issue strictly limited to editing operations? Is panning/zooming slow? GP tool performance? - Have you always witnessed latency or is this something that has recently occurred? - Have any architectural changes occurred recently? DBMS Upgrade? Moving data to a new server? - Are your feature classes registered as versioned? - How often do you run geodatabase maintenance? - Is performance only witnessed on this single feature class or is it database-wide? Regards, Quinn ... View more

Hi Saroj,  What version of SQL Server are you running? The ODBC Driver 11 for SQL Server provides support for connecting to Microsoft SQL Server 2005, 2008, 2008R2, 2012, and 2014.  I suggest that you check that the SQL Server Native Client is installed on the machine running PHP as well.  This is a requirement for using the SQLSRV extension in PHP. https://www.microsoft.com/en-us/download/details.aspx?id=36434    Download Microsoft® SQL Server® 2012 Feature Pack from Official Microsoft Download Center  PHP: Requirements - Manual  You'll need to download Version 4.0 of the Microsoft Drivers for PHP for SQL Server.  Version 4.0 supports PHP 7.0+. Download Microsoft Drivers for PHP for SQL Server from Official Microsoft Download Center  Quinn ... View more

Hi Yan, There is no way to delete the Oracle database via ArcCatalog or any other esri tools.  The database connection in ArcCatalog is merely an SDE connection file that is stored on the machine making the connection to the server machine.  In order to delete the database you will need to use Oracle tools to do so.  You can achieve this by running Database Configuration Assistant (DBCA) or by using the DROP DATABASE statement in an Oracle developer program (SQL Plus, SQL Developer, TOAD, etc.). DROP DATABASE  Quinn ... View more

From the screen capture it looks like you're putting the incorrect SQL Server instance name into the 'Instance' parameter of the tool. You'll need to put the fully qualified name (AHCEC-GIS-H\HASSASRVR) in order to access the SQL Server instance Quinn ... View more

Hi Sarah, You may have the command line tools installed on your machine already without you knowing.  Open up a command prompt and type in an ArcSDE command such as 'sdelayer' or 'sdemon'.  If information is returned regarding the command you typed in then you know the command line tools are installed.  Also, you can check the %SDEHOME%/bin directory on your machine to check if the tools are installed.  If the command tools are not installed, you can download them from the MyEsri site by navigating to My Organization > Downloads > ArcGIS for Server Enterprise > View Downloads.  Once installed, you'll want to run the 'sdetable -o create_view' command in a command prompt window. ArcSDE Administration Command Reference ... View more

Hi Nicola, SQL Server Express supports both Desktop and Workgroup geodatabases. Create a desktop or workgroup geodatabase—Database Server (Desktop) installation guide | ArcGIS for Desktop ... View more

The reason you are not being prompted for an authorization file in your third screenshot is because your SQL Server Express instance has already been authorized to store workgroup/personal geodatabases.  This authorization would have occurred when you ran the ArcSDE for Microsoft SQL Server Express installation wizard.  During this process you designate a SQL Server Express instance to use as a database server, a server administrator is added to the database server, a SQL Server Express instance is enabled to store geodatabases, and the software is authorized. ArcGIS Server Workgroup Microsoft SQL Server Express installation You create geodatabases on database servers in the Catalog window. Creating a geodatabase creates a new database on a SQL Server Express instance. ArcGIS Help (10.2, 10.2.1, and 10.2.2) As Asrujit SenGupta mentioned above, the 3 connection limit indicates that you may be using an ArcSDE Personal geodatabase rather than a Workgroup geodatabase. You can run a simple statement in a new query window in SQL Server Management Studio to find the contents of the SDE_server_config table. Check the AUTH_KEY parameter value. SELECT *   FROM [DatabaseName].[sde].[SDE_server_config] ... View more

Hi Linus, Were you able to resolve this issue? I have seen this occur when the version name and owner do not have the same syntax in the python script as in the Geodatabase Administrator window.  If the owner and name of the version in the Geodatabase Administrator window reads "dbo.DEFAULT" you will need to ensure that the same syntax is used in the script.  "DBO.DEFAULT" or "dbo.Default" would both fail and throw the warning message you are experiencing.  Both the version name and owner are case sensitive. There is also a bug that has been logged identifying an issue with reconciling using OS authenticated users. NIM084500 - Arcpy.ReconcileVersions_management() fails to reco.. Quinn ... View more

The link below provides some useful information on Oracle data types supported in ArcGIS Oracle data types supported in ArcGIS—Help | ArcGIS for Desktop ... View more

Here's a document that talks about this scenario: http://resources.arcgis.com/en/help/main/10.2/index.html#//006200000009000000   To summarize: - Reconcile/post and compress your edits - Unregister feature dataset as versioned - Create your topology - Register feature dataset as versioned. Be aware that unregistering features as versioned has the potential for data loss if edits still exist in the delta tables. 29160 - Compress a versioned database to state 0 ... View more

Try installing the SQL Server 2012 Native client from MyEsri or from the Microsoft website and test your connection again. Download Microsoft® SQL Server® 2012 Feature Pack from Official Microsoft Download Center ... View more

Which version of SQL Server are you using?  At ArcGIS Pro 1.1 the minimum supported version is SQL Server 2012 SP1.  What version of the native client do you have installed? Microsoft SQL Server database requirements for ArcGIS Pro 1.1—ArcGIS Pro | ArcGIS for Desktop ... View more

Hi David, You can change the data source of layers by right clicking on the layer in the Contents pane > Properties > Source tab > Change data source. Repair broken data links—ArcGIS Pro | ArcGIS for Professionals ... View more

Hi David, You'll need to delete the database on the RDBMS side (SQL Server).  DROP DATABASE should do the trick. DROP DATABASE databaseName; DROP DATABASE (Transact-SQL) ... View more