i had faced this issue using oracle datasource, when i try running regenerating scenario again it works... first time it errors out for some reason, next time it works.!!
I wish that were the case, but trust me - I've run relentlessly.
Even more oddly - consistently works fine with one table, but not with another table in the same database, nor a view in another - the latter two giving the same error as outlined above.
Credentials / Permissions are the same
Datatypes are all INT
The working table has a primary key, added one to the table that doesn't - same error
Not sure why one table works, another doesn't..
That link was me posting about the same issue previously, which I've worked around - but getting tough to do so.
1 person found this helpful
Open ODI Studio > Designer tab > delete the package and model named LedgerEntry (same name as your Table Name in FDMEE Source Adapter settings).
Then in FDMEE, click Generate Package, and then Regenerate ODI Scenario for your import format.
If your question is answered, help others and improve the forum by marking replies as Helpful or Correct.
Sadly blowing everything away in ODI Studio didn't make any difference.
I've ultimately resolved by building an interface out using Open Interface Adapter instead of the UDA.