legumeinfo / mine-issues

Report ALL issues on LIS mines here! Regardless of which mine you found it on!
2 stars 0 forks source link

[IMTABLES] error running query #122

Open sammyjava opened 1 year ago

sammyjava commented 1 year ago

From @adf-ncgr

this was generated from applying a filter using the histogram of lengths UI. Apparently it generates floating values and someone else demands they be integers...

We encountered an error running a query from an
embedded result table.

page: https://mines.legumeinfo.org/legumemine/report.do?id=169205990
service: https://mines.legumeinfo.org/legumemine/service/
error: Error: XML is well formatted but query contains errors:
Value in constraint GeneFamily.proteins.length >= 327.8 is not in correct format for type of Integer.

date-stamp: Fri Aug 25 2023 22:13:41 GMT-0600 (Mountain Daylight Time)

-------------------------------
IMJS: 3.18.1
-------------------------------
IMTABLES: 2.1.0
-------------------------------
QUERY: <query model="genomic" view="GeneFamily.proteins.primaryIdentifier GeneFamily.proteins.name GeneFamily.proteins.description GeneFamily.proteins.organism.name GeneFamily.proteins.strain.identifier GeneFamily.proteins.length" ><join path="GeneFamily.proteins.organism" style="OUTER"/><join path="GeneFamily.proteins.strain" style="OUTER"/><constraint path="GeneFamily.id" op="=" value="169205990" code="A" /><constraint path="GeneFamily.proteins.length" op="&gt;=" value="327.8" /><constraint path="GeneFamily.proteins.length" op="&lt;=" value="359" /></query>
-------------------------------
STACK: Error: XML is well formatted but query contains errors:
Value in constraint GeneFamily.proteins.length >= 327.8 is not in correct format for type of Integer.

at module.exports.<anonymous> (https://mines.legumeinfo.org/CDN/js/intermine/im-tables/latest/imtables.js:42368:31)
at EventEmitter.emit (https://mines.legumeinfo.org/CDN/js/intermine/im-tables/latest/imtables.js:50494:17)
at Response.handle (https://mines.legumeinfo.org/CDN/js/intermine/im-tables/latest/imtables.js:54570:19)
at xhr.onreadystatechange (https://mines.legumeinfo.org/CDN/js/intermine/im-tables/latest/imtables.js:54333:13)
sammyjava commented 11 months ago

Where is the histogram of lengths UI?

sammyjava commented 8 months ago

Where is the histogram of lengths UI?

You mean one of the Datatables tools?

adf-ncgr commented 8 months ago

Yes, I think so. This

image
adf-ncgr commented 8 months ago

though I can't seem to reproduce the behavior I only vaguely recall