[BioC] Error in sqliteExecStatement(con, statement, bind.data)

Kaj Chokeshaiusaha [guest] guest at bioconductor.org
Wed Feb 20 08:35:30 CET 2013


Dear R helpers,

I try to to create .db for Bovine Agilent Microarray Ship. R shows me error as indicated

> library(AnnotationForge)
> setwd("D:\\Progect for MOU\\Detailed Projects\\Cumulus cell")
> bov_9712<-read.table("015354_D_GeneList_20061130.txt", sep = "\t", skip=1,
+ header = FALSE, as.is = TRUE, fill=T)[,c(1,5)]
> write.table(bov_9712, file = "bov_9712.txt", sep = "\t",
+ row.names=F, col.names=F)
> output="D:\\Progect for MOU\\Detailed Projects\\Cumulus cell\\Annotations"
> makeDBPackage("BOVINECHIP_DB",
+ affy=FALSE,
+ prefix="bov_9712gbNRef",
+ fileName="bov_9712.txt",
+ baseMapType="gbNRef",
+ outputDir=output,
+ version="1.0.0",
+ manufacturer = "Agilent Technologies",
+ chipName = "Agilent-015354 Bovine Oligo Microarray")
Error in sqliteExecStatement(con, statement, bind.data) : 
  RS-DBI driver: (error in statement: table metadata already exists)

Please describe what does the error indicate? and please guide me how to solve it.

Best Regards,
Kaj


 -- output of sessionInfo(): 

R version 2.15.1 (2012-06-22)
Platform: x86_64-pc-mingw32/x64 (64-bit)

locale:
[1] LC_COLLATE=Thai_Thailand.874  LC_CTYPE=Thai_Thailand.874   
[3] LC_MONETARY=Thai_Thailand.874 LC_NUMERIC=C                 
[5] LC_TIME=Thai_Thailand.874    

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
[1] BiocInstaller_1.8.3   AnnotationForge_1.0.3 org.Hs.eg.db_2.8.0   
[4] RSQLite_0.11.2        DBI_0.2-5             AnnotationDbi_1.20.3 
[7] Biobase_2.18.0        BiocGenerics_0.4.0   

loaded via a namespace (and not attached):
[1] IRanges_1.16.5  parallel_2.15.1 stats4_2.15.1   tools_2.15.1 

--
Sent via the guest posting facility at bioconductor.org.



More information about the Bioconductor mailing list