My Oracle Support Banner

ODI Reverse Engineer of BICC Data Server Fails with "illegal string body character after dollar sign" Error (Doc ID 2634901.1)

Last updated on MAY 01, 2020

Applies to:

Oracle Data Integrator on Marketplace - Version 2.0.1 and later
Oracle Data Integrator - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

NOTE: In the examples below, the names represent a fictitious sample for clarity. Any similarity to actual environments, past or present, is purely coincidental and not intended in any manner.

When attempting to reverse engineer a Business Intelligence Cloud Connector (BICC) data server in Oracle Data Integrator (ODI) 12.2.1.4 or ODI on Marketplace using the RKM Oracle BI Cloud Connector Reverse Knowledge Module (RKM), an error is reported by the Groovy interpreter:

ODI-1590: The execution of the script failed.
Caused By: org.apache.bsf.BSFException: exception from Groovy: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed:
_: 112: illegal string body character after dollar sign;
  solution: either escape a literal dollar sign "\$5" or bracket the value expression "${5}" @ line 112, column 5.
  password = "pa$$word"
                ^

1 error
  at org.codehaus.groovy.bsf.GroovyEngine.exec(GroovyEngine.java:114)
  at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.execInBSFEngine(SnpScriptingInterpretor.java:396)
  at com.sunopsis.dwg.codeinterpretor.SnpScriptingInterpretor.exec(SnpScriptingInterpretor.java:247)
  at oracle.odi.runtime.agent.execution.interpreter.SessionTaskScriptingInterpretor.scripting(SessionTaskScriptingInterpretor.java:190)
  at oracle.odi.runtime.agent.execution.SessionTask.scripting(SessionTask.java:116)
  at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:49)
  at oracle.odi.runtime.agent.execution.cmd.ScriptingExecutor.execute(ScriptingExecutor.java:21)
  at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)
  ...

Caused by: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed:
_: 112: illegal string body character after dollar sign;
  solution: either escape a literal dollar sign "\$5" or bracket the value expression "${5}" @ line 112, column 5.
  password = "pa$$word"
                ^

1 error
  at org.codehaus.groovy.control.ErrorCollector.failIfErrors(ErrorCollector.java:309)
  at org.codehaus.groovy.control.ErrorCollector.addFatalError(ErrorCollector.java:149)
  at org.codehaus.groovy.control.ErrorCollector.addError(ErrorCollector.java:119)
  ...

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.