[BioC] makePdInfoPackage Error in sqliteExecStatement(con, statement, bind.data) : , bind.data must have non-zero dimensions

mabawsa mabawsa at gmail.com
Wed Feb 22 07:11:58 CET 2012


Hi,
I get "Error in sqliteExecStatement(con, statement, bind.data) : ,  
bind.data must have non-zero dimensions" when run.
It seems similar this error 
https://stat.ethz.ch/pipermail/bioconductor/2011-February/037796.html. I 
generated the pos file myself.
I guess the SEQ_ID on the NDF file is strange but the entry at 194289 
and 194290 seems to be OK.
                     SEQ_ID MISMATCH PROBE_CLASS          PROBE_ID
194288    CHR9:46353-46389        0  experiment CHR0999P000090528
194289 CHR13:230623-230659        0  experiment CHR1300P000332204
194290 CHR13:595769-595805        0  experiment CHR1300P000337972
194291    CHR1:85497-85533        0  experiment CHR0100P000197636

Any Help would be greatly appreciated...


Here is my script

library('oligo', quietly=TRUE)
library('ff', quietly=TRUE)
library('pdInfoBuilder', quietly=TRUE)
library('genefilter', quietly=TRUE)
library('limma', quietly=TRUE)
library('RColorBrewer', quietly=TRUE)
palette(brewer.pal(8, "Dark2"))

data.dir <- "/microarray-data/ExtractedData/xys" #point to where the 
data is stored
annotation.dir <- "/RNA/NASA/"
xys.files <- list.xysfiles(data.dir, full.names = TRUE)
pos.file <- list.files(annotation.dir, pattern=".pos", full.names = TRUE)
ndf.file <- list.files(annotation.dir, pattern=".ndf", full.names = TRUE)

####################################################
## Make info package  MUST have only one POS and  ##
## NDF file in the directory                      ##
####################################################
seed <- new("NgsTilingPDInfoPkgSeed",
             ndfFile = ndf.file,
             xysFile = xys.files[1],
             posFile = pos.file,
             author = "x",
             email = "x at gmail.com",
             biocViews = "AnnotationData",
             genomebuild = "S288C_reference_genome_R49-1-1_20051216",
             organism = "Yeast",
             manufacturer="Nimblegen",
             species = "Saccharomyces cerevisiae", url = 
"http://google.com")

makePdInfoPackage(seed, destDir=annotation.dir)


Here is my output:

================================================================================
Building annotation package for Nimblegen Tiling Array
NDF: 100507_NYW_BC396_NASA_Yeast_WG.ndf
POS: 100507_NYW_BC396_NASA_Yeast_WG.pos
XYS: 09_20_Expression_405004_S04.xys
================================================================================
Parsing file: 100507_NYW_BC396_NASA_Yeast_WG.ndf... OK
Parsing file: 100507_NYW_BC396_NASA_Yeast_WG.pos... OK
Merging NDF and POS files... OK
Parsing file: 09_20_Expression_405004_S04.xys... OK
Creating package in 
/home/dougie/Documents/projects/RNA/NASA//pd.100507.nyw.bc396.nasa.yeast.wg
Inserting 194289 rows into table featureSet... OK
Inserting 0 rows into table pmfeature... Error in 
sqliteExecStatement(con, statement, bind.data) :
   bind.data must have non-zero dimensions

 > traceback()
8: stop("bind.data must have non-zero dimensions")
7: sqliteExecStatement(con, statement, bind.data)
6: sqliteQuickSQL(conn, statement, bind.data, ...)
5: dbGetPreparedQuery(conn, sql_template, bind.data = data)
4: dbGetPreparedQuery(conn, sql_template, bind.data = data)
3: dbInsertDataFrame(conn, "pmfeature", parsedData[["pmFeatures"]],
        tiledRegionPmFeatureSchema[["col2type"]], !quiet)
2: makePdInfoPackage(seed, destDir = annotation.dir)
1: makePdInfoPackage(seed, destDir = annotation.dir)

 > sessionInfo()
R version 2.14.1 (2011-12-22)
Platform: x86_64-pc-linux-gnu (64-bit)

locale:
  [1] LC_CTYPE=en_GB.UTF-8       LC_NUMERIC=C
  [3] LC_TIME=en_GB.UTF-8        LC_COLLATE=en_GB.UTF-8
  [5] LC_MONETARY=en_GB.UTF-8    LC_MESSAGES=en_GB.UTF-8
  [7] LC_PAPER=C                 LC_NAME=C
  [9] LC_ADDRESS=C               LC_TELEPHONE=C
[11] LC_MEASUREMENT=en_GB.UTF-8 LC_IDENTIFICATION=C

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

other attached packages:
  [1] genefilter_1.36.0    Ringo_1.18.0         Matrix_1.0-3
  [4] lattice_0.20-0       limma_3.10.2         RColorBrewer_1.0-5
  [7] pdInfoBuilder_1.18.0 affxparser_1.26.2    RSQLite_0.11.1
[10] DBI_0.2-5            ff_2.2-5             bit_1.1-8
[13] oligo_1.18.1         oligoClasses_1.16.0  Biobase_2.14.0
[16] stringr_0.6

loaded via a namespace (and not attached):
  [1] affyio_1.22.0         annotate_1.32.1       AnnotationDbi_1.16.16
  [4] Biostrings_2.22.0     IRanges_1.12.6        plyr_1.7.1
  [7] preprocessCore_1.16.0 splines_2.14.1        survival_2.36-12
[10] xtable_1.7-0          zlibbioc_1.0.0



More information about the Bioconductor mailing list