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 ONE Support launchpad (Login required).

Search for additional results

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