Problem with MapGuide and Oracle Spatial (FDOKingOracle) in linux

[rafael]

In last version, the FDO KingOracle crashed and the MapGuide shutdown when I tried to use the FDOKingOracle in Linux. I tried with this beta and, apparently, the problem continues.

[zspitzer]

Can you describe

1. the version of oracle you are using
2. the dataset you testing against,
3. How far you got, ie some data displayed or it crashed trying to author a layer?

& attach any errors logs from the server

[rafael]

Can you describe

1. the version of oracle you are using

Oracle client 11.2 Oracle Server 10.2 I changed the providers.xml and add:

<FeatureProvider>

<Name>OSGeo.KingOracle.3.5</Name> <DisplayName>OSGeo FDO Provider for Oracle</DisplayName> <Description>Read/write access to spatial and attribute data in an Oracle.</Description> <IsManaged>False</IsManaged> <Version>3.5.0.0</Version> <FeatureDataObjectsVersion>3.5.0.0</FeatureDataObjectsVersion> <LibraryPath>libKingOracleProvider.so</LibraryPath>

</FeatureProvider>

2. the dataset you testing against,

Oracle Spatial tables. (SDO)

3. How far you got, ie some data displayed or it crashed trying to author a layer? The first problem I found. It was missing the lib libaio.so. Now LDD is OK rafael@ubuntu:/usr/local/fdo-3.5.0/lib$ ldd -r libKingOracleOverrides-3.5.0.so

linux-gate.so.1 => (0x00aa5000) libFDO-3.5.0.so => /usr/local/fdo-3.5.0/lib/libFDO-3.5.0.so (0x00110000) libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x00484000) libm.so.6 => /lib/tls/i686/cmov/libm.so.6 (0x0097f000) libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0x00576000) libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x006ba000) libxalan-c.so => /usr/local/fdo-3.5.0/lib/libxalan-c.so (0xb73e7000) libxalanMsg.so.17 => /usr/local/fdo-3.5.0/lib/libxalanMsg.so.17 (0x009b4000) libxerces-c.so.25 => /usr/local/fdo-3.5.0/lib/libxerces-c.so.25 (0xb702f000) libpthread.so.0 => /lib/tls/i686/cmov/libpthread.so.0 (0x007cc000) libdl.so.2 => /lib/tls/i686/cmov/libdl.so.2 (0x00e5e000) /lib/ld-linux.so.2 (0x00891000) rafael@ubuntu:/usr/local/fdo-3.5.0/lib$ ldd -r libKingOracleProvider-3.5.0.so linux-gate.so.1 => (0x00889000) libKingOracleOverrides-3.5.0.so => /usr/local/fdo-3.5.0/lib/libKingOracleOverrides-3.5.0.so (0x00be3000) libFDO-3.5.0.so => /usr/local/fdo-3.5.0/lib/libFDO-3.5.0.so (0x00110000) libocci.so.11.1 => /usr/local/oracle/instantclient_11_2/libocci.so.11.1 (0x00a4b000) libclntsh.so.11.1 => /usr/local/oracle/instantclient_11_2/libclntsh.so.11.1 (0xb5bf1000) libociei.so => /usr/local/oracle/instantclient_11_2/libociei.so (0xb06b4000) libnnz11.so => /usr/local/oracle/instantclient_11_2/libnnz11.so (0x005c5000) libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x00484000) libm.so.6 => /lib/tls/i686/cmov/libm.so.6 (0x00e9c000) libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0x0088a000) libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00576000) libxalan-c.so => /usr/local/fdo-3.5.0/lib/libxalan-c.so (0x00ec2000) libxalanMsg.so.17 => /usr/local/fdo-3.5.0/lib/libxalanMsg.so.17 (0x00594000) libxerces-c.so.25 => /usr/local/fdo-3.5.0/lib/libxerces-c.so.25 (0xb02ed000) libpthread.so.0 => /lib/tls/i686/cmov/libpthread.so.0 (0x00812000) libdl.so.2 => /lib/tls/i686/cmov/libdl.so.2 (0x0059c000) libnsl.so.1 => /lib/tls/i686/cmov/libnsl.so.1 (0x0082b000) libaio.so.1 => /lib/libaio.so.1 (0x005a0000) /lib/ld-linux.so.2 (0x005a8000)

Now when I try to connect this was showed in error file: <2010-06-02T14:05:34> -1395135632 MapGuide Maestro v2.0.0.4650 127.0.0.1

Error: Session has expired or is invalid. Please log in again. StackTrace:

• MgSiteServiceHandler.ProcessOperation() line 83 file SiteServiceHandler.cpp
• MgOpAuthenticate.Execute() line 107 file OpAuthenticate.cpp
• MgServerSiteService.Authenticate() line 709 file ServerSiteService.cpp
• MgSecurityManager.Authenticate() line 224 file SecurityManager.cpp
• MgSessionCache.GetSessionInfo() line 175 file SessionCache.cpp

<2010-06-02T14:07:07> -1366713488 MapGuide Maestro v2.0.0.4650 127.0.0.1 Administrator

Error: An exception occurred in FDO component.

CLNT_8_UNABLE_TO_LOAD_LIBRARY

StackTrace:

• MgFeatureServiceHandler.ProcessOperation() line 83 file FeatureServiceHandler.cpp
• MgOpTestFeatureSourceConnection.Execute() line 100 file OpTestFeatureSourceConnection.cpp
• MgServerFeatureService.TestConnection() line 233 file ServerFeatureService.cpp
• MgFdoConnectionManager.Open() line 308 file FdoConnectionManager.cpp

<2010-06-02T14:07:28> -1375134864 MapGuide Maestro v2.0.0.4650 127.0.0.1 Administrator

Error: An exception occurred in FDO component.

CLNT_8_UNABLE_TO_LOAD_LIBRARY

StackTrace:

• MgFeatureServiceHandler.ProcessOperation() line 83 file FeatureServiceHandler.cpp
• MgOpTestFeatureSourceConnection.Execute() line 100 file OpTestFeatureSourceConnection.cpp
• MgServerFeatureService.TestConnection() line 233 file ServerFeatureService.cpp
• MgFdoConnectionManager.Open() line 308 file FdoConnectionManager.cpp

<2010-06-02T14:15:27> -1217176736

Success: Server stopped.

[zspitzer]

32 bit or 64 bit? which os & version are your running?

[gkobluk]

I try in both 32 bit and 64 bit. Ubuntu 9, Centos 5.3 and it's the same: when I create a new data connection I get CLNT_8_UNABLE_TO_LOAD_LIBRARY. And there is nothing to do to change this.

[tomfukushima]

Try setting NLSPATH to /usr/local/fdo-3.5.0/nls/%N and then try running the error again. This may give you a more useful error message. See FDO ticket ​http://trac.osgeo.org/fdo/ticket/640 for details. Tom

[gkobluk]

Maybe setting NLSPATH has no relation with this message but maybe can tell us somthing more:

(2861513584) An exception occurred in FDO component. Failed to retrieve the third party exception mesage. This message may not be unicode compliant

Linux: Linux mrhyde 2.6.32-25-generic-pae #45-Ubuntu SMP Sat Oct 16 21:01:33 UTC 2010 i686 GNU/Linux

[gkobluk]

I forgot send stacktrace from Error.log too:

<2010-11-14T19:11:34> -1432401040 MapGuide Maestro v2.0.0.4650 127.0.0.1 Administrator

Error: An exception occurred in FDO component.

Failed to retrieve the third party exception mesage. This message may not be unicode compliant.

StackTrace:

• MgFeatureServiceHandler.ProcessOperation() line 83 file FeatureServiceHandler.cpp
• MgOpTestFeatureSourceConnection.Execute() line 100 file OpTestFeatureSourceConnection.cpp
• MgServerFeatureService.TestConnection() line 233 file ServerFeatureService.cpp
• MgFdoConnectionManager.Open() line 948 file FdoConnectionManager.cpp

<2010-11-14T19:13:02> -1277126896

I hope to be useful.

[tomfukushima]

CC'ng Haris to see if he has any ideas on how to help resolve this.

[zspitzer]

importantly, you need to have your fdo, oracle client and mapguide server to be all the same, ie all 64-bit or 32-bit, mix and it will not work