locked
Data not moving from Staging table to Entity table. RRS feed

  • Question

  • Hi,

    I Master data services, i inserted few rows in the tables tblStgMember and tblStgMemberAttribute,

    After inserting the rows, I executed the stored procedure "mdm.udpStagingSweep", and  mdm.udpValidateModel,

    but the data which was inserted to staging tables has not moved to Entity tables in database.

     

    the service broker is enabled for the database, 

    Also, On the import page, the staging batch doesnot start.

    Any other Resolution ?

     

     


    Thursday, August 11, 2011 7:14 AM

Answers

  • Did you try using the MDM page for imports?

    That might give you a clue to the problem. You should see you staged counts and by clicking on Import you should see the status change.


    Believing is being
    • Marked as answer by Challen Fu Monday, August 22, 2011 10:20 AM
    Wednesday, August 17, 2011 5:53 PM

All replies

  • Did you try using the MDM page for imports?

    That might give you a clue to the problem. You should see you staged counts and by clicking on Import you should see the status change.


    Believing is being
    • Marked as answer by Challen Fu Monday, August 22, 2011 10:20 AM
    Wednesday, August 17, 2011 5:53 PM
  • Hi,

    I Master data services, i inserted few rows in the tables tblStgMember and tblStgMemberAttribute,

    After inserting the rows, I executed the stored procedure "mdm.udpStagingSweep", and  mdm.udpValidateModel,

    but the data which was inserted to staging tables has not moved to Entity tables in database.

     

    the service broker is enabled for the database, 

    Also, On the import page, the staging batch doesnot start.

    Any other Resolution ?

     

     


    Hi,

              Did you get any kind of solution for this issue?

              It would be helpful if you could share that.

              Thank you :)

    Wednesday, June 14, 2017 5:28 AM