SQD0125E - Delimited datastore field count mismatch - connect_cdc_sqdata - Latest

Connect CDC (SQData) Error Messages and Codes

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
ft:locale
en-US
Product name
Connect CDC (SQData)
ft:title
Connect CDC (SQData) Error Messages and Codes
Copyright
2026
First publish date
2000
ft:lastEdition
2026-03-10
ft:lastPublication
2026-03-10T11:39:12.937000
L1_Product_Gateway
Integrate
L2_Product_Segment
Data Integration
L3_Product_Brand
Precisely Connect
L4_Investment_Segment
Application Data Integration
L5_Product_Group
ADI - Connect
L6_Product_Name
Connect CDC

(<#>) Record <name> in datastore <name> contains <number> fields vs <number> fields

The specified delimited datastore described by the specified record does not have the same number of fields that were specified in the corresponding DESCRIPTION command for the file/datastore. This may occur if a delimiter character is specified that is found in the source datastore data. Correct the definition of the input datastore to match the correct number of fields. If the number of fields is correct and this error is due to the delimiter character found in a source field, change the delimiter character in the DATASTORE command for this datastore, re-parse the script and rerun the Integration Engine.