Symptom
When an input stream has a BigDateTime column defined for the JMS CSV Input Adapter,
the following error message is reported in the frameworkadapter.log when the project is running:
02-23-2016 06:10:59.721 ERROR [Thread-18] (CSVInputFormatter.parseCSV)
Exception is thrown java.lang.StringIndexOutOfBoundsException: String index out of range: 26 at
java.lang.String.substring(String.java:1950) at com.sybase.esp.adapter.framework.common.BigDatetimeFormat.extractMicros
(BigDatetimeFormat.java:296) at com.sybase.esp.adapter.framework.common.BigDatetimeFormat.parse
(BigDatetimeFormat.java:153) at com.sybase.esp.adapter.formatters.csv.CSVInputFormatter.parseCSV
(CSVInputFormatter.java:317) at com.sybase.esp.adapter.formatters.csv.CSVInputFormatter.convert
(CSVInputFormatter.java:206) at com.sybase.esp.adapter.framework.wrappers.FormatterWrapper.processRow
(FormatterWrapper.java:175) at com.sybase.esp.adapter.framework.wrappers.FormatterWrapper.run
(FormatterWrapper.java:150) at java.lang.Thread.run(Thread.java:812) 02-23-2016 06:10:59.726
ERROR [Thread-18] (CSVInputFormatter.convert) Error code:402005, Severity : 3 (Error)
Error message:CSV Formatter failed to convert a string: SLA456~1800~CRITICAL~3hrs~NO0000001KO3~2016-02-22T18:05:00:007.
Error description:CSV Formatter failed to convert a string: SLA456~1800~CRITICAL~3hrs~NO0000001KO3~2016-02-22T18:05:00:007.
Read more...
Environment
- ESP 5.1 SP10
Product
Keywords
csv,jms,bigdatetime,date,format,backslash,formatter,exception,adapter,CSVInputFormatter.parseCSV , KBA , BC-SYB-ESP , Sybase ESP (Event Stream Processor) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.