java.sql.SQLSyntaxErrorException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • ERPI 11.1.2.1.501 and ODI 11.1.1.5
    via by 725050,
  • DB adapter polling error
    via by 940358,
  • Error Creating Folder using UCM
    via by Dinesh Joshi,
    • java.sql.SQLSyntaxErrorException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Invalid object name 'AIF_processes'. at weblogic.jdbc.sqlserverbase.dda4.b(Unknown Source) at weblogic.jdbc.sqlserverbase.dda4.a(Unknown Source) at weblogic.jdbc.sqlserverbase.dda3.b(Unknown Source) at weblogic.jdbc.sqlserverbase.dda3.a(Unknown Source) at weblogic.jdbc.sqlserver.tds.ddr.v(Unknown Source) at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source) at weblogic.jdbc.sqlserver.tds.ddq.a(Unknown Source) at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source) at weblogic.jdbc.sqlserver.ddj.m(Unknown Source) at weblogic.jdbc.sqlserverbase.ddde.e(Unknown Source) at weblogic.jdbc.sqlserverbase.ddde.a(Unknown Source) at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source) at weblogic.jdbc.sqlserverbase.ddde.v(Unknown Source) at weblogic.jdbc.sqlserverbase.ddde.u(Unknown Source) at weblogic.jdbc.sqlserverbase.ddb9.executeQuery(Unknown Source) at oracle.odi.query.JDBCTemplate.executeQuery(JDBCTemplate.java:189) at oracle.odi.runtime.agent.execution.sql.RefreshVariableExecutor.execute(RefreshVariableExecutor.java:54) at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1) at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50) at com.sunopsis.dwg.dbobj.SnpSessTaskSqlV.processTask(SnpSessTaskSqlV.java:401) at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2609) at com.sunopsis.dwg.dbobj.SnpSessTaskSqlV.treatTask(SnpSessTaskSqlV.java:230) at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:537) at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:453) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1740) at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1595) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580) at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:214) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513) at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1070) at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:123) at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82) at java.lang.Thread.run(Thread.java:662)
    No Bugmate found.