<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML ><HEAD><TITLE>SDF load problems</TITLE>
<META content="MSHTML 6.00.2900.2802" name=GENERATOR>
<STYLE>font-face {
font-family: Tahoma;
}
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: blue; TEXT-DECORATION: underline
}
P.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman";}
LI.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman";}
DIV.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman";}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman";}
SPAN.EmailStyle19 {
COLOR: navy; FONT-FAMILY: Arial;}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=blue link=blue>
<DIV id=idOWAReplyText7085 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>OK...That's good.
Thanks for clarifying. </FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>- Juan</FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Andy Morsell
[mailto:amorsell@spatialgis.com]<BR><B>Sent:</B> Wed 3/22/2006 6:02
PM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] SDF load problems<BR></FONT><BR></DIV>
<DIV>
<DIV dir=ltr align=left><SPAN class=953060223-22032006><FONT face=Arial
color=#0000ff size=2>Sorry, I should have clarified that my rant pertains to
flat files only. Database connections will be direct to their
source.</FONT></SPAN></DIV>
<DIV> </DIV>
<P><SPAN lang=en-us><FONT face=Tahoma size=1>Andy </FONT></SPAN><BR></P>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Butler, Juan P
[mailto:jpbutler@co.pinellas.fl.us] <BR><B>Sent:</B> Wednesday, March 22, 2006
2:46 PM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] SDF load problems<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">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?
</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Can someone from
Autodesk comment on this? </SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Juan Butler - Senior
Programmer/Analyst<BR>GIS Applications<BR>Pinellas County Information
Systems<BR><A
href="mailto:jpbutler@pinellascounty.org">jpbutler@pinellascounty.org</A><FONT
color=navy><SPAN style="COLOR: navy"></SPAN></FONT></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal><B><FONT face=Tahoma size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; 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>
users@mapguide.osgeo.org<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: [mapguide-users] SDF load
problems</SPAN></FONT></P></DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">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></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">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></P>
<DIV>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV>
<P><FONT face=Tahoma size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Tahoma">Andy Morsell, P.E.</SPAN></FONT>
<BR><FONT face=Tahoma size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Tahoma">Spatial Integrators,
Inc.</SPAN></FONT> <BR><FONT face=Tahoma size=1><SPAN
style="FONT-SIZE: 7.5pt; FONT-FAMILY: Tahoma"><A
href="http://www.SpatialGIS.com">http://www.SpatialGIS.com</A></SPAN></FONT>
</P>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><B><FONT face=Tahoma size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; 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>
users@mapguide.osgeo.org<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: [mapguide-users] SDF load
problems</SPAN></FONT></P></DIV>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">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></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">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></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Joel Carranza<BR>Gatekeeper
Systems<BR>626-449-3070 x114</SPAN></FONT></P>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoAutoSig style="MARGIN-BOTTOM: 12pt"><B><FONT face=Tahoma
size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; 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>
users@mapguide.osgeo.org<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: [mapguide-users] SDF load
problems</SPAN></FONT></P></DIV></DIV></DIV></DIV></DIV>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">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></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Arial color=blue size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: Arial">Jason</SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center><FONT
face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
<HR tabIndex=-1 align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><B><FONT face=Tahoma size=2><SPAN
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; 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>
users@mapguide.osgeo.org<BR><B><SPAN
style="FONT-WEIGHT: bold">Subject:</SPAN></B> [mapguide-users] SDF load
problems</SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">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></P>
<P><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">The
apache logs showed the following. None of the other logs reported anything of
interest that I could see. </SPAN></FONT></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; 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></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; 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></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; 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></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; 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></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; 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></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; 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></P>
<P><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Anyone have any ideas about what is
going on?</SPAN></FONT> </P>
<P><FONT face="Courier New" size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">Joel Carranza<BR>Gatekeeper
Systems<BR>626-449-3070 x114</SPAN></FONT> </P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV></DIV></BODY></HTML>