ODI Integration error help
Hi,
I am currently running an integration with error below and all indications are pointing to Agent however there is no certainty.
Has anyone experienced the error below and what were resolution methods?
DI-1228: Task ERPI Open Interface to ERPI Balances (Integration) fails on the target GENERIC_SQL connection FDMEE_DATA_SERVER_MSSQL.
Caused By: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]The multi-part identifier "VW_GL_HIST.ACCOUNT" could not be bound.
at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)