Dataload Failing On Export To Arm With SQL ' Error Incorrect Syntax Near The Keyword 'AND' ' (Doc ID 2077315.1)

Last updated on APRIL 12, 2017

Applies to:

Hyperion Financial Close Management - Version 11.1.2.2.000 to 11.1.2.4.101 [Release 11.1]
Information in this document applies to any platform.

Symptoms

Data load failing on export step to ARM. The following error is thrown:

  

[2015-07-09T15:10:59.356-05:00] [ErpIntegrator0] [ERROR] [ODI-1134] [] [tid: 11] [userId: <anonymous>] [ecid: 00iUGoVd_U86uH45zVo2yW0002xG0002RB,0:1] [APP: oraclediagent] Agent OracleDIAgent encountered an error: ODI-1217: Session COMM_LOAD_EXCHANGE_RATES (7804501) fails with return code 156. Caused by: ODI-1226: Step p_import_grp_ledger_name fails after 1 attempt(s).[[
ODI-1217: Session COMM_LOAD_EXCHANGE_RATES (7804501) fails with return code 156.
ODI-1226: Step p_import_grp_ledger_name fails after 1 attempt(s).
ODI-1228: Task p_import_grp_ledger_name (Variable) fails on the target  connection FDMEE_DATA_SERVER_MSSQL.
Caused By: java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'AND'.
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)
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.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

]]
[2015-07-09T15:11:00.168-05:00] [ErpIntegrator0] [NOTIFICATION:16] [ODI-1101] [] [tid: 11] [userId: <anonymous>] [ecid: 00iUGoVd_U86uH45zVo2yW0002xG0002RB,0:1] [APP: oraclediagent] Agent OracleDIAgent successfully completed session COMM_LOAD_BALANCES (7802501) (for scenario COMM_LOAD_BALANCES) on FDMEE using context GLOBAL with statistics: Rows 0 Inserts 0 Updates 0 Deletes 0 Errors 0.
[2015-07-09T15:11:06.408-05:00] [ErpIntegrator0] [NOTIFICATION:16] [ODI-1125] [] [tid: 11] [userId: <anonymous>] [ecid: 0000KtoSMH86uH45zVs1yW1LbWZ400001n,0] [APP: oraclediagent] Agent OracleDIAgent started session EXPORTTOARM (7805501) from scenario EXPORTTOARM in work repository FDMEE using context GLOBAL.
[2015-07-09T15:11:08.108-05:00] [ErpIntegrator0] [WARNING] [ODI-1134] [] [tid: 11] [userId: <anonymous>] [ecid: 0000KtoSMH86uH45zVs1yW1LbWZ400001n,0] [APP: oraclediagent] Agent OracleDIAgent encountered an error: ODI-1226: Step Configuration Error fails after 1 attempt(s).
[2015-07-09T15:11:08.108-05:00] [ErpIntegrator0] [ERROR] [ODI-1217] [] [tid: 11] [userId: <anonymous>] [ecid: 0000KtoSMH86uH45zVs1yW1LbWZ400001n,0] [APP: oraclediagent] Session EXPORTTOARM (7805501) fails with return code 7000.[[
ODI-1226: Step Configuration Error fails after 1 attempt(s).
ODI-1232: Procedure Configuration Error execution fails.
Caused By: org.apache.bsf.BSFException: exception from Jython:
SyntaxError: ("no viable alternative at input '='", ('<string>', 12, 6, 'result=sqlstring.executeUpdate(sqlstmt)\n'))

at org.apache.bsf.engines.jython.JythonEngine.exec(JythonEngine.java:146)
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:322)
at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:170)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.scripting(SnpSessTaskSql.java:2473)
at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:48)
at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:1)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:580)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
......................................................
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: SyntaxError: ("no viable alternative at input '='", ('<string>', 12, 6, 'result=sqlstring.executeUpdate(sqlstmt)\n'))

at org.python.core.PyException.fillInStackTrace(PyException.java:70)
at java.lang.Throwable.<init>(Throwable.java:181)
at java.lang.Exception.<init>(Exception.java:29)
at java.lang.RuntimeException.<init>(RuntimeException.java:32)
at org.python.core.PyException.<init>(PyException.java:46)
at org.python.core.PyException.<init>(PyException.java:43)

  

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms