[mapserver-users] MapServer 6.2.1 and ArcSDE 10

[Lime, Steve D (MNIT)]

I've not done much tuning on my setup. I use SDE only when necessary and live with the performance issues. Tuning on the database itself is the best place to try and improve things. You might ping the list on this one, more folks use SDE in general than on 64-bit Linux.

Steve

From: Weisbender, Eric [mailto:Weisbend at WAPA.GOV]
Sent: Tuesday, June 11, 2013 9:55 AM
To: Lime, Steve D (MNIT); mapserver-users at lists.osgeo.org
Cc: Klein, Michael
Subject: RE: MapServer 6.2.1 and ArcSDE 10

Success!  Thanks again for all your help.  One last thing, do you suggest any of the other SDE Layer parameters that would improve the speed/performance.

Thanks,

Eric Weisbender
Western Area Power Administration
Corporate Service Office
U.S. Dept. of Energy
office: (720) 962-7280
email: weisbend at wapa.gov<mailto:weisbend at wapa.gov>

From: Lime, Steve D (MNIT) [mailto:Steve.Lime at state.mn.us]
Sent: June 10, 2013 3:01 PM
To: Weisbender, Eric
Cc: Klein, Michael
Subject: RE: MapServer 6.2.1 and ArcSDE 10

Patch goes into your source directory and I believe you just do something like:

  patch <4531.diff

Or you can just edit mapsde.c by hand based on the patch- it's straight forward. Then just recompile.

Steve

From: Weisbender, Eric [mailto:Weisbend at WAPA.GOV]
Sent: Monday, June 10, 2013 3:58 PM
To: Lime, Steve D (MNIT)
Cc: Klein, Michael
Subject: RE: MapServer 6.2.1 and ArcSDE 10

I just now realized that.  Where do I put the patch and how do I compile against it?

Thanks,

Eric Weisbender
Western Area Power Administration
Corporate Service Office
U.S. Dept. of Energy
office: (720) 962-7280
email: weisbend at wapa.gov<mailto:weisbend at wapa.gov>

From: Lime, Steve D (MNIT) [mailto:Steve.Lime at state.mn.us]
Sent: June 10, 2013 2:00 PM
To: Weisbender, Eric
Subject: RE: MapServer 6.2.1 and ArcSDE 10

Looks like you still have a 64/32-bit type error. Did you apply the patch I supplied last week?

From: Weisbender, Eric [mailto:Weisbend at WAPA.GOV]
Sent: Monday, June 10, 2013 2:53 PM
To: Lime, Steve D (MNIT); mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org>
Subject: RE: MapServer 6.2.1 and ArcSDE 10

Hello,

I recompiled MapServer / SDE setting CFLAGS='-DSDE64'.  I am now getting the following error when I try to draw the SDE Layer.

msDrawMap(): Image handling error. Failed to draw layer named 'sde' sdeCopyShape(): SDE error. Unsupported SDE shape type (140733193388036).

This is my SDE Layer Definition.  Any help would be greatly appreciated.

LAYER
  NAME "sde"
  TYPE LINE
  STATUS OFF
  CONNECTION "JLVGISGATEM,5353,sde,cso_editor,c1rcu1t#"
  CONNECTIONTYPE SDE
  DATA "RMR.MNT_SPANS,SHAPE,SDE.DEFAULT"
  TEMPLATE "/data/gis/www/html/ms_common/tlines.html"
  CLASS
     STYLE
      COLOR 200 200 0
                  WIDTH 10
     END
  END
END

Thanks,

Eric Weisbender
Western Area Power Administration
Corporate Service Office
U.S. Dept. of Energy
office: (720) 962-7280
email: weisbend at wapa.gov<mailto:weisbend at wapa.gov>

From: Lime, Steve D (MNIT) [mailto:Steve.Lime at state.mn.us]
Sent: June 07, 2013 1:46 PM
To: Weisbender, Eric; mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org>
Subject: RE: MapServer 6.2.1 and ArcSDE 10

Ah, I ran into this to as well, see ticket https://github.com/mapserver/mapserver/issues/4521. I've attached a diff that made things work well for me. Once a fix is put in place for 6.4 (git master) we can backport to 6.2.

Steve

From: mapserver-users-bounces at lists.osgeo.org<mailto:mapserver-users-bounces at lists.osgeo.org> [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Weisbender, Eric
Sent: Friday, June 07, 2013 2:26 PM
To: mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org>
Subject: [mapserver-users] MapServer 6.2.1 and ArcSDE 10

Hello,

We have successfully compiled MapServer 6.2.1 with ArcSDE10 and can see the SDE server ok.  When I try to draw a line layer I get the following error.

msDrawMap(): Image handling error. Failed to draw layer named 'sde' msSDELayerWhichShapes(): SDE error. getSDEQueryInfo(): Success. (0 getSDEQueryInfo(): SDE error. SE_queryinfo_set_columns(): Invalid parameter value passed to function. (4294967230)

The layer definition looks like this and all of the parameters look good.

LAYER
  NAME "sde"
  TYPE LINE
  STATUS OFF
  CONNECTIONTYPE SDE
  CONNECTION "JLVGISGATEM,5353,sde,cso_editor,c1rcu1t#"
  DATA "RMR.MNT_SPANS,SHAPE,SDE.DEFAULT"
  TEMPLATE "/data/gis/www/html/ms_common/tlines.html"
  CLASS
     STYLE
      COLOR 200 200 0
                  WIDTH 10
     END
  END
END

If anyone has an idea of what I am missing or doing wrong any help is greatly appreciated.


Thanks,

Eric Weisbender

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20130611/8437e829/attachment.htm>