db_array_fetch_spix_recs OCI Fetch Error (933)

[syed_ahamedrafi]

Hi,

I am getting the below error offlate continuously in the database server.

we are using arcsde 9.1 on oracle 10.2.0.1.0

we have not had this issue before. please suggest.


.
[11/26/2012 10:12:23;SdeId=7108371;Client=DGINTAPP01] db_array_fetch_spix_recs OCI Fetch Error (933)
[11/26/2012 10:12:23;SdeId=7108371;Client=DGINTAPP01] load_buffer error -51
db_sda_execute_stmt::OCIStmtExecute (933)
.
[11/26/2012 10:12:25;SdeId=7108601;Client=dgintapp02] db_array_fetch_spix_recs OCI Fetch Error (933)
[11/26/2012 10:12:25;SdeId=7108601;Client=dgintapp02] load_buffer error -51
db_sda_execute_stmt::OCIStmtExecute (933)
.
[11/26/2012 10:12:31;SdeId=7108597;Client=dgintapp02] db_array_fetch_spix_recs OCI Fetch Error (933)
[11/26/2012 10:12:31;SdeId=7108597;Client=dgintapp02] load_buffer error -51
[11/26/2012 10:12:42;SdeId=0;Client=GIOMGR] Could Not Get XDR Request.
db_sda_execute_stmt::OCIStmtExecute (933)
.
[11/26/2012 10:13:01;SdeId=7108600;Client=dgintapp02] db_array_fetch_spix_recs OCI Fetch Error (933)
[11/26/2012 10:13:01;SdeId=7108600;Client=dgintapp02] load_buffer error -51
db_sda_execute_stmt::OCIStmtExecute (933)
.

[VinceAngelo]

Oracle 10.2.0.1 never functioned correctly with any Esri software.  Years ago, back when
ArcSDE 9.1 was still supported, you needed to use 10.2.0.2 or 10.2.0.3 with the special
ArcSDE for Oracle 10gR2 release for base functionality.  There was a general update patch
and several other patches released for 9.1; you should have those applied.

Oracle deprecated LONG RAW use long ago, and it worked less effectively toward the end
of the 10.2 lifetime; using SDELOB storage sometimes helped with the more bizarre database
retrieval errors.

- V