Connect CDC

 View Only
Back to discussions
Expand all | Collapse all

Query related to Error Code "4137"

  • 1.  Query related to Error Code "4137"

    Posted 10 days ago

    Hello - 

    We are getting below error in Syncsort Tool during Distribution Creation for Missing Column Mapping.
    ++++++
    4137:Source and target (ORACLE_SCHEMA.table@SOURCE.column, SQLDB.dbo.table@TARGET.column) matching columns have incompatible or unsupported datatypes: source [CLOB], target [nvarchar(4000) [UNI]]
    ++++++
    But same 4137 error is not coming in Validation Report. Due to this, we are missing some Column Mappings, which needs to capture & resolve manually. Also we found Datatype of Column "COLUMN" is "VARCHAR2(4000)" in Source (Oracle) Database, but in Tool, it is coming as "CLOB", which is misleading.
    Kindly let us know, if there is any option to capture "4137" & "0433" in Validation Report or any Specific Report.


    ------------------------------
    Smruti Roul
    Blue Yonder, Inc.
    SCOTTSDALE AZ
    ------------------------------