[prev in list] [next in list] [prev in thread] [next in thread] 

List:       fdo-users
Subject:    [fdo-users] Trying to debug issues in FDO's SQL Server Spatial
From:       Sören_Kuklau <S.Kuklau () trenz ! ag>
Date:       2011-05-25 9:04:45
Message-ID: 57CEE7A3-E561-4EB5-8489-5D4F194A5981 () trenz ! ag
[Download RAW message or body]

Hi,

first of all, I'm unsure if -users or -internals is the appropriate mailing=
 list; I'd be willing to try and make changes to the codebase if it helps f=
ix the issues.

a customer is experiencing various issues with the MS SQL Server Spatial pr=
ovider in AutoCAD Map 3D 2012 (FDO 3.6). _I cannot reproduce these issues i=
n Map 3D 2010 (FDO 3.4)_, so I'm assuming that they are caused by changes o=
n AutoCAD's or FDO's end:

1) I can no longer add views as layers if one of their columns contains an =
umlaut (e.g. "Grundst=FCck").
2) AutoCAD now throws a "Item dbo.<name of a function> is already in this n=
amed collection." warning. Apparently, this occurs if the same function is =
used by multiple views.

Those two can be easily worked around, but if I have a chance to fix them, =
I wouldn't mind. :) However, then there's this one:

3) If checking in to a table with an INSTEAD OF INSERT trigger, AutoCAD eit=
her shows an "invalid cursor state" message (this appears related to this p=
ost: http://osgeo-org.1803224.n2.nabble.com/autocad-2011-commit-changes-pro=
blem-td6180452.html), or, in most cases, crashes with a "FATAL ERROR: Unhan=
dled Access Violation Reading 0x0000 Exception at <ever-changing memory add=
ress>" message. My guess is that this is caused by r4552 (http://trac.osgeo=
.org/fdo/ticket/507).

I've managed to set up a build environment both for the /branches/3.6 suppl=
ied with AutoCAD Map 3D 2012 as well as with /trunk (from Subversion). Thus=
 far, I've been unsuccessful getting those custom builds to run in AutoCAD:=
 if I install _all_ DLLs generated by build_thirdparty and build (fdo, sqls=
patial), the Data Connect panel is entirely empty with a "failed to load" m=
essage; if I merely add all SqlSpatial-related DLLs to the provider.xml or =
replace the existing one with my custom build (I've also tried using a sub-=
directory), it fails to load those. Which files in particular can I replace=
 to reproduce this? Is doing a debug build with .pdb files and then loading=
 the acminidump.dmp into VS 2010 at all feasible?

In addition, I've tried running FDO Toolbox, which uses FDO 3.6 as well, bu=
t oddly does not exhibit the third problem.

Thanks in advance for any pointers,
S=F6ren Kuklau


[Attachment #3 (text/html)]

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space; "> Hi,<br>
<br>
first of all, I'm unsure if -users or -internals is the appropriate mailing list; I'd \
be willing to try and make changes to the codebase if it helps fix the issues.<br> \
<br> a customer is experiencing various issues with the MS SQL Server Spatial \
provider in AutoCAD Map 3D 2012 (FDO 3.6). _I cannot reproduce these issues in Map 3D \
2010 (FDO 3.4)_, so I'm assuming that they are caused by changes on AutoCAD's or \
FDO's end:<br> <br>
1) I can no longer add views as layers if one of their columns contains an umlaut \
(e.g. &quot;Grundstück&quot;).<br> 2) AutoCAD now throws a &quot;Item dbo.&lt;name of \
a function&gt; is already in this named collection.&quot; warning. Apparently, this \
occurs if the same function is used by multiple views.<br> <br>
Those two can be easily worked around, but if I have a chance to fix them, I wouldn't \
mind. :) However, then there's this one:<br> <br>
3) If checking in to a table with an INSTEAD OF INSERT trigger, AutoCAD either shows \
an &quot;invalid cursor state&quot; message (this appears related to this \
post:&nbsp;<a href="http://osgeo-org.1803224.n2.nabble.com/autocad-2011-commit-changes \
-problem-td6180452.html">http://osgeo-org.1803224.n2.nabble.com/autocad-2011-commit-changes-problem-td6180452.html</a>),
  or, in most cases, crashes with a &quot;FATAL ERROR: Unhandled Access Violation \
Reading 0x0000 Exception at &lt;ever-changing memory address&gt;&quot; message. My \
guess is that this is caused by r4552 (<a \
href="http://trac.osgeo.org/fdo/ticket/507">http://trac.osgeo.org/fdo/ticket/507</a>).<br>
 <br>
I've managed to set up a build environment both for the /branches/3.6 supplied with \
AutoCAD Map 3D 2012 as well as with /trunk (from Subversion). Thus far, I've been \
unsuccessful getting those custom builds to run in AutoCAD: if I install _all_ DLLs \
generated  by build_thirdparty and build (fdo, sqlspatial), the Data Connect panel is \
entirely empty with a &quot;failed to load&quot; message; if I merely add all \
SqlSpatial-related DLLs to the provider.xml or replace the existing one with my \
custom build (I've also tried using  a sub-directory), it fails to load those. Which \
files in particular can I replace to reproduce this? Is doing a debug build with .pdb \
files and then loading the acminidump.dmp into VS 2010 at all feasible?<br> <br>
In addition, I've tried running FDO Toolbox, which uses FDO 3.6 as well, but oddly \
does not exhibit the third problem.<br> <br>
Thanks in advance for any pointers,<br>
Sören Kuklau<br>
<br>
</body>
</html>



_______________________________________________
fdo-users mailing list
fdo-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users

--===============1954188819==--

[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic