ODI-17506: VARIABLE HAS NO VALUE: RA_BI.RA_BUSINESS_CURRENT_DT.

(Doc ID 2420786.1)

Last updated on JULY 13, 2018

Applies to:

Oracle Retail Merchandising Insights - Version 15.0.1 and later
Information in this document applies to any platform.

Symptoms

Getting below error while looping the batch scheduler.

"oracle.odi.core.exception.OdiRuntimeException: java.lang.Exception: ODI-17506: Variable has no value: RA_BI.RA_BUSINESS_CURRENT_DT
at oracle.odi.query.VariableDwgBridgeImpl.getValue(VariableDwgBridgeImpl.java:35)
at oracle.odi.query.VariableValueGetter.initVarValue(VariableValueGetter.java:26)
at oracle.odi.query.VariableValueGetter.getStringValue(VariableValueGetter.java:40)
at oracle.odi.query.SubstitutionHelper.getSubstitutedText(SubstitutionHelper.java:89)
at oracle.odi.runtime.agent.execution.cmd.TextCommand.initialize(TextCommand.java:80)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:49)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2925)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2637)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1898)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:583)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
"

Steps To Reproduce:
1. Loop the batch scheduler.
2. Note the above error may happen randomly.

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