laptop and a wrench

漏洞

ST_transform queries are failing with errors for some queries with Canadian Projection.

上次发布: October 9, 2019 ArcSDE/Enterprise Geodatabase
漏洞 ID 编号 BUG-000125615
已提交September 27, 2019
上次修改时间June 5, 2024
适用范围ArcSDE/Enterprise Geodatabase
找到的版本10.6.1
状态Will Not Be Addressed

附加信息

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.

解决办法

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))

  )

 )

 

重现步骤

漏洞 ID: BUG-000125615

软件:

  • ArcSDE/Enterprise Geodatabase

当漏洞状态发生变化时获得通知

下载 Esri 支持应用程序

发现关于本主题的更多内容

获取来自 ArcGIS 专家的帮助

联系技术支持部门

下载 Esri 支持应用程序

转至下载选项