Erro
ST_transform queries are failing with errors for some queries with Canadian Projection.
| Número de ID do Erro | BUG-000125615 |
|---|---|
| Enviado | September 27, 2019 |
| Última Modificação | June 5, 2024 |
| Aplica-se à | ArcSDE/Enterprise Geodatabase |
| Versão encontrada | 10.6.1 |
| Status | Will 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. Note that ArcGIS 10.8.2 is the current release of ArcGIS Desktop and will enter Mature Support in March 2024 https://support.esri.com/en-us/products/arcmap/life-cycle. There are no plans to release an ArcGIS Desktop 10.9, and we recommend that you migrate to ArcGIS Pro. See Migrate from ArcMap to ArcGIS Pro https://www.esri.com/en-us/arcgis/products/arcgis-pro/resources/migrate for more information.Solução Provisória
To get the GSD files to work in Windows and Linux, add the PEDATAHOME to the extproc.ora and the listener.ora, and restart both the database and the listener. The query does not work when the variable is only added to 1 of the files.
1. Add the following line to the extproc.ora on Windows.
SET PEDATAHOME=C:\pedata
2. Add the following line to the listener.ora on Windows.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\product\12.1.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\product\12.1.0\dbhome_1\bin\oraclr12.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = CUTSP09.ESRI.local)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
LINUX CONFIGURATION:
1. Add the following line to the extproc.ora on Windows.SET PEDATAHOME="/oracle/app/oracle/st_geometry1071/pedate"
2. Add the following line to the listener.ora on Windows.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = /oracle/app/oracle/product/12.2.0/dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ANY")
)
(SID_DESC =
(SID_NAME = nspower)
(ENVS="PEDATAHOME=/oracle/app/oracle/st_geometry1071/pedata")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = nspowerdb.tssupport.int)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
Etapas para Reproduzir
ID do Erro: BUG-000125615
Software:
- ArcSDE/Enterprise Geodatabase
Seja notificado quando o status de um erro mudar
Descubra mais sobre este tema
Procurar por informações relacionadas
Encontre treinamento relacionado a este tópico
Explore idéias e forneça comentários
Obtenha ajuda de especialistas do ArcGIS
Baixe o Aplicativo de Suporte da Esri