Bug #81555 Workbench Migration Fails
Submitted: 23 May 2016 21:38 Modified: 24 May 2016 9:27
Reporter: Kenny Gryp Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Workbench: Migration Severity:S3 (Non-critical)
Version:6.3.6 OS:Any
Assigned to: CPU Architecture:Any

[23 May 2016 21:38] Kenny Gryp
Description:
For many tables I am trying to convert, I am getting the following error:

```
ERROR:`schema`.`table`:SQLGetData: Error 100
```

Is this really an error? Looking at sybase documentation, error 100 means a warning actually:

100
Warning	
2001	
02000	
"Row not found"	
You positioned a cursor beyond the beginning or past the end of the query. There is no row at that position.

From: http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00462.1510/conc...

How to repeat:

Running data migration data import from Sybase, for many tables I get errors like this:

```
17:56:00 [INF][      copytable]: --table [schema]       [dbo].table    `schema`        `table` [ID], [col], [Famille_idx], [Source], [AExporter], [IdNosica]
17:56:00 [INF][      copytable]: Connecting to MySQL server at 10.5.46.49:3306 with user root
17:56:00 [INF][      copytable]: Connection to MySQL opened
17:56:00 [INF][      copytable]: Opening ODBC connection to [unknown] 'DSN=sybase_dev;DATABASE=schema;UID=sa;DelimitIdentifier=No;PWD=XXX'
17:56:00 [INF][      copytable]: ODBC connection to 'DSN=sybase_dev;DATABASE=schema;UID=sa;DelimitIdentifier=No;PWD=' opened
17:56:00 [INF][      copytable]: Connecting to MySQL server at 10.5.46.49:3306 with user root
17:56:00 [INF][      copytable]: Connection to MySQL opened
17:56:00 [INF][      copytable]: Opening ODBC connection to [unknown] 'DSN=sybase_dev;DATABASE=schema;UID=sa;DelimitIdentifier=No;PWD=XXX'
BEGIN:`schema`.`table`:Copying 6 columns of 1325 rows from table [schema].[dbo].table
17:56:00 [INF][      copytable]: Truncating table `schema`.`table`
17:56:00 [INF][      copytable]: ODBC connection to 'DSN=sybase_dev;DATABASE=schema;UID=sa;DelimitIdentifier=No;PWD=' opened
17:56:00 [INF][      copytable]: Connecting to MySQL server at 10.5.46.49:3306 with user root
17:56:00 [INF][      copytable]: Connection to MySQL opened
ERROR:`schema`.`table`:SQLGetData: Error 100
ERROR:`schema`.`table`:Failed copying 1325 rows
17:56:00 [INF][      copytable]: Re-enabling triggers for schema 'schema'
17:56:00 [INF][      copytable]: No triggers found for 'schema'
FINISHED
```
[24 May 2016 9:26] Kenny Gryp
I was able to fix the error.

Some rows contained accents (é), and the ODBC was configured as ANSI client charset (default). 
I changed it to iso_1 character set in ODBC and everything worked better (no guarantees that charsets are working fine atm).
[24 May 2016 9:27] Kenny Gryp
closing as not-a-bug. 

Hopefully this bug will be a good reference to future sybase migrators ending up in this page