Re: Adding Nodes

Posted by ErmanArslansOracleBlog on May 16, 2017; 3:48pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Adding-Nodes-tp2595p2705.html

Sorry but there is abnormal situation here.
1)You don't have these two records in ad_timestamps table.

INSTANTIATED_CURRENT_VIEW_SNAPSHOT
BACKFILLED_BUGS_IN_CURRENT_VIEW_SNAPSHOT

2)update should not cause ORA-01403.
--

Lets put some more prompts and be sure where the sql is failing.

Modify the relevant part of the sql as below; (backup original sql, put propmts as below , save sql and rerun your failing adadnode )

prompt Updating AD_APPL_TOPS

    update ad_appl_tops
    set name = l_new_appltop_name
    where applications_system_name = l_new_apps_system_name
    and name = l_old_appltop_name;

    -- Update AD_TIMESTAMPS. Assume that the "apps-sys-name" portion in
    -- ATTRIBUTE has already been updated (The portion before the
    -- asterisk '*'. adadmprf.sql does this)

prompt successfully updated AD_APPL_TOPS
prompt now updating AD_TIMESTAMPS

    update ad_timestamps
    set attribute = l_new_apps_system_name || '*' || l_new_appltop_name
    where type in ('INSTANTIATED_CURRENT_VIEW_SNAPSHOT',
                   'BACKFILLED_BUGS_IN_CURRENT_VIEW_SNAPSHOT')
    and attribute = l_new_apps_system_name || '*' || l_old_appltop_name;

prompt successfully updated AD_TIMESTAMPS