[fdo-users] AutoCAD Map 3D 2010 and FDO PostGIS - problems when generating new geometries

[Astrid Emde]

Hello list,

I am just testing AutoCAD Map 3D 2010 and FDO (OSGeo.PostGIS.3.4 - Logged
FdoPg34L.zip).

(Some month ago I tested AutoCAD Map 3D 2009 with FDO 3.3.)

I have problems to save new objects. AutoCAD reports that "The Objekt
could not be saved" allthough the new object is in my table.

This is what I observe:
1: I have a table with POINTS

This is may Table Schema:

CREATE TABLE fdo.drain_pnt
(
  gid integer NOT NULL DEFAULT nextval('drain_pnt_gid_seq'::regclass),
path_file_dxf character varying,
  file_dxf character varying,
  handle character varying,
  layer character varying,
  block_name character varying,
  rotation double precision,
  radius double precision,
  the_geom geometry,
  CONSTRAINT drain_pnt_pkey PRIMARY KEY (gid),
  CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),
  CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) =
'POINT'::text OR the_geom IS NULL),
  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 31466)
)
WITH OIDS;

* I can load the table in AutoCAD
* I can change attribute of the existing points and move them
* when I add a new point and want to check in the new point, I get the
following warnings:

 german:
 Das Objekt wurde nicht in der Zielobjektquelle gespeichert.
  FdoPostGIS:drain_pnt (0), Rev# <0>
  Objekt konnte nicht eingefügt werden.
  2=Ungültiger Eigenschaftswertname.
  1=FDO-Befehl konnte nicht ausgeführt werden.
  Einige Objekte konnten nicht gespeichert werden.
  Bearbeitungssatz konnte nicht gespeichert werden.

 English (free translation)
 The Objekt could not be saved
   FdoPostGIS:drain_pnt (0), Rev# <0>
   2= invalid attribut value name
   1= FDO-order could not be excecuted
   Some Objects could not be saved

The odd thing is, that when I have a look in the database the new object
is generated in my table. So everything should be ok. Do you have an idea
what could be the problem?


++++++++++++++++++++++++++++++
The acad_fdopostgis.log reports the following:
14:47:54:632 (0x00000B6C) :  	+ the_geom (SRID=31466)
14:47:54:632 (0x00000B6C) :  >>[ExpressionProcessor::ProcessGeometryValue]
14:47:54:632 (0x00000B6C) :   Geometry: POINT (2568006.29821128
5631522.16784554)
14:47:54:632 (0x00000B6C) :   Geometry WKB HEX:
	010100000080C92B26A397434139FBBD8A887B5541
14:47:54:632 (0x00000B6C) :  <<[ExpressionProcessor::ProcessGeometryValue]
14:47:54:632 (0x00000B6C) :  >>[Connection::+PgExecuteCommand]
14:47:54:632 (0x00000B6C) :   SQL:
	INSERT INTO "fdo"."drain_pnt"
(the_geom,path_file_dxf,file_dxf,handle,layer,block_name,rotation,radius)
VALUES
(setsrid(Geometry('010100000080C92B26A397434139FBBD8A887B5541'),31466),'test','test',NULL,NULL,NULL,NULL,NULL)
14:47:54:648 (0x00000B6C) :   Affected tuples: 1
14:47:54:648 (0x00000B6C) :  <<[Connection::+PgExecuteCommand]
14:47:54:648 (0x00000B6C) :  >>[InsertFeatureReader::InsertFeatureReader]
14:47:54:648 (0x00000B6C) :  <<[InsertFeatureReader::InsertFeatureReader]
14:47:54:648 (0x00000B6C) : <<[InsertCommand::+Execute]
############################


Astrid