SAP Knowledge Base Article - Preview

3666142 - All secondary node's emergency shutdown - SAP IQ

Symptom

All secondary nodes went down at the same time. The coordinator node has not crashed and continued up.

Based in all logs, issue occurred when replaying DDL statement: alter view "DBAXX"."view01_V" recompile

=====

Shared IQ Store update DDL statement:
alter view "DBAXX"."view01_V" recompile
Disposition: SQLSTATE:55W16  [ No recovery!! ]
***Emergency Shutdown***
Exception Thrown from dblib/db_iqutility.cxx:5167, Err# 46, tid 11111111111111 origtid 222222222222222
O/S Err#: 0, ErrID: 1025 (db_catalogException); SQLCode: -1009413, SQLState: 'QCB11', Severity: 23
Secondary server cannot maintain catalog sync. 
-- (dblib/db_iqutility.cxx 516

=====


Read more...

Environment

SAP IQ 16.1 SP05 PL10

Product

SAP IQ 16.1

Keywords

Secondary server cannot maintain catalog sync, Emergency Shutdown, SQLCode: -1009413, SQLState: 'QCB11', 55W16, SQLSTATE:55W16 , KBA , BC-SYB-IQ , Sybase IQ , 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.