Load Ingest Data
Results 1 to 2 of 2

Thread: MySQL to Hadoop/Oracle CDC - Source character set not supported by Client

  1. #1
    Ojasvi is offline Junior Member
    Join Date
    Apr 2018
    Posts
    1
    Rep Power
    0

    Question MySQL to Hadoop/Oracle CDC - Source character set not supported by Client

    We have requested for Attunity Replicate Trail/Free Version tool to analyze/compare the capabilities of Attunity CDC Tool.

    We are using MySQL as Source and Oracle/Hadoop as Target.

    We have successfully able to create different source and target for Manage Endpoint Connections. Successfully able to create Task using those source and targets. But while running the task getting below exceptions -


    00005680: 2018-05-23T05:47:26 [SERVER ]I: Task Server Log - ReplicateMySQL (V5.0.2.58 xxxxxxx Microsoft Windows 64-bit, PID: 1884) started at Wed May 23 05:47:26 2018 (logger.c:475)
    00005680: 2018-05-23T05:47:26 [SERVER ]I: Licensed to Attunity Replicate Express users (software license acceptance implied)Express license: You are running the Express Edition with reduced functionality (296 days remaining) (logger.c:478)
    00005680: 2018-05-23T05:47:26 [SERVER ]I: Client session (ID 18977) allocated (dispatcher.c:241)
    00005680: 2018-05-23T05:47:26 [TABLES_MANAGER ]I: Task 'ReplicateMySQL' running full load and CDC in resume mode after recoverable error, retry #63 (replicationtask.c:900)
    00005680: 2018-05-23T05:47:26 [METADATA_MANAGER]I: ODBC additional properties = 'GET_SERVER_PUBLIC_KEY=1' (mysql_endpoint_imp.c:562)
    00005680: 2018-05-23T05:47:26 [METADATA_MANAGER]I: Connecting to MySQL through ODBC connection string: DRIVER={MySQL ODBC 5.2 Unicode Driver};SERVER=localhost;port=3306;UID=xxxx;PWD=** **;DB=;Option=74448896;GET_SERVER_PUBLIC_KEY=1 (mysql_endpoint_imp.c:646)
    00005680: 2018-05-23T05:47:26 [METADATA_MANAGER]I: Going to connect to Oracle server CDB12C with username xxxx (oracle_endpoint_imp.c:828)
    00005680: 2018-05-23T05:47:27 [UTILITIES ]I: The state is restored from file 'C:\Program Files\Attunity\Replicate\data\tasks\ReplicateMySQL/StateManager/ars_saved_state_000002.sts' saved at Wed, 23 May 2018 09:41:52 GMT (1527068512396752) (statemanager.c:1065)
    00001912: 2018-05-23T05:47:27 [TASK_MANAGER ]I: Creating threads for all components (replicationtask.c:1390)
    00001912: 2018-05-23T05:47:27 [METADATA_MANAGER]E: RetCode: SQL_ERROR SqlState: 07006 NativeError: 0 Message: [MySQL][ODBC 5.2(w) Driver][mysqld-8.0.11]Source character set not supported by client [122502] ODBC general error. (ar_odbc_stmt.c:2814)
    00001912: 2018-05-23T05:47:27 [METADATA_MANAGER]E: Error in captured tables list query: select TABLE_SCHEMA,TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_TYPE='BASE TABLE' AND(
    ( /* Explicit */
    (TABLE_SCHEMA='emp' and TABLE_NAME='persons1' )
    ) OR ( /* Inc patters */
    (1=0)
    )
    )AND NOT ( /* Exc patterns */
    (TABLE_SCHEMA like '%' and TABLE_NAME like 'attrep_changes%' or TABLE_SCHEMA like '%' and TABLE_NAME like 'attrep_apply%' or TABLE_SCHEMA like '%' and TABLE_NAME like 'attrep_truncation%' or TABLE_SCHEMA like '%' and TABLE_NAME like 'attrep_audit_table' or TABLE_SCHEMA like '%' and TABLE_NAME like 'attrep_status' or TABLE_SCHEMA like '%' and TABLE_NAME like 'attrep_suspended_tables' or TABLE_SCHEMA like '%' and TABLE_NAME like 'attrep_history' )
    ) ORDER BY 1,2 LIMIT 60000; [122511] Query setup error (mysql_endpoint_imp.c:1867)
    00001912: 2018-05-23T05:47:27 [METADATA_MANAGER]E: Failed to get the capture list from the endpoint [122511] Query setup error (metadatamanager.c:2910)
    00001912: 2018-05-23T05:47:27 [TABLES_MANAGER ]E: Cannot get captured tables list [122511] Query setup error (tasktablesmanager.c:870)
    00001912: 2018-05-23T05:47:27 [TASK_MANAGER ]E: Build tables list failed [122511] Query setup error (replicationtask.c:1494)
    00001912: 2018-05-23T05:47:27 [TASK_MANAGER ]E: Task 'ReplicateMySQL' failed [122511] Query setup error (replicationtask.c:2348)
    00001912: 2018-05-23T05:47:27 [TASK_MANAGER ]I: Task 'ReplicateMySQL' encountered a recoverable error (repository.c:4411)
    00001912: 2018-05-23T05:47:27 [UTILITIES ]I: The last state is saved to file 'C:\Program Files\Attunity\Replicate\data\ta


    Environment Details

    Operating System Windows Server 2012 R2 Standard
    MySQL - 8.0.11.0
    ODBC Connector 5.2 Unicode Driver
    MySQL Schema Table Details emp.persons1

    Name:  odbc.png
Views: 395
Size:  14.2 KB

  2. #2
    Layeeq is offline Junior Member
    Join Date
    Nov 2018
    Posts
    8
    Rep Power
    0

    Mysql Connection Error : No valid MySQL ODBC 5.x Unicode Driver is installed.

    Hi Team,

    I am getting below error after installing driver also , not able to connect to mysql.

    No valid MySQL ODBC 5.x Unicode Driver is installed. The required ODBC driver or driver manager is not properly installed and configured.
    I installed Attunity Express Edition for one month.

    ODBC Driver:
    mysql-connector-odbc-5.3.10-1.el7.x86_64
    Mysql version : | version | 5.6.41
    | version_comment | MySQL Community Server (GPL)
    | version_compile_machine | x86_64
    version_compile_os | Linux

    I am doing CDC from MYSQL to Hadoop.

    Please find attached screen.

    Please help me on this, Thanks.
    Attached Images Attached Images  

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •