1921948 - ESP Replication Adapter raises error 400050 when Replication Server tries to replicate the text data type to Event Stream Processor

While trying to replicate Oracle CLOB data (or any other 'text' data type from other heterogeneous data sources) to Event Stream Processor (ESP), the error 400050 is raised:

<TIMESTAMPT> DEBUG [Thread-4] (TdsSrv.handleLanguage) Invoking SQL Parser for Lang command: insert into text_test (c1, c2) values (1    , ''   )
<TIMESTAMPT> DEBUG [Thread-4] (TdsSrv.handleLanguage) statement: insert into text_test (c1, c2) values (1    , ''   )
<TIMESTAMPT> DEBUG [Thread-4] (TdsSrv.handleLanguage) Invoking SQL Parser for Lang command: select c2 from text_test where c1=1
<TIMESTAMPT>ERROR [Thread-4] (TdsSrv.handleLanguage) Error code:400050, Severity : 3 (Error)
Error message:SQL Parser Unsupported Statement
Error description:Please check stacktrace below for more information
com.sybase.esp.adapter.repserver.SqlParserUnsupportedStatementException: Unsupported: select c2 from text_test where c1=1
        at com.sybase.esp.adapter.repserver.SqlParser.doSelect(Unknown Source)
        at com.sybase.esp.adapter.repserver.SqlParser.parseByOperator(Unknown Source)
        at com.sybase.esp.adapter.repserver.SqlParser.parse(Unknown Source)
        at com.sybase.esp.adapter.repserver.TdsSrv.handleLanguage(Unknown Source)
        at com.sybase.jdbc4.tds.SrvReceiver.language(Unknown Source)
        at com.sybase.jdbc4.tds.SrvSession.fireEvent(Unknown Source)
        at com.sybase.jdbc4.tds.SrvSession.processRequests(Unknown Source)
        at com.sybase.jdbc4.tds.SrvSession.run(Unknown Source)
        at java.lang.Thread.run(Thread.java:722)

• SAP Event Stream Processor 5.1

ESP, LoB, CLOB, data types, replication , KBA , BC-SYB-ESP , Sybase ESP (Event Stream Processor) , Problem