Updating CUCM users via BAT

[ybpants]

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

[Sreekanth Narayanan]

I think you may be hitting this bug. CSCue02300

Have you filled in anything on the MLPP attrib column?

[ybpants]

Thanks Sreekanth,

The 3 MLPP columns are all blank but it does look like a similar bug

[Brian Meade]

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.

[Rajkumar Yadav]

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.

[heathrw]

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

[ybpants]

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