1856595 - Message: 30291 The procedure 'sys.sp_indexoption' cannot be executed within a transaction - SRS | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1856595 - Message: 30291 The procedure 'sys.sp_indexoption' cannot be executed within a transaction - SRS

Symptom

  • SAP Replication Server (SRS)
  • Creating a connection to Enterprise Connect Data Access (ECDA) to a Microsoft SQL Server (MSSQL) 
  • SRS reports the following error:

ERROR #1028 USER(...) - seful/cm.c(7850)
Message from server: Message: 30291, State 0, Severity 19 -- '[[Message Iteration=1|Data Source Name=W2K8Server\MSSQL2K8|SQLState=42000|Native Error=15002|Message=[Easysoft][SQL Server Driver 11.0][SQL Server]The procedure 'sys.sp_indexoption' cannot be executed within a transaction.]'.

 


Read more...

Environment

  • SAP Replication Server (SRS) all versions
  • Enterprise Connect Data Access (ECDA) all versions
  • Microsoft SQL Server 2008
  • Windows 2008

Product

SAP Replication Server 15.7 ; Sybase Enterprise Connect Data Access 15.0 ; Sybase EnterpriseConnect Data Access 15.7 ; Sybase Replication Server 15.6

Keywords

30291 Message from server: Message: 15002, State 0, Severity 16 SQLState=42000 Native Error=15002 sys.sp_indexoption MSSQL , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-ECD , Enterprise Connect (ECDA) , Bug Filed

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.