Opened 8 years ago

Closed 6 years ago

#1369 closed defect (fixed)

Problem with MapGuide and Oracle Spatial (FDOKingOracle) in linux

Reported by: rafael Owned by:
Priority: high Milestone: 2.5
Component: General Version: 2.2.0
Severity: critical Keywords: FDO Oracle linux
Cc: gkobluk, haris External ID:

Description

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.

Change History (11)

comment:1 Changed 8 years ago by 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

comment:2 Changed 8 years ago by 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?>

  1. the dataset you testing against,

Oracle Spatial tables. (SDO)

  1. 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?:

<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?:

<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?:

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

Success: Server stopped.

comment:3 Changed 8 years ago by zspitzer

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

comment:4 Changed 8 years ago by gkobluk

Cc: gkobluk added

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.

comment:5 Changed 8 years ago by 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

comment:6 Changed 8 years ago by 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

comment:7 Changed 8 years ago by 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?:

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

I hope to be useful.

comment:8 Changed 8 years ago by tomfukushima

Cc: haris added

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

comment:9 Changed 8 years ago by 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

comment:10 Changed 6 years ago by jng

Milestone: 2.22.5

comment:11 Changed 6 years ago by jng

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.