[Geoserver-users] Duplicate AttributeTypes

GeoServer GeoServer User
1

Hi,

I tried to follow the tutorial to add a new Shapefile to geoserver. After
selecting my new shapefile I always got the following error:

Duplicate AttributeTypes

DefaultAttributeType [name=ID , type=class java.lang.Long , nillable=true,
min=1, max=1]

Googleing for this error brought me here:
http://jira.codehaus.org/browse/GEOS-584 with the explanation:

"A "duplicate attribute types" error is encountered when attempting to add a
new feature type that exists in multiple Oracle schemas in the same
database. The user must have security permissions to select the metadata for
both tables."

I logged in using admin/geoserver, so I think I have all needed security
permissions?

I am using latest geoserver v1.5.1
--
View this message in context: http://www.nabble.com/Duplicate-AttributeTypes-tf4136526.html#a11764990
Sent from the GeoServer - User mailing list archive at Nabble.com.

2

Hmmm... I've not seen that error with shapefiles ever. What OS are you working on? Any chance you can send us the shapefile to test with?

It also might have something to do with ID being the name of one of the attributes, like we may already use that or something?

Chris

Salke wrote:

Hi,

I tried to follow the tutorial to add a new Shapefile to geoserver. After
selecting my new shapefile I always got the following error:

Duplicate AttributeTypes

DefaultAttributeType [name=ID , type=class java.lang.Long , nillable=true,
min=1, max=1]

Googleing for this error brought me here:
http://jira.codehaus.org/browse/GEOS-584 with the explanation:

"A "duplicate attribute types" error is encountered when attempting to add a
new feature type that exists in multiple Oracle schemas in the same
database. The user must have security permissions to select the metadata for
both tables."

I logged in using admin/geoserver, so I think I have all needed security
permissions?

I am using latest geoserver v1.5.1

3

Here's one shapefile that doesn't work, but it seems that I can't add any
additional files, it's really strange. Geoserver runs on WinXP SP2.
Hopefully you can find out what's the problem, but I believe the shapefile
will work fine on your testing servers :frowning:

http://www.nabble.com/file/p11863828/parkareas.rar parkareas.rar

Chris Holmes wrote:

Hmmm... I've not seen that error with shapefiles ever. What OS are you
working on? Any chance you can send us the shapefile to test with?

It also might have something to do with ID being the name of one of the
attributes, like we may already use that or something?

Chris

Salke wrote:

Hi,

I tried to follow the tutorial to add a new Shapefile to geoserver. After
selecting my new shapefile I always got the following error:

Duplicate AttributeTypes

DefaultAttributeType [name=ID , type=class java.lang.Long ,
nillable=true,
min=1, max=1]

Googleing for this error brought me here:
http://jira.codehaus.org/browse/GEOS-584 with the explanation:

"A "duplicate attribute types" error is encountered when attempting to
add a
new feature type that exists in multiple Oracle schemas in the same
database. The user must have security permissions to select the metadata
for
both tables."

I logged in using admin/geoserver, so I think I have all needed security
permissions?

I am using latest geoserver v1.5.1

begin:vcard
fn:Chris Holmes
n:Holmes;Chris
org:The Open Planning Project
adr:;;349 W. 12th Street, #3;New York;NY;10014;USA
email;internet:cholmes@anonymised.com
title:Managing Director, Strategic Development
x-mozilla-html:FALSE
url:http://topp.openplans.org
version:2.1
end:vcard

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
View this message in context: http://www.nabble.com/Duplicate-AttributeTypes-tf4136526.html#a11863828
Sent from the GeoServer - User mailing list archive at Nabble.com.

4

Salke ha scritto:

Here's one shapefile that doesn't work, but it seems that I can't add any
additional files, it's really strange. Geoserver runs on WinXP SP2.
Hopefully you can find out what's the problem, but I believe the shapefile
will work fine on your testing servers :frowning:

http://www.nabble.com/file/p11863828/parkareas.rar parkareas.rar

Hi,
I downloaded the file and tried it out, and I can confirm it's broken,
at least from the GeoServer/GeoTools point of view.
The DBF has duplicate attributes for good, it has two ID and two NAME
fields, and unfortunately our feature model is strict and does not
allow that.

See for yourself with this screenshot I took from QGIS, which has a less
strict operation mode and allows for duplicated attributes (attached).

Anyways, no all is lost. I opened the dbf with OpenOffice Calc, removed
the two extra columns, and saved it again (you can do the same with Excel). Then I could show the file contents just fine.

Cheers
Andrea

attributes.jpg