Hi,
I just migrated from ODI 10g to ODI 11g but it seems that one of my scenario doesn't want to work anymore. Each time I execute it, I have the following error message :
ODI-1227: Task SS_0 (Loading) fails on the source ORACLE connection POM
Caused By: java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long
After some research it seems that on ODI 11g, the identifier has to have at most 30 characters in the alias column, so my problem come from the following request
| select | * | |
| END | | |
| nvl(ENCADRANT_INTERVENANT.SI_APTITUDE_TRAJET_LONG,0) | C15_ENC_SI_APTITUDE_LONG_TRAJET |
| | |
| from | PROD_DSN. | |
| where | (1=1) | |
So I went in Topology (Physical) , change the field 'Maximum Column Name Length' to 25 on Advanced tab but it doesn't work.
Any idea, please ?
Regards,
Jean