Book a Demo

Author Topic: Import DB schema -> error import table  (Read 3220 times)

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1405
  • Karma: +42/-2
    • View Profile
    • www.umlchannel.com
Import DB schema -> error import table
« on: September 17, 2013, 11:48:36 pm »
Hi,

I ran an Import DB Schema from ODBC to retrieve the DB schema from a remote MySQL 5.1.
For each imported table, I got the following error :

Error importing Table: <name of the table> => There was an error parsing  on line < line number >. Unexpected symbol: (

Is there any way to gather exactly what happened? (and if there's any impact on the generated tables in EA)

thanks
Guillaume
« Last Edit: September 18, 2013, 01:16:47 am by gfuk »
Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com


qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Import DB schema -> error import table
« Reply #1 on: September 18, 2013, 09:16:56 am »
Just a guess: it might be an issue with the MySQL ODBC driver. Have you checked here that it's valid? There were some recent discussions about which drivers are valid and which aren't.

q.

zaukrut

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Re: Import DB schema -> error import table
« Reply #2 on: September 19, 2013, 12:58:06 am »
Hi,
I'm using EA 10 Ultimate Edition and get a similar error when trying to import tables from Oracle 10g
Although the owner of the tables are same user that is defined in ODBC Resource "tables" are not retrieved via import screen in EA,

("Select DB Objects to Import" captioned screen does not show anything)

Any idea ?