Unified Operations & Dynamics AX Forum

Expand all | Collapse all

DMF requires all columns in source file to have a value for all rows?

Jump to Best Answer
  • 1.  DMF requires all columns in source file to have a value for all rows?

    TOP CONTRIBUTOR
    Posted 12 days ago
    I have a processing group that is designed to import from a single spreadsheet tab into multiple entities.  This processing group works just fine as long as every single column in the source spreadsheet has a value in every column for every row that has any data in it.  If any record has a column that is blank, the corresponding data entity that has a field mapped to that column will fail *all* records, even ones that do have a value.

    Here is a sample infolog that might help clarify what is happening.  In this scenario, there are two records in the spreadsheet.  One record has a value in every column, and the other has no value in the columns that are mapped to the Unit of Measure Conversion entity.

    Info        Message (10:43:56 am)        '2' 'Configurations assigned to product masters' record(s) inserted in staging

    Info        Message (10:43:56 am)        '2' 'Product variants' record(s) inserted in staging

    Warning        Message (10:43:56 am)        '0' 'Unit of Measure Conversion' record(s) inserted in staging

    Warning        Message (10:43:56 am)        For additional warnings or errors, please check the log

    Info        Message (10:43:56 am)        '2' 'Item coverage' record(s) inserted in staging

    Info        Message (10:43:56 am)        '2' 'Barcode' record(s) inserted in staging

    Info        Message (10:43:56 am)        '2' 'Configuration selection' record(s) inserted in staging

    Info        Message (10:43:56 am)        '2' 'External item descriptions' record(s) inserted in staging

    Info        Message (10:43:56 am)        '2' 'Price discount agreement journal' record(s) inserted in staging

    The SSIS server event log shows this:
    There was an error with OLE DB Destination.Inputs[OLE DB Destination Input].Columns[Copy of DENOMINATOR] on OLE DB Destination.Inputs[OLE DB Destination Input]. The column status returned was: "The value violated the integrity constraints for the column.".

    My question is why the  DMF is failing to import *all* records into the staging table for the Unit of Measure Conversion, when it should have been able to import one record (the one that has values)?

    Here is what I've tried so far...
    - Added code to the validateWrite method on the entity table.  (Does not seem to be called at all, so basically pointless...)
    - Made sure the corresponding fields in the entity table were not mandatory

    Thanks in advance for any advice.






    ------------------------------
    Daniel Zook
    Director of IT
    Lehman's
    Dalton OH
    ------------------------------


  • 2.  RE: DMF requires all columns in source file to have a value for all rows?
    Best Answer

    TOP CONTRIBUTOR
    Posted 12 days ago
    I eventually stumbled upon the answer myself.

    By default "ignore error" is disabled, so I tried it with it enabled and it worked like I needed it to… the records with data were imported into the entity staging table, and the blank rows threw a warning.  The key is that the blank rows didn't prevent the other rows from going into stage.

    Info        Message (11:43:28 am)        '2' 'Configurations assigned to product masters' record(s) inserted in staging

    Info        Message (11:43:28 am)        '2' 'Product variants' record(s) inserted in staging

    Info        Message (11:43:28 am)        '2' 'Unit of Measure Conversion' record(s) inserted in staging

    Info        Message (11:43:28 am)        '2' 'Item coverage' record(s) inserted in staging

    Warning        Message (11:43:28 am)        The file for entity Barcode is having 1 error(s)

    Info        Message (11:43:28 am)        '1' 'Barcode' record(s) inserted in staging

    Warning        Message (11:43:28 am)        '1' 'Barcode' record(s) didn't insert in staging

    Warning        Message (11:43:28 am)        For additional warnings or errors, please check the log

    Info        Message (11:43:28 am)        '2' 'Configuration selection' record(s) inserted in staging

    Info        Message (11:43:28 am)        '2' 'External item descriptions' record(s) inserted in staging

    Info        Message (11:43:28 am)        '2' 'Price discount agreement journal' record(s) inserted in staging



    ------------------------------
    Daniel Zook
    Director of IT
    Lehman's
    Dalton OH
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role