SAP Knowledge Base Article - Preview

2433320 - How to synchronize secondary servers with the coordinator in multiplex - SAP IQ

Symptom

  •  In iqmsg:

I. 02/14 21:45:00. 0003714748 Secondary server out of catalog synch
I. 02/14 21:45:00. 0003714748 Exception Thrown from stcxtlib/st_txnMgr.cxx:3174, Err# 12, tid 8 origtid 8
I. 02/14 21:45:00. 0003714748    O/S Err#: 0, ErrID: 5120 (st_databaseException); SQLCode: -1008026, SQLState: 'QNA26', Severity: 14
I. 02/14 21:45:00. 0003714748 [21048]: Multiplex secondary server out of synchronization with the coordinator.
-- (stcxtlib/st_txnMgr.cxx 3174)

  • Output of sp_iqmpxversioninfo in secondary server:

CatalogID            VersionID                OAVID ServerType CatalogSync           WCatalogID           WVersionID
-------------------------------------------------------------------------------------------------------------------------------
          1300587831           1300587831           1300587831 W          F                     1300982609           1300982663

  • During start_iq secondary server, get following message:

Error: Multiplex secondary server out of synchronization with the coordinator.
Server failed to start


Read more...

Environment

SAP SYBASE IQ 15.4 and higher

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.4

Keywords

SQLCode: -1008026, out of synchronization, dbbackup, dblog, sp_iqmpxversioninfo , KBA , BC-SYB-IQ , Sybase IQ , How To

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.