SAP Knowledge Base Article - Preview

2488634 - Error "35330: INSERT statement failed because data cannot be updated in a table with a columnstore index" in MAIN_SWITCH/EU_SWITCH phase

Symptom

SUM error in phase MAIN_SWITCH/EU_SWITCH.

  • SAPupConsole.log:

Severe error(s) occurred in phase MAIN_SWITCH/EU_SWITCH!

Last error code set: Errors were found in the logfile MSSPROCSTHROW.LOG after
execution of the script MSSPROCSTHROW.SQL. SAPup cannot proceed until these
errors are fixed.

  • SAPup_troubleticket.log

SAPup broke during phase EU_SWITCH in module MAIN_SWITCH / Downtime I: Switch tables and Kernel
Error Message: Errors were found in the logfile MSSPROCSTHROW.LOG after execution of the script MSSPROCSTHROW.SQL. SAPup cannot proceed until these errors are fixed.

  • MSSPROCSTHROW.LOG

(0 rows affected)
The module 'sap_backup_databases' depends on the missing object 'msdb..sap_backup_user_exit'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'sap_dbcoll' depends on the missing object 'sap_clr_retrieve'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'sap_verify_backups' depends on the missing object 'msdb..sap_user_verify_backups'. The module will still be created; however, it cannot run successfully until the object exists.
Msg 50000, Level 15, State 1, Server BASWSAPPSQL\P03, Line 79
Creation of stored procedure 'sap_z_collector' threw SQL Error 35330: INSERT statement failed because data cannot be updated in a table with a columnstore index. Consider disabling the columnstore index before issuing the INSERT statement, then rebuilding the columnstore index after INSERT is complete.
Execution completed successfully.


Read more...

Environment

SAP Netweaver System;
SQL Server database

 

Product

SAP NetWeaver all versions

Keywords

SUM, MAIN_SWITCH/EU_SWITCH, SQL Error 35330: INSERT statement failed because data cannot be updated in a table with a columnstore index, Consider disabling the columnstore index before issuing the INSERT statement, then rebuilding the columnstore index after INSERT is complete,

, KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BC-UPG-TLS-TLA , Upgrade tools for ABAP , 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.