Head over to operator and pull the step that is failing from operator log - Paste up here if you wish.
You are probably referencing a column that doesnt exist (either in Source table or you have a literal that is not enclosed in quotes).
There is also the possibility you are trying to reference a source column in a mapping that is executed on Staging or target . Double check this.
Also double check filters are syntax correct.
This is a database message indicating that column name you are using is invalid
In the ODI operator drill down to the error step and then click on "CODE" - this should show the SQL you tried to execute. Look for errors in that - perhaps even paste it in to SQL developer as this may highlight the line at fault.
Typically this error is caused by
- Having an invalid column name in the model (Oracle column names are limited to 30 characters, must start with a letter, and only contain [A-Z][0-9] and a few special characters such as '$' and '_'
- A bug in a KM that causes a syntax error such as a missed space << less likely on the standard KMs - more likely on custom KMs
Look at the generated code and then work out what needs fixing
Thank you,. Issue got resolved.