Hi
I have several package scenarios created by a former team member which export the contents of database views to CSV files which are sent onto other teams. Unfortunately the original packages which generated these scenarios no longer exist .... but I do have the interface mappings. Hence I thought that recreating the packages (as a basis for future requested changes) would just be a matter of dragging applicable variables and the mappings into a new package.
However - when I execute that package or generated scenario I get the following error at the Insert New Rows step (inserting rows into the CSV)
oracle.odi.runtime.agent.exception.ExecutionEngineException: java.sql.SQLException: ODI-40486: Could not read value ODI-40483: Could not read value DW_EXTRACT_ACTION_V.DW_SOURCE_SYSTEM
at oracle.odi.runtime.agent.execution.sql.SQLCommand.doInitializeStatement(SQLCommand.java:118)
at oracle.odi.runtime.agent.execution.sql.SQLCommand.getStatement(SQLCommand.java:147)
. . . Lots more java stuff . . .
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: ODI-40486: Could not read value ODI-40483: Could not read value DW_EXTRACT_ACTION_V.DW_SOURCE_SYSTEM
at com.sunopsis.jdbc.driver.file.SQLManager.buildRowFromInsert(SQLManager.java:422)
The value that can't be read is the first column in the database view that's being used as the source in the mapping that outputs to the CSV. I initially thought it was permission related - but the user executing the view has full permissions to the view (as it is the owner). The ODI_TEMP user which is used for the work schema also has permissions.
I've tried looking for more info on this error and possible causes through the usual routes (Google plus searches of Oracle support docs) but haven't found anything that sheds light.
Has anyone else encountered this error and know how to resolve it?
As an only occasional ODI user I figure its got to be something basic that I'm missing.
Hopefully the screenshots help provide some clues.
PS: The version of ODI we're using is 12.2.1.
Cheers
