<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7226.0">
<TITLE>Re: [UMN_MAPSERVER-USERS] error 1 on virtual point layer</TITLE>
</HEAD>
<BODY>
<DIV id=idOWAReplyText54234 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>
OK, I've done
some more work on this, and the results are... well, strange. Here's what I found, in case it
helps others work through the same situation:</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>I was able to get my virtual layer to work
by going back to a slightly earlier build of mapserver and mapscript. The one
that didn't work was a late April build, the one that did work was an early
April build, both custom builds supplied by Assefa at DM. The primary difference
(from my point of view) between the builds is that the later build, the one that
didn't work with the virtual layers, supports fastcgi.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>What is interesting is this: prior to going
back to the earlier mapserver executable, I tried to simply swap out the
gdal13.dll for the earlier version. This resulted in the same errors
("[MapServer Error]: msOGRFileNextShape(): SetAttributeFilter() not supported on
ExecuteSQL() results."), so no change. It was when I swapped out the
mapserver/mapscript executables that I was able to get the virtual layer to
work. So does that imply that it's not gdal itself that is causing the problem,
but in how mapserver/mapscript is using it? (Apologies if that's an egghead
question.)</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>So for now, I'm up and running, just can't
use the build that supports fastcgi....</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Cheers.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2></FONT> </DIV></DIV>
<DIV id=idSignature43528 dir=ltr><FONT face=Arial color=#000000 size=2><FONT
face="Times New Roman" color=navy size=2><SPAN lang=EN-CA
style="FONT-SIZE: 10pt; COLOR: navy">
<DIV class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN lang=EN-CA
style="FONT-SIZE: 10pt; COLOR: navy" >------------------------------</SPAN><SPAN
style="COLOR: black"></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN lang=EN-CA
style="FONT-SIZE: 10pt; COLOR: navy" >Mark
Adams</SPAN><SPAN style="COLOR: black"></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN lang=EN-CA
style="FONT-SIZE: 10pt; COLOR: navy" >Senior Analyst
& Project Manager</SPAN><SPAN style="COLOR: black"></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN lang=EN-CA
style="FONT-SIZE: 10pt; COLOR: navy" >Cuesta Systems
(DPRA Canada)</SPAN><SPAN
style="COLOR: black"></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN lang=EN-CA
style="FONT-SIZE: 10pt; COLOR: navy" >5230 South
Service Road</SPAN><SPAN
style="COLOR: black"></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN lang=EN-CA
style="FONT-SIZE: 10pt; COLOR: navy" >Burlington</SPAN><SPAN
lang=EN-CA style="FONT-SIZE: 10pt; COLOR: navy" >,
ON L7L
5K2</SPAN><SPAN
style="COLOR: black"></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN lang=EN-CA
style="FONT-SIZE: 10pt; COLOR: navy" >Phone:
905-333-4544 x14</SPAN><SPAN style="COLOR: black"></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN lang=EN-CA
style="FONT-SIZE: 10pt; COLOR: navy" >Fax:
905-333-0455</SPAN><SPAN style="COLOR: black"></SPAN></DIV>
<DIV class=MsoNormal style="MARGIN: 0in 0in 0pt"><SPAN lang=EN-CA
style="FONT-SIZE: 10pt; COLOR: navy" >Email:
mark.adams@dpra.com</SPAN><SPAN style="COLOR: black"></SPAN></DIV>
<DIV class=MsoNormal></SPAN></FONT> </DIV></FONT></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Frank Warmerdam on behalf of Frank
Warmerdam<BR><B>Sent:</B> Wed 5/10/2006 2:37 PM<BR><B>To:</B> Mark
Adams<BR><B>Cc:</B> MAPSERVER-USERS@LISTS.UMN.EDU<BR><B>Subject:</B> Re:
[UMN_MAPSERVER-USERS] error 1 on virtual point layer<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>Mark Adams wrote:<BR>> Hi all,<BR>> <BR>> I've
found references to this problem in the list, but no solution:<BR>> I've got
an application developed in our office that uses ODBC<BR>> connections and
OVF files to publish several layers from an Oracle<BR>> database. All is
working well in our office; however, this week I am<BR>> implementing the app
in the client's environment, and mapserver is<BR>> failing on trying to load
the virtual layers (no mapserver error, just<BR>> never get a map
back).<BR>> <BR>> Using OGRINFO I can see the data, but I get an
error message before the<BR>> results are listed:<BR>> ERROR1:
SetAttributeFilter() not supported on ExecuteSQL() results<BR>> <BR>>
I am presuming that this error is also the reason why the layer doesn't<BR>>
draw in mapserver.<BR>> Does anyone have any insight as to what this error
means?<BR><BR>Mark,<BR><BR>I am guessing you have slightly different versions of
OGR in your different<BR>environments. The message means that an SQL
result (perhaps using<BR>SrcSQL in the OVF file?) is being constrained with a
SetAttributeFilter()<BR>call. But this is not supported and the attribute
filter will be ignored.<BR><BR>I believe this was always the case, but there was
some recent work to<BR>propagate the errors out properly which may have changed
the behavior.<BR><BR>I don't know that this will help you. It is vaguely
possible that updating<BR>to GDAL/OGR 1.3.2 will help in this regard as I made a
few changes in<BR>the OGR VRT and OGR ODBC drivers to better handle this whole
sequence.<BR>Or, that may be what is causing the problems!<BR><BR>Best
regards,<BR>--<BR>---------------------------------------+--------------------------------------<BR>I
set the clouds in motion - turn up | Frank Warmerdam,
warmerdam@pobox.com<BR>light and sound - activate the windows | <A
href="http://pobox.com/~warmerdam">http://pobox.com/~warmerdam</A><BR>and watch
the world go round - Rush | President OSGF, <A
href="http://osgeo.org">http://osgeo.org</A><BR><BR></FONT></P></DIV>
</BODY>
</HTML>