Landingpage
http://biocase.snsb.info/wrapper/pywrapper.cgi?dsa=GFBio201900216SNSB
ERROR
<biocase:diagnostics> <biocase:diagnostic severity="ERROR">A SQL statement produced an error: SELECT "Unit"."ID", "Metadata"."DatasetGUID", "TechnicalContact"."Name", "TechnicalContact"."Email", "TechnicalContact"."Phone", "TechnicalContact"."Address", "ContentContact"."Name", "ContentContact"."Email", "ContentContact"."Phone", "ContentContact"."Address", "Metadata"."Description_Representation_Title", "Metadata"."Description_Representation_Details", "Metadata"."Description_Representation_URI", "Metadata"."RevisionData_DateModified", "Metadata"."Owner_Organisation_Name_Text", "Metadata"."Owner_Organisation_Name_Abbreviation", "Metadata"."Owner_Person_FullName", "Metadata"."Owner_Role", "Metadata"."Owner_Address", "Metadata"."Owner_Telephone_Number", "Metadata"."Owner_EmailAddress", "Metadata"."Owner_URL", "Metadata"."Owner_LogoURI", "Metadata"."IPRStatements_IPRDeclaration_Text", "Metadata"."IPRStatements_IPRDeclaration_Details", "Metadata"."IPRStatements_IPRDeclaration_URI", "Metadata"."IPRStatements_Copyright_Text", "Metadata"."IPRStatements_Copyright_Details", "Metadata"."IPRStatements_Copyright_URI", "Metadata"."IPRStatements_License_Text", "Metadata"."IPRStatements_License_Details", "Metadata"."IPRStatements_License_URI", "Metadata"."IPRStatements_TermsOfUse_Text", "Metadata"."IPRStatements_TermsOfUse_Details", "Metadata"."IPRStatements_TermsOfUse_URI", "Metadata"."IPRStatements_Disclaimer_Text", "Metadata"."IPRStatements_Disclaimer_Details", "Metadata"."IPRStatements_Disclaimer_URI", "Metadata"."IPRStatements_Acknowledgement_Text", "Metadata"."IPRStatements_Acknowledgement_Details", "Metadata"."IPRStatements_Acknowledgement_URI", "Metadata"."IPRStatements_Citation_Text", "Metadata"."IPRStatements_Citation_URI", "Unit"."UnitGUID", "Unit"."SourceInstitutionID", "Unit"."SourceID", "Unit"."UnitID", "Unit"."DateLastEdited", "Unit"."Identification_Taxon_HigherTaxonName", "Unit"."Identification_Taxon_ScientificName_FullScientificName", "Unit"."Identification_Taxon_ScientificName_Qualifier", "Unit"."RecordBasis", "Unit"."KindOfUnit_Language", "Unit"."KindOfUnit", "Unit_SpecimenUnit"."NomenclaturalTypeDesignation_TypifiedName_FullScientificName", "Unit_SpecimenUnit"."NomenclaturalTypeDesignation_TypeStatus", "Unit"."HerbariumUnit_Exsiccatum", "MultiMediaObject"."fileUri", "MultiMediaObject"."ProductURI", "MultiMediaObject"."fileFormat", "MultiMediaObject"."IPR_Copyright_Text", "MultiMediaObject"."IPR_License_Text", "MultiMediaObject"."IPR_License_Details", "MultiMediaObject"."IPR_License_URI", "MultiMediaObject"."IPR_TermsOfUse_Text", "MultiMediaObject"."CreatorAgent", "Unit_Associations_UnitAssociation"."SourceInstitutionCode", "Unit_Associations_UnitAssociation"."SourceName", "Unit_Associations_UnitAssociation"."AssociatedUnitID", "Unit_Associations_UnitAssociation"."AssociationType_Language", "Unit_Associations_UnitAssociation"."AssociationType", "Unit_Associations_UnitAssociation"."Comment_Language", "Unit_Associations_UnitAssociation"."Comment", "Unit_Gathering"."DateTime_ISODateTimeBegin", "Unit_Gathering_Agents"."GatheringAgent_AgentText", "Unit_Gathering"."LocalityText", "Unit_Gathering"."Country_Name", "Unit_Gathering"."ISO3166Code", "Unit_Gathering"."SiteCoordinateSets_CoordinatesLatLong_LongitudeDecimal", "Unit_Gathering"."SiteCoordinateSets_CoordinatesLatLong_LatitudeDecimal", "Unit_Gathering"."SiteCoordinateSets_CoordinatesLatLong_SpatialDatum", "Unit_Gathering_Stratigraphy_ChronostratigraphicTerm"."Term", "Unit_Gathering_Stratigraphy_LithostratigraphicTerm"."Term", "Unit_Gathering"."Synecology_AssociatedTaxa_TaxonIdentified_HigherTaxonName", "Unit_Gathering"."Synecology_AssociatedTaxa_TaxonIdentified_HigherTaxonRank", "MeasurementOrFact"."MeasuredBy", "MeasurementOrFact"."MeasurementDateTime", "MeasurementOrFact"."Parameter", "MeasurementOrFact"."AnalysisNumber", "MeasurementOrFact"."LowerValue", "MeasurementOrFact"."UnitOfMeasurement", "MeasurementOrFact"."MeasurementOrFactReference", "Unit"."RecordURI", "Metadata"."ProjectID", "TechnicalContact"."ProjectID", "ContentContact"."ProjectID", "Unit"."ID", "Unit_SpecimenUnit"."ID", "MultiMediaObject"."ID", "MultiMediaObject"."DisplayOrder", "Unit_Associations_UnitAssociation"."ID", "Unit_Gathering"."ID", "Unit_Gathering_Agents"."ID", "Unit_Gathering_Agents"."GatheringAgent_AgentText", "Unit_Gathering_Stratigraphy_ChronostratigraphicTerm"."ID", "Unit_Gathering_Stratigraphy_LithostratigraphicTerm"."ID", "MeasurementOrFact"."ID", "MeasurementOrFact"."AnalysisID", "MeasurementOrFact"."AnalysisNumber" FROM "ABCD_Metadata" AS "Metadata" LEFT JOIN "ABCD_TechnicalContact" AS "TechnicalContact" ON ("TechnicalContact"."ProjectID" = "Metadata"."ProjectID") LEFT JOIN "ABCD_ContentContact" AS "ContentContact" ON ("ContentContact"."ProjectID" = "Metadata"."ProjectID"), "ABCD_Unit" AS "Unit" LEFT JOIN "ABCD_Unit_SpecimenUnit" AS "Unit_SpecimenUnit" ON ("Unit_SpecimenUnit"."ID" = "Unit"."ID") LEFT JOIN "ABCD_MultiMediaObject" AS "MultiMediaObject" ON ("MultiMediaObject"."ID" = "Unit"."ID") LEFT JOIN "ABCD_Unit_Associations_UnitAssociation" AS "Unit_Associations_UnitAssociation" ON ("Unit_Associations_UnitAssociation"."ID" = "Unit"."ID") LEFT JOIN "ABCD_Unit_Gathering" AS "Unit_Gathering" ON ("Unit_Gathering"."ID" = "Unit"."ID") LEFT JOIN "ABCD_Unit_Gathering_Agents" AS "Unit_Gathering_Agents" ON ("Unit_Gathering_Agents"."ID" = "Unit"."ID") LEFT JOIN "ABCD_Unit_Gathering_Stratigraphy_ChronostratigraphicTerm" AS "Unit_Gathering_Stratigraphy_ChronostratigraphicTerm" ON ("Unit_Gathering_Stratigraphy_ChronostratigraphicTerm"."ID" = "Unit"."ID") LEFT JOIN "ABCD_Unit_Gathering_Stratigraphy_LithostratigraphicTerm" AS "Unit_Gathering_Stratigraphy_LithostratigraphicTerm" ON ("Unit_Gathering_Stratigraphy_LithostratigraphicTerm"."ID" = "Unit"."ID") LEFT JOIN "ABCD_MeasurementOrFact" AS "MeasurementOrFact" ON ("MeasurementOrFact"."ID" = "Unit"."ID") WHERE ("Unit"."ID" IN ('226-21', '229-24', '231-26', '232-27', '235-30', '242-37', '258-53', '259-54', '271-66', '274-69', '332-127', '334-129', '342-137', '347-142', '348-143', '373-168', '374-169', '376-171', '378-173', '379-174', '381-176', '392-187', '393-188')) ORDER BY "Unit"."ID"</biocase:diagnostic> </biocase:diagnostics> </biocase:response>