04-17-2014 08:12 PM - last edited on 03-25-2019 08:29 PM by ciscomoderator
I am running CUCM 9.1(2) and I am trying to update the user to ensure device association and group membership. I created a CSV file based on a BAT export and updated the group and associated device fields and for the PIN, Password and Digest Credentials fields I have used the # symbol coupled with the "Value for fields to be ignored" option.
When i run the BAT job i get the following error for almost all of the records
[user id] Missing key in referenced table for referential constraint (informix.fk_enduser_fkucserviceprofile).
I am not using a user template for the BAT update and my users are all LDAP sync'ed
I have not been able to find anything helpful online, does anyone have any ideas?
Thanks in advance
04-18-2014 02:23 AM
I think you may be hitting this bug. CSCue02300
Have you filled in anything on the MLPP attrib column?
04-18-2014 05:33 AM
Thanks Sreekanth,
The 3 MLPP columns are all blank but it does look like a similar bug
04-18-2014 11:20 AM
Set the Bulk Provisioning Service traces to Detailed/Debug level under Unified Serviceability->Trace->Configuration then run the BAT job again and pull the BPS traces via RTMT. That should have more details on what the issue is.
04-19-2014 08:45 AM
Hi,
Please look for the bug CSCue81148, CSCud9100.
Even I had the issue for the CUCM 9.1.1 version when I was trying to associate the User with their respective devices. (not with group).
I see your is 9.1.2.
Regards,
Raaj.
04-23-2014 05:33 PM
Hi,
Just another thing that could be worth checking "fk_enduser_fkucserviceprofile" sounds like is referencing the UC Service Profile for IM&P are you populating, ignoring with a #, or is it blank? If you are ignoring with a # try just setting it to blank.
I found when enabling users with IM&P I had to specify the UC Service profile and not just use the system default
04-24-2014 06:30 PM
Thanks Heathrw, I actually missed that the service profile was listed in the error. I reached out to TAC and they suggested that i convert the users to local users, run the BAT update and then resync with the AD.
It worked but not the best solution so i will try again with another set of users and this time add a UC service profile.
thanks
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide