I am unable to view postgis data when using the data interoperability
extension.
Using:
ArcGIS Desktop 10 Service Pack 2 Build 3200
Data Interoperability Extension Build 6233
This is the error message I get:
Error executing SQL query ('SELECT BOX3D(extent("the_geom")) FROM
"mdb"."PROV2011_proposed"'): 'ERROR: function box3d(box3d_extent) is
not unique
LINE 1: SELECT BOX3D(extent("the_geom")) FROM
"mdb"."PROV2011_propos...
^
HINT: Could not choose a best candidate function. You might need to
add explicit type casts.
Below is the complete log:
2011-05-31 16:55:26| 0.1| 0.0|INFORM|Data Interoperability
(20101013 - Build 6233 - WIN32)
2011-05-31 16:55:26| 0.1| 0.0|INFORM|Feature Manipulation Engine
2010 SP3 (ESRI DESKTOP) (Build 6233)
2011-05-31 16:56:38| 10.7| 10.6|INFORM|Loaded module 'POSTGIS' from
file 'C:\Program Files (x86)\ESRI\Data Interoperability Extension
\plugins/postgis/POSTGIS.dll'
2011-05-31 16:56:38| 10.7| 0.0|INFORM|FME API version of module
'POSTGIS' matches current internal version (3.6 20090807)
2011-05-31 16:56:38| 10.7| 0.0|INFORM|Opening POSTGIS reader for
dataset 'geodb'
2011-05-31 16:56:43| 12.0| 1.3|INFORM|PostgreSQL 8.4.8 on x86_64-pc-
linux-gnu, compiled by GCC gcc-4.5.real (Ubuntu/Linaro 4.5.2-8ubuntu4)
4.5.2, 64-bit
2011-05-31 16:56:43| 12.0| 0.0|INFORM|1.5 USE_GEOS=1 USE_PROJ=1
USE_STATS=1
2011-05-31 16:56:45| 12.0| 0.0|INFORM|PostGIS client encoding:
'LATIN1'
2011-05-31 16:56:45| 12.0| 0.0|INFORM|Using Dynamic Reader
$Revision: 62876 $ ( $Date: 2009-08-27 11:28:55 -0700 (Thu, 27 Aug
2009) $ ) with module POSTGIS to read data from dataset `geodb'
2011-05-31 16:56:48| 12.0| 0.0|INFORM|Reading POSTGIS table:
'mdb.PROV2011_proposed'...
2011-05-31 16:56:51| 13.3| 1.3|INFORM|FME Configuration: Source
coordinate system for reader R_1[POSTGIS] set to `EPSG:4326' as read
from input data
2011-05-31 16:56:54| 15.5| 2.2|INFORM|Coordinate System `EPSG:4326'
parameters: CS_NAME=`LL84' DESC_NM=`WGS84 datum, Latitude-Longitude;
Degrees' DT_NAME=`WGS84' EPSG=`4326' GROUP=`LL' MAP_SCL=`1' PROJ=`LL'
QUAD=`1' SCL_RED=`1' SOURCE=`Mentor Software' UNIT=`DEGREE'
2011-05-31 16:56:54| 15.5| 0.0|INFORM|Coordinate System `EPSG:4326'
as OGC Well Known Text: GEOGCS["WGS84 datum, Latitude-Longitude;
Degrees",DATUM["WGS_1984",SPHEROID["World Geodetic System of 1984, GEM
10C",
6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],P RIMEM["Greenwich",
0],UNIT["degree",0.0174532925199433],AUTHORITY["EPSG","4326"]]
2011-05-31 16:56:54| 15.6| 0.1|INFORM|FME API version of module
'POSTGIS' matches current internal version (3.6 20090807)
2011-05-31 16:56:54| 15.6| 0.0|INFORM|Opening POSTGIS reader for
dataset 'geodb'
2011-05-31 16:56:54| 15.6| 0.0|INFORM|PostgreSQL 8.4.8 on x86_64-pc-
linux-gnu, compiled by GCC gcc-4.5.real (Ubuntu/Linaro 4.5.2-8ubuntu4)
4.5.2, 64-bit
2011-05-31 16:56:54| 15.6| 0.0|INFORM|1.5 USE_GEOS=1 USE_PROJ=1
USE_STATS=1
2011-05-31 16:56:54| 15.6| 0.0|INFORM|PostGIS client encoding:
'LATIN1'
2011-05-31 16:56:54| 15.6| 0.0|INFORM|Successfully closed POSTGIS
database reader
2011-05-31 16:56:54| 15.6| 0.0|INFORM|Merged 1 schema features read
from 1 datasets into 1 resulting feature types
2011-05-31 16:57:04| 17.0| 1.3|ERROR |Error executing SQL query
('SELECT BOX3D(extent("the_geom")) FROM "mdb"."PROV2011_proposed"'):
'ERROR: function box3d(box3d_extent) is not unique
LINE 1: SELECT BOX3D(extent("the_geom")) FROM
"mdb"."PROV2011_propos...
^
HINT: Could not choose a best candidate function. You might need to
add explicit type casts.
'
2011-05-31 16:57:05| 17.2| 0.2|INFORM|Reading POSTGIS table:
'mdb.PROV2011_proposed'...
2011-05-31 16:57:09| 20.2| 3.0|STATS |
POSTGIS::__CollectionTest(TestFactory): Tested 10 input feature(s) --
0 feature(s) passed and 10 feature(s) failed
2011-05-31 16:57:09| 20.2| 0.0|STATS |
POSTGIS::__DeaggCollections(DeaggregateFactory): Split 0 input
feature(s) into 0 point-in-polygon feature(s), 0 donut polygon(s), 0
polygon(s), 0 line(s), 0 point(s), and 0 aggregate(s)
2011-05-31 16:57:09| 20.2| 0.0|STATS |
POSTGIS::__AggregateHomo(AggregateFactory): Combined 0 input
feature(s) into 0 output feature(s), including 0 singleton(s)
2011-05-31 16:57:14| 20.6| 0.5|INFORM|Reading POSTGIS table:
'mdb.PROV2011_proposed'...
2011-05-31 16:57:51| 33.9| 13.2|INFORM|... Last line repeated 10
times ...
2011-05-31 16:57:51| 33.9| 0.0|INFORM|Loaded module 'fmeprompter'
from file 'fmeprompter.dll'