<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">Hi Tomas,</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">Thank you for the report.</div>
<div class="moz-cite-prefix">I will try to reproduce the error and
provide some feedback.</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">Cheers,</div>
<div class="moz-cite-prefix">Angelos<br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">On 12/4/18 1:30 AM, Tomas Kliment
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAFTCg308=CBPqpt_8fXHnaP5bqR0atVKKSn21i5rJ18Lqy4-BA@mail.gmail.com">
<pre class="moz-quote-pre" wrap="">Dear devs,
I have deployed the latest version of pycsw from docker repo.
The service is running from here: <a class="moz-txt-link-freetext" href="https://klimeto.com/services/pycsw/latest">https://klimeto.com/services/pycsw/latest</a>
I would like to use it as CSW harvesting engine.
However I discovered problems with harvesting the following 2 CSWs:
[1]
<a class="moz-txt-link-freetext" href="https://rpi.gov.sk/rpi_csw/Service.svc/get?request=getcapabilities&service=csw">https://rpi.gov.sk/rpi_csw/Service.svc/get?request=getcapabilities&service=csw</a>
[2]
<a class="moz-txt-link-freetext" href="https://zbgisws.skgeodesy.sk/zbgiscsw/Service.svc/get?request=GetCapabilities&service=CSW">https://zbgisws.skgeodesy.sk/zbgiscsw/Service.svc/get?request=GetCapabilities&service=CSW</a>
I prepared XML Body for POST request and sent with curl:
[1] curl -X POST -d @post_rpi.xml <a class="moz-txt-link-freetext" href="https://klimeto.com/services/pycsw/latest">https://klimeto.com/services/pycsw/latest</a>
[2] curl -X POST -d @post_ugkk.xml
<a class="moz-txt-link-freetext" href="https://klimeto.com/services/pycsw/latest">https://klimeto.com/services/pycsw/latest</a>
Both respond in ExceptionError:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!-- pycsw 2.3.dev0 -->
<ows:ExceptionReport xmlns:csw=<a class="moz-txt-link-rfc2396E" href="http://www.opengis.net/cat/csw/2.0.2">"http://www.opengis.net/cat/csw/2.0.2"</a>
xmlns:dc=<a class="moz-txt-link-rfc2396E" href="http://purl.org/dc/elements/1.1/">"http://purl.org/dc/elements/1.1/"</a> xmlns:dct=<a class="moz-txt-link-rfc2396E" href="http://purl.org/dc/terms/">"
http://purl.org/dc/terms/"</a> xmlns:gmd=<a class="moz-txt-link-rfc2396E" href="http://www.isotc211.org/2005/gmd">"http://www.isotc211.org/2005/gmd"</a>
xmlns:gml=<a class="moz-txt-link-rfc2396E" href="http://www.opengis.net/gml">"http://www.opengis.net/gml"</a> xmlns:ows=<a class="moz-txt-link-rfc2396E" href="http://www.opengis.net/ows">"http://www.opengis.net/ows"</a>
xmlns:xs=<a class="moz-txt-link-rfc2396E" href="http://www.w3.org/2001/XMLSchema">"http://www.w3.org/2001/XMLSchema"</a> xmlns:xsi=<a class="moz-txt-link-rfc2396E" href="http://www.w3.org/2001/XMLSchema-instance">"
http://www.w3.org/2001/XMLSchema-instance"</a> language="en-US" version="1.2.0"
xsi:schemaLocation=<a class="moz-txt-link-rfc2396E" href="http://www.opengis.net/owshttp://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd">"http://www.opengis.net/ows
http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd"</a>>
<ows:Exception exceptionCode="NoApplicableCode" locator="source">
<ows:ExceptionText>Harvest (insert) failed: (psycopg2.IntegrityError) null
value in column "identifier" violates not-null constraint
DETAIL: Failing row contains (null, csw:Record,
<a class="moz-txt-link-freetext" href="http://www.opengis.net/cat/csw/2.0.2">http://www.opengis.net/cat/csw/2.0.2</a>, local, 2018-12-03T23:10:32Z,
\x3c457863657074696f6e5265706f727420786d6c6e733d22687474703a2f2f..., An
unexpected error occurred. Original message: 'No Content-type..., null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, <a class="moz-txt-link-freetext" href="https://zbgisws.skgeodesy.sk/zbgiscsw/Service.svc/post">https://zbgisws.skgeodesy.sk/zbgiscsw/Service.svc/post</a>, null, null,
null, null, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null, null, null, null, 'content':9 'content-typ':8
'error':3 'messag':6 'occur':4 'orig..., null).
[SQL: 'INSERT INTO records (typename, schema, mdsource, insert_date, xml,
anytext, language, type, title, title_alternate, abstract, keywords,
keywordstype, parentidentifier, relation, time_begin, time_end,
topicategory, resourcelanguage, creator, publisher, contributor,
organization, securityconstraints, accessconstraints, otherconstraints,
date, date_revision, date_creation, date_publication, date_modified,
format, source, crs, geodescode, denominator, distancevalue, distanceuom,
wkt_geometry, servicetype, servicetypeversion, operation, couplingtype,
operateson, operatesonidentifier, operatesoname, degree, classification,
conditionapplyingtoaccessanduse, lineage, responsiblepartyrole,
specificationtitle, specificationdate, specificationdatetype, links,
anytext_tsvector, wkb_geometry) VALUES (%(typename)s, %(schema)s,
%(mdsource)s, %(insert_date)s, %(xml)s, %(anytext)s, %(language)s,
%(type)s, %(title)s, %(title_alternate)s, %(abstract)s, %(keywords)s,
%(keywordstype)s, %(parentidentifier)s, %(relation)s, %(time_begin)s,
%(time_end)s, %(topicategory)s, %(resourcelanguage)s, %(creator)s,
%(publisher)s, %(contributor)s, %(organization)s, %(securityconstraints)s,
%(accessconstraints)s, %(otherconstraints)s, %(date)s, %(date_revision)s,
%(date_creation)s, %(date_publication)s, %(date_modified)s, %(format)s,
%(source)s, %(crs)s, %(geodescode)s, %(denominator)s, %(distancevalue)s,
%(distanceuom)s, %(wkt_geometry)s, %(servicetype)s, %(servicetypeversion)s,
%(operation)s, %(couplingtype)s, %(operateson)s, %(operatesonidentifier)s,
%(operatesoname)s, %(degree)s, %(classification)s,
%(conditionapplyingtoaccessanduse)s, %(lineage)s, %(responsiblepartyrole)s,
%(specificationtitle)s, %(specificationdate)s, %(specificationdatetype)s,
%(links)s, %(anytext_tsvector)s, %(wkb_geometry)s)'] [parameters:
{'securityconstraints': None, 'date_publication': None, 'couplingtype':
None, 'conditionapplyingtoaccessanduse': None, 'time_end': None,
'date_creation': None, 'wkb_geometry': None, 'keywords': None, 'title':
None, 'specificationdatetype': None, 'source': '
<a class="moz-txt-link-freetext" href="https://zbgisws.skgeodesy.sk/zbgiscsw/Service.svc/post">https://zbgisws.skgeodesy.sk/zbgiscsw/Service.svc/post</a>', 'classification':
None, 'topicategory': None, 'parentidentifier': None, 'format': None,
'operation': None, 'servicetypeversion': None, 'accessconstraints': None,
'wkt_geometry': None, 'xml': b'<ExceptionReport xmlns=<a class="moz-txt-link-rfc2396E" href="http://www.opengis.net/ows">"
http://www.opengis.net/ows"</a> xmlns:xsi=<a class="moz-txt-link-rfc2396E" href="http://www.w3.org/2001/XMLSchema-instance">"
http://www.w3.org/2001/XMLSchema-instance"</a> xsi:schemaLocation=<a class="moz-txt-link-rfc2396E" href="http://www.opengis.net...(114characterstruncated)...icableCode">"
http://www.opengis.net ... (114 characters truncated) ...
icableCode"</a>><ExceptionText>An unexpected error occurred. Original
message: \'No Content-type
provided\'</ExceptionText></Exception></ExceptionReport>',
'schema': '<a class="moz-txt-link-freetext" href="http://www.opengis.net/cat/csw/2.0.2">http://www.opengis.net/cat/csw/2.0.2</a>', 'contributor': None,
'date_revision': None, 'geodescode': None, 'degree': None, 'servicetype':
None, 'creator': None, 'operatesonidentifier': None, 'links': None,
'typename': 'csw:Record', 'mdsource': 'local', 'otherconstraints': None,
'anytext_tsvector': None, 'language': None, 'distancevalue': None, 'crs':
None, 'organization': None, 'specificationtitle': None, 'publisher': None,
'time_begin': None, 'resourcelanguage': None, 'denominator': None,
'distanceuom': None, 'anytext': "An unexpected error occurred. Original
message: 'No Content-type provided'", 'title_alternate': None,
'keywordstype': None, 'relation': None, 'responsiblepartyrole': None,
'date': None, 'specificationdate': None, 'type': None, 'operateson': None,
'operatesoname': None, 'date_modified': None, 'abstract': None, 'lineage':
None, 'insert_date': '2018-12-03T23:10:32Z'}] (Background on this error at:
<a class="moz-txt-link-freetext" href="http://sqlalche.me/e/gkpj">http://sqlalche.me/e/gkpj</a>).</ows:ExceptionText>
</ows:Exception>
</ows:ExceptionReport>
Anybody has an idea where the problem with null violation for identifier is
caused?
Many thanks,
Tomas
<a class="moz-txt-link-rfc2396E" href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail"><https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail></a>
Virus-free.
<a class="moz-txt-link-abbreviated" href="http://www.avast.com">www.avast.com</a>
<a class="moz-txt-link-rfc2396E" href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail"><https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail></a>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
pycsw-devel mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pycsw-devel@lists.osgeo.org">pycsw-devel@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/pycsw-devel">https://lists.osgeo.org/mailman/listinfo/pycsw-devel</a></pre>
</blockquote>
<p><br>
</p>
<pre class="moz-signature" cols="72">--
Angelos Tzotsos, PhD
Charter Member
Open Source Geospatial Foundation
<a class="moz-txt-link-freetext" href="http://users.ntua.gr/tzotsos">http://users.ntua.gr/tzotsos</a></pre>
</body>
</html>