Oracle reader error ora-00904 invalid identifier MI_STYLE

Liz Sanderson
Liz Sanderson
  • Updated

FME Version

  • FME 2015.x

Symptom

There are several reasons for encountering an invalid Oracle identifier:

  • identifier might be more then 30 characters
  • The Oracle table may have changed since the workspace was created and an attribute no longer exists
  • Specifically for a MI_STYLE identifier:
    • When the Oracle reader was added to the workspace the parameter "Apply MapInfo Symbology" was checked.

http_download_1444329513252_6032.jpeg


If the MapInfo styling attribute does not exist in the Oracle table then you'll get the ORA-00904 error. The MapInfo Style Column may be added to your Oracle tables by MapInfo applications. MI_STYLE store the record styling and FME will automatically map these to the appropriate mapinfo_ format attributes if your writing to MapInfo TAB.

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.