spatial database error

Posted in 2011

Topics: Connectivity: ODBC / JDBC / .NET, Platform-Specific Issues

KARL OLIVER — Tue, 14 Jun 2011 20:53:57 — source: IIUG Forums & Mailing Lists

hello Hoping someone can help with the meaning of this error below IBM Informix Dynamic Server Version 9.40.HC5 ArcSDE 9.2 Service Pack 5 HP-UX wdcuast5 B.11.11 U Tue Jun 14 17:01:21 2011] [2209] [WDCWAST203] db_array_fetch_attrs Fetch Error (-51)[Tue Jun 14 17:01:21 2011] [2209] [WDCWAST203] SDE_ODBC_STREAM Error: -51 [Informix][Informix ODBCDriver][Informix]User Defined Routine error.[U0000]Spatial reference conflict, 1 vs 2. [Tue Jun 14 17:01:21 2011] [2209] [WDCWAST203] load_buffer error -51 [Tue Jun 14 17:01:21 2011] [2209] [WDCWAST203] db_array_fetch_attrs Fetch Error (-51) [Wed Jun 15 06:13:56 2011] [2209] [WDCWAST203] Error Message: [Wed Jun 15 06:13:56 2011] [2209] [WDCWAST203] SDE_ODBC_STREAM Error: -2

↪ replying to KARL OLIVER

Art Kagel — Tue, 14 Jun 2011 21:14:48 — source: IIUG Forums & Mailing Lists

On HPUX errno 51 (Informix's libraries translate most ERRNO values to negative) is ENODATA (see /usr/include/sys/errno.h) which usually means an asynchronous IO has either returned no data or the data is not ready yet. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Jun 14, 2011 at 4:53 PM, KARL OLIVER <karl.oliver@maf.govt.nz>wrote: > hello > Hoping someone can help with the meaning of this error below > > IBM Informix Dynamic Server Version 9.40.HC5 > ArcSDE 9.2 Service Pack 5 > HP-UX wdcuast5 B.11.11 U > > Tue Jun 14 17:01:21 2011] [2209] [WDCWAST203] db_array_fetch_attrs Fetch > Error > (-51)[Tue Jun 14 17:01:21 2011] [2209] [WDCWAST203] SDE_ODBC_STREAM Error: > -51 > [Informix][Informix ODBCDriver][Informix]User Defined Routine > error.[U0000]Spatial reference conflict, 1 vs 2. > [Tue Jun 14 17:01:21 2011] [2209] [WDCWAST203] load_buffer error -51 > [Tue Jun 14 17:01:21 2011] [2209] [WDCWAST203] db_array_fetch_attrs Fetch > Error (-51) > > [Wed Jun 15 06:13:56 2011] [2209] [WDCWAST203] Error Message: > [Wed Jun 15 06:13:56 2011] [2209] [WDCWAST203] SDE_ODBC_STREAM Error: -2 > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --bcaec51a7e3e841f6004a5b2861f

↪ replying to KARL OLIVER

Stuart McCann — Tue, 14 Jun 2011 21:46:21 — source: IIUG Forums & Mailing Lists

Karl, Haven't seen exactly that one before but check out the SDE Server settings like:- MAXBLOBSIZE BLOBMEM MAXARRAYSIZE MAXARRAYBYTES Stuart McCann -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of KARL OLIVER Sent: Wednesday, 15 June 2011 6:54 AM To: ids@iiug.org Subject: spatial database error [24039] hello Hoping someone can help with the meaning of this error below IBM Informix Dynamic Server Version 9.40.HC5 ArcSDE 9.2 Service Pack 5 HP-UX wdcuast5 B.11.11 U Tue Jun 14 17:01:21 2011] [2209] [WDCWAST203] db_array_fetch_attrs Fetch Error (-51)[Tue Jun 14 17:01:21 2011] [2209] [WDCWAST203] SDE_ODBC_STREAM Error: -51 [Informix][Informix ODBCDriver][Informix]User Defined Routine error.[U0000]Spatial reference conflict, 1 vs 2. [Tue Jun 14 17:01:21 2011] [2209] [WDCWAST203] load_buffer error -51 [Tue Jun 14 17:01:21 2011] [2209] [WDCWAST203] db_array_fetch_attrs Fetch Error (-51) [Wed Jun 15 06:13:56 2011] [2209] [WDCWAST203] Error Message: [Wed Jun 15 06:13:56 2011] [2209] [WDCWAST203] SDE_ODBC_STREAM Error: -2 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. *************************************************************** This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of the Land and Property Management Authority. This email message has been swept by MIMEsweeper for the presence of computer viruses. *************************************************************** Please consider the environment before printing this email.

↪ replying to KARL OLIVER

KARL OLIVER — Wed, 15 Jun 2011 20:19:05 — source: IIUG Forums & Mailing Lists

thanks for that information Art

↪ replying to KARL OLIVER

Petr Pomykacek — Wed, 15 Jun 2011 22:16:47 — source: IIUG Forums & Mailing Lists

Hi Karl, error -51 is SDE error see $SDEHOME/include/sdeerr.h #define SE_DB_IO_ERROR (-51) /* DATABASE LEVEL I/O ERROR OCCURRED */ Problem is in using reference (may be) 2. No implicit coordinate transformations ----------------------------------------- All functions with two ST_Geometry operands will raise error USE23 (spatial reference conflict) if the SRIDs of the operands are not the same. If you want to compare two geometries with different SRIDs you can explicitly transform one, as in: SELECT * FROM tab1 a, tab2 b WHERE ST_Intersects(a.shape, ST_Transform(b.shape, ST_SRID(a.shape))); Petr Dne 14.6.2011 22:53, KARL OLIVER napsal(a): > hello > Hoping someone can help with the meaning of this error below > > IBM Informix Dynamic Server Version 9.40.HC5 > ArcSDE 9.2 Service Pack 5 > HP-UX wdcuast5 B.11.11 U > > Tue Jun 14 17:01:21 2011] [2209] [WDCWAST203] db_array_fetch_attrs Fetch Error > (-51)[Tue Jun 14 17:01:21 2011] [2209] [WDCWAST203] SDE_ODBC_STREAM Error: -51 > [Informix][Informix ODBCDriver][Informix]User Defined Routine > error.[U0000]Spatial reference conflict, 1 vs 2. > [Tue Jun 14 17:01:21 2011] [2209] [WDCWAST203] load_buffer error -51 > [Tue Jun 14 17:01:21 2011] [2209] [WDCWAST203] db_array_fetch_attrs Fetch > Error (-51) > > [Wed Jun 15 06:13:56 2011] [2209] [WDCWAST203] Error Message: > [Wed Jun 15 06:13:56 2011] [2209] [WDCWAST203] SDE_ODBC_STREAM Error: -2 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >