• Sign In
  1. Messages

Study and Studydataset tables are empty

General Server Forum (Inactive)

View Message

view list print
Study and Studydataset tables are empty mjavadi  2017-11-24 16:49
Status: Closed
 
Hello,

I'm trying to load tables from postgres and whenever I try to load any of the 'studydataset' tables or any 'study' tables (i.e. 'participant', 'participantvisit', etc.) they are empty, in fact I get an error that data table does not contain any columns. However I can see these tables when I log-in under the study datasets.

Some of the 'studydataset' tables are assays which are then copied to study. The datatables that are copied to study from an assay do have the tables available under 'assayresult' tables. Other are datasets created directly in the study. Irrespective of the source, the 'studydataset' tables are empty.

Any assistance or insight you may have on how to resolve this issue would be much appreciated.

Thanks,

Mojib
 
 
Jon (LabKey DevOps) responded:  2017-11-27 00:53
Hi Mojib,

I'm a bit confused as to why you're trying to load tables directly from the database rather than within the confines of the LabKey UI, the LabKey API, or using something like an ETL or Pipeline job to import the information into the various datasets for your study.

Can you provide us with more details as to why you're needing to do a direct DB loading of the tables in lieu of using LabKey instead?

Regards,

Jon
 
mjavadi responded:  2017-11-27 06:43
Hi Jon,

I'm trying to bring the tables into visual analytics software like Tibco Spotfire, where I integrate them with clinical and imaging data that's also being collected by the study. Our group utilizes LabKey for molecular data management and the users who sole interact with molecular data do use the LabKey UI for their needs, however, we also need a federated view of the data which is presented by dashboards built in Spotfire.

Thanks,

Mojib
 
Jon (LabKey DevOps) responded:  2017-12-05 22:03
Hi Mojib,

Thanks for the additional details.

I know that one of our clients is using Tibco Spotfire via the Rlabkey R package (https://www.labkey.org/Documentation/wiki-page.view?name=rAPI & https://cran.r-project.org/web/packages/Rlabkey/index.html) and TERR (https://community.tibco.com/products/terr).

We are also looking into Spotfire connectivity through the LabKey JDBC driver for upcoming premium feature work, but that's going to be a long way out.

So you could use the Rlabkey API with TERR if you need to pass the data across from Spotfire to LabKey without having to write directly to the database.

Regards,

Jon