WA Agent for Informatica: Not able to invoke informatica job type jobs from autosys

book

Article ID: 210654

calendar_today

Updated On:

Products

CA Workload Automation Agent CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation Agent CA Workload Automation DE - System Agent (dSeries)

Issue/Introduction

When running the Informatica job, the following error is seen in the logs:

XX/XX/20XX 00:00:12.345-0500 1 InformaticaPlugin.pool-1-thread-1.CybInformaticaLoggerHandlerWOB.log[:86] - java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
                            at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
                            at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
                            at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
                            at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
                            at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
                            at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
                            at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
                           

 

Cause

The Informatica schema is missing the synonym.  Make sure the IDP is properly installed.

 

Environment

Release : 12.0

Component : CA Workload Automation Agent for Informtica

Resolution

Create the missing synonym.  Refer to this KD from Informatica for more details.

https://knowledge.informatica.com/s/article/324943?language=en_US

 

For IDP files, refer to this documentation link.