locked
How to see all Staging Batch Errors in a sql request ? (answer included) RRS feed

  • Question

  • Hi,

    maybe this can help you to debug your staging batches errors (mds web interface is slow and displays only 500 error lines by default) 

    exec mdm.udpStagingBatchGet @User_ID=1,@StagingType_ID=4,@Batch_ID=25,@Status_ID=2,@BatchStatus_ID=6,@PageSize=NULL

    (just replace User_ID and Batch_ID with your values in order to get the full staging table errors during an import)

    Regards,

     


    Xavier Averbouch
    Thursday, September 30, 2010 3:07 PM

Answers

  • Hi,

    maybe this can help you to debug your staging batches errors (mds web interface is slow and displays only 500 error lines by default) 

    exec mdm.udpStagingBatchGet @User_ID=1,@StagingType_ID=4,@Batch_ID=25,@Status_ID=2,@BatchStatus_ID=6,@PageSize=NULL

    (just replace User_ID and Batch_ID with your values in order to get the full staging table errors during an import)

    Regards,

     


    Xavier Averbouch
    Answer included :)
    Xavier Averbouch
    Thursday, October 7, 2010 1:49 PM