laptop and a wrench

Erro

ORA-14451 error when creating an operating system authenticated user with the Create Database User geoprocessing tool.

Última Publicação: December 10, 2019 ArcGIS for Desktop
Número de ID do Erro BUG-000126055
EnviadoOctober 16, 2019
Última ModificaçãoJune 25, 2025
Aplica-se àArcGIS for Desktop
Versão encontrada10.7.1
Sistema OperacionalWindows OS
Versão do Sistema Operacional10.0 64 Bit
StatusWill Not Be Addressed

Informações Adicionais

We apologize that we were unable to address this issue within the current product support cycle.  If the issue continues to affect your work in a supported release, please contact Technical Support.

Solução Provisória

  1. After running the tool in 10.7.1, connect as the OS-authenticated user and make an appropriate selection set using ArcMap or ArcGIS Pro, which should create the missing indexes and sequence and still allow the log files to be Global Temporary Tables.
  2. Use 10.7 or earlier to create the OS-authenticated user which uses traditional tables for the log files (optionally, convert them to Global Temporary Tables as per https://support.esri.com/en/Technical-Article/000009061).
  3. Create a database authenticated user and use Oracle tools to create the missing indexes and sequences based on the DDL from the database-authenticated user, for example:

CREATE INDEX "TESTUSER3"."SDE_LOGFILE_DATA_IDX1" ON "TESTUSER3"."SDE_LOGFILE_DATA" ("LOGFILE_DATA_ID", "SDE_ROW_ID") ;

CREATE INDEX "TESTUSER3"."SDE_LOGFILE_DATA_IDX2" ON "TESTUSER3"."SDE_LOGFILE_DATA" ("SDE_ROW_ID") ;

CREATE INDEX "TESTUSER3"."SDE_LOGFILE_DATA_IDX3" ON "TESTUSER3"."SDE_LOGFILE_DATA" ("LOGFILE_DATA_ID", "UUID_VAL") ;

CREATE INDEX "TESTUSER3"."SDE_LOGFILE_DATA_IDX4" ON "TESTUSER3"."SDE_LOGFILE_DATA" ("UUID_VAL") ;

CREATE SEQUENCE "TESTUSER3"."SDE_LOGFILE_LID_GEN" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 21 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE GLOBAL ; 

Etapas para Reproduzir

ID do Erro: BUG-000126055

Software:

  • ArcGIS for Desktop

Seja notificado quando o status de um erro mudar

Baixe o Aplicativo de Suporte da Esri

Descubra mais sobre este tema

Obtenha ajuda de especialistas do ArcGIS

Entre em contato com Suporte Técnico

Baixe o Aplicativo de Suporte da Esri

Ir para as opções de download