For context, we have our UN-enabled Enterprise GDB deployed on an Oracle DB (Non-Spatial) as an electric distribution utility.
We have around 18k+ subnetworks (vast majority if which are low voltage subnetworks). And then we have 67 medium voltage subnetworks, of which 2 persistently throw database error when running the Update Subnetwork process in default & branch versions.
Here's the log message in Server Manager related to said error:
Warning on subnetwork "03-TLS321" - FDO error: -2147216072 [03-TLS321], Underlying DBMS error [ORA-01795: maximum number of expressions in a list is 1000] [UN_6_Subnetworks][STATE_ID = 0]
My question is what kind of query is it running? So that I can limit the objects in that subnetwork that's causing this overflow of more than 1000 elements/expressions in said list.
Will be glad to provide additional details for those willing to help. I'm stumped, this is in production environment and this problem is causing frictions with the designers & planners.
