Error: Failed to retrieve report results

LabKey Support Forum (Inactive)
Error: Failed to retrieve report results Shadi Eshghi  2016-05-27 12:16
Status: Closed
 
Hi Jon,

Thanks for your quick reply.

I am running the development version of Labkey 16.1 on a private server and developing an R view for a custom sql query of targetedms schema type.

This is what I get by default in my R Report Builder Interface, which I believe is identical to what you provided.

# This sample code returns the query data in tab-separated values format, which LabKey then
# renders as HTML. Replace this code with your R script. See the Help tab for more details.
write.table(labkey.data, file = "${tsvout:tsvfile}", sep = "\t", qmethod = "double", col.names=NA)

An screenshot of the error is attached. I should also mention that the problem is not always persistent. Sometimes logging out and in again into the server temporarily fixes the issue, but most of the times it doesn't. And I get the same error even when using the default R script copied above, so it does not seem to depend on the script.

Thanks for your help!