After changing the AWBATCH Login Object, Jobs are unable to find particular views/tables.

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

After changing the AWBATCH Login Object, Jobs are unable to find particular views/tables.

Environment

Release: 9.3, 9.4
Component: Applications Manager

Resolution

In order to correct this problem, update the Login Object and verify that the DBLINK is correct.  

In addition, the following Synonyms must be set up:

 

create or replace synonym quenbr_pk for quenbr_pk@&&dblink;

create or replace synonym que for que@&&dblink;

create or replace synonym queappl for queappl@&&dblink;

create or replace synonym queapplhist for queapplhist@&&dblink;

create or replace synonym queapplparam for queapplparam@&&dblink;

create or replace synonym bankoption for bankoption@&&dblink;

create or replace synonym appl for appl@&&dblink;

create or replace synonym parameter for parameter@&&dblink;

create or replace synonym applparameter for applparameter@&&dblink;

create or replace synonym acctcycleappl for acctcycleappl@&&dblink;

create or replace synonym queapplacctcycle for queapplacctcycle@&&dblink;

create or replace synonym queapplerror for queapplerror@&&dblink;

Create or replace synonym quetyp for quetyp@&&dblink;

Create or replace synonym extfile for extfile@&&dblink;