Value for resourceid tag in cmn_users_write.xml is case sensitive
search cancel

Value for resourceid tag in cmn_users_write.xml is case sensitive


Article ID: 218883


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


We notice that the resourceid tag in cmn_users_write.xml is case sensitive. A sample XML is as below.

<NikuDataBus xmlns:xsi="" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_user.xsd">
 <Header action="write" externalSource="NIKU" objectType="user" version=""/>
  <User externalId="sample007" isLDAP="true" oldUserName="******" uiThemeDefaultPartitionCode=" " userLanguage="Norwegian" userLocale="no_NO" userName="sample007" userStatus="LOCK" userTimezone="Europe/Amsterdam" userType="INTERNAL" userUid="sample007">
   <PersonalInformation emailAddress="[email protected]" firstName="Sample" lastName="007"/>
   <Resource resourceId="SAMPLE007"/>                          

If the Resource ID of the User being manipulated through this XML is in lower case - sample007, and if the upper case letters are used in the XML, then the following error is thrown.

java.lang.Exception: Resource SAMPLE007 already associated with another user. Please use an unique resourceId


This is an expected behaviour of the cmn_users_write.xml template


Extract the exact Resource ID from the system (with all the case information) and use in cmn_users_write.xml.

Additional Information

Following point is of relevance with respect to the Resource IDs.

  • Resource IDs are not case sensitive when creating a new Resource. That is if "sample007" is stored against unique_name column of the srm_resources table, then a new resource cannot be created with ID "SAMPLE007".