I am running the MDM against our development server at the moment and have corrected a couple of minor issues, but this one is proving more difficult. Whenever the MDM runs it gets to the last section and then returns the error message below:
The database structures for 'EndUser' with primary key '889c4b0f-4c3b-4e91-869f-006fb267468c' are incomplete. There is a missing record in the 'tps_end_user' table. Please restore a valid database backup.. Please check the metadata manager log file for further details (time elapsed: 238 seconds)
Any assistance that could be offered with this would be gratefully received?
My first reaction is that you have some corruption or deleted record in the tps_end_user table. Users are stored in two places. There is the main record which is stored in the tps_users table and then a sub record that is located in the tps_end_user or tps_analyst etc tables. I suggest you check to see if there are any records that are shown as being End Users in the tps_users table that don't appear in the tps_end_user table.
Yep, there are 683 records where the TPS_User_GUID appears in the TPS_Users table but not in the TPS_End_User table, is it enough to put the GUID back in, or does the entire User record need to be copied into TPS_End_User?
Thanks for your help with this,
If you look at the tps_end_user table, you'll probably find that it just has the one column containing the GUID of the record in the tps_users table. If that is the case, then you just need to have the missing one added to the table.
This is sometimes caused by using support scripts that move an analyst to an end user and visa versa. There are also scripts available from support which can fix this up once and for all. I'd recommend asking for a copy from your local support team as a first step.
Indeed, that was all we had to do. Add the column containing the GUID to tps_end_user and it all worked fine after that. Thank you to everyone for all your help.