Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

I have seen this once before and immediately forgot about it, so I write it down to remember:



My Oracle Data Integrator mappings / scenarios do not run. 

ODI creates inexecutable SQL code which generate an ORA-00928 error.


The generated code looks like:

AND ACCOUNT_REPORT.DWH_GUELTIG_VON   <= to_date('#BI.V_NAECHSTES_DELTA', 'DD.MM.YYYY HH24:MI:SS')
AND ACCOUNT_REPORT.DWH_GUELTIG_BIS   > to_date('#BI.V_NAECHSTES_DELTA', 'DD.MM.YYYY HH24:MI:SS')
AND ADRESSE.DWH_GUELTIG_VON <= to_date('#BI.V_NAECHSTES_DELTA', 'DD.MM.YYYY HH24:MI:SS')
AND ADRESSE.DWH_GUELTIG_BIS > to_date('#BI.V_NAECHSTES_DELTA', 'DD.MM.YYYY HH24:MI:SS')
) 
  ) UNION   
  ) DSTNCT_ACCREPRT_LAND
where	(1=1)
) S
where NOT EXISTS 


Why's that?

Beware of operator names in ODI that consist of SQL reserved words, like:

So not name a set operator "Union", for example.

And once you rename an operator in ODI's logical view, also rename it manually (warning) in the physical view, too, since this is not done automatically.


  • No labels