NIM085629 for ArcSDE/Enterprise Geodatabase

Bug ID Number	NIM085629
Submitted	October 12, 2012
Last Modified	April 2, 2025
Applies to	ArcSDE/Enterprise Geodatabase
Version found	10.1
Status	Will Not Be Addressed

Additional Information

Not in the plan to address this issue in the command line tool. Please consider the functionality of registering a view with the geodatabase added at ArcGIS 10.5.

Workaround

Using a conversion function such as NVL or DECODE on the field that is used for the SUM in creating the original tabular view referenced works fine. Also an obvious workaround of ensuring that there are no null values within the field that is used within the aggregate function.SQL> CREATE OR REPLACE FORCE VIEW SDE.VIEWnvl (ID, NONNULLE) AS SELECT MIN (id) AS id, SUM (NVL(nonnulle,0)) AS nonnulle FROM SDE.TEST;View created.<a href="file:c:/arcgis/ArcSDE/commands/bin" target="_blank">c:\arcgis\ArcSDE\commands\bin</a>>sdetable -o create_view -u sde -p sde -i sde:oracle11g:tenpointone -T nvlsecondview -t "viewnvl v,monde_stgeometry fc" -c v.nonnulle,<a href="http://v.id" target="_blank">v.id</a>,fc.shape -w fc.objectid=<a href="http://v.id" target="_blank">v.id</a>ArcSDE 10.1 for Oracle11g Build 679 Thu Apr 5 11:43:21 2012Attribute Administration Utility-----------------------------------------------------Successfully created view nvlsecondview.