CallManager SQL command update - Permission Not Pass

[Chi Fai Leung]

Hi,

I want  to use the SQL command to update the CM enduser attribute.

CM 1 version is 10.5 & CM 2 version is 10.5

CM 1 update fail:
admin:run sql update enduser set ocsprimaryuseraddress='petter_chan@abc.com' where userid='petter_chan'
No UPDATE permission for enduser.ocsprimaryuseraddress

CM2 update success:
admin:run sql update enduser set ocsprimaryuseraddress='petter_chan@abc.com' where userid='petter_chan'
No UPDATE permission for enduser.ocsprimaryuseraddress
Rows: 1

Is it my CM 1 have database issue?

[Sreekanth Narayanan]

Are CM 1 and CM2 the exact same version? Is CM1 the publisher and CM2 the subscriber?

Is this the first time you've tried this update?

I tried this update on an 8.x server and it worked fine.

[Chi Fai Leung]

No ... CM1 and CM2 is two CM Cluster.

Yes ... CM1 and CM2 are first time to update this.

Is it the ocsprimaryuseraddress of the "IM address"? Actually, I made the inter-domain XMPP federation with two Presence cluster including the two IM addresses "hkuser@abchk.com" and "sguser@abcsg.com". And I want to sync the sg LDAP users to hk CM, then I can search the UDS users adding manually as XMPP federation communication, so I want to modify the IM addresses

[Sreekanth Narayanan]

I don't think you can update that field (ocsprimaryuseraddress). I tried this on a 10.5 server in the lab and was unable to do so.

Are you sure CM2 was able to update it? What are the versions of CM1 and CM2?

admin:run sql update enduser set ocsprimaryuseraddress="sknth.n" where lastname="narayanan"
No UPDATE permission for enduser.ocsprimaryuseraddress.

admin:show version active
Active Master Version: 10.5.1.11008-1

[Sreekanth Narayanan]

As per the data dictionary, this field is not modifiable.

https://developer.cisco.com/media/UCM10.5DataDictionary/UCM10.5DataDictionary.htm#enduser

2.3.163.30 ocsprimaryuseraddress (FI-3701)
Type:	string [447] (Not Modifiable)
Default Value:	EMPTY
Remarks:	Corresponds to the msRTCSIP-primaryuseraddress field in Active Directory schema