SAP Knowledge Base Article - Preview

2191336 - Table Comparison transform job fails with error: Cursors are not supported on a table which has a clustered columnstore index - SAP Data Services 4.2 SP5

Symptom

A job which contains a table comparison transform fails with error:

780 6376 DBS-070401 7/10/2015 1:40:09 PM ODBC data source <MSSQL2014> error message for operation <SQLExecute>: <[Microsoft][SQL Server Native Client 11.0][SQL

780 6376 DBS-070401 7/10/2015 1:40:09 PM Server]Cursors are not supported on a table which has a clustered columnstore index.

 


Read more...

Environment

  • SAP Data Services 14.2.5.800
  • SAP Information Platform Services 4.1 SP4
  • SQL Server 2014
  • Windows Server 2012 R2

Product

SAP Data Services 4.2

Keywords

DBS-070401, columnstore index, clustered, table comparison , KBA , EIM-DS-EXE , Job Execution , How To

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.