SAP Knowledge Base Article - Preview

2488634 - Error 35330 data cannot be updated in a table with a columnstore index in phase MAIN_SWITCH/EU_SWITCH

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.