I have a process in which data is transferred from PGDB to SDE GDB, recently I have encountered error - 'OutofMemoryException' and the process stops. I have noticed this error while trying to transfer line features in bulk (process works fine with the same amount of data in point or polygon). Once this error is encountered, I am unable to open source PDGB, trying to open it gives an error - "Failed to connect to database. An underlying database error occurred. System Resources Exceeded." New session of ArcMap allows to open PGDB but data transfer will still not proceed.
The transfer happens here to a feature class inside a versioned feature class inside a feature dataset, which also has a geometric network in it.
Version used here is ArcGIS 9.3.1 SP2 (GDB is also upgraded) with SQL SERVER 2008R2.