SAP Knowledge Base Article - Preview

2288258 - CSV Formatter exception in JMS adapter - SAP ESP 5.1 SP10

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

SAP Event Stream Processor 5.1

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.