Load Ingest Data
Results 1 to 2 of 2

Thread: Error in copy date from mysql rds to redshift

  1. #1
    qing is offline Junior Member
    Join Date
    Sep 2015
    Posts
    4
    Rep Power
    0

    Error in copy date from mysql rds to redshift

    I got the below error when I did the full load copy. It just happened to the table T_WEB_PROFILE but not to other tables.
    Not sure how to handle the 'Metadata Manager table definition cannot be found issue'.

    00118512: 2015-09-16T13:52:13 [METADATA_MANAGER]E: Metadata Manager table definition cannot be found. Table ID: 1. Component ID: MySQLProd [120416] Failed to get a table definition. (metadatamanager.c:1115)
    00118512: 2015-09-16T13:52:13 [SOURCE_UNLOAD ]I: mysql_endpoint_get_table_def_imp T_WEB_PROFILE (mysql_endpoint_metadata.c:376)
    00118512: 2015-09-16T13:52:13 [SOURCE_UNLOAD ]I: Entering mysql_unload_source_loop (mysql_endpoint_unload.c:438)
    00118512: 2015-09-16T13:52:13 [SOURCE_UNLOAD ]I: 'ResumeFetchForXRows' property is set for 1500000000 rows (mysql_endpoint_unload.c:237)
    00118512: 2015-09-16T13:52:13 [SOURCE_UNLOAD ]W: Value for column 'PERSONAL_RISK_ANSWERS' was truncated. data len: 19212, bind len: 16386 (ar_odbc_stmt.c:2835)
    00118512: 2015-09-16T13:52:14 [SOURCE_UNLOAD ]W: Value for column 'PERSONAL_RISK_ANSWERS' was truncated. data len: 1148232, bind len: 16386 (ar_odbc_stmt.c:2835)
    00118512: 2015-09-16T13:52:15 [SOURCE_UNLOAD ]W: Value for column 'PERSONAL_RISK_ANSWERS' was truncated. data len: 19110, bind len: 16386 (ar_odbc_stmt.c:2835)
    00118512: 2015-09-16T13:52:16 [SOURCE_UNLOAD ]W: Value for column 'PERSONAL_RISK_ANSWERS' was truncated. data len: 19076, bind len: 16386 (ar_odbc_stmt.c:2835)
    00118512: 2015-09-16T13:52:16 [SOURCE_UNLOAD ]I: Unload finished for table 'T_WEB_PROFILE' (Id = 1). 32152 rows sent. (streamcomponent.c:2548)
    00119796: 2015-09-16T13:52:16 [TARGET_LOAD ]I: Load finished for table 'T_WEB_PROFILE' (Id = 1). 32152 rows received. 0 rows skipped. Volume transfered 125729080 (streamcomponent.c:2768)
    00119796: 2015-09-16T13:52:24 [TARGET_LOAD ]E: RetCode: SQL_ERROR SqlState: XX000 NativeError: 7 Message: ERROR: Load into table 't_web_profile' failed. Check 'stl_load_errors' system table for details.;
    Error while executing the query [122502] ODBC general error. (ar_odbc_stmt.c:4031)
    00119796: 2015-09-16T13:52:24 [TARGET_LOAD ]E: Failed to load t_web_profile from S3, file name: LOAD00000001.csv [122502] ODBC general error. (redshift_imp.c:1444)
    00119796: 2015-09-16T13:52:24 [TARGET_LOAD ]E: Failed to copy data of file C:\Program Files\Attunity\Replicate\data\tasks\web_profile\re dshift\1\LOAD00000001.csv to database [122502] ODBC general error. (redshift_imp.c:1505)
    00119200: 2015-09-16T13:52:25 [TASK_MANAGER ]W: Table 'T_WEB_PROFILE' (subtask 1 thread 1) is suspended. (replicationtask.c:1501)
    00119796: 2015-09-16T13:52:24 [TARGET_LOAD ]E: Handling End of table 'T_WEB_PROFILE' loading failed by subtask 1 thread 1 [122502] ODBC general error. (endpointshell.c:1364)
    00119200

  2. #2
    stevenguyen is offline Senior Member
    Join Date
    May 2014
    Posts
    301
    Rep Power
    6
    Hello qing,

    The error indicate some records in the table cannot be copy to Redshift.

    Please check the Check 'stl_load_errors' system table for detail.

    This would provide more information.

    Thanks,
    Steve

Posting Permissions

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