SAP Knowledge Base Article - Preview

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

Symptom

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:

  • 09-18-2013 14:26:31.969 DEBUG [Thread-4] (TdsSrv.handleLanguage) Invoking SQL Parser for Lang command: insert into text_test (c1, c2) values (1    , ''   )
    09-18-2013 14:26:31.970 DEBUG [Thread-4] (TdsSrv.handleLanguage) statement: insert into text_test (c1, c2) values (1    , ''   )
    09-18-2013 14:26:31.982 DEBUG [Thread-4] (TdsSrv.handleLanguage) Invoking SQL Parser for Lang command: select c2 from text_test where c1=1
    09-18-2013 14:26:31.983 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)


Read more...

Environment

  • SAP Event Stream Processor 5.1

Product

SAP Event Stream Processor 5.1

Keywords

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.