One or more objects failed to paste. SDE has lost its connection with underlying DBMS

[Gabriel_J_Ortiz_Rico]

Hi all,

we are having problems trying to copy&paste several huge SDE Raster Datasets from our ArcSDE 9.3.1 geodatabases (SQL Server 2008 64bits) to a File Geodatabase.

After some hours of processing (about 300GB pasted) we get this error message in ArcCatalog:

"One or more objects failed to paste. SDE has lost its connection with underlying DBMS".

Then , looking into the SQL Server log, we found the corresponding error message:

"Error: 7886, severity: 20, state: 1.
A read operation on a large object failed while sending data to the client. A common cause for this is if the application is running in READ UNCOMMITTED isolation level. This connection will be terminated."

Can we adjust/tune something in order to solve this?

We work with ArcGIS 9.3.1 SP1 on Windows Server 2008 64bits, SQL Server 2008 64bits.

Many thanks

[RandyKreuziger]

Did you make any progress on this?  We are getting a different error number but the same result.

"A read operation on a large object failed while sending data to the client. A common cause for this is if the application is running in READ UNCOMMITTED isolation level. This connection will be terminated."

In our case an ArcObjects program loses its connection to ArcSDE.  Like you we are running ArcSDE 9.3.1 64-bit on 64-bit Windows Server 2008 R2.

[Gabriel_J_Ortiz_Rico]

Yes, we did.

In our case it turned out to be a misconfiguration of the drivers and software of the storage (SAN). For some reason, the storage network failed when reading large amounts of data and big files.

When we tried to do a normal backup from SQL Server (even without SDE intervention), we realized that similar errors appeared in the events registry of the operating system and in the registry of SQL Server, so we began to look in another direction (something related with the operating system actually).

Best regards.