UDB CATSYNC - TABLE ALIAS AND OUT OF BOUND ARRAY ISSUES

Products

• Repository

Issue/Introduction

1. The UDB catsync process does not load all aliases from the input file and the base table for a table alias.
    The job writes warning messages like below to SYSPRINT:

    WARNING !  THE TABLE/VIEW COLUMN TABLE1.COLUMN WAS NOT FOUND IN
    THE REPOSITORY. THE VIEW COLUMN VTABLE2.COLUMN COULD NOT BE INSERTED
 
2. In addition, Out of bound array exception occurs when processing a table view.
    The job ends with the below error message:

    ONCODE=8094  Protection exception From entry point WRITE_TO_FILE...

SYMPTOMS:
All aliases are not present in the Repository after catsync and
in the case of out of bounds array, the job ends with 'Protection
exception' error.
 
IMPACT:
Inaccurate representation of metadata in the repository.

 

Environment

Repository Exchange for UDB r7.2

Resolution

LU16037 - UDB CATSYNC - TABLE ALIAS AND OUT OF BOUND ARRAY ISSUES