2259644 - How to understand CDB compilation conditions - SRS 15.7.1

Symptom

This article explains how the Consolidated DataBase (CDB) determines when statements are compilable or not depending on errors found in the errorlog. For example:

Message below is reported when CDB cannot compile statements:

HQCPL: table .DBA non-compilable due to pkey changed and NA data
TEST_IQ_390_1291(TEST_IQ): total 1 tables, noncmpl cmds 3

However, message below is reported when CDB can compile statements:

Msg : TEST_IQ_390_1313(TEST_IQ): total 1 tables, noncmpl cmds 0
CDB table 'rs_iDBA_390_1' row-count 1
CDB table 'rs_uDBA_390_1' row-count 1
Replicate to: .DBA, total INS 1/0, UPD 1/0, DEL 0/0 owner F

Environment

SAP Replication Server (SRS) 15.7.1 - Real Time Loading Edition

Product

Sybase Replication Server 15.7, real-time loading edition

Keywords

KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-RSO , Rep Server Options (RSO) , 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.