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 [email protected]&&dblink;

create or replace synonym que for [email protected]&&dblink;

create or replace synonym queappl for [email protected]&&dblink;

create or replace synonym queapplhist for [email protected]&&dblink;

create or replace synonym queapplparam for [email protected]&&dblink;

create or replace synonym bankoption for [email protected]&&dblink;

create or replace synonym appl for [email protected]&&dblink;

create or replace synonym parameter for [email protected]&&dblink;

create or replace synonym applparameter for [email protected]&&dblink;

create or replace synonym acctcycleappl for [email protected]&&dblink;

create or replace synonym queapplacctcycle for [email protected]&&dblink;

create or replace synonym queapplerror for [email protected]&&dblink;

Create or replace synonym quetyp for [email protected]&&dblink;

Create or replace synonym extfile for [email protected]&&dblink;