<div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">Dear devs,<div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><blockquote style="margin:0px 0px 0px 40px;border:none;padding:0px"><div><div><div><div></div></div></div></div></blockquote><div><div dir="ltr"><div dir="ltr"><div dir="ltr">
<div><div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><div><br></div><div>I have deployed the latest version of pycsw from docker repo.</div><div><br></div><div>The service is running from here: <a href="https://klimeto.com/services/pycsw/latest">https://klimeto.com/services/pycsw/latest</a></div><div><br></div><div>I would like to use it as CSW harvesting engine.</div><div><br></div><div>However I discovered problems with harvesting the following 2 CSWs:</div><div><br></div><div>[1] <a 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><br></div><div><br></div><div>[2] <a 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><br></div><div><br></div><div>I prepared XML Body for POST request and sent with curl:</div><div><br></div><div>[1] curl -X POST -d @post_rpi.xml <a href="https://klimeto.com/services/pycsw/latest">https://klimeto.com/services/pycsw/latest</a></div><div>[2] curl -X POST -d @post_ugkk.xml <a href="https://klimeto.com/services/pycsw/latest">https://klimeto.com/services/pycsw/latest</a></div><div><br></div><div>Both respond in ExceptionError:</div><div><br></div><div><div><?xml version="1.0" encoding="UTF-8" standalone="no"?></div><div><!-- pycsw 2.3.dev0 --></div><div><ows:ExceptionReport xmlns:csw="<a href="http://www.opengis.net/cat/csw/2.0.2">http://www.opengis.net/cat/csw/2.0.2</a>" xmlns:dc="<a href="http://purl.org/dc/elements/1.1/">http://purl.org/dc/elements/1.1/</a>" xmlns:dct="<a href="http://purl.org/dc/terms/">http://purl.org/dc/terms/</a>" xmlns:gmd="<a href="http://www.isotc211.org/2005/gmd">http://www.isotc211.org/2005/gmd</a>" xmlns:gml="<a href="http://www.opengis.net/gml">http://www.opengis.net/gml</a>" xmlns:ows="<a href="http://www.opengis.net/ows">http://www.opengis.net/ows</a>" xmlns:xs="<a href="http://www.w3.org/2001/XMLSchema">http://www.w3.org/2001/XMLSchema</a>" xmlns:xsi="<a 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 href="http://www.opengis.net/ows">http://www.opengis.net/ows</a> <a href="http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd">http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd</a>"></div><div><span style="white-space:pre"> </span><ows:Exception exceptionCode="NoApplicableCode" locator="source"></div><div><span style="white-space:pre"> </span><ows:ExceptionText><span style="background-color:rgb(0,255,0)">Harvest (insert) failed: (psycopg2.IntegrityError) null value in column "identifier" violates not-null constraint</span></div><div><span style="white-space:pre"> </span>DETAIL: Failing row contains (null, csw:Record, <a 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 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).</div><div><span style="white-space:pre"> </span>[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 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 href="http://www.opengis.net/ows">http://www.opengis.net/ows</a>" xmlns:xsi="<a href="http://www.w3.org/2001/XMLSchema-instance">http://www.w3.org/2001/XMLSchema-instance</a>" xsi:schemaLocation="<a href="http://www.opengis.net">http://www.opengis.net</a> ... (114 characters truncated) ... icableCode"><ExceptionText>An unexpected error occurred. Original message: \'No Content-type provided\'</ExceptionText></Exception></ExceptionReport>', 'schema': '<a 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 href="http://sqlalche.me/e/gkpj)">http://sqlalche.me/e/gkpj)</a>.</ows:ExceptionText></div><div><span style="white-space:pre"> </span></ows:Exception></div><div></ows:ExceptionReport></div></div><div><br></div><div>Anybody has an idea where the problem with null violation for identifier is caused?</div><div><br></div><div>Many thanks,</div><div>Tomas</div></div></div></div></div></div></div></div><div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2"><br>
<table style="border-top:1px solid #d3d4de">
<tr>
<td style="width:55px;padding-top:13px"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" width="46" height="29" style="width: 46px; height: 29px;"></a></td>
<td style="width:470px;padding-top:12px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px">Virus-free. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank" style="color:#4453ea">www.avast.com</a>
</td>
</tr>
</table><a href="#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1"></a></div>