Latest Contributions by George_Thompson

Hi Hunter, Here is some code that you could use for the ArcPy operations that you are requesting. Using Python scripting to batch reconcile and post versions As for rebooting the machine, you may want to consult with the OS manual. Hope this will get you going in the right direction...... -George Geodatabase​ ... View more

To add on to what Vince said, this is from Help Documentation for 10.2.x for database authentication DB Authentication: 14. If the user requires a matching schema (for example, the user will own data in the geodatabase), type the schema name in the Default schema field. Remember, the user name and schema name must be the same if this user is going to own data. Adding database-authenticated logins to a SQL Server database Windows Authentication: 14. If you are adding an individual login rather than a group, and the user will own data in the geodatabase, type the schema name in the Default schema field. Remember, the user name and schema name must be the same. For Windows groups, a matching schema will be created for any group member the first time the user creates data in the geodatabase. The schema name will be the same as the login name, not the name of the group. This is done automatically; you do not have to create the schema ahead of time. Adding Windows-authenticated logins or groups to a SQL Server database Hope this helps clear up any confusion. -George Geodatabase​ Managing Data​ ... View more

Hi Mark, The only way to safely update the SERVER_CONFIG table value for the license is with the command line tools. You can install them up to the 10.2.2 release. There is a request for a GP tool to be created to update the license file post 10.3 release. Here is a blog that reviews how to update the license before it expires: Updating the license for ArcSDE enterprise geodatabases at 10.1 | Support Services Blog The two tools that you referenced are for creating/enabling the geodatabase functionality in a supported RDBMS. They do not update the license in an existing enterprise geodatabase. Hopefully this help! -George Managing Data​ Geodatabase​ ... View more

Hi Paul, Yes, you would need to have the 64-bit client for Pro. I have the 64-bit full client (for SQLPlus) and the 32-bit Instant client. I have not seen any issues with this configuration in using ArcGIS Pro and ArcGIS 10.2.x/10.3. The 64-bit is first in my path variable as I have ArcGIS Server installed on the same machine. Here is the link of the ArcGIS Pro connections to supported enterprise geodatabases One thing that I noticed in your post is that you are using the Oracle 11.1.0 full client. I would recommend that you use at least the full (admin) client that matches your database version (i.e. 11.2.0.1). I would test with the correct client version of the full clients and see if the crash behavior is present. If the crash still occurs, I would create a case with Esri Technical Support​ so we can investigate the crashing (this should not happen). I have been using the Instant clients for well over 18 months with no issues. As for Oracle recommending the full client install, I could see this as being beneficial as there is more functionality built into it than with the instant client, so no argument there. This really comes down to the preference of your organization and your DBA's. I look forward to the results of your testing with the newer 11.2.0.1 or newer client. -George Managing Data​ ArcGIS-Pro​ ... View more

Hi Randall, I think that we are going to need some more information in order to possibly help with this.... 1. What ArcGIS Desktop version is being used and license level (Basic, Standard or Advanced)? 2. What RDBMS is being used? (Oracle 11.2.0.3. SQL Server 2008, etc...) 3. What are the permissions of the user that is loading the data into the geodatabase? 4. What version was the enterprise geodatabase created at? Those questions may help get some more responses. -George ... View more

Hi Syed, There is also a group call Geodatabase​ that has been created and would be a good resource. -George ... View more

Hi Howard, From what I read in your original post, you want to update the licenses in your enterprise geodatabases? If so, the Enable tool will not do this. This tool is designed to add the SDE repository tables to an existing database (SQL Server, Oracle, PostgreSQL, etc...) Enable Enterprise Geodatabase GP Tool "The Enable Enterprise Geodatabase tool creates geodatabase system tables, stored procedures, functions, and types in an existing enterprise database, thereby enabling geodatabase functionality in the database." Here is a Blog that talks about updating the enterprise database license In a nut shell, you must use SDE command line to update the license before it expires. Please let me know if this is not what you are looking for. -George Geodatabase​ Managing Data​ ... View more

Hi Diego, There is a KB article related to this: Problem: License Manager does not start after upgrading to ArcGIS 10.3 Hopefully this helps! -George ... View more

I am not sure about the Server side and editing, but from ArcMap you can not. I believe that it has something to do with Feature Services and editing that way..... -George ... View more

Hi Dustin, There is no tool to do this, I would not recommend removing the geodatabase objects (repository tables, stored procedures, triggers, etc...) from the database, especially if SDE or another user in the geodatabase owns any objects. If this occurred it could corrupt the database as a whole. I think the easiest and safest way it the process that Alex P. referenced: "You may still be better off porting the tables and views that you want to save to a new database." Hope this helps... -George ... View more

Ronald, Can you connect to the Oracle database in SQLPlus (32 bit version)? Try uninstalling both the 32 and 64 bit clients, then re-install the 32 bit administrator full client. I have seen where the re-install and configuring of the TNSNAMES corrects the issue. I would recommend starting with the 32 bit client, then after that is successful add the 64 bit client, if needed. -George ... View more

Hi Diego, I have no way of knowing what was previously changed and why. I would recommend you log a Esri Technical Support‌ case if you need further clarification. -George ... View more