Using A Query In Migration Toolkit

[peterlaursen]

It is the ODBC-source that returns this error – not the MySQL-target.

Please tell: what is the ODBC-source?  I think you have earlier reported an issue with OpenEdge?

(we have tried with MySQL as source and a query like yours with LIMIT works fine)

[mkgreidi]

Yes,I reported an issue with OpenEdge. Finally, I solved this problem. I have to aggregate “pub” before the table name to select.

For example:

Error : SELECT * FROM table1

Correct: SELECT * FROM pub.table1

Now, I have a problem with the openEdge database, and if I want to import the table show me this error.

ERROR: [DataDirect][ODBC OPENEDGE driver][OPENEDGE]Column desc_Art in table PUB.tl_articulo has value exceeding its max length or precision. : Import unsuccessful

I wanted to use the previus query to make an import by groups,very little groups, to try to identificate witch register is wrong in openedge database.

Try and import loke this

SELECT * FROM table1 LIMIT 0,10

SELECT * FROM table1 LIMIT 10,10

SELECT * FROM table1 LIMIT 20,10

In Mysql runs perfectly,but in migration toolkit process shows me the previous error.

[Khushboo]

Hi,

The query which we specify to Import, is executed on the source not on the target. So, the SQL written should be compatible with the ODBC source.

Please execute a simple query like “SELECT * from table1 LIMIT 0,5” in your source client interface i.e OpenEdge and check if it executes successfully.

It may be possible that “LIMIT” keyword is not supported by OpenEdge.

Please check which keyword(equivalent to LIMIT clause in MySQL) is supported by OpenEdge and use that in Import Wizard.

Thanks & Regards,

Khushboo

[Author]

Posts