SAP Knowledge Base Article - Preview

3748000 - DROP USER command cause Emergency shutdown - SAP IQ

Symptom

  • Multiplex environment
  • The command "drop user" cause "Emergency Shutdown"

Excerpt of IQMSG

Shared IQ Store update DDL statement:
drop user "My_IQ_User"
Disposition: SQLSTATE:42W19 
-- dropped 0 of 0 connection(s) for user: DS_RN_00049SQLSTATE:42W19 
-- dropped 0 of 0 connection(s) for user: DS_RN_00049SQLSTATE:42W19 
-- dropped 0 of 0 connection(s) for user: DS_RN_00049SQLSTATE:42W19 
..... Lots of similar "dropped" message .....
-- dropped 0 of 0 connection(s) for user: DS_RN_00049SQLSTATE:42W19 
-- dropped 0 of 0 connection(s) for user: DS_RN_00049SQLSTATE:42W19 
-- dropped 0 of 0 connection(s) for user: DS_RN_00049SQLSTATE:42W19 Excerpt of sybipc06.iqmsg.20260205
***Emergency Shutdown***
Exception Thrown from dblib/db_iqutility.cxx:5167, Err# 46, tid 140222450317056 origtid 140222450317056
O/S Err#: 0, ErrID: 1025 (db_catalogException); SQLCode: -1009413, SQLState: 'QCB11', Severity: 23
[21051]: Secondary server cannot maintain catalog sync. 
-- (dblib/db_iqutility.cxx 5167) 
sp_mpxprocesstlvlog exception, SQLSTATE=QCB11 [Secondary server cannot maintain catalog sync. 
-- (dblib/db_iqutility.cxx 5167) ]


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

MPX, crash, abort, 42W19, "cannot maintain catalog sync" , 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.