Untitled
plain_text
a month ago
10 kB
1
Indexable
Never
part-a Count for PPM_PRODUCT_COMPONENT_REF_MAP: 3 ---------------------MASTER-AUDIT------------------ Count for PPM_POLICY_PARAMS: 0 ---------------------MASTER-AUDIT------------------ Count for PPM_POLICY_PARAMS_AUD: 0 ---------------------AUDIT-CHILD------------------ Count for TCARE_PPM_PRODUCT: 29 (master) 11 Count for TCARE_PPM_PRODUCT_COMPONENTS: 11 (master) 21 Count for COMPONENT_DEFINITION: 11 (master) 31 Count for TCARE_PPM_PRODUCT_ATTRIBUTES: 4 (master) 41 Count for TCARE_PPM_PACKAGE: 13 (master) 51 Count for TCARE_PPM_PACKAGE_PRODUCT_MAP: 13 (master) 61 Count for TCARE_PPM_OFFERABILITY_RULE: 5 (master) 71 Count for PPM_OFFERABLE_RULE_PRODUCT_MAP: 0 (master) 81 Count for PPM_CONDITIONAL_RULE_GROUP: 0 (master) 91 Count for PPM_CONDITIONAL_RULE: 0 (master) 101 Count for PPM_RULE_CONDITION: 0 (master) 111 Count for PPM_RULE_ACTION: 0 (master) 121 Count for PPM_PRODUCT_ATTRIBUTE_GROUPS: 2 (master) 131 Count for PPM_ATTRIBUTE_TYPE_REF: 0 (master) 141 Count for TCARE_PPM_ATTRIBUTES: 8 (master) 151 Count for PPM_ATTRIBUTE_GROUPS: 1 (master) 161 Count for PPM_ATTRIBUTE_GROUP_DEFN: 2 (master) 171 Count for PPM_PRD_TYPE_ATTR_GRP_MAP: 0 (master) 181 Count for PPM_PRODUCT_TYPE_ATTR_MAP_REF: 0 (master) 191 Count for UI_SERVICE_TEMPLATE_MASTER: 1 (master) 201 Count for UI_TEMPLATE_ITEM_MAP: 1 (master) 211 Count for UI_ELEMENTS: 2 (master) 221 Count for UI_ITEM_ELEMENT_MAP: 2 (master) 231 Count for PPM_PRODUCT_TEMPLATE_MAP: 2 (master) 241 Count for PPM_PRODUCT_TYPE_TEMPLATE_MAP: 0 (master) 251 Count for PPM_EVENT_MASTER: 4 (master) 261 Count for PPM_EVENT_PARAMS: 5 (master) 271 Count for PPM_ITEM_EVENT_MAP: 4 (master) 281 Count for UI_ELEMENT_DEPENDENCY: 0 (master) 291 Count for TCARE_PPM_PCAT_INFO: 26 (master) 301 Count for PPM_POLICY_MASTER: 2 (master) 311 Count for PPM_POLICY_ASSOC: 2 (master) 321 Count for PPM_COMPOSITE_ATTR_ASSOC: 0 (master) 331 Count for DISCOUNT_DEFINITION: 2 (master) 341 Count for ITEM_DISCOUNT_MAP: 0 (master) 351 Count for PPM_ITEM_EVENT_MAP: 4 (master) 361 Count for PPM_DECISION_MATRIX: 0 (master) 371 Count for PPM_DECISION_MATRIX_DTL: 0 (master) 381 Count for RMS_USAGE_TYPE_MST_AUD: 92 (master) 10012 Count for TCARE_PPM_PRODUCT_AUD: 29 (audit) Count for PPM_PROD_COMPONENTS_AUD: 11 (audit) Count for COMPONENT_DEFINITION_AUD: 11 (audit) Count for PPM_PROD_ATTRIBUTES_AUD: 4 (audit) Count for TCARE_PPM_PACKAGE_AUD: 13 (audit) Count for PPM_PACKAGE_PROD_MAP_AUD: 13 (audit) Count for PPM_OFFERABILITY_AUD: 5 (audit) Count for OFFER_RULE_PRD_MAP_AUD: 0 (audit) Count for PPM_COND_RULE_GROUP_AUD: 0 (audit) Count for PPM_CONDITIONAL_RULE_AUD: 0 (audit) Count for PPM_RULE_CONDITION_AUD: 0 (audit) Count for PPM_RULE_ACTION_AUD: 0 (audit) Count for PPM_PROD_ATTR_GROUPS_AUD: 2 (audit) Count for PPM_ATTR_TYPE_REF_AUD: 0 (audit) Count for TCARE_PPM_ATTRIBUTES_AUD: 8 (audit) Count for PPM_ATTRIBUTE_GROUPS_AUD: 1 (audit) Count for PPM_ATTR_GROUP_DEFN_AUD: 2 (audit) Count for PRD_TYP_ATTR_GRP_MAP_AUD: 0 (audit) Count for PRD_TYP_ATTR_MAP_REF_AUD: 0 (audit) Count for SRVC_TEMPLATE_MAST_AUD: 1 (audit) Count for UI_TEMPLATE_ITEM_MAP_AUD: 1 (audit) Count for UI_ELEMENTS_AUD: 2 (audit) Count for UI_ITEM_ELEMENT_MAP_AUD: 2 (audit) Count for PPM_PRD_TEMPLATE_MAP_AUD: 2 (audit) Count for PRD_TYP_TEMPLATE_MAP_AUD: 0 (audit) Count for PPM_EVENT_MASTER_AUD: 4 (audit) Count for PPM_EVENT_PARAMS_AUD: 0 (audit) Count for PPM_ITEM_EVENT_MAP_AUD: 4 (audit) Count for UI_ELEMENT_DEPENDENCY_AUD: 0 (audit) Count for TCARE_PPM_PCAT_INFO_AUD: 26 (audit) Count for PPM_POLICY_MASTER_AUD: 2 (audit) Count for PPM_POLICY_ASSOC_AUD: 2 (audit) Count for PPM_COMPOSITE_ATTR_AUD: 0 (audit) Count for DISCOUNT_DEFINITION_AUD: 2 (audit) Count for ITEM_DISCOUNT_MAP_AUD: 0 (audit) Count for PPM_ITEM_EVENT_MAP_AUD: 4 (audit) Count for PPM_DECISION_MATRIX_AUD: 0 (audit) Count for PPM_DEC_MATRIX_DTL_AUD: 0 (audit) Count for RMS_USAGE_TYPE_MST: 0 (audit) Count for PPM_RELEASE_MASTER: 1 (release) Count for PPM_RELEASE_ENTITY_MAP: 69 (release) Count for RELEASE_ENTITY_INST_MAP: 151 (release) Count for APAD_MATRIX: 66528 PC_EXT Count for APAD_MATRIX: 66528PC_EXT for deletion Count for COBP_PASS_MATRIX: 90566 PC_EXT Count for COBP_PASS_MATRIX: 90566PC_EXT for deletion Count for DEVICE_COMBO_SUBSIDY: 1196 PC_EXT Count for DEVICE_COMBO_SUBSIDY: 1196PC_EXT for deletion Count for EASYPHONE_MATRIX: 4428 PC_EXT Count for EASYPHONE_MATRIX: 4428PC_EXT for deletion Count for EASYPHONE_UPGRADE: 924 PC_EXT Count for EASYPHONE_UPGRADE: 924PC_EXT for deletion Count for FEATURE_GROUP_MASTER: 196 PC_EXT Count for FEATURE_GROUP_MASTER: 196PC_EXT for deletion Count for PACKAGE_MAPPING: 4824 PC_EXT Count for PACKAGE_MAPPING: 4824PC_EXT for deletion Count for PRODUCT_MAPPING: 583 PC_EXT Count for PRODUCT_MAPPING: 583PC_EXT for deletion UPDATE tibtcare_ppm.ppm_replication_status SET status='SOURCE', status_message='success', error_description=NULL, updated_by='REP_990_234' , updated_date=NOW() WHERE replication_job_id='REP_990_234' AND release_id='275.2' part-b Count for PPM_PRODUCT_COMPONENT_REF_MAP: 3 ---------------------MASTER-AUDIT------------------ Count for PPM_POLICY_PARAMS: 0 ---------------------MASTER-AUDIT------------------ Count for PPM_POLICY_PARAMS_AUD: 0 ---------------------AUDIT-CHILD------------------ Count for TCARE_PPM_PRODUCT: 29 (master) 11 Count for TCARE_PPM_PRODUCT_COMPONENTS: 11 (master) 21 Count for COMPONENT_DEFINITION: 11 (master) 31 Count for TCARE_PPM_PRODUCT_ATTRIBUTES: 4 (master) 41 Count for TCARE_PPM_PACKAGE: 13 (master) 51 Count for TCARE_PPM_PACKAGE_PRODUCT_MAP: 13 (master) 61 Count for TCARE_PPM_OFFERABILITY_RULE: 5 (master) 71 Count for PPM_OFFERABLE_RULE_PRODUCT_MAP: 0 (master) 81 Count for PPM_CONDITIONAL_RULE_GROUP: 0 (master) 91 Count for PPM_CONDITIONAL_RULE: 0 (master) 101 Count for PPM_RULE_CONDITION: 0 (master) 111 Count for PPM_RULE_ACTION: 0 (master) 121 Count for PPM_PRODUCT_ATTRIBUTE_GROUPS: 2 (master) 131 Count for PPM_ATTRIBUTE_TYPE_REF: 0 (master) 141 Count for TCARE_PPM_ATTRIBUTES: 8 (master) 151 Count for PPM_ATTRIBUTE_GROUPS: 1 (master) 161 Count for PPM_ATTRIBUTE_GROUP_DEFN: 2 (master) 171 Count for PPM_PRD_TYPE_ATTR_GRP_MAP: 0 (master) 181 Count for PPM_PRODUCT_TYPE_ATTR_MAP_REF: 0 (master) 191 Count for UI_SERVICE_TEMPLATE_MASTER: 1 (master) 201 Count for UI_TEMPLATE_ITEM_MAP: 1 (master) 211 Count for UI_ELEMENTS: 2 (master) 221 Count for UI_ITEM_ELEMENT_MAP: 2 (master) 231 Count for PPM_PRODUCT_TEMPLATE_MAP: 2 (master) 241 Count for PPM_PRODUCT_TYPE_TEMPLATE_MAP: 0 (master) 251 Count for PPM_EVENT_MASTER: 4 (master) 261 Count for PPM_EVENT_PARAMS: 5 (master) 271 Count for PPM_ITEM_EVENT_MAP: 4 (master) 281 Count for UI_ELEMENT_DEPENDENCY: 0 (master) 291 Count for TCARE_PPM_PCAT_INFO: 26 (master) 301 Count for PPM_POLICY_MASTER: 2 (master) 311 Count for PPM_POLICY_ASSOC: 2 (master) 321 Count for PPM_COMPOSITE_ATTR_ASSOC: 0 (master) 331 Count for DISCOUNT_DEFINITION: 2 (master) 341 Count for ITEM_DISCOUNT_MAP: 0 (master) 351 Count for PPM_ITEM_EVENT_MAP: 4 (master) 361 Count for PPM_DECISION_MATRIX: 0 (master) 371 Count for PPM_DECISION_MATRIX_DTL: 0 (master) 381 Count for RMS_USAGE_TYPE_MST_AUD: 92 (master) 10012 Count for TCARE_PPM_PRODUCT_AUD: 29 (audit)10 Count for PPM_PROD_COMPONENTS_AUD: 11 (audit)20 Count for COMPONENT_DEFINITION_AUD: 11 (audit)30 Count for PPM_PROD_ATTRIBUTES_AUD: 4 (audit)40 Count for TCARE_PPM_PACKAGE_AUD: 13 (audit)50 Count for PPM_PACKAGE_PROD_MAP_AUD: 13 (audit)60 Count for PPM_OFFERABILITY_AUD: 5 (audit)70 Count for OFFER_RULE_PRD_MAP_AUD: 0 (audit)80 Count for PPM_COND_RULE_GROUP_AUD: 0 (audit)90 Count for PPM_CONDITIONAL_RULE_AUD: 0 (audit)100 Count for PPM_RULE_CONDITION_AUD: 0 (audit)110 Count for PPM_RULE_ACTION_AUD: 0 (audit)120 Count for PPM_PROD_ATTR_GROUPS_AUD: 2 (audit)130 Count for PPM_ATTR_TYPE_REF_AUD: 0 (audit)140 Count for TCARE_PPM_ATTRIBUTES_AUD: 8 (audit)150 Count for PPM_ATTRIBUTE_GROUPS_AUD: 1 (audit)160 Count for PPM_ATTR_GROUP_DEFN_AUD: 2 (audit)170 Count for PRD_TYP_ATTR_GRP_MAP_AUD: 0 (audit)180 Count for PRD_TYP_ATTR_MAP_REF_AUD: 0 (audit)190 Count for SRVC_TEMPLATE_MAST_AUD: 1 (audit)200 Count for UI_TEMPLATE_ITEM_MAP_AUD: 1 (audit)210 Count for UI_ELEMENTS_AUD: 2 (audit)220 Count for UI_ITEM_ELEMENT_MAP_AUD: 2 (audit)230 Count for PPM_PRD_TEMPLATE_MAP_AUD: 2 (audit)240 Count for PRD_TYP_TEMPLATE_MAP_AUD: 0 (audit)250 Count for PPM_EVENT_MASTER_AUD: 4 (audit)260 Count for PPM_EVENT_PARAMS_AUD: 0 (audit)270 Count for PPM_ITEM_EVENT_MAP_AUD: 4 (audit)280 Count for UI_ELEMENT_DEPENDENCY_AUD: 0 (audit)290 Count for TCARE_PPM_PCAT_INFO_AUD: 26 (audit)300 Count for PPM_POLICY_MASTER_AUD: 2 (audit)310 Count for PPM_POLICY_ASSOC_AUD: 2 (audit)320 Count for PPM_COMPOSITE_ATTR_AUD: 0 (audit)330 Count for DISCOUNT_DEFINITION_AUD: 2 (audit)340 Count for ITEM_DISCOUNT_MAP_AUD: 0 (audit)350 Count for PPM_ITEM_EVENT_MAP_AUD: 4 (audit)360 Count for PPM_DECISION_MATRIX_AUD: 0 (audit)370 Count for PPM_DEC_MATRIX_DTL_AUD: 0 (audit)380 Count for RMS_USAGE_TYPE_MST: 0 (audit)10011 Count for PPM_RELEASE_MASTER: 1 (release)1 Count for PPM_RELEASE_ENTITY_MAP: 69 (release)2 Count for RELEASE_ENTITY_INST_MAP: 151 (release)3 Count for APAD_MATRIX: 66528 PC_EXT Count for APAD_MATRIX: 66528PC_EXT for deletion Count for COBP_PASS_MATRIX: 90566 PC_EXT Count for COBP_PASS_MATRIX: 90566PC_EXT for deletion Count for DEVICE_COMBO_SUBSIDY: 1196 PC_EXT Count for DEVICE_COMBO_SUBSIDY: 1196PC_EXT for deletion Count for EASYPHONE_MATRIX: 4428 PC_EXT Count for EASYPHONE_MATRIX: 4428PC_EXT for deletion Count for EASYPHONE_UPGRADE: 924 PC_EXT Count for EASYPHONE_UPGRADE: 924PC_EXT for deletion Count for FEATURE_GROUP_MASTER: 196 PC_EXT Count for FEATURE_GROUP_MASTER: 196PC_EXT for deletion Count for PACKAGE_MAPPING: 4824 PC_EXT Count for PACKAGE_MAPPING: 4824PC_EXT for deletion Count for PRODUCT_MAPPING: 583 PC_EXT Count for PRODUCT_MAPPING: 583PC_EXT for deletion UPDATE tibtcare_ppm.ppm_replication_status SET status='SOURCE', status_message='success', error_description=NULL, updated_by='REP_990_234' , updated_date=NOW() WHERE replication_job_id='REP_990_234' AND release_id='275.2' please verify if part a and part b are same or not