Opened 18 years ago

Closed 17 years ago

#588 closed defect (fixed)

BioAssaySetExporter uses incorrect alias names in queries

Reported by: Nicklas Nordborg Owned by: Nicklas Nordborg
Priority: major Milestone: BASE 2.3.1
Component: coreplugins Version:
Keywords: Cc:

Description

When a formula column has been selected for export the BioAssaySetExporter uses the formula name as an alias in the query. It can't do that since the name may contain characters that are invalid in aliases.

Possible workaround: Change the name of all formulas to only use letters and numbers.

Here is the stacktrace:

net.sf.basedb.core.InvalidDataException: Alias 'A, log10(ch1 * ch2) / 2' has one or more invalid characters. Only a-z, A-Z and 0-9 is allowed.
at net.sf.basedb.core.query.Selects.expression(Selects.java:57)
at net.sf.basedb.plugins.BioAssaySetExporter.exportBaseFileSerial(BioAssaySetExporter.java:298)
at net.sf.basedb.plugins.BioAssaySetExporter.run(BioAssaySetExporter.java:937)
at net.sf.basedb.core.PluginExecutionRequest.invoke(PluginExecutionRequest.java:88)
at net.sf.basedb.core.InternalJobQueue$JobRunner.run(InternalJobQueue.java:420)
at java.lang.Thread.run(Thread.java:595)

Change History (2)

comment:1 by Nicklas Nordborg, 17 years ago

Owner: changed from Johan Enell to Nicklas Nordborg
Status: newassigned

comment:2 by Nicklas Nordborg, 17 years ago

Resolution: fixed
Status: assignedclosed

(In [3451]) Fixes #588

Note: See TracTickets for help on using tickets.