SAP Knowledge Base Article - Preview

3702257 - Error:" Cannot compile Like pattern: either bad pattern or pattern too long.' occurs when DS job fails - SAP Data Services

Symptom

  • Job fails intermittently with the error message: "[SAP][ODBC Driver][SAP IQ]Cannot compile Like pattern: either bad pattern or pattern too long."
  • The issue only occurs when multibyte characters are used. For example: decode (XXX.XXXlike 'n\[āā\]ra%' 
  • The issue is specific to SAP Data Services 4.3 Server on Linux. Works fine when DS Server is Windows.


Read more...

Environment

  • SAP Data Services
  • SAP IQ 16
  • Linux OS

Product

SAP Data Services 2025 ; SAP Data Services 4.3

Keywords

job failure, like pattern, multibyte characters, utf-8, codepage, sap data services, linux server, sap iq, pattern too long , KBA , EIM-DS-EXE , Job Execution , 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.