Re: [basex-talk] Index cvs error throws "Content is not allowed in prolog"

[Erol Akarsu]

I solved this one,

SET PARSER csv
SET CSVPARSER encoding=utf-8, header=true, separator=comma
SET CREATEFILTER *.csv

But now with 16565274 rows csv file, 690M. During indexing, I am getting
this.
I have set memory to 30G

Creating Database...
java.lang.NegativeArraySizeException
        at java.util.Arrays.copyOf(Arrays.java:2271)
        at org.basex.util.TokenBuilder.addByte(TokenBuilder.java:242)
        at org.basex.util.TokenBuilder.add(TokenBuilder.java:151)
        at org.basex.io.parse.XmlTokenBuilder.add(XmlTokenBuilder.java:96)
        at
org.basex.io.parse.XmlTokenBuilder.addText(XmlTokenBuilder.java:51)
        at
org.basex.io.parse.csv.CsvStringConverter.entry(CsvStringConverter.java:76)
        at org.basex.io.parse.csv.CsvParser.record(CsvParser.java:105)
        at org.basex.io.parse.csv.CsvParser.parse(CsvParser.java:80)
        at org.basex.io.parse.csv.CsvParser.parse(CsvParser.java:54)
        at org.basex.io.parse.csv.CsvConverter.convert(CsvConverter.java:37)
        at org.basex.build.CsvParser.toXML(CsvParser.java:40)


On Wed, Jan 7, 2015 at 9:30 PM, Erol Akarsu <eaka...@gmail.com> wrote:

>
> I am trying to index an csv file through basexclient. I issued this command
>
> SET INTPARSE false; CREATE DB Properties Properties.csv
>
> got these error message in basex server. What shall I do to index csv
> through basexclient command?
>
>
> [kangadm@kangapp12 javaProcess]$ basexserver -d
> BaseX 7.9 [Server]
> Server was started (port: 1984)
> Creating Database...
> org.xml.sax.SAXParseException; systemId:
> file:///home/kangadm/basex/migros/production/javaProcess/Brands.sql.csv;
> lineNumber: 1; columnNumber: 1; Content is not allowed in prolog.
>         at
> com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:198)
>         at
> com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:177)
>         at
> com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:441)
>         at
> com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:368)
>         at
> com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1436)
>
>