topic Re: Could not create geodatabase tables and stored procedures in Geodatabase Questions

Could not create geodatabase tables and stored procedures

NirmalOjha — Wed, 31 Jul 2019 18:48:32 GMT

I want to enable SDE on the SQL Server DB but I get error with 'Could not create geodatabase tables and stored procedures'. I tried with ArcGIS Pro (v2.4), ArcCatalog (v 10.4.1), SQL Server 2014.

I followed through this support page: Error: Could not create geodatabase tables and stored procedures. Failed to execute (EnableEnterpriseGeodatabase) but no resolution. I get the similar (same) error message shown in that page.

It can connect to other DB on the same server without problem.

Nirmal

Re: Could not create geodatabase tables and stored procedures

George_Thompson — Wed, 31 Jul 2019 18:58:36 GMT

What is the exact version of your SQL Server 2014? The min is SP3.

What other information are in the log files referenced in the errors?

Re: Could not create geodatabase tables and stored procedures

NirmalOjha — Wed, 31 Jul 2019 19:15:33 GMT

Thanks George for quick reply.

The SQL Server 2014 is SP2. So, this might be the cause. Is there anything that can be done without installing/updating with the service pack. I don't have access to the Server (for now)? I have other couple of SDE enabled DBs in the same server.

Here is the Message I get when I run from toolbox:

Executing: EnableEnterpriseGeodatabase "Database Connections\AAAA.sde" C:\Users\<USER>\Documents\AGS_Test\keycode_AGS\keycodes
Start Time: <Date-Time>
Validated authorization file.
User has required privileges for geodatabase setup.
XML support is enabled for the database instance.
Successfully enabled database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT.
[Underlying DBMS error]
See the setup log in the following location for additional error information:
C:\Users\<USER>\AppData\Local\Temp\sde_setup.log
Could not create geodatabase tables and stored procedures.
Failed to execute (EnableEnterpriseGeodatabase).

The log file content is:

[Wed Jul 31 13:04:08 2019] DB_instance_open() db_connect error: -1
[Wed Jul 31 13:04:08 2019] Error: Underlying DBMS error (-51).
[Wed Jul 31 13:04:08 2019] Error: DB_arcsde_setup: Unable to connect
[Wed Jul 31 13:04:08 2019] 42S02:[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Invalid object name '<DBANME>.sde.SDE_version'.
[Wed Jul 31 13:04:09 2019] ERROR installing/upgrading ArcSDE, Error = -51

Re: Could not create geodatabase tables and stored procedures

George_Thompson — Wed, 31 Jul 2019 19:24:55 GMT

I would recommend that you upgrade the SP on SQL Server for the new Enterprise Geodatabase creation.

What is the name DB being created?

Is the DB set up as DBO or as SDE schema?

Re: Could not create geodatabase tables and stored procedures

George_Thompson — Wed, 31 Jul 2019 19:27:15 GMT

https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-sql-server/comparison-geodatabase-owners-sqlserver.htm

https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-sql-server/setup-geodatabase-sqlserver.htm#ESRI_SECTION1_0CB5A7EBA7EB4F69AA7180F0FA84779E

Can you provide a screenshot of the empty database and any tables that are created after it fails?

Re: Could not create geodatabase tables and stored procedures

NirmalOjha — Wed, 31 Jul 2019 19:40:57 GMT

It is DBO schema.

I ran the "Create Enterprise Geodatabase" tool and it successfully created the database but no tables and procedures were created.

Authentication: Operating system Authentication, my user account has full access (admin level) to the DB server.

So I tired with "Enable Enterprise Geodatabase" but same result.

Here is the screen shot of the DB that is created with "Create Enterprise Geodatabase" tool.

So, for me the connection to SQL server should have no issue as it created the DB.

Re: Could not create geodatabase tables and stored procedures

George_Thompson — Wed, 31 Jul 2019 19:50:43 GMT

Ok, you may want to contact Esri technical support and work with an analyst on this.

Re: Could not create geodatabase tables and stored procedures

NirmalOjha — Wed, 31 Jul 2019 19:53:43 GMT

Thanks George.

I will first upgrade the SQL Server and if it did not resolve I will contact technical support.