locked
Removing the deleted Member from the MDS Database - SQL Server 2012 RRS feed

  • Question

  • Hi am trying to remove the deleted member from the MDS Database.

    Created records to purge in stg.Business_Detail_Leaf with Import Type 4 and ImportStatus_id 0

    INSERT INTO [stg].[Business_Detail_Leaf] (
    	[ImportType]
    	,[ImportStatus_ID]
    	,[BatchTag]
    	,[Code]
    	,[Name]
    	)
    SELECT 4 -- purge member
    	,0 -- ready for staging
    	,'Purge Member' -- batch tag
    	,code -- code
    	,NAME -- name
    FROM mdm.tbl_2_6_EN
    WHERE Status_ID = 2

    This does appears in MDS Integration Management as a batch to process on local server.

    But when am doing the  same on other server where I got System Administration and Integration Management rights on the Model,  this batch doesn't appear to process.

    Am I missing any right to do this?


    Sree



    • Edited by VenSree Monday, December 7, 2015 11:28 PM
    Monday, December 7, 2015 10:52 PM

Answers

  • Thanks Vincent for the reply.

    Yes I did figured out later. 

    • The MDS Server which I was working was one upgraded from 2008 to 2012.
    • Batches created with Import Status Id was not showing up in the grid.

    What I did was inserted records into [stg].[Business_Detail_Leaf] with [ImportStatus_ID] = 1, this then showed up in the grid.  Then updated the [ImportStatus_ID] to 0 and started the batch, this was successfully processed and the records where purged.

     

     


    Sree

    • Proposed as answer by Charlie Liao Tuesday, December 8, 2015 6:16 AM
    • Marked as answer by Charlie Liao Thursday, December 17, 2015 8:07 AM
    Tuesday, December 8, 2015 4:41 AM

All replies

  • 1. The batch tag need to be unique for each batch. You can add a unique identifier to the 'Purge Member'

    2 .Did the batch appear in the grid?

    3. After click the 'Start Batches', did the batch status changed to Queued to run?

    4. If the batch stuck in Queued to Run status, did the service broker is enabled on the database?

    https://sqljoe.wordpress.com/2011/12/14/master-data-services-error-resolving-from-a-long-running-stucked-staging-batch-with-status-queued-to-clear-or-running/

    Tuesday, December 8, 2015 1:57 AM
  • Thanks Vincent for the reply.

    Yes I did figured out later. 

    • The MDS Server which I was working was one upgraded from 2008 to 2012.
    • Batches created with Import Status Id was not showing up in the grid.

    What I did was inserted records into [stg].[Business_Detail_Leaf] with [ImportStatus_ID] = 1, this then showed up in the grid.  Then updated the [ImportStatus_ID] to 0 and started the batch, this was successfully processed and the records where purged.

     

     


    Sree

    • Proposed as answer by Charlie Liao Tuesday, December 8, 2015 6:16 AM
    • Marked as answer by Charlie Liao Thursday, December 17, 2015 8:07 AM
    Tuesday, December 8, 2015 4:41 AM
  • Hi Sree,

    Glad to hear that your issue had been solved. Thank you for your sharing, please mark the corresponding reply, it will help others to find the correct answer who have the similar issue.

    Regards,


    Charlie Liao
    TechNet Community Support

    Tuesday, December 8, 2015 6:16 AM