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.