<html><head><meta name="color-scheme" content="light dark"></head><body><pre style="word-wrap: break-word; white-space: pre-wrap;">
***********************************************************************
                 Oracle GoldenGate Delivery for Oracle
    Version 18.1.0.0.0 OGGCORE_18.1.0.0.0_PLATFORMS_180928.0432_FBO
 Solaris, sparc, 64bit (optimized), Oracle 12c on Sep 30 2018 10:11:16
 
Copyright (C) 1995, 2018, Oracle and/or its affiliates. All rights reserved.

                    Starting at 2019-10-04 10:51:38
***********************************************************************

Operating System Version:
SunOS
Version 11.4.9.5.0, Release 5.11
Node: dware1
Machine: sun4v
                         soft limit   hard limit
Address Space Size   :    unlimited    unlimited
Heap Size            :    unlimited    unlimited
File Size            :    unlimited    unlimited
CPU Time             :    unlimited    unlimited

Process id: 19364

Description: 

***********************************************************************
**            Running with the following parameters                  **
***********************************************************************

2019-10-04 10:51:39  INFO    OGG-03059  Operating system character set identified as US-ASCII.

2019-10-04 10:51:39  INFO    OGG-02695  ANSI SQL parameter syntax is used for parameter parsing.

2019-10-04 10:51:44  INFO    OGG-01360  REPLICAT is running in Integrated mode.
REPLICAT REPLOGGT
ASSUMETARGETDEFS
DDLOPTIONS REPORT
USERIDALIAS oraggext
ddl include mapped
MAP CBS_CORE.CB_SUB_INVOICE,TARGET CBSOGG.CB_SUB_INVOICE;
MAP CBS_CORE.CB_INVOICE,TARGET CBSOGG.CB_INVOICE;
MAP CBS_CORE.CB_ADDRESS_XML, TARGET CBSOGG.CB_ADDRESS_XML;
MAP CBS_CORE.CB_SUB_AR_AP,TARGET CBSOGG.CB_SUB_AR_AP ;
MAP CBS_CORE.CB_RECEIPTS,TARGET CBSOGG.CB_RECEIPTS;
MAP CBS_CORE.CB_ACCS_RECEIVE_PAY_ADJUST,TARGET CBSOGG.CB_ACCS_RECEIVE_PAY_ADJUST;
MAP CBS_CORE.CB_SUBS_REFUND,TARGET CBSOGG.CB_SUBS_REFUND  ;
MAP CBS_CORE.GSM_SERVICE_MAST,TARGET CBSOGG.GSM_SERVICE_MAST   ;
MAP CBS_CORE.CB_PAY_MODE_DTLS,TARGET CBSOGG.CB_PAY_MODE_DTLS   ;
MAP CBS_CORE.CB_ACCOUNT_SERVICE_LIST,TARGET CBSOGG.CB_ACCOUNT_SERVICE_LIST ;
MAP CBS_CORE.CB_ACCOUNT_RECEIVE_PAY,TARGET CBSOGG.CB_ACCOUNT_RECEIVE_PAY  ;
MAP CBS_CORE.CB_ACCOUNT_MASTER,TARGET CBSOGG.CB_ACCOUNT_MASTER  ;
MAP CBS_CORE.CB_INVOICE_DETAILS,TARGET CBSOGG.CB_INVOICE_DETAILS ;
MAP CBS_CUST.CB_POS_TRANS_DTLS,TARGET CBSOGG.CB_POS_TRANS_DTLS  ;
MAP CBS_CUST.CB_POS_TRANSACTIONS,TARGET CBSOGG.CB_POS_TRANSACTIONS;
MAP CBS_CORE.CB_RECEIPTS_ADJUST,TARGET CBSOGG.CB_RECEIPTS_ADJUST    ;
MAP CBS_CORE.CB_CALCULATED_CHARGES,TARGET CBSOGG.CB_CALCULATED_CHARGES ;
MAP CBS_CORE.CB_RECEIPTS_ADJUST,TARGET CBSOGG.CB_RECEIPTS_ADJUST ;
MAP CBS_CORE.FXL_CYCLE_SUMMARY_DETAILS,TARGET CBSOGG.FXL_CYCLE_SUMMARY_DETAILS ;
MAP CBS_CORE.CB_SUBSCRIBER_MASTER,target cbsogg.CB_SUBSCRIBER_MASTER  ;
MAP CBS_CORE.CB_SUBS_POS_SERVICES,target cbsogg.CB_SUBS_POS_SERVICES ;
MAP CBS_CORE.CB_CR_DB_NOTES,target cbsogg.CB_CR_DB_NOTES   ;
MAP CBS_CUST.CB_MULTI_ACCT_RECEIPT_DETAILS,target CBSOGG.CB_MULTI_ACCT_RECEIPT_DETAILS ;
MAP CBS_CUST.CB_MULTI_ACCT_INVOICE_DETAILS,target CBSOGG.CB_MULTI_ACCT_INVOICE_DETAILS ;
MAP CBS_CORE.CB_SUBS_OFFER_DETAILS,TARGET CBSOGG.CB_SUBS_OFFER_DETAILS,KEYCOLS(ACCOUNT_LINK_CODE_N,FACILITY_REF_ID_V,OFFER_CODE_V);
MAP CBS_CORE.CB_WORK_ORDER,TARGET CBSOGG.CB_WORK_ORDER;
MAP CBS_CORE.CB_SUBS_INFORMATION_MASTER,TARGET CBSOGG.CB_SUBS_INFORMATION_MASTER  ;
MAP TT_MSO.CB_SELFCARE_USERS,TARGET CBSOGG.CB_SELFCARE_USERS   ;
MAP TT_MSO.TMP_REPORT_ENT_SELFCARE,TARGET CBSOGG.TMP_REPORT_ENT_SELFCARE   ;
MAP CBS_CUST.CB_MULTI_ACCT_RECEIPT_HEADER,TARGET CBSOGG.CB_MULTI_ACCT_RECEIPT_HEADER  ;
MAP CBS_CORE.CB_AUTO_DEBIT,TARGET CBSOGG.CB_AUTO_DEBIT  ;
MAP CBS_CORE.CB_SUBS_PAID_ADV_DTLS,TARGET CBSOGG.CB_SUBS_PAID_ADV_DTLS;
MAP CBS_CORE.CB_SUBS_PROVISIONING,TARGET CBSOGG.CB_SUBS_PROVISIONING ;
MAP CLM_TT.TT_TICKETINFO,TARGET CBSOGG.TT_TICKETINFO;
MAP CLM_TT.TT_CATEGORY_MASTER,TARGET CBSOGG.TT_CATEGORY_MASTER ;
MAP CLM_TT.WF_TODOITEM_HISTORY,TARGET CBSOGG.WF_TODOITEM_HISTORY ;
MAP CLM_TT.TT_TICKET_ADDNL_INFO,TARGET CBSOGG.TT_TICKET_ADDNL_INFO,keycols(DOCKET_NUMBER_N) ;
MAP CLM_TT.WF_WORKFLOW,TARGET CBSOGG.WF_WORKFLOW ;
MAP CLM_TT.WF_WORKASSIGNMENT_HISTORY,TARGET CBSOGG.WF_WORKASSIGNMENT_HISTORY ;
MAP CLM_TT.WF_WORKASSIGNMENT,TARGET CBSOGG.WF_WORKASSIGNMENT ;
MAP CLM_TT.WF_TODOITEM,TARGET CBSOGG.WF_TODOITEM,FILTER ( @GETENV ('TRANSACTION', 'CSN') &gt;  267043013905);
MAP CLM_TT.TT_TICKETINCIDENT,TARGET CBSOGG.TT_TICKETINCIDENT ;
MAP CBS_CORE.WF_USERGROUP, TARGET CBSOGG.WF_USERGROUP;
MAP CBS_CORE.CB_USER_GROUP, TARGET CBSOGG.CB_USER_GROUP ;
MAP CBS_CORE.CB_USERS, TARGET CBSOGG.CB_USERS ;
MAP CBS_CORE.CB_SUB_SERVICES, TARGET CBSOGG.CB_SUB_SERVICES ;
MAP CBS_CORE.CB_BANK_MASTER, TARGET CBSOGG.CB_BANK_MASTER ;
MAP CBS_CORE.CB_SUBSCRIBER_SUB_CATEGORY, TARGET CBSOGG.CB_SUBSCRIBER_SUB_CATEGORY ;
MAP CBS_CORE.CB_SUBSCRIBER_CATEGORY, TARGET CBSOGG.CB_SUBSCRIBER_CATEGORY ;
MAP CBS_CORE.CB_RETAIL_OUTLETS, TARGET CBSOGG.CB_RETAIL_OUTLETS ;
MAP CBS_CORE.CB_ADVANCE_RENTAL, TARGET CBSOGG.CB_ADVANCE_RENTAL ;
MAP CBS_CORE.CB_PACKAGE, TARGET CBSOGG.CB_PACKAGE ;
MAP CBS_CORE.CB_OFFERS, TARGET CBSOGG.CB_OFFERS ;
MAP CBS_CORE.CB_DEALER_MASTER, TARGET CBSOGG.CB_DEALER_MASTER ;
MAP CBS_CORE.CB_ARTICLE_GROUPS, TARGET CBSOGG.CB_ARTICLE_GROUPS ;
MAP CBS_CORE.CB_ARTICLES, TARGET CBSOGG.CB_ARTICLES ;
MAP CBS_CORE.PS_ACTION, TARGET CBSOGG.PS_ACTION ;
MAP CBS_CORE.CB_STATUS_MASTER, TARGET CBSOGG.CB_STATUS_MASTER ;
MAP CBS_CORE.CB_SERVICES, TARGET CBSOGG.CB_SERVICES ;
MAP CBS_CORE.CB_PAYMENT_METHODS, TARGET CBSOGG.CB_PAYMENT_METHODS ;
MAP CBS_CORE.CB_SCHEME_REFERENCE, TARGET CBSOGG.CB_SCHEME_REFERENCE ;
MAP CBS_CORE.CB_CANCEL_RECEIPTS, TARGET CBSOGG.CB_CANCEL_RECEIPTS ;
MAP CBS_CORE.FXL_SERVICE_MAST, TARGET CBSOGG.FXL_SERVICE_MAST ;
MAP CBS_CORE.CB_POS_SERVICES, TARGET CBSOGG.CB_POS_SERVICES ;
MAP CBS_CORE.CB_WORK_ORDER_PRODUCT_DTLS, TARGET CBSOGG.CB_WORK_ORDER_PRODUCT_DTLS ;
MAP CBS_CORE.CB_REASON_MASTER, TARGET CBSOGG.CB_REASON_MASTER ;
MAP CBS_CORE.CB_POS_SERVICES_PARAMS, TARGET CBSOGG.CB_POS_SERVICES_PARAMS ;
MAP CBS_CORE.cb_order_request_dtls, TARGET CBSOGG.cb_order_request_dtls ;
MAP CBS_CORE.WF_WRKFLWMGR, TARGET CBSOGG.WF_WRKFLWMGR ;
MAP CBS_CORE.CB_INSTALLMENT, TARGET CBSOGG.CB_INSTALLMENT ;
MAP CBS_CORE.CB_INSTALLMENT_DTLS, TARGET CBSOGG.CB_INSTALLMENT_DTLS ;
MAP CBS_CORE.cb_serv_installment_dtls, TARGET CBSOGG.cb_serv_installment_dtls ;
MAP CBS_CORE.cb_subs_deposits, TARGET CBSOGG.cb_subs_deposits ;
MAP CBS_CORE.cb_bill_cycle, TARGET CBSOGG.cb_bill_cycle ;
MAP CBS_CUST.CB_DID_HEADER_MAP, TARGET CBSOGG.CB_DID_HEADER_MAP ;
MAP CBS_CORE.CB_REVENUE, TARGET CBSOGG.CB_REVENUE ;
MAP CBS_CORE.CB_SAP_GL_SL_CODES, TARGET CBSOGG.CB_SAP_GL_SL_CODES ;
MAP CBS_CORE.CB_SCHEDULES, TARGET CBSOGG.CB_SCHEDULES  ;
MAP CBS_CORE.cb_batch_process_metrics, TARGET CBSOGG.cb_batch_process_metrics ;
MAP CBS_CORE.CB_BATCH_CRITERIA_DETAILS, TARGET CBSOGG.CB_BATCH_CRITERIA_DETAILS ;
MAP CBS_CORE.inv_stock_summary, TARGET CBSOGG.inv_stock_summary ;

2019-10-04 10:51:47  INFO    OGG-06451  Triggers will be suppressed by default.

2019-10-04 10:51:47  INFO    OGG-01815  Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /ogg/ora12c/dirtmp.

Database Version:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
PL/SQL Release 12.1.0.2.0 - Production
CORE	12.1.0.2.0	Production
TNS for Solaris: Version 12.1.0.2.0 - Production
NLSRTL Version 12.1.0.2.0 - Production

Database Language and Character Set:
NLS_LANGUAGE     = "AMERICAN" 
NLS_TERRITORY    = "AMERICA" 
NLS_CHARACTERSET = "WE8MSWIN1252" 

2019-10-04 10:51:47  INFO    OGG-06604  Database DWARE1 CPU info: CPU Count 16, CPU Core Count 2, CPU Socket Count 1.

2019-10-04 10:51:47  WARNING OGG-05673  CSN-based duplicate suppression is disabled because there is no checkpoint table for this Replicat.

2019-10-04 10:51:47  INFO    OGG-02545  Parameter GROUPTRANSOPS is ignored by Integrated Replicat when parallelism is greater than 1.

2019-10-04 10:51:47  INFO    OGG-02527  Integrated Replicat does not populate a trace table.

2019-10-04 10:51:48  INFO    OGG-02530  Integrated replicat successfully attached to inbound server OGG$REPLOGGT.

***********************************************************************
**                     Run Time Messages                             **
***********************************************************************


2019-10-04 10:51:48  INFO    OGG-02243  Opened trail file /ogg/ora12c/dirdat/cd000000352 at 2019-10-04 10:51:48.445192.

2019-10-04 10:51:48  WARNING OGG-02760  ASSUMETARGETDEFS is ignored because trail file /ogg/ora12c/dirdat/cd000000352 contains table definitions.

2019-10-04 10:51:48  INFO    OGG-03522  Setting session time zone to source database time zone '+04:00'.

2019-10-04 10:51:48  INFO    OGG-03506  The source database character set, as determined from the trail file, is we8mswin1252.

2019-10-04 10:51:48  INFO    OGG-06505  MAP resolved (entry CBS_CORE.CB_CR_DB_NOTES): MAP "CBS_CORE"."CB_CR_DB_NOTES",target cbsogg.CB_CR_DB_NOTES.

2019-10-04 10:51:51  INFO    OGG-06441  Unique key CB_CR_DB_NOTES#$1 for table CB_CR_DB_NOTES cannot be used due to the inclusion of virtual columns, or user-defined datatypes, or extended long varchar columns, or function-based index columns.

2019-10-04 10:51:51  WARNING OGG-06440  No viable unique key is defined for table CB_CR_DB_NOTES. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

2019-10-04 10:51:51  INFO    OGG-02756  The definition for table CBS_CORE.CB_CR_DB_NOTES is obtained from the trail file.

2019-10-04 10:51:51  INFO    OGG-06511  Using following columns in default map by name: TRANS_NUM_V, TRANS_DATE_D, TRANS_TYPE_V, TRANS_SUB_TYPE_V, DB_CR_V, TRANS_REF_NO_V, ENTITY_TYPE_V, ACCOUNT_LINK_CODE_N, SAP_SUB_AC_CODE_N, TRANS_AMT_N, DESCRIPTION_V, USER_CODE_N, POSTED_TO_ACCOUNTS_N, POSTED_TRANS_NUM_V, EXTERNAL_REFERENCE_V, AUTO_DEBIT_FLG_N, MAIN_CRDB_REF_N, POSTED_FROM_SAGE_V, UNITS_N, WALLET_ID_V, LAST_MODIFIED_DATE_D.

2019-10-04 10:51:51  INFO    OGG-06510  Using the following key columns for target table CBSOGG.CB_CR_DB_NOTES: TRANS_NUM_V, TRANS_DATE_D, TRANS_TYPE_V, TRANS_SUB_TYPE_V, DB_CR_V, TRANS_REF_NO_V, ENTITY_TYPE_V, ACCOUNT_LINK_CODE_N, SAP_SUB_AC_CODE_N, TRANS_AMT_N, DESCRIPTION_V, USER_CODE_N, POSTED_TO_ACCOUNTS_N, POSTED_TRANS_NUM_V, EXTERNAL_REFERENCE_V, AUTO_DEBIT_FLG_N, MAIN_CRDB_REF_N, POSTED_FROM_SAGE_V, UNITS_N, WALLET_ID_V, LAST_MODIFIED_DATE_D.


Source Context :
  SourceModule            : [er.replicat.utiity]
  SourceID                : [/scratch/jkrath/view_storage/jkrath_ogg1810rc4vw/oggcore/OpenSys/src/app/er/replicat/reputility.cpp]
  SourceMethod            : [validateUpdate]
  SourceLine              : [428]

2019-10-04 10:51:51  ERROR   OGG-01169  Encountered an update where all key columns for target table CBSOGG.CB_CR_DB_NOTES are not present.

***********************************************************************
*                   ** Run Time Statistics **                         *
***********************************************************************


2019-10-04 10:51:55  INFO    OGG-02333  Reading /ogg/ora12c/dirdat/cd000000352, current RBA 1,478,202, 0 records, m_file_seqno = 352, m_file_rba = 1,478,779.

Report at 2019-10-04 10:51:55 (activity since 2019-10-04 10:51:51)

From Table CBS_CORE.CB_CR_DB_NOTES to CBSOGG.CB_CR_DB_NOTES:
       #                   inserts:     35177
       #                   updates:         0
       #                   deletes:     13809
       #                  discards:         0


Integrated Replicat Statistics:

            Total transactions:         0
                    Redirected:         0
         Replicated procedures:         0
                DDL operations:         0
             Stored procedures:         0
        Datatype functionality:         0
                 Event actions:         0
     Direct transactions ratio:         0%



DDL replication statistics:

                    Operations:         0
             Mapped operations:         0
           Unmapped operations:         0
              Other operations:         0
           Excluded operations:         0
                        Errors:         0
                Retried errors:         0
              Discarded errors:         0
                Ignored errors:         0




Last log location read:
     FILE:      /ogg/ora12c/dirdat/cd000000352
     SEQNO:     352
     RBA:       1478202
     TIMESTAMP: 2019-10-04 10:19:00.000181
     EOF:       NO
     READERR:   0


2019-10-04 10:51:55  ERROR   OGG-01668  PROCESS ABENDING.

CACHE OBJECT MANAGER statistics

CACHE MANAGER VM USAGE
vm current     =      1M   vm anon queues =      1M
vm anon in use =      0    vm file        =      0 
vm used max    =      1M   cachesize      =     16G

CACHE CONFIGURATION
cache size            =  16G   cache force paging   =  24G
pageout eligible size =   8M   cache vm pageout max =  64M

================================================================================
RUNTIME STATS FOR SUPERPOOL

Note: CACHE objects are often but not always proxies for transactions

CACHE Object Stats
objects active  =      0    max concurrent =      1 
non-zero total  =      5    objects total  =      5 

CACHE File Caching
filecache rqsts        =      0    bytes to disk      =      0 
file retrieves         =      0    objs filecached    =      0 
queue entries          =      0    queue processed    =      0 
queue entry not needed =      0    queue not signaled =      0 
fc requesting obj      =      0 

CACHE MANAGEMENT
buffer links   =      0   anon gets   =      0 
forced unmaps  =      0   cnnbl try   =      0 
cached out     =      0 

Allocation Request Distribution
&lt; 128B:       0 
 128B:        0         0     | 512B:        0         4 
   2K:        1         0     |   8K:        0         0 
  32K:        0         0     | 128K:        0         0 
 512K:        0         0     |   2M:        0         0 
   8M:        0         0     |  32M:        0         0 
 128M:        0         0     | 512M:        0         0 
   2G:        0 

Cached Object Size Distribution
    0:        0 
 &lt; 4K:        5 
   4K:        0         0     |  16K:        0         0 
  64K:        0         0     | 256K:        0         0 
   1M:        0         0     |   4M:        0         0 
  16M:        0         0     |  64M:        0         0 
 256M:        0         0     |   1G:        0         0 
   4G:        0         0     |  16G:        0         0 
  64G:        0         0     | 256G:        0         0 
   1T:        0         0     |   4T:        0         0 
  16T:        0         0     |  64T:        0         0 
 256T:        0         0     |1024T:        0         0 

================================================================================
CUMULATIVE STATS FOR SUPERPOOL (PREVIOUS RUNS ONLY)

Note: CACHE objects are often but not always proxies for transactions

CACHE Object Stats
objects active  =      0    max concurrent =      0 
non-zero total  =      0    objects total  =      0 

CACHE File Caching
filecache rqsts        =      0    bytes to disk      =      0 
file retrieves         =      0    objs filecached    =      0 
queue entries          =      0    queue processed    =      0 
queue entry not needed =      0    queue not signaled =      0 
fc requesting obj      =      0 

CACHE MANAGEMENT
buffer links   =      0   anon gets   =      0 
forced unmaps  =      0   cnnbl try   =      0 
cached out     =      0 

Allocation Request Distribution
&lt; 128B:       0 
 128B:        0         0     | 512B:        0         0 
   2K:        0         0     |   8K:        0         0 
  32K:        0         0     | 128K:        0         0 
 512K:        0         0     |   2M:        0         0 
   8M:        0         0     |  32M:        0         0 
 128M:        0         0     | 512M:        0         0 
   2G:        0 

Cached Object Size Distribution
    0:        0 
 &lt; 4K:        0 
   4K:        0         0     |  16K:        0         0 
  64K:        0         0     | 256K:        0         0 
   1M:        0         0     |   4M:        0         0 
  16M:        0         0     |  64M:        0         0 
 256M:        0         0     |   1G:        0         0 
   4G:        0         0     |  16G:        0         0 
  64G:        0         0     | 256G:        0         0 
   1T:        0         0     |   4T:        0         0 
  16T:        0         0     |  64T:        0         0 
 256T:        0         0     |1024T:        0         0 


QUEUE Statistics
num queues =      9     q hits =      4      q misses =      1 

queue size  q hits  curlen  maxlen     cannibalized
  0    1M      4       1       1       0 
  1    2M      0       0       0       0 
  2    4M      0       0       0       0 
  3    8M      0       0       0       0 
  4   16M      0       0       0       0 
  5   32M      0       0       0       0 
  6   64M      0       0       0       0 
  7  128M      0       0       0       0 
  8  256M      0       0       0       0 

================================================================================
RUNTIME STATS FOR CACHE POOL #0
POOL INFO   group: reploggt  id: p19364_BLOB
objects active =        0   objects concurrent (max) =     1 
objects total  =        5   (5 )
flag           = 0x000000030
last error     = (0=&lt;none&gt;)

Allocation Request Distribution
&lt; 128B:       0 
 128B:        0         0     | 512B:        0         4 
   2K:        1         0     |   8K:        0         0 
  32K:        0         0     | 128K:        0         0 
 512K:        0         0     |   2M:        0         0 
   8M:        0         0     |  32M:        0         0 
 128M:        0         0     | 512M:        0         0 
   2G:        0 

================================================================================
CUMULATIVE STATS FOR CACHE POOL #0 (PREVIOUS RUNS ONLY)
POOL INFO   group: reploggt  id: p19364_BLOB
objects active =        0   objects concurrent (max) =     0 
objects total  =        0   (0 )
flag           = 0x000000030
last error     = (0=&lt;none&gt;)

Allocation Request Distribution
&lt; 128B:       0 
 128B:        0         0     | 512B:        0         0 
   2K:        0         0     |   8K:        0         0 
  32K:        0         0     | 128K:        0         0 
 512K:        0         0     |   2M:        0         0 
   8M:        0         0     |  32M:        0         0 
 128M:        0         0     | 512M:        0         0 
   2G:        0 

</pre></body></html>