Symptom
- Coordinator is upgraded to a newer SAP IQ version
- Secondary node immediately goes down with the following error:
.. ev_begintxn started
.. sp_mpxprocesstlvlog exception, SQLSTATE=53002 [Wrong number of values for INSERT] runstate=S(1)
.. ***Emergency Shutdown***
.. Exception Thrown from dblib/db_iqutility.cxx:4615, Err# 46, tid 6 origtid 6
.. 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 4615)
- Even after secondary node resync, the same issue persists
Read more...
Environment
- SAP IQ 16.0
- SAP IQ 16.1
Product
SAP IQ 16.0
Keywords
sp_mpxprocesstlvlog , catalog sync , syshistory, resync, "Emergency Shutdown", "Wrong number of values for INSERT" , KBA , errid: 535 (hos_constraintexception) , 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.