The requested operation could not be performed.
PSQLException : ERROR: column "owner" is of type integer but expression is
of type character varying Hint: You will need to rewrite or cast the
expression. Position: 27
Any hints for such a message?
Arto
Hi Arto, Could you provide the full error message from the log file ?
Thanks.
Francois
2010/6/25 Arto Vuorela <arto.k.vuorela@anonymised.com>:
The requested operation could not be performed.
PSQLException : ERROR: column "owner" is of type integer but expression is
of type character varying Hint: You will need to rewrite or cast the
expression. Position: 27
Any hints for such a message?
Arto
------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
Sure. This is from geonetwork.log. Selected the first Searched record
and tried to change the owner...
2010-07-09 15:19:50,468 INFO [jeeves.request] -
2010-07-09 15:19:50,468 INFO [jeeves.request] - HTML Request (from
192.168.0.136) : /geonetwork/srv/en/metadata.select
2010-07-09 15:19:50,468 DEBUG [jeeves.request] - Method : GET
2010-07-09 15:19:50,468 DEBUG [jeeves.request] - Content type : null
2010-07-09 15:19:50,468 DEBUG [jeeves.request] - Accept :
text/javascript, text/html, application/xml, text/xml, */*
2010-07-09 15:19:50,468 DEBUG [jeeves.request] - Session id is
3BBCD06BE4B370DE821C816B2758F5DA
2010-07-09 15:19:50,468 INFO [jeeves.service] - Dispatching : metadata.select
2010-07-09 15:19:50,468 DEBUG [jeeves.service] - -> parameters are :
<request>
<selected>add</selected>
<id>50ebbf3c-b96c-42d1-8252-d9296dde46c3</id>
</request>
2010-07-09 15:19:50,468 INFO [jeeves.service] - -> dispatching to
output for : metadata.select
2010-07-09 15:19:50,468 INFO [jeeves.service] - -> writing xml
for : metadata.select
2010-07-09 15:19:50,468 DEBUG [jeeves.service] - Service xml is :
<response>
<Selected>1</Selected>
</response>
2010-07-09 15:19:50,468 INFO [jeeves.service] - -> output ended
for : metadata.select
2010-07-09 15:19:50,468 INFO [jeeves.service] - -> dispatch ended
for : metadata.select
2010-07-09 15:19:54,656 INFO [jeeves.request] -
2010-07-09 15:19:54,656 INFO [jeeves.request] - HTML Request (from
192.168.0.136) : /geonetwork/srv/en/metadata.massive.newowner.form
2010-07-09 15:19:54,656 DEBUG [jeeves.request] - Method : GET
2010-07-09 15:19:54,656 DEBUG [jeeves.request] - Content type : null
2010-07-09 15:19:54,656 DEBUG [jeeves.request] - Accept :
text/javascript, text/html, application/xml, text/xml, */*
2010-07-09 15:19:54,656 DEBUG [jeeves.request] - Session id is
3BBCD06BE4B370DE821C816B2758F5DA
2010-07-09 15:19:54,656 INFO [jeeves.service] - Dispatching :
metadata.massive.newowner.form
2010-07-09 15:19:54,656 DEBUG [jeeves.service] - -> no input parameters
2010-07-09 15:19:54,656 INFO [jeeves.service] - -> dispatching to
output for : metadata.massive.newowner.form
2010-07-09 15:19:54,656 INFO [jeeves.service] - -> transforming
with stylesheet : C:\Tomcat\Tomcat
6.0\webapps\geonetwork\/xsl/metadata-massiveownership.xsl
2010-07-09 15:19:54,687 INFO [jeeves.service] - -> end
transformation for : metadata.massive.newowner.form
2010-07-09 15:19:54,687 INFO [jeeves.service] - -> output ended
for : metadata.massive.newowner.form
2010-07-09 15:19:54,687 INFO [jeeves.service] - -> dispatch ended
for : metadata.massive.newowner.form
2010-07-09 15:19:58,765 INFO [jeeves.request] -
2010-07-09 15:19:58,765 INFO [jeeves.request] - HTML Request (from
192.168.0.136) : /geonetwork/srv/en/xml.usergroups.list
2010-07-09 15:19:58,765 DEBUG [jeeves.request] - Method : POST
2010-07-09 15:19:58,765 DEBUG [jeeves.request] - Content type :
application/xml; charset=UTF-8
2010-07-09 15:19:58,765 DEBUG [jeeves.request] - Accept :
text/javascript, text/html, application/xml, text/xml, */*
2010-07-09 15:19:58,765 DEBUG [jeeves.request] - Session id is
3BBCD06BE4B370DE821C816B2758F5DA
2010-07-09 15:19:58,765 INFO [jeeves.service] - Dispatching :
xml.usergroups.list
2010-07-09 15:19:58,765 DEBUG [jeeves.service] - -> parameters are :
<request>
<id>4</id>
</request>
2010-07-09 15:19:58,765 INFO [jeeves.service] - -> dispatching to
output for : xml.usergroups.list
2010-07-09 15:19:58,765 INFO [jeeves.service] - -> writing xml
for : xml.usergroups.list
2010-07-09 15:19:58,765 DEBUG [jeeves.service] - Service xml is :
<groups>
<group>
<id>3</id>
<name>DoSUP</name>
<description>This is the group representing all sections of
Department Surveys and Urban Planning under the Ministry of Water,
Contractions, Energy and Lands in Zanzibar</description>
</group>
</groups>
2010-07-09 15:19:58,765 INFO [jeeves.service] - -> output ended
for : xml.usergroups.list
2010-07-09 15:19:58,765 INFO [jeeves.service] - -> dispatch ended
for : xml.usergroups.list
2010-07-09 15:20:00,375 INFO [jeeves.request] -
2010-07-09 15:20:00,375 INFO [jeeves.request] - HTML Request (from
192.168.0.136) : /geonetwork/srv/en/metadata.massive.newowner
2010-07-09 15:20:00,375 DEBUG [jeeves.request] - Method : GET
2010-07-09 15:20:00,375 DEBUG [jeeves.request] - Content type : null
2010-07-09 15:20:00,375 DEBUG [jeeves.request] - Accept :
text/javascript, text/html, application/xml, text/xml, */*
2010-07-09 15:20:00,375 DEBUG [jeeves.request] - Session id is
3BBCD06BE4B370DE821C816B2758F5DA
2010-07-09 15:20:00,375 INFO [jeeves.service] - Dispatching :
metadata.massive.newowner
2010-07-09 15:20:00,375 DEBUG [jeeves.service] - -> parameters are :
<request>
<group>3</group>
<user>4</user>
</request>
2010-07-09 15:20:00,375 INFO
[jeeves.webapp.metadata.massive.newowner] - Get selected metadata
2010-07-09 15:20:00,375 INFO
[jeeves.webapp.metadata.massive.newowner] - Attempting to set metadata
owner on: 41
2010-07-09 15:20:00,562 ERROR [jeeves.service] - Exception when
executing service
2010-07-09 15:20:00,562 ERROR [jeeves.service] - (C) Exc :
org.postgresql.util.PSQLException: ERROR: column "owner" is of type
integer but expression is of type character varying
Hint: You will need to rewrite or cast the expression.
Position: 27
2010-07-09 15:20:00,562 DEBUG [jeeves.service] - Raised exception
while executing service
<error id="error">
<message>ERROR: column "owner" is of type integer but expression is
of type character varying
Hint: You will need to rewrite or cast the expression.
Position: 27</message>
<class>PSQLException</class>
<stack>
<at class="org.postgresql.core.v3.QueryExecutorImpl"
file="QueryExecutorImpl.java" line="2062"
method="receiveErrorResponse" />
<at class="org.postgresql.core.v3.QueryExecutorImpl"
file="QueryExecutorImpl.java" line="1795" method="processResults" />
<at class="org.postgresql.core.v3.QueryExecutorImpl"
file="QueryExecutorImpl.java" line="257" method="execute" />
<at class="org.postgresql.jdbc2.AbstractJdbc2Statement"
file="AbstractJdbc2Statement.java" line="479" method="execute" />
<at class="org.postgresql.jdbc2.AbstractJdbc2Statement"
file="AbstractJdbc2Statement.java" line="367"
method="executeWithFlags" />
<at class="org.postgresql.jdbc2.AbstractJdbc2Statement"
file="AbstractJdbc2Statement.java" line="321" method="executeUpdate"
/>
<at class="jeeves.resources.dbms.Dbms" file="???" line="-1"
method="execute" />
<at class="org.fao.geonet.kernel.DataManager" file="???" line="-1"
method="updateMetadataOwner" />
<at class="org.fao.geonet.kernel.DataManager" file="???" line="-1"
method="updateMetadataOwner" />
<at class="org.fao.geonet.services.metadata.MassiveNewOwner"
file="???" line="-1" method="exec" />
</stack>
<request>
<language>en</language>
<service>metadata.massive.newowner</service>
</request>
</error>
2010-07-09 15:20:00,562 INFO [jeeves.service] - -> dispatching to
error for : metadata.massive.newowner
2010-07-09 15:20:00,562 INFO [jeeves.service] - -> transforming
with stylesheet : C:\Tomcat\Tomcat
6.0\webapps\geonetwork\/xsl/error.xsl
2010-07-09 15:20:00,578 INFO [jeeves.service] - -> end error
transformation for : metadata.massive.newowner
2010-07-09 15:20:00,578 INFO [jeeves.service] - -> error ended for
: metadata.massive.newowner
2010-07-09 15:20:05,796 INFO [jeeves.request] -
2010-07-09 15:20:05,796 INFO [jeeves.request] - HTML Request (from
192.168.0.136) : /geonetwork/srv/en/user.logout
2010-07-09 15:20:05,796 DEBUG [jeeves.request] - Method : POST
2010-07-09 15:20:05,796 DEBUG [jeeves.request] - Content type :
application/x-www-form-urlencoded
2010-07-09 15:20:05,796 DEBUG [jeeves.request] - Accept :
text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
2010-07-09 15:20:05,796 DEBUG [jeeves.request] - Session id is
3BBCD06BE4B370DE821C816B2758F5DA
2010-07-09 15:20:05,796 INFO [jeeves.service] - Dispatching : user.logout
2010-07-09 15:20:05,796 DEBUG [jeeves.service] - -> no input parameters
2010-07-09 15:20:05,796 INFO [jeeves.service] - -> dispatching to
output for : user.logout
2010-07-09 15:20:05,796 INFO [jeeves.service] - -> forwarding to : main.home
2010-07-09 15:20:05,796 INFO [jeeves.service] - Dispatching : main.home
2010-07-09 15:20:05,796 DEBUG [jeeves.service] - -> parameters are :
<request>
<forward service="user.logout" />
</request>
2010-07-09 15:20:05,796 INFO [jeeves.service] - -> dispatching to
output for : main.home
2010-07-09 15:20:05,937 INFO [jeeves.service] - -> transforming
with stylesheet : C:\Tomcat\Tomcat
6.0\webapps\geonetwork\/xsl/main-page.xsl
2010-07-09 15:20:06,093 INFO [jeeves.service] - -> end
transformation for : main.home
2010-07-09 15:20:06,093 INFO [jeeves.service] - -> output ended
for : main.home
2010-07-09 15:20:06,093 INFO [jeeves.service] - -> dispatch ended
for : main.home
We have a database created using the PostGIS template in PostgreSQL,
and Tomcat web server.
Arto
2010/7/6, Francois Prunayre:
Hi Arto, Could you provide the full error message from the log file ?
Thanks.
Francois
2010/6/25 Arto Vuorela:
The requested operation could not be performed.
PSQLException : ERROR: column "owner" is of type integer but expression is
of type character varying Hint: You will need to rewrite or cast the
expression. Position: 27
Any hints for such a message?
Arto
The initially installed 2.4.2 we had updated to the newest 2.4.3, and
some things that did not work reliably in the previous worked in the latter
(e.g. saving the record no more got stuck). Then why not this if the new
version was updated succesfully? The source code we haven't in use.
Arto
2010/7/12 Francois Prunayre
Not sure which version you're using but it looks to be fixed in :
http://osgeo-org.1803224.n2.nabble.com/GeoNetwork-opensource-Developer-website-166-bug-in-massive-ownership-transfer-td3904616.html#a3904624
Francois
...