nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Could not create geodatabase tables and stored procedures

NirmalOjha

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

Encontre mais publicações marcadas com

Accepted answers

All comments

NirmalOjha

Thanks George.

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

George Thompson

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

George Thompson

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?

George Thompson

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?

NirmalOjha

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

George Thompson

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?

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.