Problem to Import FlowJo Workspace

LabKey Support Forum
Problem to Import FlowJo Workspace johann pellet  2021-06-11 07:59
Status: Closed
 

Hi,

I have a problem with my dataset when I am trying to import a Flowjob Workspace in my Labkey server (LabKey Server 19.3.0).

11 Jun 2021 16:51:18,000 DEBUG: Analysis results contains 275 statistics, 76 graphs
11 Jun 2021 16:51:21,656 ERROR: FlowJo Workspace import failed
org.labkey.api.query.RuntimeValidationException: name: Value is too long for column 'name', a maximum length of 256 is allowed. Supplied value was 259 characters long.
    at org.labkey.api.data.Table.insert(Table.java:708)
    at org.labkey.flow.persist.FlowManager.ensureAttributeName(FlowManager.java:468)
    at org.labkey.flow.persist.FlowManager.ensureAttributeName(FlowManager.java:484)
    at org.labkey.flow.persist.FlowManager.ensureAttributeNameAndAliases(FlowManager.java:549)
    at org.labkey.flow.persist.FlowManager.ensureStatisticNameAndAliases(FlowManager.java:508)
    at org.labkey.flow.persist.AttributeSetHelper.ensureStatisticNames(AttributeSetHelper.java:109)
    at org.labkey.flow.persist.AttributeSetHelper.prepareForSave(AttributeSetHelper.java:89)
    at org.labkey.flow.script.WorkspaceJob.extractAnalysis(WorkspaceJob.java:371)
    at org.labkey.flow.script.WorkspaceJob.createExperimentRun(WorkspaceJob.java:170)
    at org.labkey.flow.script.WorkspaceJob.createExperimentRun(WorkspaceJob.java:148)
    at org.labkey.flow.script.AbstractExternalAnalysisJob.doRun(AbstractExternalAnalysisJob.java:233)
    at org.labkey.flow.script.WorkspaceJob.doRun(WorkspaceJob.java:138)
    at org.labkey.flow.script.FlowJob.run(FlowJob.java:76)
    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
    at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
    at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1130)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:630)
    at java.base/java.lang.Thread.run(Thread.java:831)
Caused by: name: Value is too long for column 'name', a maximum length of 256 is allowed. Supplied value was 259 characters long.
    at org.labkey.api.query.RuntimeValidationException.<init>(RuntimeValidationException.java:36)
    ... 19 more
11 Jun 2021 16:51:21,693 INFO : Job completed at 2021-06- 16:51
11 Jun 2021 16:51:21,693 INFO : Elapsed time 40.326s```

The 'name' is too long to be inserted in the database (as I undestand).  Could you please tell me what name refers to this value.

Thank you.

Regards,
Johann
 
 
kevink responded:  2021-06-11 11:08

It looks like the statistic name is too long by just a few characters. The statistic name is composed of the population name and the statistic of interest. For example, the name could look something like "/S/Lv/L/CD3+/IFNg+:Count" or "/S/Lv/L/CD3+/IFNg+:Freq_Of_Parent". I vaguely remember FlowJo had a limit on the total population name length such that it would fit under our current limit, but they may have increased it in recent years.

For a workaround, you can try shortening the population names and re-importing into LabKey. I've filed an issue to address this:

https://www.labkey.org/home/Developer/issues/issues-details.view?issueId=43360