Edited data isn't saved

Jun 10, 2012 at 10:15 PM

Hi,

I've downloaded and registered the dataserver. I've created simple metadata to be able to edit my PostGIS-data. I can access the data and I can edit the attribute-data, but the changes I make isn't saved.

When I change some of the attributes and click OK I get a message that says:

------------

ERROR: syntax error at or near "returning"

LINE 1: ...nrammer_forslag set distrikt = $1 where ctid = $2 returning...

-------------

...nrammer_forslag     is a part of the name of the table

distrikt     is the name of the attribute I tried to edit

 

When I click OK in the message-box the Properties window is shown again, and when I click OK again it closes. If I doubleclick the feature again the changes I made is shown. But if I close the connection and opens it again, the changes is gone and the attributes are back to original.

 

When I try the edit the geometry, I get a message that says:

------------

Method '~' og object '~' failed

------------

 

Coordinator
Jun 11, 2012 at 12:25 PM

Hi, what is the actual length of the whole table name? It should not exceed 64 characters in the current version of PostGIS GDO. You can also run the debug version of the dataserver (just rename PostGISGDO.dll to PostGISGDO.dll.release and rename PostGISGDO.dll.debug to PostGISGDO.dll and run GeoMedia again. You don't need to re-register anything. After that, a PostGISGDO.log file should be created in the dll folder. Try to edit an attribute and then check the log file. Some more information about the problem should appear somewhere at the end of the log file.

Pavel

Jun 13, 2012 at 9:39 PM
Hi again,

Here is the log file when I've also tried to edit a geometry.



Med venlig hilsen

Morten Friis
Teamkoordinator for Kortkontoret og Teknisk Stab
Ikast-Brande Kommune
Administrationen Brande
Centerparken 1, 7330 Brande
Tlf. 9960 3320 / 2928 8145



Fra: "pkrejcir" <notifications@codeplex.com>
Til: mofri@ikast-brande.dk
Dato: 11-06-2012 13:25
Emne: Re: Edited data isn't saved [GeoMediaPostGIS:359111]




From: pkrejcir

Hi, what is the actual length of the whole table name? It should not exceed 64 characters in the current version of PostGIS GDO. You can also run the debug version of the dataserver (just rename PostGISGDO.dll to PostGISGDO.dll.release and rename PostGISGDO.dll.debug to PostGISGDO.dll and run GeoMedia again. You don't need to re-register anything. After that, a PostGISGDO.log file should be created in the dll folder. Try to edit an attribute and then check the log file. Some more information about the problem should appear somewhere at the end of the log file.

Pavel

Read the full discussion online.

To add a post to this discussion, reply to this email (GeoMediaPostGIS@discussions.codeplex.com)

To start a new discussion for this project, email GeoMediaPostGIS@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com

Jun 13, 2012 at 9:48 PM
Hi,

I'm not sure, that my first to emails was delivered, so I try again with this one.

I've done what you suggested, but I don't know how I can solve the problem.

I've attached two log files (zipped and renamed *.zp)i. I hope that you can help me. It's very important for me to be able to edit my PostGIS data in GeoMedia.

The log file when I edited an attribute:

The log file when I edited a geometry:


Med venlig hilsen

Morten Friis
Teamkoordinator for Kortkontoret og Teknisk Stab
Ikast-Brande Kommune
Administrationen Brande
Centerparken 1, 7330 Brande
Tlf. 9960 3320 / 2928 8145



Fra: "pkrejcir" <notifications@codeplex.com>
Til: mofri@ikast-brande.dk
Dato: 11-06-2012 13:25
Emne: Re: Edited data isn't saved [GeoMediaPostGIS:359111]




From: pkrejcir

Hi, what is the actual length of the whole table name? It should not exceed 64 characters in the current version of PostGIS GDO. You can also run the debug version of the dataserver (just rename PostGISGDO.dll to PostGISGDO.dll.release and rename PostGISGDO.dll.debug to PostGISGDO.dll and run GeoMedia again. You don't need to re-register anything. After that, a PostGISGDO.log file should be created in the dll folder. Try to edit an attribute and then check the log file. Some more information about the problem should appear somewhere at the end of the log file.

Pavel

Read the full discussion online.

To add a post to this discussion, reply to this email (GeoMediaPostGIS@discussions.codeplex.com)

To start a new discussion for this project, email GeoMediaPostGIS@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com

Coordinator
Jun 14, 2012 at 6:52 AM

Hi Morten,

I have received no e-mail. Please try to contact me again without any attachments and I will reply.

Thanks, Pavel

Jun 14, 2012 at 8:28 AM

I opened yesterday a issue on the same problem :  link

Jun 15, 2012 at 9:13 AM
Hi,

I've done what you suggested, but I don't know how I can solve the problem.

It's very important for me to be able to edit my PostGIS data in GeoMedia, so I hope you can help me.

When I try to edit attribute data the log file shows this at the end of the file:

--------------------
.........
GTDField::get_Name
GField::get_Required
GField::get_SourceTable
GField::get_SourceField
GDatabase::get_GTableDefs
GTableDefs::get_Item
index: "testdata.kommuneplanrammer_forslag"
GTableDef::get_GFields
_IGCollection::get_Count
GTDFields::get_Item
index: "pl_nr_navn"
GTDField::get_Type
Type: 10
GTableDef::get_GIndexes
GIndexes::get_Item
index: 0
GIndex::get_Primary
GIndexes::get_Item
index: 1
GIndex::get_Primary
GIndex::get_Unique
GIndex::get_GFields
_IGCollection::get_Count
GTDFields::get_Item
index: 0
GTDField::get_Name
GField::get_Size
GField::get_Type
GField::set_Value
Field name: distrikt
Value: "Det aabne land - test test test test test"
VType: 8
GRecordset::get_Updatable
GRecordset::get_EditMode
GRecordset::Update
update testdata.kommuneplanrammer_forslag set distrikt = $1 where ctid = $2 returning ctid
GErrors::HandlePQError
Message: ERROR: syntax error at or near "returning"
LINE 1: ...nrammer_forslag set distrikt = $1 where ctid = $2 returning ...
^

GDatabase::get_GErrors
_IGCollection::get_Count
GDatabase::get_GErrors
GErrors::get_Item
GError::get_Description

--------------------



When I try to edit a geometry the log file shows this at the end of the file:

--------------------
.........
GField::get_Name
GField::get_Name
GRecordset::set_Bookmark
GRecordset::GetExtension
Name: FeatureClass
GRecordset::GetExtension
Name: FeatureClass
GField::get_SourceTable
GDatabase::get_GTableDefs
GTableDefs::get_Item
index: "testdata.kommuneplanrammer_forslag"
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GField::get_Name
GRecordset::Edit
GField::set_Value
Field name: wkb_geometry
Value: Unknown type: 8209
VType: 8209
GRecordset::Update
update testdata.kommuneplanrammer_forslag set distrikt = $1, wkb_geometry = $2 where ctid = $3 returning ctid
GErrors::HandlePQError
Message: ERROR: syntax error at or near "returning"
LINE 1: ... distrikt = $1, wkb_geometry = $2 where ctid = $3 returning ...
^

--------------------


Regards,

Morten Friis
Teamkoordinator for Kortkontoret og Teknisk Stab
Ikast-Brande Kommune
Administrationen Brande
Centerparken 1, 7330 Brande
Tlf. 9960 3320 / 2928 8145



Fra: "pkrejcir" <notifications@codeplex.com>
Til: mofri@ikast-brande.dk
Dato: 14-06-2012 07:52
Emne: Re: Edited data isn't saved [GeoMediaPostGIS:359111]




From: pkrejcir

Hi Morten,

I have received no e-mail. Please try to contact me again without any attachments and I will reply.

Thanks, Pavel

Read the full discussion online.

To add a post to this discussion, reply to this email (GeoMediaPostGIS@discussions.codeplex.com)

To start a new discussion for this project, email GeoMediaPostGIS@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com

Coordinator
Jun 18, 2012 at 3:49 PM

The last log is not from the latest version of PostGIS GDO. Please update the software and try it again.

Pavel

Jun 22, 2012 at 9:26 PM
I've downloaded the latest version and registered it. But now GeoMedia Pro crashes when I click "Add Legend Entries"

This is the log file:

DllGetClassObject
CPostGISClassFactory::CreateInstance
GDatabase::OpenDatabase
Name: srvikgis02
Source: "k756_test/k756_test@k756_test"
trying to connect with: host=srvikgis02 dbname=k756_test user=k756_test password=k756_test
DB Encoding:
Numeric: 8
Name: LATIN1
GDatabase::get_GAliasTable
GDatabase::GetExtension
Name: FeatureModel
GDatabase::ClearModificationLog
GDatabase::GetExtension
Name: ExtendedPropertySet
DBExtendedPropertySet::GetValue
Name: SessionID
GDatabase::get_GAliasTable
GDatabase::GetExtension
Name: ExtendedPropertySet
DBExtendedPropertySet::GetValue
Name: ConnectPropertyIsDynamic
GDatabase::get_GTableDefs
_IGCollection::get_Count
GTableDefs::get_Item
index: 0



Med venlig hilsen

Morten Friis
Teamkoordinator for Kortkontoret og Teknisk Stab
Ikast-Brande Kommune
Administrationen Brande
Centerparken 1, 7330 Brande
Tlf. 9960 3320 / 2928 8145



Fra: "pkrejcir" <notifications@codeplex.com>
Til: mofri@ikast-brande.dk
Dato: 18-06-2012 16:49
Emne: Re: Edited data isn't saved [GeoMediaPostGIS:359111]




From: pkrejcir

The last log is not from the latest version of PostGIS GDO. Please update the software and try it again.

Pavel

Read the full discussion online.

To add a post to this discussion, reply to this email (GeoMediaPostGIS@discussions.codeplex.com)

To start a new discussion for this project, email GeoMediaPostGIS@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe on CodePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at CodePlex.com

Coordinator
Jul 6, 2012 at 2:58 PM

Try to drop the metadata and recreate them using the PostGIS GDO Database Utilities. Pavel