Latest Contributions by George_Thompson

Hi Shannon, Can you provide a little more information on the error that you are receiving? -What version of RDBMS is being used? -Are you upgrading via ArcCatalog 10.3.1? -Can you provide a full error message (screenshot, etc..) to this post for review? -Can you also run the Pre-requisite check on the geodatabase before the upgrade and provide the results? Upgrade an enterprise geodatabase in SQL Server—Help | ArcGIS for Desktop Please make sure to review the above documentation before upgrading. The above information will be helpful for troubleshooting this issue. -George Geodatabase​ Managing Data​ Enterprise GIS​ ... View more

Jenn, Here is some of the documentation for making connections to SQL Server database from ArcGIS Pro; Database connections in ArcGIS Pro—ArcGIS Pro | ArcGIS for Desktop Set up a database connection—ArcGIS Pro | ArcGIS for Desktop I tested ArcGIS Pro 1.1 and was able to see data in a SQL Server database (non-geodatabase) and in a geodatabase at version 10.3.1. You may need to contact Esri Tech Support to look into the issue in more detail. Make sure that you are on a supported release of SQL Server for ArcGIS Pro (SQL Server 2012 or newer) Microsoft SQL Server database requirements for ArcGIS Pro 1.1—ArcGIS Pro | ArcGIS for Desktop Hope this help! -George Geodatabase​ Enterprise GIS​ ... View more

Do you have the TNS_ADMIN variable set to the new location? Here is the link for Server 10.1: ArcGIS Help 10.1 Can you open SQLPlus from the Oracle 64-bit client install (%ORACLE_HOME%\BIN folder) and then connect to the Oracle database as one of the users? This is an IMPORTANT testing step!!!!!! If you are using the 64-bit SQLPlus it is also have a sqlplus.exe running in the process list. If you see it with a *32 at the end then there is a client configuration issue. I would make sure that you can connect outside of the ArcGIS client first. You may have to open a support case with Esri Support to investigate in more detail. but it points more towards the Oracle client configuration for the 64-bit client used by ArcGIS for Server. Hope this helps! -George ... View more

Paul, The Oracle client would need to have access to the TNSNAMES.ora file. This is something that your IT and DBA team should be able to remedy. Are you using the full Oracle client or Instant Client? ... View more

Hi Paul, To add to what Josh mentioned, what type of Oracle 64-bit client was installed? Did you restart the ArcGIS Server service after installation of the Oracle client? This MUST be done for the Server service to re-read the PATH variable and use the Oracle client. -George Geodatabase​ Managing Data​ ... View more

I understand that it can be a daunting task, but if you do it manually and there is another table that needs to be updated at the same time and the update is not done it could corrupt everything. I think the safe move is to export/import the jobs or recreate them again. ArcGIS Help (10.2, 10.2.1, and 10.2.2) - Export WMX Jobs This may help speed up the process. -George ... View more

Hi Alison, I would recommend not editing any of the JTX_ repository tables!!!!! This could lead to corruption in which a correction is not possible. This is also an unsupported modification in which support may not be able to help if there are other issues down the road. In my experience it is better to let the ArcGIS WMX extension do those changes. Hope this helps -George ... View more

Sounds like you are not editing the correct version and the state. Make sure that you start the edit session pointing to the correct version. Here is the documentation for Oracle at 10.3, but all the other RDBMS versions are listed on this page also. Edit versioned data in Oracle using SQL—Help | ArcGIS for Desktop An overview of editing versioned data using SQL—Help | ArcGIS for Desktop Hope this helps -George ... View more

Hi Duncan, Here is a link for the support data types in ArcGIS Pro: Supported data types and items—ArcGIS Pro | ArcGIS for Desktop Hope this helps.... -George ... View more

Hi Terry, Can you provide a little more information related to the RDBMS being used? It looks like you are using Oracle but want to verify. Do you happen to have other map services registered with the SDE user that may be using the incorrect password? I am going to link to other groups with may help get more responses. Geodatabase​ Managing Data​ Enterprise GIS​ -George ... View more

Managing Data​ Enterprise GIS​ Python​ Geoprocessing​ ... View more

Here is a blog outlining the instructions for upgrading the database from SQL Server 2000 to SQL Server 2012. Migration SQL Server 2000 to SQL Server 2012 - Microsoft SQL Server - Site Home - TechNet Blogs Once the database is at SQL Server 2012, you could then make a connection in ArcCatalog and then upgrade the geodatabase to 10.3.1. -George ... View more

If you look at the error message it says..... "...revoke database owner from the SDE login..." I do not think it has anything to do with the password. -George ... View more