De-activating member not working in MDS

• Friday, January 27, 2012 6:28 AM

   

   
  

  0

  I will not repeat that that is told to me. The same problem as under the reference http://social.msdn.microsoft.com/Forums/en-US/sqlmds/thread/1886673e-c80e-442c-8d17-21aee717624f :

  I try to de-activate a member using mdm.tblStgMemberAttribute table. I use the below code to de-activate member. It is not working. When I do processing, the processing does not do anything with respect to this staged row. The Membercode is not getting deactivated. Please let me know whether I am doing something wrong?.....

  A thread result - its bug of MDS. Prompt if changes on the given problem?

   

  Example:

  ETL insert data:

  INSERT INTO [mdm].[tblStgMemberAttribute   ([ModelName],[EntityName],[MemberType_ID],[MemberCode],[AttributeName],[AttributeValue])

  VALUES ('NSI', N'Grain', 1, N'209', 'MDMMemberStatus', 'De-Activated')

  And call EXECUTE mdm.udpStagingSweep @User_ID, @Version_ID, 1

  After end of processing the batch this record have Status_ID=0 in tblStgMemberAttribute. What not affect on the record in entity table tbl_2_68_EN in my model. 

   

   

  • Edited by Raiden Friday, January 27, 2012 7:28 AM
  •  
  • Reply
  • Quote