AnsweredAssumed Answered

15.2 Upgrade Issue: PPM_INVALID_USER.xml

Question asked by Lowell on Dec 16, 2017
Latest reply on Dec 18, 2017 by Suman Pramanik

When attempting an upgrade in an On Premise, Oracle 12 environment, I run into an error: PPM_INVALID_USER.xml file fails to execute.

 

When I attempt to run the XOG manually, I get an error message that you cannot create a duplicate resource.

 

The issue I see with the XOG is that the bad code has a " " space in the "externalId".  Has anyone else run into this issue?

 

Bad Code (Externalid is a space “ “)

<?xml version="1.0" encoding="UTF-8"?>

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_user.xsd">

<Header action="write" externalSource="NIKU" objectType="user" version="7.0"/>

<Users>

<User externalId=" " userLanguage="English" userName="ppm_invalid_user" userStatus="LOCK" userType="INTERNAL">

<PersonalInformation emailAddress="ppm_invalid_user@mailserver.com" firstName="PPM" lastName="Invalid_User"/>

<Resource resourceId="ppm_invalid_user"/>

<Company/>

<Groups/>

<GlobalRights/>

<InstanceRights/>

<InstanceOBSRights/>

</User>

</Users>

</NikuDataBus>

 

Workaround (Creates optional resource to avoid issue)

<?xml version="1.0" encoding="UTF-8"?>

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_user.xsd">

<Header action="write" externalSource="NIKU" objectType="user" version="7.0"/>

<Users>

<User externalId="ppm_invalid_user1" userLanguage="English" userName="ppm_invalid_user1" userStatus="LOCK" userType="INTERNAL">

<PersonalInformation emailAddress="ppm_invalid_user@mailserver1.com" firstName="PPM1" lastName="Invalid_User1"/>

<Resource resourceId="ppm_invalid_user1"/>

<Company/>

<Groups/>

<GlobalRights/>

<InstanceRights/>

<InstanceOBSRights/>

</User>

</Users>

</NikuDataBus>

Outcomes