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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.