Hi Kaj,

That error means that you have previously tried to make this package (and presumably failed or you wouldn't be trying again).  I am guessing that this
is probably from when you were passing in the wrong argument type (from when you wrote in before).

So what is wrong now is that the old half finished .sqlite file is still in your working directory (which is why there is a metadata table there already).

Please delete all files that were generated from when you did this before, and start again.


   Marc





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.


	[[alternative HTML version deleted]]

