[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.

[mkgreidi]

I don´t know if this maybe can help you but the source-database is Progress.

It´s my fault not to specify before,sorry.

Thank you

[mkgreidi]

If I try to import with the option “use a query to specify the data to transfer” it doesn´t work too.

I write the query SELECT * FROM `tl_tarifas` but it shows me the error

[DataDirect][ODBC OPENEDGE driver][OPENEDGE]Syntax error in SQL statement at or about “tl_tarifas”(10713)

I used the quotes and backsticks, and try to use a subquery but when I specified the table name always have the same error.

Sorry,but it´s the first time I use this software and I don´t fins many information.

[mkgreidi]

Thanks for answer

I try to make your suggestion but it shows an error.

I write in WHERE clause cod_tar IN (SELECT cod_tar FROM tl_precios) but shows me the message error “[DataDirect][ODBC OPENEDGE driver][OPENEDGE]Syntax error in SQL statement at or about “'tl_tarifas') and 1=0″ (10713)”

What does it mean?How can I solve it?

[attachment=1376:example_error.jpg]

[Author]

Posts