2012-10-11 00:43:57,439 - INFO from webapp.querytool: QUERY PROTOCOL CREATED: <?xml version="1.0" encoding="UTF-8"?> <request xmlns="http://www.biocase.org/schemas/protocol/1.3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.biocase.org/schemas/protocol/1.3 http://www.bgbm.org/biodivinf/schema/protocol.xsd"> <header> <version software="querytool">2.4.2</version> <sendTime>2012-10-11 00:43:57.000</sendTime> <type>scan</type> </header> <scan> <requestFormat>http://www.tdwg.org/schemas/abcd/2.06</requestFormat> <concept>/DataSets/DataSet/Units/Unit/Identifications/Identification/Result/TaxonIdentified/ScientificName/FullScientificNameString</concept> <filter> <and> <like path="/DataSets/DataSet/Units/Unit/Identifications/Identification/Result/TaxonIdentified/HigherTaxa/HigherTaxon/HigherTaxonName">HRsJgmACpgeQ</like> <equals path="/DataSets/DataSet/Units/Unit/Gathering/SiteCoordinateSets/SiteCoordinates/CoordinatesLatLong/LongitudeDecimal">nogood87@yahoo.com</equals> <like path="/DataSets/DataSet/Units/Unit/Gathering/LocalityText">urXTGjKLTrFUrlbG</like> <like path="/DataSets/DataSet/Units/Unit/Identifications/Identification/Result/TaxonIdentified/ScientificName/FullScientificNameString">Zoe</like> <like path="/DataSets/DataSet/Units/Unit/Gathering/Country/Name">USA</like> <like path="/DataSets/DataSet/Units/Unit/UnitID">90130</like> <like path="/DataSets/DataSet/Units/Unit/Gathering/SiteCoordinateSets/SiteCoordinates/CoordinatesLatLong/CoordinatesText">LlnWXn</like> <equals path="/DataSets/DataSet/Units/Unit/Gathering/SiteCoordinateSets/SiteCoordinates/CoordinatesLatLong/LatitudeDecimal">VaTfEtvhro</equals> <equals path="/DataSets/DataSet/Units/Unit/Gathering/SiteCoordinateSets/SiteCoordinates/CoordinatesLatLong/CoordinateErrorDistanceInMeters">nogood87@yahoo.com</equals> <like path="/DataSets/DataSet/Units/Unit/Identifications/Identification/PreferredFlag">UdRYbjwSFzluNAug</like> </and> </filter> </scan> </request> 2012-10-11 00:43:57,477 - INFO from webapp.querytool: SEND QUERY TO http://biology.africamuseum.be/BiocaseProvider_2.4.2/www/pywrapper.cgi?dsa=RMCA_Amphibians 2012-10-11 00:43:57,477 - INFO from webapp.querytool: SECURITY ROLE=None 2012-10-11 00:44:02,299 - INFO from webapp.querytool: FULL WRAPPER RESPONSE
2.4.3 (#2, Jan 21 2010, 19:56:43) [GCC 4.0.3 (Ubuntu 4.0.3-1ubuntu5)] 2.4.2 PostgreSQL DB module v0.91 using pyPgSQL 2.4 posix 2012-10-11T00:44:02+02:00 biology.africamuseum.be 193.190.223.48 scan
Logging started. BioCASe protocol used. set PSF=/var/www/BiocaseProvider_2.4.2/configuration/datasources/RMCA_Amphibians/provider_setup_file.xml set logDir=/var/www/BiocaseProvider_2.4.2/log HTTP parameter 'query' used for building the request. All parameters found in the request: {'debug': '1', 'query': '<?xml version="1.0" encoding="UTF-8"?>\n <request \n xmlns="http://www.biocase.org/schemas/protocol/1.3" \n xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" \n xsi:schemaLocation="http://www.biocase.org/schemas/protocol/1.3 http://www.bgbm.org/biodivinf/schema/protocol.xsd">\n <header>\n <version software="querytool">2.4.2</version>\n <sendTime>2012-10-11 00:43:57.000</sendTime>\n <type>scan</type>\n </header>\n <scan>\n <requestFormat>http://www.tdwg.org/schemas/abcd/2.06</requestFormat>\n <concept>/DataSets/DataSet/Units/Unit/Identifications/Identification/Result/TaxonIdentified/ScientificName/FullScientificNameString</concept>\n \n<filter>\n<and>\n <like path="/DataSets/DataSet/Units/Unit/Identifications/Identification/Result/TaxonIdentified/HigherTaxa/HigherTaxon/HigherTaxonName">HRsJgmACpgeQ</like>\n <equals path="/DataSets/DataSet/Units/Unit/Gathering/SiteCoordinateSets/SiteCoordinates/CoordinatesLatLong/LongitudeDecimal">nogood87@yahoo.com</equals>\n <like path="/DataSets/DataSet/Units/Unit/Gathering/LocalityText">urXTGjKLTrFUrlbG</like>\n <like path="/DataSets/DataSet/Units/Unit/Identifications/Identification/Result/TaxonIdentified/ScientificName/FullScientificNameString">Zoe</like>\n <like path="/DataSets/DataSet/Units/Unit/Gathering/Country/Name">USA</like>\n <like path="/DataSets/DataSet/Units/Unit/UnitID">90130</like>\n <like path="/DataSets/DataSet/Units/Unit/Gathering/SiteCoordinateSets/SiteCoordinates/CoordinatesLatLong/CoordinatesText">LlnWXn</like>\n <equals path="/DataSets/DataSet/Units/Unit/Gathering/SiteCoordinateSets/SiteCoordinates/CoordinatesLatLong/LatitudeDecimal">VaTfEtvhro</equals>\n <equals path="/DataSets/DataSet/Units/Unit/Gathering/SiteCoordinateSets/SiteCoordinates/CoordinatesLatLong/CoordinateErrorDistanceInMeters">nogood87@yahoo.com</equals>\n <like path="/DataSets/DataSet/Units/Unit/Identifications/Identification/PreferredFlag">UdRYbjwSFzluNAug</like>\n</and>\n</filter>\n\n </scan>\n </request>', 'request_string': '<?xml version="1.0" encoding="UTF-8"?>\n <request \n xmlns="http://www.biocase.org/schemas/protocol/1.3" \n xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" \n xsi:schemaLocation="http://www.biocase.org/schemas/protocol/1.3 http://www.bgbm.org/biodivinf/schema/protocol.xsd">\n <header>\n <version software="querytool">2.4.2</version>\n <sendTime>2012-10-11 00:43:57.000</sendTime>\n <type>scan</type>\n </header>\n <scan>\n <requestFormat>http://www.tdwg.org/schemas/abcd/2.06</requestFormat>\n <concept>/DataSets/DataSet/Units/Unit/Identifications/Identification/Result/TaxonIdentified/ScientificName/FullScientificNameString</concept>\n \n<filter>\n<and>\n <like path="/DataSets/DataSet/Units/Unit/Identifications/Identification/Result/TaxonIdentified/HigherTaxa/HigherTaxon/HigherTaxonName">HRsJgmACpgeQ</like>\n <equals path="/DataSets/DataSet/Units/Unit/Gathering/SiteCoordinateSets/SiteCoordinates/CoordinatesLatLong/LongitudeDecimal">nogood87@yahoo.com</equals>\n <like path="/DataSets/DataSet/Units/Unit/Gathering/LocalityText">urXTGjKLTrFUrlbG</like>\n <like path="/DataSets/DataSet/Units/Unit/Identifications/Identification/Result/TaxonIdentified/ScientificName/FullScientificNameString">Zoe</like>\n <like path="/DataSets/DataSet/Units/Unit/Gathering/Country/Name">USA</like>\n <like path="/DataSets/DataSet/Units/Unit/UnitID">90130</like>\n <like path="/DataSets/DataSet/Units/Unit/Gathering/SiteCoordinateSets/SiteCoordinates/CoordinatesLatLong/CoordinatesText">LlnWXn</like>\n <equals path="/DataSets/DataSet/Units/Unit/Gathering/SiteCoordinateSets/SiteCoordinates/CoordinatesLatLong/LatitudeDecimal">VaTfEtvhro</equals>\n <equals path="/DataSets/DataSet/Units/Unit/Gathering/SiteCoordinateSets/SiteCoordinates/CoordinatesLatLong/CoordinateErrorDistanceInMeters">nogood87@yahoo.com</equals>\n <like path="/DataSets/DataSet/Units/Unit/Identifications/Identification/PreferredFlag">UdRYbjwSFzluNAug</like>\n</and>\n</filter>\n\n </scan>\n </request>'} Found online debuglevel setting: 1 The biocase.wrapper.dbmod.dbmod_postgres database module has been used. Try to get CMF for namespace http://www.tdwg.org/schemas/abcd/2.06 Load CMFile '/var/www/BiocaseProvider_2.4.2/configuration/datasources/RMCA_Amphibians/cmf_ABCD_2.06.xml' Load the pickled CMF object '.cmf_ABCD_2.06.xml.pick' Pickled file is of latest revision. Global CMF Filters integrated into the SQL: () Compressed filter used: (("v_abcd2v06higherrankbymanyidentifications"."taxonname" ILIKE HRsJgmACpgeQ ) AND ("v_abcd2v06herpnet_trigger"."decimallongitude" = nogood87@yahoo.com ) AND ("v_abcd2v06herpnet_trigger"."locality" ILIKE urXTGjKLTrFUrlbG ) AND ("v_abcd2v06manytomanyidentifications"."fullscientificnamestring" ILIKE Zoe ) AND ("v_abcd2v06herpnet_trigger"."country" ILIKE USA ) AND ("v_abcd2v06herpnet_trigger"."catalognumbertext" ILIKE 90130 ) AND ("v_abcd2v06herpnet_trigger"."coordinatesverbatim" ILIKE LlnWXn ) AND ("v_abcd2v06herpnet_trigger"."decimallatitude" = VaTfEtvhro ) AND ("v_abcd2v06herpnet_trigger"."coordinateuncertainityinmeters" = nogood87@yahoo.com ) AND ("v_abcd2v06manytomanyidentifications"."preferredflag" ILIKE UdRYbjwSFzluNAug )) The scan request contained a hidden filter which was integrated: (("v_abcd2v06higherrankbymanyidentifications"."taxonname" ILIKE HRsJgmACpgeQ ) AND ("v_abcd2v06herpnet_trigger"."decimallongitude" = nogood87@yahoo.com ) AND ("v_abcd2v06herpnet_trigger"."locality" ILIKE urXTGjKLTrFUrlbG ) AND ("v_abcd2v06manytomanyidentifications"."fullscientificnamestring" ILIKE Zoe ) AND ("v_abcd2v06herpnet_trigger"."country" ILIKE USA ) AND ("v_abcd2v06herpnet_trigger"."catalognumbertext" ILIKE 90130 ) AND ("v_abcd2v06herpnet_trigger"."coordinatesverbatim" ILIKE LlnWXn ) AND ("v_abcd2v06herpnet_trigger"."decimallatitude" = VaTfEtvhro ) AND ("v_abcd2v06herpnet_trigger"."coordinateuncertainityinmeters" = nogood87@yahoo.com ) AND ("v_abcd2v06manytomanyidentifications"."preferredflag" ILIKE UdRYbjwSFzluNAug )) Final fully compressed filter: (("v_abcd2v06higherrankbymanyidentifications"."taxonname" ILIKE HRsJgmACpgeQ ) AND ("v_abcd2v06herpnet_trigger"."decimallongitude" = nogood87@yahoo.com ) AND ("v_abcd2v06herpnet_trigger"."locality" ILIKE urXTGjKLTrFUrlbG ) AND ("v_abcd2v06manytomanyidentifications"."fullscientificnamestring" ILIKE Zoe ) AND ("v_abcd2v06herpnet_trigger"."country" ILIKE USA ) AND ("v_abcd2v06herpnet_trigger"."catalognumbertext" ILIKE 90130 ) AND ("v_abcd2v06herpnet_trigger"."coordinatesverbatim" ILIKE LlnWXn ) AND ("v_abcd2v06herpnet_trigger"."decimallatitude" = VaTfEtvhro ) AND ("v_abcd2v06herpnet_trigger"."coordinateuncertainityinmeters" = nogood87@yahoo.com ) AND ("v_abcd2v06manytomanyidentifications"."preferredflag" ILIKE UdRYbjwSFzluNAug )) Executing SQL: 'SELECT DISTINCT "v_abcd2v06manytomanyidentifications"."fullscientificnamestring" FROM "t_abcd2v06herpnet_trigger" AS "v_abcd2v06herpnet_trigger" LEFT JOIN "t_abcd2v06manytomanyidentifications_trigger" AS "v_abcd2v06manytomanyidentifications" ON ("v_abcd2v06manytomanyidentifications"."fk" = "v_abcd2v06herpnet_trigger"."pk") LEFT JOIN "t_abcd2v06higherrankbymanyidentifications_trigger" AS "v_abcd2v06higherrankbymanyidentifications" ON ("v_abcd2v06higherrankbymanyidentifications"."recordfk" = "v_abcd2v06manytomanyidentifications"."pk") WHERE (("v_abcd2v06higherrankbymanyidentifications"."taxonname" ILIKE 'HRsJgmACpgeQ' ) AND ("v_abcd2v06herpnet_trigger"."decimallongitude" = 'nogood87@yahoo.com' ) AND ("v_abcd2v06herpnet_trigger"."locality" ILIKE 'urXTGjKLTrFUrlbG' ) AND ("v_abcd2v06manytomanyidentifications"."fullscientificnamestring" ILIKE 'Zoe' ) AND ("v_abcd2v06herpnet_trigger"."country" ILIKE 'USA' ) AND ("v_abcd2v06herpnet_trigger"."catalognumbertext" ILIKE '90130' ) AND ("v_abcd2v06herpnet_trigger"."coordinatesverbatim" ILIKE 'LlnWXn' ) AND ("v_abcd2v06herpnet_trigger"."decimallatitude" = 'VaTfEtvhro' ) AND ("v_abcd2v06herpnet_trigger"."coordinateuncertainityinmeters" = 'nogood87@yahoo.com' ) AND ("v_abcd2v06manytomanyidentifications"."preferredflag" ILIKE 'UdRYbjwSFzluNAug' ))' Request processing aborted due to fatal error ! OperationalError: ERROR: invalid input syntax for type double precision: "nogood87@yahoo.com" Traceback (most recent call last): File "/var/www/BiocaseProvider_2.4.2/lib/biocase/wrapper/protocol/BioCASe/biocase_protocol.py", line 85, in doRequest scanList = operationObj.scan(self.requestObj) File "/var/www/BiocaseProvider_2.4.2/lib/biocase/wrapper/operations.py", line 158, in scan rs += self.execDistinct([mapping.getItems()[0]], FilterObj) File "/var/www/BiocaseProvider_2.4.2/lib/biocase/wrapper/dbmod/base_dbmod.py", line 84, in execDistinct return [r[0] for r in self.execSQL(sql, paras)] File "/var/www/BiocaseProvider_2.4.2/lib/biocase/wrapper/dbmod/dbmod_postgres.py", line 85, in execSQL self.c.execute(sql) File "/usr/lib/python2.4/site-packages/pyPgSQL/PgSQL.py", line 3072, in execute raise OperationalError, msg OperationalError: ERROR: invalid input syntax for type double precision: "nogood87@yahoo.com"
2012-10-11 00:44:02,360 - INFO from webapp.querytool: ANALYZING RESPONSE DOC 2012-10-11 00:44:02,366 - INFO from webapp.querytool: DOC ROOT response 2012-10-11 00:44:02,379 - INFO from webapp.querytool: PROTOCOL NS found: http://www.biocase.org/schemas/protocol/1.3 2012-10-11 00:44:02,379 - INFO from webapp.querytool: Header section found. 2012-10-11 00:44:02,379 - INFO from webapp.querytool: Content section found. 2012-10-11 00:44:02,379 - INFO from webapp.querytool: Diagnostics section found. 2012-10-11 00:44:02,379 - INFO from webapp.querytool: Record Start = 0 2012-10-11 00:44:02,379 - INFO from webapp.querytool: Record Count = 0 2012-10-11 00:44:02,380 - INFO from webapp.querytool: Record Drop = 0 2012-10-11 00:44:02,380 - INFO from webapp.querytool: Record Total = 0 2012-10-11 00:44:02,381 - DEBUG from webapp.querytool: WRAPPER DIAGNOSTICS: 2012-10-11 00:44:02,381 - DEBUG from webapp.querytool: Logging started. 2012-10-11 00:44:02,381 - DEBUG from webapp.querytool: BioCASe protocol used. 2012-10-11 00:44:02,381 - DEBUG from webapp.querytool: set PSF=/var/www/BiocaseProvider_2.4.2/configuration/datasources/RMCA_Amphibians/provider_setup_file.xml 2012-10-11 00:44:02,381 - DEBUG from webapp.querytool: set logDir=/var/www/BiocaseProvider_2.4.2/log 2012-10-11 00:44:02,381 - DEBUG from webapp.querytool: HTTP parameter 'query' used for building the request. 2012-10-11 00:44:02,382 - DEBUG from webapp.querytool: All parameters found in the request: {'debug': '1', 'query': '\n \n
\n 2.4.2\n 2012-10-11 00:43:57.000\n scan\n
\n \n http://www.tdwg.org/schemas/abcd/2.06\n /DataSets/DataSet/Units/Unit/Identifications/Identification/Result/TaxonIdentified/ScientificName/FullScientificNameString\n \n\n\n HRsJgmACpgeQ\n nogood87@yahoo.com\n urXTGjKLTrFUrlbG\n Zoe\n USA\n 90130\n LlnWXn\n VaTfEtvhro\n nogood87@yahoo.com\n UdRYbjwSFzluNAug\n\n\n\n \n
', 'request_string': '\n \n
\n 2.4.2\n 2012-10-11 00:43:57.000\n scan\n
\n \n http://www.tdwg.org/schemas/abcd/2.06\n /DataSets/DataSet/Units/Unit/Identifications/Identification/Result/TaxonIdentified/ScientificName/FullScientificNameString\n \n\n\n HRsJgmACpgeQ\n nogood87@yahoo.com\n urXTGjKLTrFUrlbG\n Zoe\n USA\n 90130\n LlnWXn\n VaTfEtvhro\n nogood87@yahoo.com\n UdRYbjwSFzluNAug\n\n\n\n \n
'} 2012-10-11 00:44:02,382 - DEBUG from webapp.querytool: Found online debuglevel setting: 1 2012-10-11 00:44:02,382 - DEBUG from webapp.querytool: The biocase.wrapper.dbmod.dbmod_postgres database module has been used. 2012-10-11 00:44:02,382 - DEBUG from webapp.querytool: Try to get CMF for namespace http://www.tdwg.org/schemas/abcd/2.06 2012-10-11 00:44:02,382 - DEBUG from webapp.querytool: Load CMFile '/var/www/BiocaseProvider_2.4.2/configuration/datasources/RMCA_Amphibians/cmf_ABCD_2.06.xml' 2012-10-11 00:44:02,382 - DEBUG from webapp.querytool: Load the pickled CMF object '.cmf_ABCD_2.06.xml.pick' 2012-10-11 00:44:02,382 - DEBUG from webapp.querytool: Pickled file is of latest revision. 2012-10-11 00:44:02,382 - DEBUG from webapp.querytool: Global CMF Filters integrated into the SQL: () 2012-10-11 00:44:02,382 - DEBUG from webapp.querytool: Compressed filter used: (("v_abcd2v06higherrankbymanyidentifications"."taxonname" ILIKE HRsJgmACpgeQ ) AND ("v_abcd2v06herpnet_trigger"."decimallongitude" = nogood87@yahoo.com ) AND ("v_abcd2v06herpnet_trigger"."locality" ILIKE urXTGjKLTrFUrlbG ) AND ("v_abcd2v06manytomanyidentifications"."fullscientificnamestring" ILIKE Zoe ) AND ("v_abcd2v06herpnet_trigger"."country" ILIKE USA ) AND ("v_abcd2v06herpnet_trigger"."catalognumbertext" ILIKE 90130 ) AND ("v_abcd2v06herpnet_trigger"."coordinatesverbatim" ILIKE LlnWXn ) AND ("v_abcd2v06herpnet_trigger"."decimallatitude" = VaTfEtvhro ) AND ("v_abcd2v06herpnet_trigger"."coordinateuncertainityinmeters" = nogood87@yahoo.com ) AND ("v_abcd2v06manytomanyidentifications"."preferredflag" ILIKE UdRYbjwSFzluNAug )) 2012-10-11 00:44:02,383 - DEBUG from webapp.querytool: The scan request contained a hidden filter which was integrated: (("v_abcd2v06higherrankbymanyidentifications"."taxonname" ILIKE HRsJgmACpgeQ ) AND ("v_abcd2v06herpnet_trigger"."decimallongitude" = nogood87@yahoo.com ) AND ("v_abcd2v06herpnet_trigger"."locality" ILIKE urXTGjKLTrFUrlbG ) AND ("v_abcd2v06manytomanyidentifications"."fullscientificnamestring" ILIKE Zoe ) AND ("v_abcd2v06herpnet_trigger"."country" ILIKE USA ) AND ("v_abcd2v06herpnet_trigger"."catalognumbertext" ILIKE 90130 ) AND ("v_abcd2v06herpnet_trigger"."coordinatesverbatim" ILIKE LlnWXn ) AND ("v_abcd2v06herpnet_trigger"."decimallatitude" = VaTfEtvhro ) AND ("v_abcd2v06herpnet_trigger"."coordinateuncertainityinmeters" = nogood87@yahoo.com ) AND ("v_abcd2v06manytomanyidentifications"."preferredflag" ILIKE UdRYbjwSFzluNAug )) 2012-10-11 00:44:02,383 - DEBUG from webapp.querytool: Final fully compressed filter: (("v_abcd2v06higherrankbymanyidentifications"."taxonname" ILIKE HRsJgmACpgeQ ) AND ("v_abcd2v06herpnet_trigger"."decimallongitude" = nogood87@yahoo.com ) AND ("v_abcd2v06herpnet_trigger"."locality" ILIKE urXTGjKLTrFUrlbG ) AND ("v_abcd2v06manytomanyidentifications"."fullscientificnamestring" ILIKE Zoe ) AND ("v_abcd2v06herpnet_trigger"."country" ILIKE USA ) AND ("v_abcd2v06herpnet_trigger"."catalognumbertext" ILIKE 90130 ) AND ("v_abcd2v06herpnet_trigger"."coordinatesverbatim" ILIKE LlnWXn ) AND ("v_abcd2v06herpnet_trigger"."decimallatitude" = VaTfEtvhro ) AND ("v_abcd2v06herpnet_trigger"."coordinateuncertainityinmeters" = nogood87@yahoo.com ) AND ("v_abcd2v06manytomanyidentifications"."preferredflag" ILIKE UdRYbjwSFzluNAug )) 2012-10-11 00:44:02,383 - DEBUG from webapp.querytool: Executing SQL: 'SELECT DISTINCT "v_abcd2v06manytomanyidentifications"."fullscientificnamestring" FROM "t_abcd2v06herpnet_trigger" AS "v_abcd2v06herpnet_trigger" LEFT JOIN "t_abcd2v06manytomanyidentifications_trigger" AS "v_abcd2v06manytomanyidentifications" ON ("v_abcd2v06manytomanyidentifications"."fk" = "v_abcd2v06herpnet_trigger"."pk") LEFT JOIN "t_abcd2v06higherrankbymanyidentifications_trigger" AS "v_abcd2v06higherrankbymanyidentifications" ON ("v_abcd2v06higherrankbymanyidentifications"."recordfk" = "v_abcd2v06manytomanyidentifications"."pk") WHERE (("v_abcd2v06higherrankbymanyidentifications"."taxonname" ILIKE 'HRsJgmACpgeQ' ) AND ("v_abcd2v06herpnet_trigger"."decimallongitude" = 'nogood87@yahoo.com' ) AND ("v_abcd2v06herpnet_trigger"."locality" ILIKE 'urXTGjKLTrFUrlbG' ) AND ("v_abcd2v06manytomanyidentifications"."fullscientificnamestring" ILIKE 'Zoe' ) AND ("v_abcd2v06herpnet_trigger"."country" ILIKE 'USA' ) AND ("v_abcd2v06herpnet_trigger"."catalognumbertext" ILIKE '90130' ) AND ("v_abcd2v06herpnet_trigger"."coordinatesverbatim" ILIKE 'LlnWXn' ) AND ("v_abcd2v06herpnet_trigger"."decimallatitude" = 'VaTfEtvhro' ) AND ("v_abcd2v06herpnet_trigger"."coordinateuncertainityinmeters" = 'nogood87@yahoo.com' ) AND ("v_abcd2v06manytomanyidentifications"."preferredflag" ILIKE 'UdRYbjwSFzluNAug' ))' 2012-10-11 00:44:02,383 - DEBUG from webapp.querytool: Request processing aborted due to fatal error ! 2012-10-11 00:44:02,383 - DEBUG from webapp.querytool: OperationalError: ERROR: invalid input syntax for type double precision: "nogood87@yahoo.com" 2012-10-11 00:44:02,383 - DEBUG from webapp.querytool: Traceback (most recent call last): File "/var/www/BiocaseProvider_2.4.2/lib/biocase/wrapper/protocol/BioCASe/biocase_protocol.py", line 85, in doRequest scanList = operationObj.scan(self.requestObj) File "/var/www/BiocaseProvider_2.4.2/lib/biocase/wrapper/operations.py", line 158, in scan rs += self.execDistinct([mapping.getItems()[0]], FilterObj) File "/var/www/BiocaseProvider_2.4.2/lib/biocase/wrapper/dbmod/base_dbmod.py", line 84, in execDistinct return [r[0] for r in self.execSQL(sql, paras)] File "/var/www/BiocaseProvider_2.4.2/lib/biocase/wrapper/dbmod/dbmod_postgres.py", line 85, in execSQL self.c.execute(sql) File "/usr/lib/python2.4/site-packages/pyPgSQL/PgSQL.py", line 3072, in execute raise OperationalError, msg OperationalError: ERROR: invalid input syntax for type double precision: "nogood87@yahoo.com"