com.univocity.parsers.common.TextParsingException: Length of parsed input (101) exceeds the maximum number of characters defined in your parser settings (100). Hint: Number of characters processed may have exceeded limit of 100 characters per column. Use settings.setMaxCharsPerColumn(int) to define the maximum number of characters a column can have Ensure your configuration is correct, with delimiters, quotes and escape sequences that match the input format you are trying to parse Parser Configuration: CsvParserSettings: Auto configuration enabled=true Autodetect column delimiter=false Autodetect quotes=false Column reordering enabled=true Empty value=null Escape unquoted values=false Header extraction enabled=null Headers=null Ignore leading whitespaces=true Ignore trailing whitespaces=true Input buffer size=1048576 Input reading on separate thread=true Keep escape sequences=false Keep quotes=false Length of content displayed on error=-1 Line separator detection enabled=false Maximum number of characters per column=100 Maximum number of columns=512 Normalize escaped line separators=true Null value=null Number of records to read=all Processor=none Restricting data in exceptions=false RowProcessor error handler=null Selected fields=none Skip empty lines=true Unescaped quote handling=nullFormat configuration: CsvFormat: Comment character=# Field delimiter=\t Line separator (normalized)=\n Line separator sequence=\n Quote character=" Quote escape character=" Quote escape escape character=null Internal state when error was thrown: line=23, column=0, record=22, charIndex=6218, content parsed=C78,The Electric Company,"The Electric Marketing Co., LLC",23456789,Y,FERC Electric Tariff Original

GitHub | mumrah | 6 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Strange maxCharsPerColumn behavior

    GitHub | 6 months ago | mumrah
    com.univocity.parsers.common.TextParsingException: Length of parsed input (101) exceeds the maximum number of characters defined in your parser settings (100). Hint: Number of characters processed may have exceeded limit of 100 characters per column. Use settings.setMaxCharsPerColumn(int) to define the maximum number of characters a column can have Ensure your configuration is correct, with delimiters, quotes and escape sequences that match the input format you are trying to parse Parser Configuration: CsvParserSettings: Auto configuration enabled=true Autodetect column delimiter=false Autodetect quotes=false Column reordering enabled=true Empty value=null Escape unquoted values=false Header extraction enabled=null Headers=null Ignore leading whitespaces=true Ignore trailing whitespaces=true Input buffer size=1048576 Input reading on separate thread=true Keep escape sequences=false Keep quotes=false Length of content displayed on error=-1 Line separator detection enabled=false Maximum number of characters per column=100 Maximum number of columns=512 Normalize escaped line separators=true Null value=null Number of records to read=all Processor=none Restricting data in exceptions=false RowProcessor error handler=null Selected fields=none Skip empty lines=true Unescaped quote handling=nullFormat configuration: CsvFormat: Comment character=# Field delimiter=\t Line separator (normalized)=\n Line separator sequence=\n Quote character=" Quote escape character=" Quote escape escape character=null Internal state when error was thrown: line=23, column=0, record=22, charIndex=6218, content parsed=C78,The Electric Company,"The Electric Marketing Co., LLC",23456789,Y,FERC Electric Tariff Original
  2. 0

    1.5版本load data infile 报错

    GitHub | 9 months ago | 694551594
    com.univocity.parsers.common.TextParsingException: Error processing input: java.lang.ArrayIndexOutOfBoundsException - 512 Hint: Number of columns processed may have exceeded limit of 512 columns. Use settings.setMaxColumns(int) to define the maximum number of columns your input can have Ensure your configuration is correct, with delimiters, quotes and escape sequences that match the input format you are trying to parse Parser Configuration: CsvParserSettings: Column reordering enabled=true Empty value=null Header extraction enabled=false Headers=null Ignore leading whitespaces=true Ignore trailing whitespaces=true Input buffer size=1048576 Input reading on separate thread=true Line separator detection enabled=false Maximum number of characters per column=4096 Maximum number of columns=512 Null value=null Number of records to read=all Parse unescaped quotes=true Row processor=none Selected fields=none Skip empty lines=trueFormat configuration: CsvFormat: Comment character=# Field delimiter=\t Line separator (normalized)=\n Line separator sequence=\n Quote character=" Quote escape character=quote escape Quote escape escape character=\0, line=0, char=2929. Content parsed: [null]

    Root Cause Analysis

    1. java.lang.ArrayIndexOutOfBoundsException

      100

      at com.univocity.parsers.common.input.DefaultCharAppender.appendUntil()
    2. com.univocity.parsers
      AbstractParser.parseNext
      1. com.univocity.parsers.common.input.DefaultCharAppender.appendUntil(DefaultCharAppender.java:216)
      2. com.univocity.parsers.csv.CsvParser.parseRecord(CsvParser.java:136)
      3. com.univocity.parsers.common.AbstractParser.parseNext(AbstractParser.java:444)
      3 frames
    3. com.lucidworks.apollo
      CsvParserTest.testUnivocity
      1. com.lucidworks.apollo.pipeline.parse.impl.text.CsvParserTest.testUnivocity(CsvParserTest.java:453)
      1 frame
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:498)
      4 frames
    5. TestNG
      RemoteTestNGStarter.main
      1. org.testng.internal.MethodInvocationHelper.invokeMethod(MethodInvocationHelper.java:84)
      2. org.testng.internal.Invoker.invokeMethod(Invoker.java:714)
      3. org.testng.internal.Invoker.invokeTestMethod(Invoker.java:901)
      4. org.testng.internal.Invoker.invokeTestMethods(Invoker.java:1231)
      5. org.testng.internal.TestMethodWorker.invokeTestMethods(TestMethodWorker.java:127)
      6. org.testng.internal.TestMethodWorker.run(TestMethodWorker.java:111)
      7. org.testng.TestRunner.privateRun(TestRunner.java:767)
      8. org.testng.TestRunner.run(TestRunner.java:617)
      9. org.testng.SuiteRunner.runTest(SuiteRunner.java:334)
      10. org.testng.SuiteRunner.runSequentially(SuiteRunner.java:329)
      11. org.testng.SuiteRunner.privateRun(SuiteRunner.java:291)
      12. org.testng.SuiteRunner.run(SuiteRunner.java:240)
      13. org.testng.SuiteRunnerWorker.runSuite(SuiteRunnerWorker.java:52)
      14. org.testng.SuiteRunnerWorker.run(SuiteRunnerWorker.java:86)
      15. org.testng.TestNG.runSuitesSequentially(TestNG.java:1224)
      16. org.testng.TestNG.runSuitesLocally(TestNG.java:1149)
      17. org.testng.TestNG.run(TestNG.java:1057)
      18. org.testng.IDEARemoteTestNG.run(IDEARemoteTestNG.java:72)
      19. org.testng.RemoteTestNGStarter.main(RemoteTestNGStarter.java:124)
      19 frames
    6. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:498)
      4 frames
    7. IDEA
      AppMain.main
      1. com.intellij.rt.execution.application.AppMain.main(AppMain.java:147)
      1 frame