2142117 - Discarded Records or Invalid function argument error on using non-numeric values in to_integer function - SAP ESP | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2142117 - Discarded Records or Invalid function argument error on using non-numeric values in to_integer function - SAP ESP

Symptom

  • In an SAP Event Stream Processor (ESP) 5.1 project, strings are converted to integer values using the construct "ifnull(to_integer(stringvalue), nullvalue)".
  • When non-numeric values are supplied, the following error is written into the log file and the corresponding record is getting discarded:

9640 | container | [SP-3-131082] (71.807) sp(10160) CompiledStream(AnalysisStream): Invalid function arguments.string_tointeger 

  • The file with discarded records contains the following message:

Stream(): error occurred in computation of row. (tid=1)
An internal error has occurred. ComputeVm of label l_AnalysisStream_InputData for logic <InputData EntryId="112" EntryValue="samplestring"/>.


Read more...

Environment

SAP Event Stream Processor (ESP) 5.1

Product

SAP Event Stream Processor 5.1

Keywords

regexp_search, regex, streaming, processing , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.