[mapguide-users] New King.Oracle 0.8 - improved performance

[Haris Kurtagic]

Hi,

It looks like King.Oracle 0.8.x has problems in DescribeSchema in some
cases.
I will try to solve in next couple of days.
Your input could help me to faster find point of error.
Do you use KinfFdoClass  table ?
Do you use OracleSchema connection property (to use tables from only one
owner) ?
And if so is it same owner as the username you use to connect to
database ?
You already told so, but to recheck it is same for 9.2 and 10g ?

If you could isolate problem to one particular table and send me SQL to
recreate that table, that could help.

Thanks,
Haris

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of born2bwild
Sent: Monday, December 08, 2008 2:53 PM
To: mapguide-users at lists.osgeo.org
Subject: Re: [mapguide-users] New King.Oracle 0.8 - improved performance


Hi and sorry for my poor english,

MGOS 2.0.2

All work fine with king oracle 0.7.4 but, I've a problem with new king
oracle 0.8.5 on Maestro, when i want to select a feature source for a
layer
(i've tested with oracle 9.2i and 10g and instant client from 10.1 to
10.2)
i've always got this error message :

"Failed to read schema from data source. Thet operation gave the error
massage : (559) MgFdoException : An Excetion occured in FDO component.
ORA-00933:SQL command not properly ended
Exception occured in method MgServerDescribeSchema.ExecuteDescribeSchema
at
line 176 in file
d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services
\feature\ServerDescribeSchema.cpp"
"

In the log file, there is :

Error: An exception occurred in FDO component.
        ORA-00933: SQL command not properly ended
 StackTrace:
  - MgFeatureServiceHandler.ProcessOperation line 83 file
d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services
\feature\FeatureServiceHandler.cpp
  - MgOpDescribeSchemaAsXml.Execute line 105 file
d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services
\feature\OpDescribeSchemaAsXml.cpp
  - MgServerDescribeSchema.DescribeSchemaAsXml line 607 file
d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services
\feature\ServerDescribeSchema.cpp
  - MgServerDescribeSchema.DescribeSchema line 564 file
d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services
\feature\ServerDescribeSchema.cpp
  - MgServerDescribeSchema.ExecuteDescribeSchema line 176 file
d:\build\mapguide_open_source_v2.0\build_30.11\mgdev\server\src\services
\feature\ServerDescribeSchema.cpp
An exception occurred in FDO component.
ORA-00933: SQL command not properly ended



Thanks

-- 
View this message in context:
http://n2.nabble.com/New-King.Oracle-0.8---improved-performance-tp151912
0p1629093.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users