<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>SDF load problems</title>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman";}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {color:blue;
        text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
        {mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:12.0pt;
        font-family:"Times New Roman";}
p
        {mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:12.0pt;
        font-family:"Times New Roman";}
span.EmailStyle19
        {mso-style-type:personal-reply;
        font-family:Arial;
        color:navy;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
        {page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Wow. So you’re saying that if
and when a provider for Oracle Spatial comes along, we won’t be able to
define the connection to the database and have the data come directly from that
connection? It basically dumps the data (that point in time) into a
repository that resides in on the MG server? <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Can someone from Autodesk comment on
this? <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Juan Butler - Senior Programmer/Analyst<br>
<st1:PersonName w:st="on">GIS</st1:PersonName> Applications<br>
<st1:place w:st="on"><st1:PlaceName w:st="on">Pinellas</st1:PlaceName> <st1:PlaceType
w:st="on">County</st1:PlaceType></st1:place> Information Systems<br>
<a href="mailto:jpbutler@pinellascounty.org">jpbutler@pinellascounty.org</a><font
color=navy><span style='color:navy'><o:p></o:p></span></font></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Andy Morsell
[mailto:amorsell@spatialgis.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, March 22, 2006
5:37 PM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">users@mapguide.osgeo.org</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] SDF
load problems</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>This is where using a managed data
structure is a detriment, in my opinion. Many of us will want to update
our data through external processes and there is no easy way to just copy files
into the repository or point to an existing network location. I think
this is going to become a much bigger problem as people put these systems into
production and realize that they have to "load" their data into
repositories. It's also going to be a large problem for keeping data up
to date with ongoing system maintenance. Scheduled process are going to
be a necessity to ensure that the data in the repository is in synch with the
source data. And, in the case of large source datasets, the entire
dataset will have to be reloaded as there is no incremental update
method. </span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>I believe (but have not yet done this)
that the Studio API is going to have to be used to load these resources, not
the server API.</span></font><o:p></o:p></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<p><font size=1 face=Tahoma><span style='font-size:7.5pt;font-family:Tahoma'><!-- Converted from text/rtf format -->Andy
Morsell, P.E.</span></font> <br>
<font size=1 face=Tahoma><span style='font-size:7.5pt;font-family:Tahoma'>Spatial
Integrators, Inc.</span></font> <br>
<font size=1 face=Tahoma><span style='font-size:7.5pt;font-family:Tahoma'><a
href="http://www.SpatialGIS.com">http://www.SpatialGIS.com</a></span></font> <o:p></o:p></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Joel
Carranza [mailto:jec@gatekeeper.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, March 22, 2006
2:17 PM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">users@mapguide.osgeo.org</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] SDF
load problems</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Ahhh. I see, I misunderstood the use of
"Packages" and didn't think too look there. Thank you. It
is working fine now. </span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>I have noticed that imported SDFs are
processed (into SDF v3, I believe). Is it currently possible to import SDF
data sources into the repository without using Studio at all, just
using the server API? Is it possible to create your own Packages using the
server API? I would be interested in doing this for our
migration tools. </span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>Joel
Carranza<br>
Gatekeeper Systems<br>
626-449-3070 x114</span></font><o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoAutoSig style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Jason
Birch [mailto:Jason.Birch@nanaimo.ca] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, March 22, 2006
1:42 PM<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">users@mapguide.osgeo.org</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] SDF
load problems</span></font><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>It looks like it's too big. You'll
probably have to "Package" the data and upload it to the server
manually, then bring it in via the site Admin web app.</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Jason</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Joel
Carranza [mailto:jec@gatekeeper.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, March 22, 2006
13:39<br>
<b><span style='font-weight:bold'>To:</span></b> <st1:PersonName w:st="on">users@mapguide.osgeo.org</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> [mapguide-users] SDF load
problems</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'><!-- Converted from text/rtf format -->I
am trying to load a 225 MB SDF file using MapGuide studio. I have tried any
number of different options and they all seem to fail. The process crunches for
a while, and then says "Communicating with server" and the progress
bars fills to 100% . Eventually, an error dialog is popped that says
"Unable to complete request to site. Connection lost". </span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>The
apache logs showed the following. None of the other logs reported anything of
interest that I could see. </span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>[Wed
Mar 22 13:33:54 2006] [warn] FastCGI: (dynamic) server "C:/Program
Files/MapGuideOpenSource/WebServerExtensions/www/mapagent/MapAgent.exe"
restarted (pid 5284)</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>[Wed
Mar 22 13:34:00 2006] [warn] FastCGI: scheduled the restart of the last
(dynamic) server "C:/Program
Files/MapGuideOpenSource/WebServerExtensions/www/mapagent/MapAgent.exe"
process: reached dynamicMaxClassProcs (10)</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>[Wed
Mar 22 13:34:00 2006] [warn] FastCGI: (dynamic) server "C:/Program
Files/MapGuideOpenSource/WebServerExtensions/www/mapagent/MapAgent.exe"
restarted (pid 6008)</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>[Wed
Mar 22 13:34:21 2006] [warn] FastCGI: (dynamic) server "C:/Program
Files/MapGuideOpenSource/WebServerExtensions/www/mapagent/MapAgent.exe"
(pid 5540) terminated with exit with status '0'</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>[Wed
Mar 22 13:34:38 2006] [warn] FastCGI: (dynamic) server "C:/Program
Files/MapGuideOpenSource/WebServerExtensions/www/mapagent/MapAgent.exe"
(pid 6008) termination signaled</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>[Wed
Mar 22 13:34:39 2006] [warn] FastCGI: (dynamic) server "C:/Program
Files/MapGuideOpenSource/WebServerExtensions/www/mapagent/MapAgent.exe"
(pid 6008) terminated with exit with status '0'</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Anyone
have any ideas about what is going on?</span></font> <o:p></o:p></p>
<p><font size=2 face="Courier New"><span style='font-size:10.0pt;font-family:
"Courier New"'>Joel Carranza<br>
Gatekeeper Systems<br>
626-449-3070 x114</span></font> <o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>