• Sign In
  1. Messages

Error in retrieving Date fields using Rlabkey with R 2.11.1

LabKey Support Forum (Inactive)

View Message

view list print
Error in retrieving Date fields using Rlabkey with R 2.11.1 ashoka  2010-07-02 12:10
Status: Closed
 
I have a query in Labkey as follows:
SELECT MS2SearchRuns.Name AS DatasetName,
MS2SearchRuns.MS2Details.PeptideCount AS PeptideCount,
MS2SearchRuns.MS2Details.Created
FROM MS2SearchRuns

which returns a Date field as the last item. If I use labkey.selectRows in Rlabkey to retrieve this data in R, I get an error message with the new R version (2.11.1):

Error in strptime(x, format, tz = "GMT") :
  use of %Z for input is not supported

It used to work fine with the older version of R (I had a 2.10.x before). I noticed that R has changed strptime starting 2.11.0. Any ideas?

Thanks,
-Ashoka
 
 
Brian Connolly responded:  2010-07-09 09:03
Ashoka,
I am very sorry for the delay in getting back to you on this problem.

What operating system are you experiencing this problem on? And this is happening when you are running R on your desktop/laptop and not when you are using an R view on the server correct?

Again, I am very sorry for the delay.

Brian
 
Peter responded:  2010-07-09 13:17
Ashoka,

We found this same problem recently. Please try the attached update to Rlabkey (2.1.114). We are intending to release this to CRAN when LabKey Server version 10.2 is officially released this month.

Peter