0

I am using FME on daily basis working with sde feature classes. Sometime I am receiving data with more then hundred columns and when working I receive the following error.

The error number from Arc Objects is: '-2147216067'. The error message from Arc Objects is: {Invalid column definition [ORA-04043: ..

I am wondering if there is a way in FME to detect which column is giving this issue. I do not have access to SQL Developer in my workplace so cannot check there. All I can do to fix this issue is to divide the columns into half and create a temporary feature class and then do the same till I get the culprit column.

Improve this question
3
  • This might be one for Safe Support. this other answer notes double quotes was missing stackoverflow.com/questions/35515173/…
    – Mapperz ♦
    Jan 26, 2021 at 14:23
  • Is that error occurring upon writing to the database? Can you cross reference your field names against the Oracle Reserved words? docs.oracle.com/cd/B19306_01/em.102/b40103/…
    – Fezter ♦
    Jan 27, 2021 at 7:16
  • So yes that is one of the way to do it, but to be honest matching it with a list of reserved words is a bit difficult some times when you have more then hundred columns. I mean i have a way around but just wondering if some champ has created a logger/transformer to pin point the column causing error.
    – user4906240
    Jan 27, 2021 at 20:31

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.