SQL MA Error : Falied connection ; "column-list-reordering" RRS feed

  • Question

  • Hi,

    We are using FIM 2010 in our QA environment

    We have a SQL MA connecting to SQL 2005 and SQL 2005 is installed in a separate machine.

    We have configured Export and DeltaImport run profiles to the SQL MA. Export will happen to a Table and DeltaImport from a view.

    Export is successful but when running DeltaImport we are facing the issue and the error is as below.

    Status: no-ma-start

    Connection Status : failed connection

    Error : column-list-reordering

    Error Code : 0x80040e07

    When i try to query the view as "select * from dbo.Testview" i am getting below error 

    The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

    Below is the query of the view

    SELECT     A.column1, A.column2, A.column3, A.column4, A.column5, A.column6, A.column7, A.column8, A.column9, A.column10, A.column11, A.columnDate,B.EventType
    FROM         dbo.TestTable AS A CROSS JOIN
                              (SELECT     'Delete' AS EventType) AS B
    WHERE     (DATEDIFF(day, A.columnDate, GETDATE()) <= 1)

    can anyone please let us know how we can tackle this issue. LogcreationDate is a column which will hold today's date and the datatype of this column in both table and view is Varchar(50)

    Thursday, July 4, 2013 4:25 AM

All replies

  • Jyothi,

    I think there is an issue at your SQL View side. Once you correct it, go to MA and refresh the Schema of the MA. this will help you.


    Manuj Khurana

    Monday, July 8, 2013 9:47 AM