none
SQL MA - Column name or number of supplied values does not match table definition. RRS feed

  • Question

  • Hi,

    I'm having this strange error on MA-syncs

    "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
    Column name or number of supplied values does not match table definition."

    I have the normal table and delta table with the exact same columns and names. Only the order of the columns is not the same among the 2 tables. Is there a required order?

    What about the "delta" column on the delta table. Is there a required position for it?

    Help is really appreciated.

    Thanks,

    JD

     

    mercredi 21 août 2019 16:53

Toutes les réponses

  • Did you compare character column length on the two tables as well? I had the issue before (not with MIM), where source and destination had different lengths.

    SELECT * 
    FROM [source].INFORMATION_SCHEMA.COLUMNS src
        INNER JOIN [dest].INFORMATION_SCHEMA.COLUMNS dst 
            ON dst.COLUMN_NAME = src.COLUMN_NAME
    WHERE dst.CHARACTER_MAXIMUM_LENGTH < src.CHARACTER_MAXIMUM_LENGTH 

    vendredi 23 août 2019 07:50