Bug
An Oracle error message, "ORA-24347: Warning of a NULL column in an aggregate function" is returned when upgrading a geodatabase with views containing aggregate function.
| Bug ID Number | BUG-000162656 |
|---|---|
| Submitted | November 2, 2023 |
| Last Modified | April 21, 2026 |
| Applies to | ArcGIS Pro |
| Version found | 3.1.1 |
| Operating System | Windows OS |
| Operating System Version | 10.0 |
| Status | Non-Reproducible |
Additional Information
The issue is not reproducible in the currently supported software. If the problem reappears in a supported release, log a new issue.Workaround
To successfully upgrade the geodatabase, update the view with the NVL function to handle NULL values:
"select cast(row_number() OVER(ORDER BY 1) as number(38,0)) as OBJECTID, Fac_Type,
SUM(NVL(Length,0)) AS LengthSum
FROM SDE.BikePaths
GROUP BY Fac_Type"
Steps to Reproduce
Bug ID: BUG-000162656
Software:
- ArcGIS Pro
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App