2388691 - DB Input Adapter Discovery error for uniqueidentifier column - SAP ESP | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2388691 - DB Input Adapter Discovery error for uniqueidentifier column - SAP ESP

Symptom

  • The ESP project is using the Database Input Adapter (db_in) to connect to a Microsoft SQL Server 2014 database table.
     
  • The database table has one or more columns with the uniqueidentifier datatype.
     
  • When using ESP Studio's Schema Discovery on the database table, the Data Services view displays the following error message for the table:
     

No enum constant com.sybase.esp.sdk.data.Schema.DataType.N/A

forKBADiscoveryError1.jpg

 

  • In the Data Services view, when using drag and drop on the table (to create a window or stream in the ESP Authoring perspective), creation fails and ESP Studio reports the following error:
     

Error: Discovery operation failed, reason:
Cannot cast class com.sybase.cep.studio.common.dataservices.model.DBError to class com.sybase.cep.studio.common.dataservices.model.DBColumn

forKBADiscoveryError2.jpg


Read more...

Environment

  • SAP Event Stream Processor (ESP) 5.1 SP12
  • Microsoft SQL Server 2014

Product

SAP Event Stream Processor 5.1

Keywords

streaming, processing, discover , 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.