topic Re: Create enterprise geodatabase errors in Geodatabase Questions

Create enterprise geodatabase errors

rustemrustem — Fri, 15 Jul 2016 13:13:22 GMT

When I Create Enterprise Geodatabase using toolbox in ArcCatalog it errors below. also I create database in SQL server then I add geodatabase connection to arccatalog but when I enable enterprise geodatabase it same errors

I use ArcGIS Desktop 10.3.1 and SQL Server 2014.

What is the error?

[Operastion Failed]
See the setup log in the following location for additional error information:

Colud not create geodatabase tables and stored procedures
Failed to execute (EnableEnterpriseGeodatabase)

LOG INFO:

[Thu Jul 14 15:11:09 2016] VERSION table created...
[Thu Jul 14 15:11:09 2016] SPATIAL_REFERENCES table being created...
[Thu Jul 14 15:11:09 2016] SPATIAL_REFERENCES table created...
[Thu Jul 14 15:11:09 2016] GEOMETRY_COLUMNS table being created...
[Thu Jul 14 15:11:09 2016] GEOMETRY_COLUMNS table created...
[Thu Jul 14 15:11:09 2016] LAYERS table being created...
[Thu Jul 14 15:11:09 2016] LAYERS table created...
[Thu Jul 14 15:11:09 2016] METADATA table being created...
[Thu Jul 14 15:11:09 2016] METADATA table created...
[Thu Jul 14 15:11:09 2016] RASTER_COLUMNS table being created...
[Thu Jul 14 15:11:09 2016] RASTER_COLUMNS table created...
[Thu Jul 14 15:11:09 2016] TABLE_REGISTRY table being created...
[Thu Jul 14 15:11:09 2016] TABLE_REGISTRY table created...
[Thu Jul 14 15:11:09 2016] STATES table being created...
[Thu Jul 14 15:11:09 2016] STATES table created...
[Thu Jul 14 15:11:09 2016] VERSIONS table being created...
[Thu Jul 14 15:11:09 2016] VERSIONS table created...
[Thu Jul 14 15:11:09 2016] MVTABLES_MODIFIED table being created...
[Thu Jul 14 15:11:09 2016] MVTABLES_MODIFIED table created...
[Thu Jul 14 15:11:09 2016] STATE_LINEAGES table being created...
[Thu Jul 14 15:11:09 2016] ERROR in creating STATE_LINEAGES table.
Error: -38
[Thu Jul 14 15:11:09 2016] DBMS error code: 0

[Thu Jul 14 15:11:09 2016] SDE schema object install not completed.
[Thu Jul 14 15:11:09 2016] ERROR installing/upgrading ArcSDE, Error = -1

Thanks

Re: Create enterprise geodatabase errors

RexRobichaux2 — Mon, 18 Jul 2016 16:05:06 GMT

Hi Rustem-

From the error log you provided and the attached screenshot, I would venture to guess you are having issues that stem from the SDE / Geodatabase Administrator creation process. It appears you are leaving the SDE owned schema option unchecked -if that is the case you must be logged into the SQL Server instance as a user who is dbo in the instance (sa?). Might be worth checking login / user mapping in Management Studio. If that is the case, then the geodatabase should be created in the dbo schema in the database.

Also just check to ensure the proper syntax of your instance (EMI/SQL), as well as ensure that the instance is set to allow for mixed mode authentication since you are attempting to connect using the sa administrative login via database authentication.

A quick test for elimination would be to run the create enterprise geodatabase tool, but select the option for "Sde owned schema", and create a SDE user / password to be the test Geodatabase administrator. If the tool completes then you likely have a login / mapping error with the sa user you are attempting to use to create and administer the geodatabase. I hope this helps!

-Rex

Re: Create enterprise geodatabase errors

RexRobichaux2 — Mon, 18 Jul 2016 16:15:51 GMT

Also, if you try to run the Enable Geodatabase Tool- the proper preconditions must be established in the database via SQL Server Management Studio before you can run the tool. In the code example below, an SDE Geodatabse Administrative user (sde) is created and assigned the necessary permissions to administer the geodatabase. The example that follows also creates a database from scratch named (Testtwo)- maybe try running this script with your own names / parameters and see if you have any success running the Enable Enterprise Tool afterwords? Just replace paths and database / user names if desired:

CREATE DATABASE [Testtwo]

CONTAINMENT = NONE

ON PRIMARY

( NAME = N'Testtwo', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\Testtwo.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )

LOG ON

( NAME = N'Testtwo_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\Testtwo_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)

ALTER DATABASE [Testtwo] SET COMPATIBILITY_LEVEL = 120

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))

begin

EXEC [Testtwo].[dbo].[sp_fulltext_database] @action = 'enable'

end

ALTER DATABASE [Testtwo] SET ANSI_NULL_DEFAULT OFF

ALTER DATABASE [Testtwo] SET ANSI_NULLS OFF

ALTER DATABASE [Testtwo] SET ANSI_PADDING OFF

ALTER DATABASE [Testtwo] SET ANSI_WARNINGS OFF

ALTER DATABASE [Testtwo] SET ARITHABORT OFF

ALTER DATABASE [Testtwo] SET AUTO_CLOSE OFF

ALTER DATABASE [Testtwo] SET AUTO_SHRINK OFF

ALTER DATABASE [Testtwo] SET AUTO_UPDATE_STATISTICS ON

ALTER DATABASE [Testtwo] SET CURSOR_CLOSE_ON_COMMIT OFF

ALTER DATABASE [Testtwo] SET CURSOR_DEFAULT GLOBAL

ALTER DATABASE [Testtwo] SET CONCAT_NULL_YIELDS_NULL OFF

ALTER DATABASE [Testtwo] SET NUMERIC_ROUNDABORT OFF

ALTER DATABASE [Testtwo] SET QUOTED_IDENTIFIER OFF

ALTER DATABASE [Testtwo] SET RECURSIVE_TRIGGERS OFF

ALTER DATABASE [Testtwo] SET DISABLE_BROKER

ALTER DATABASE [Testtwo] SET AUTO_UPDATE_STATISTICS_ASYNC OFF

ALTER DATABASE [Testtwo] SET DATE_CORRELATION_OPTIMIZATION OFF

ALTER DATABASE [Testtwo] SET TRUSTWORTHY OFF

ALTER DATABASE [Testtwo] SET ALLOW_SNAPSHOT_ISOLATION ON

ALTER DATABASE [Testtwo] SET PARAMETERIZATION SIMPLE

ALTER DATABASE [Testtwo] SET READ_COMMITTED_SNAPSHOT ON

ALTER DATABASE [Testtwo] SET HONOR_BROKER_PRIORITY OFF

ALTER DATABASE [Testtwo] SET RECOVERY FULL

ALTER DATABASE [Testtwo] SET MULTI_USER

ALTER DATABASE [Testtwo] SET PAGE_VERIFY CHECKSUM

ALTER DATABASE [Testtwo] SET DB_CHAINING OFF

ALTER DATABASE [Testtwo] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )

ALTER DATABASE [Testtwo] SET TARGET_RECOVERY_TIME = 0 SECONDS

ALTER DATABASE [Testtwo] SET DELAYED_DURABILITY = DISABLED

ALTER DATABASE [Testtwo] SET READ_WRITE

USE [Testtwo]

CREATE USER [sde] FOR LOGIN [sde]

USE [Testtwo]

ALTER USER [sde] WITH DEFAULT_SCHEMA=[sde]

USE [Testtwo]

CREATE SCHEMA [sde] AUTHORIZATION [sde]

USE [Testtwo]

ALTER ROLE [db_owner] ADD MEMBER [sde]

grant create function to sde;

grant create procedure to sde;

grant create view to sde;

grant create table to sde;