I was trying to load an Oracle on-premise database table to an Oracle BICS target using ODI and end-up in the below error. My ODI 12.2.1.2.6 installation is running on a Windows Server and the error may not Occurred if it is Linux or other OS installations.
ODI-1590: The execution of the script failed.
This is my simple mapping to illustrate the workaround. As you can see in the logical view, it just loads the data from DEPT_SRC onpremise table into DEPT_TGT BICS DB table.
Here are the LKM and IKM that I have used
- LKM SQL Multi-ConnectGLOBAL
- IKM SQL to Oracle BI Cloud Service
Upon running the mapping it just failed with
ODI-1590: The execution of the script failed.
Caused By: org.apache.bsf.BSFException: exception from Groovy: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed:
Load_DEPT_TGT: 64: unexpected char: '\' @ line 64, column 23.
def traceLoc = "C:\Users\KS\AppData\Local\Temp\bics_calls.log";
Caused By: org.apache.bsf.BSFException: exception from Groovy: org.codehaus.groovy.control.MultipleCompilationErrorsException: startup failed:
Load_DEPT_TGT: 64: unexpected char: '\' @ line 64, column 23.
def traceLoc = "C:\Users\KS\AppData\Local\Temp\bics_calls.log";
If you examine the above log information, it says unexpected "\" char found. All you need to do is open the mapping and select the target in Physical tab
You will see multiple physical properties that can be modified. Select the one for trace file to avoid the "\" char.
Now if you run the mapping you will see there is no error and the target would have loaded.
No comments:
Post a Comment