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.

Solution de contournement

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"

Étapes pour reproduire