Load Ingest Data
Results 1 to 3 of 3

Thread: AS400 - ODBC source. Error '1021802' initializing workspace for table

  1. #1
    mimgq2 is offline Junior Member
    Join Date
    Dec 2018
    Posts
    3
    Rep Power
    0

    AS400 - ODBC source. Error '1021802' initializing workspace for table

    Where does on start when you have the following error:

    Date and Time Level Message
    12/20/2018 8:39:16 AM ERROR_GENERAL ODBC source. Error '1021802' initializing workspace for table '.Table-id '0''
    12/20/2018 8:39:16 AM ERROR_GENERAL Table with table id '0' is not captured
    12/20/2018 8:39:16 AM ERROR_GENERAL Unable to get table_def for capture table 0
    12/20/2018 8:39:15 AM WARNING_GENERAL Table 'LXXXXXXX'.'XXXXXX' (subtask 1 thread 0) is suspended
    12/20/2018 8:39:15 AM ERROR_GENERAL Cannot refresh source table (1) metadata
    12/20/2018 8:39:15 AM ERROR_GENERAL converter 28709 not found

    This is an iSeries connection to a SQL-Server.
    I have 16 maps.. 10 work fine... 6 fail with the above error.

  2. #2
    mimgq2 is offline Junior Member
    Join Date
    Dec 2018
    Posts
    3
    Rep Power
    0

    Additional Logging found need insights

    was able to generate the following:

    What is this pointing to: No notification is defined for trigger of type


    Line 864: 00006748: 2018-12-21T16:33:06:74134 [STREAM ]V: Enqueque notify record 'TABLE_ERROR' to stream stream_0 (stream.c:1668)
    Line 875: 00006856: 2018-12-21T16:33:06:74134 [STREAM ]V: Dequeue notify record 'TABLE_ERROR' from stream_0 (stream.c:1686)
    Line 876: 00006856: 2018-12-21T16:33:06:74134 [TABLES_MANAGER ]T: The table Lxxxxx.xxxxxx Id = 1 has error (tasktablesmanager.c:4149)
    Line 878: 00006856: 2018-12-21T16:33:06:74134 [UTILITIES ]T: No notification is defined for trigger of type 'TABLE_ERROR_TRIGGER' (notification_manager.c:1017)
    Line 879: 00006748: 2018-12-21T16:33:06:105387 [UTILITIES ]T: No notification is defined for trigger of type 'GENERAL_ERROR' (notification_manager.c:1017)
    Line 882: 00006748: 2018-12-21T16:33:06:105387 [UTILITIES ]T: No notification is defined for trigger of type 'GENERAL_ERROR' (notification_manager.c:1017)
    Line 887: 00006748: 2018-12-21T16:33:06:105387 [SOURCE_UNLOAD ]T: ODBC source. Error '1021802' initializing workspace for table '.Table-id '0'' [1021802] (db2i_endpoint_unload.c:372)
    Line 1036: 00006748: 2018-12-21T16:33:06:355411 [UTILITIES ]T: No notification is defined for trigger of type 'GENERAL_ERROR' (notification_manager.c:1017)
    Line 1038: 00006748: 2018-12-21T16:33:06:371038 [UTILITIES ]T: No notification is defined for trigger of type 'GENERAL_ERROR' (notification_manager.c:1017)
    Line 1039: 00006748: 2018-12-21T16:33:06:105387 [SOURCE_UNLOAD ]E: ODBC source. Error '1021802' initializing workspace for table '.Table-id '0'' [1021802] (db2i_endpoint_unload.c:372)
    Line 1040: 00006748: 2018-12-21T16:33:06:371038 [UTILITIES ]T: No notification is defined for trigger of type 'GENERAL_ERROR' (notification_manager.c:1017)

  3. #3
    mimgq2 is offline Junior Member
    Join Date
    Dec 2018
    Posts
    3
    Rep Power
    0

    summary of resolution

    Plase task into verbose debug..

    Found that a column was added with a CCSID=28709 added a converter to make 28709 convert to 37


    00004248: 2018-12-21T20:53:08:296454 [METADATA_MANAGE ]T: Converter for column 'IREF05' = 'ibm-37_P100-1995', database CCSID = 37 (metadatamanager.c:2033)
    00004248: 2018-12-21T20:53:08:296454 [METADATA_MANAGE ]T: Converter for column 'IMSPEC' = 'ibm-37_P100-1995', database CCSID = 37 (metadatamanager.c:2033)
    00004248: 2018-12-21T20:53:08:296454 [INFRASTRUCTURE ]V: allocating model converter, ccsid 28709 (at_text.c:491)
    00004248: 2018-12-21T20:53:08:296454 [INFRASTRUCTURE ]T: converter 28709 not found [1002404] (at_text.c:499)
    00004248: 2018-12-21T20:53:08:296454 [INFRASTRUCTURE ]V: alloc_model_converter:500: Failed (at_text.c:505)
    00004248: 2018-12-21T20:53:08:296454 [INFRASTRUCTURE ]T: alloc_model_converter_descriptor: alloc_model_converter(converter_name, ccsid, &pCd->model_ucnv) failed (at_text.c:461)

Posting Permissions

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