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:
<timestamp> 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~<timestamp> .
Error description:CSV Formatter failed to convert a string: SLA456~1800~CRITICAL~3hrs~NO0000001KO3~<timestamp>
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.
SAP Knowledge Base Article - Preview