[mapguide-users] SQL Server Spatial View Selection Issue

[RenoSun]

Hi Jackie,

Thank you for your reply :)

Firstly, I have two databases on my SQL Server.

One of them, I was not able to export Data Store Configuration to XML for
it.

It showed me the error as following screen capture:
<http://osgeo-org.1560.x6.nabble.com/file/n5228292/Capture.png> 

Secondly, for another DB that I have, I successfully export the Data Store
Configuration to XML. Also, I made the changes of the XML, and I load the
XML file with my SQL Server FDO Data Sources. It showed me the primary key
under my SQL Server Spatial View table as following screen capture:

<http://osgeo-org.1560.x6.nabble.com/file/n5228292/SuccessfullyToSeePrimaryKeyInFDOToolBox.png> 

However, when I was trying to use MapGuide Maestro 6.0m4 to update the
Configuration Document for my SQL Server feature source. It showed me
following error:

*Maestro Error Report
====================

Version: 6.0.0.8587
Date: 10/6/2015 10:56:38 AM

Message: The remote server returned an error: (559) MgDbException.

Details: System.Net.WebException: The remote server returned an error: (559)
MgDbException.
   at System.Net.HttpWebRequest.GetResponse()
   at OSGeo.MapGuide.MaestroAPI.HttpServerConnection.SetResourceData(String
resourceid, String dataname, ResourceDataType datatype, Stream stream,
StreamCopyProgressDelegate callback) in
c:\working\JenkinsCI\home\slave_win\jobs\Maestro
trunk\workspace\OSGeo.MapGuide.MaestroAPI.Http\HttpServerConnection.cs:line
451
   at
OSGeo.MapGuide.MaestroAPI.PlatformConnectionBase.SetResourceData(String
resourceid, String dataname, ResourceDataType datatype, Stream stream) in
c:\working\JenkinsCI\home\slave_win\jobs\Maestro
trunk\workspace\OSGeo.MapGuide.MaestroAPI\PlatformConnectionBase.cs:line
1214
   at
OSGeo.MapGuide.ObjectModels.FeatureSource.ExtensionMethods.SetConfigurationContent(IFeatureSource
fs, IServerConnection conn, String xmlContent) in
c:\working\JenkinsCI\home\slave_win\jobs\Maestro
trunk\workspace\OSGeo.MapGuide.MaestroAPI\ExtensionMethods.cs:line 218
   at
Maestro.Base.Editor.FsEditorOptionPanel.btnEditConfiguration_Click(Object
sender, EventArgs e) in c:\working\JenkinsCI\home\slave_win\jobs\Maestro
trunk\workspace\Maestro.Base\Editor\FsEditorOptionPanel.cs:line 122
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons
button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
IntPtr wparam, IntPtr lparam)*

Also, the Maestro showed me the differences between Source and Target as
following screen capture:
<http://osgeo-org.1560.x6.nabble.com/file/n5228292/diff.png> 




--
View this message in context: http://osgeo-org.1560.x6.nabble.com/SQL-Server-Spatial-View-Selection-Issue-tp5228068p5228292.html
Sent from the MapGuide Users mailing list archive at Nabble.com.