[Mapbender-users] Error when WMS updatet or add
Christoph Baudson
christoph.baudson at wheregroup.com
Wed Aug 13 04:01:47 EDT 2008
Thanks for your mail, but please attach the zipped XML and not paste it
into the mail. I need the original.
I got a hint from Günther Rieth (thanks) that the error
ERROR: value too
long for type character varying(255)
can be fixed by changing the type of the column "fees" in the table
"wms" like this
MySQL:
ALTER TABLE wms MODIFY fees text;
PostgreSQL:
ALTER TABLE wms ALTER COLUMN fees TYPE text;
This change will most likely be included in Mapbender 2.5
Christoph
vollbotz schrieb:
> the .xml-file:
> -----------
>
> <?xml version="1.0" encoding="UTF-8"?>
> <WMT_MS_Capabilities version="1.1.1">
> <Service>
> <Name>OGC:WMS</Name>
> <Title>RLP VermKV WMS PremiumDOP</Title>
> <Abstract>Dienst für entzerrte Luftbilder: Digitale Orthophotos (DOP) der
> Vermessungs- und Katasterverwaltung Rheinland-Pfalz mit einer
> Bodenauflösung von 20 cm. </Abstract>
> <OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink"
> xlink:type="simple" xlink:href="http://www.vermkv.rlp.de" />
> <ContactInformation>
> <ContactPersonPrimary>
> <ContactPerson>Dr.-Ing. Dierk Deußen</ContactPerson>
> <ContactOrganization>Landesamt für Vermessung und
> Geobasisinformation Rheinland-Pfalz (LVermGeo)</ContactOrganization>
> </ContactPersonPrimary>
> <ContactPosition>Vertrieb</ContactPosition>
> <ContactAddress>
> <AddressType>postal</AddressType>
> <Address>Ferdinand-Sauerbruch-Str. 15</Address>
> <City>Koblenz</City>
> <StateOrProvince>Rheinland-Pfalz</StateOrProvince>
> <PostCode>56073</PostCode>
> <Country>Deutschland</Country>
> </ContactAddress>
> <ContactVoiceTelephone>+49 261 492 0</ContactVoiceTelephone>
> <ContactFacsimileTelephone>+49 261 492 492</ContactFacsimileTelephone>
>
> <ContactElectronicMailAddress>poststelle at lvermgeo.rlp.de</ContactElectronicMailAddress>
> </ContactInformation>
> <Fees>Das Anschauen ("Viewing") des Dienstes in den Online-Anwendungen der
> Vermessungs- und Katasterverwaltung Rheinland-Pfalz sowie im GeoPortal.rlp
> ist kostenfrei. Jede darüber hinaus gehende Nutzung, so auch das Einbinden
> in andere Anwendungen ("Download") ist kostenpflichtig und bedarf einer
> vertraglichen Grundlage. Bitte nehmen Sie dazu Kontakt mit dem LVermGeo
> (www.lvermgeo.rlp.de/indexgeowebdienste.html, Tel.-Nr.: 0261-492-223) auf.
> --------------- Viewing within the online-applications of the Vermessungs-
> und Katasterverwaltung Rheinland-Pfalz or within GeoPortal.rlp is free of
> charge. Any further utilization, such as embedding in other applications
> ("download") is subject to fee and requires a contractual agreement. Please
> contact the LVermGeo for that (www.lvermgeo.rlp.de/indexgeowebdienste.html,
> phone: +49-261-492-223).</Fees>
> <AccessConstraints>
> Sämtliche Rechte an diesem Dienst liegen beim Landesamt für
> Vermessung und Geobasisinformation Rheinland-Pfalz (LVermGeo). Das Anschauen
> ("Viewing") in den Online-Anwendungen der Vermessungs- und
> Katasterverwaltung Rheinland-Pfalz sowie im GeoPortal.rlp ist kostenfrei.
> Jede darüber hinaus gehende Nutzung, so auch das Einbinden in weitere
> Anwendungen ("Download") ist kostenpflichtig und bedarf einer vertraglichen
> Grundlage. Bitte nehmen Sie dazu Kontakt mit dem LVermGeo
> (www.lvermgeo.rlp.de/indexgeowebdienste.html, Tel.-Nr. 0261-492-223) auf.
> --------------- All rights of this service are reserved by Landesamt
> für Vermessung und Geobasisinformation Rheinland-Pfalz (LVermGeo).
> Viewing within the online-applications of the Vermessungs- und
> Katasterverwaltung Rheinland-Pfalz or within GeoPortal.rlp is free of
> charge. Any further utilization, such as embedding in other applications
> ("download") is subject to fee and requires a contractual agreement. Please
> contact the LVermGeo for that (www.lvermgeo.rlp.de/indexgeowebdienste.html,
> phone: +49-261-492-223).
> </AccessConstraints>
> </Service>
> <Capability>
> <Request>
> <GetCapabilities>
> <Format>application/vnd.ogc.wms_xml</Format>
> <Format>text/xml</Format>
> <DCPType>
> <HTTP>
> <Get>
> <OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink"
> xlink:type="simple"
> xlink:href="http://www.geodaten2.rlp/cgi-bin/premiumdop.cgi" />
> </Get>
> </HTTP>
> </DCPType>
> </GetCapabilities>
> <GetMap>
> <Format>image/jpeg</Format>
> <Format>image/png</Format>
> <DCPType>
> <HTTP>
> <Get>
> <OnlineResource xmlns:xlink="http://www.w3.org/1999/xlink"
> xlink:type="simple"
> xlink:href="http://www.geodaten2.rlp/cgi-bin/premiumdop.cgi" />
> </Get>
> </HTTP>
> </DCPType>
> </GetMap>
> <GetFeatureInfo>
> <Format>text/plain</Format>
> <Format>application/vnd.ogc.gml</Format>
> <DCPType>
> <HTTP>
> <Get>
> <OnlineResource
> xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple"
> xlink:href="http://www.geodaten2.rlp/cgi-bin/premiumdop.cgi"/>
> </Get>
> <Post>
> <OnlineResource
> xmlns:xlink="http://www.w3.org/1999/xlink" xlink:type="simple"
> xlink:href="http://www.geodaten2.rlp/cgi-bin/premiumdop.cgi"/>
> </Post>
> </HTTP>
> </DCPType>
> </GetFeatureInfo>
> </Request>
> <Exception>
> <Format>application/vnd.ogc.se_xml</Format>
> <Format>application/vnd.ogc.se_inimage</Format>
> <Format>application/vnd.ogc.se_blank</Format>
> <Format>text/xml</Format>
> </Exception>
> <Layer queryable="1" opaque="0" noSubsets="0">
> <Name>rlp:dop20</Name>
> <Title>VermKV PremiumDOP</Title>
> <SRS>EPSG:25832</SRS>
> <SRS>EPSG:4326</SRS>
> <SRS>EPSG:31466</SRS>
> <SRS>EPSG:31467</SRS>
> <LatLonBoundingBox minx="6.0" miny="48.9" maxx="8.6" maxy="51.0" />
> <BoundingBox SRS="EPSG:4326" minx="6.0" miny="48.9" maxx="8.6" maxy="51.0"
> />
> <BoundingBox SRS="EPSG:25832" minx="32290000" miny="5420000"
> maxx="32470000" maxy="5650000" />
> <BoundingBox SRS="EPSG:31466" minx="2507000" miny="5424000" maxx="2683000"
> maxy="5648000" />
> <BoundingBox SRS="EPSG:31467" minx="3292000" miny="5423000"
> maxx="3465000" maxy="5647000" />
>
> <Layer queryable="0" opaque="1" noSubsets="0">
> <Name>dop20:dop</Name>
> <Title>PremiumDOP</Title>
> <ScaleHint min="0.001" max="1870.0" />
> </Layer>
> <Layer queryable="1" opaque="0" noSubsets="0">
> <Name>dop20:metadop</Name>
> <Title>Metadaten PremiumDOP</Title>
> <ScaleHint min="0.001" max="1870.0" />
> </Layer>
> </Layer>
> </Capability>
> </WMT_MS_Capabilities>
>
>
>
>
>
>
> --------------------------------------------
>
> vollbotz wrote:
>
>> hi list,
>>
>> if i would like to update a wms i got the message:
>>
>> Warning: pg_execute() [function.pg-execute]: Query failed: ERROR: null
>> value in column "wms_version" violates not-null constraint in
>> /usr/local/fgs/www/htdocs/mapbender/http/php/database-pgsql.php on line
>> 176
>> sql error: ERROR: null value in column "wms_version" violates not-null
>> constraint ROLLBACK performed....
>>
>> If i use the [Preview Capabilities] Button on update - it works fine....
>>
>> If i want to add a new wms i got:
>>
>> file:
>> http://www.geodaten2.rlp/cgi-bin/premiumdop.cgi?SERVICE=WMS&VERSION=1.1.1&REQUEST=GetCapabilities
>> Missing parameters:
>>
>> id:
>> version:
>> title:
>> abstract:
>> maprequest:
>> capabilitiesrequest:
>> featureinforequest:
>> gui_wms_mapformat:
>> gui_wms_featureinfoformat:
>> gui_wms_exceptionformat:
>> gui_wms_epsg:
>> wms_srs:
>> gui_wms_visible:
>> gui_wms_opacity:
>> support_sld:
>> wms Object ( [lastURL] => [wms_id] => [wms_status] => [wms_version] =>
>> [wms_title] => [wms_abstract] => [wms_getcapabilities] =>
>> [wms_getcapabilities_doc] => [wms_getmap] => [wms_getfeatureinfo] =>
>> [wms_getlegendurl] => [wms_upload_url] => [fees] => [accessconstraints] =>
>> [contactperson] => [contactposition] => [contactorganization] => [address]
>> => [city] => [stateorprovince] => [postcode] => [country] =>
>> [contactvoicetelephone] => [contactfacsimiletelephone] =>
>> [contactelectronicmailaddress] => [wms_keyword] => Array ( ) [data_type]
>> => Array ( ) [data_format] => Array ( ) [objLayer] => Array ( )
>> [wms_supportsld] => [wms_userlayer] => [wms_userstyle] => [wms_remotewfs]
>> => [gui_wms_mapformat] => [gui_wms_featureinfoformat] =>
>> [gui_wms_exceptionformat] => [gui_wms_epsg] => [gui_wms_sldurl] =>
>> [default_epsg] => 0 [overwrite] => 1 )
>> Data not committed
>>
>> ----------------------------------------------------------
>>
>> if i add a new one by downloading the capabilities.xml i got:
>>
>> file: http://200.1.50.21:8080/mapbender/wms/Luftbild.xml
>> Warning: pg_execute() [function.pg-execute]: Query failed: ERROR: value
>> too long for type character varying(255) in
>> /usr/local/fgs/www/htdocs/mapbender/http/php/database-pgsql.php on line
>> 176
>> sql error: ERROR: value too long for type character varying(255) ROLLBACK
>> performed....
>>
>> -------------------------------------------------------------
>>
>> HMM - if i upload my own created mapfiles it works without any problems...
>> could it be the spelling of the foreign wms ....?
>> really dont know...
>>
>> -------------------------------------------------------------
>>
>> I thing that this problem has happend a few times ago....
>> there you should download a new class_wms.php
>> (i tried this but it wont help)
>>
>>
>>> Does anyonw have an idea ??
>>>
>> - i use mapbender 2.5rc5
>> - postgres 8.3.1
>> - suse linux sls 10
>>
>> Thanks (again) a lot ! V°°
>>
>>
> the xml-file:
>
--
_______________________________________
W h e r e G r o u p GmbH & Co. KG
Siemensstraße 8
53121 Bonn
Germany
Christoph Baudson
Anwendungsentwickler
Fon: +49 (0)228 / 90 90 38 - 15
Fax: +49 (0)228 / 90 90 38 - 11
christoph.baudson at wheregroup.com
www.wheregroup.com
Amtsgericht Bonn, HRA 6788
_______________________________________
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Arnulf Christl, Olaf Knopp, Peter Stamm
_______________________________________
More information about the Mapbender_users
mailing list