• Sign In
×
The 2025 Client Survey is now open! Responses will be accepted up until 10/31. Please feel free to share this link within your organization and we thank you in advance for your participation!
  1. Messages

Problem to Import FlowJo Workspace

LabKey Support Forum (Inactive)

View Message

view list print
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