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
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"