Create Projects via GEL Script - Custom MVL Field Fails?

[Alistair Miller]

Trying to Create Projects via GEL Script with a custom multi-value lookup field (the field is custom, the lookup is the OOTB Department Browse). I'm getting an error, and I wonder if I'm hitting a known bug (although a google search didn't throw up anything).

 

Creating projects manually via the GUI is happy.

Creating projects via GEL without the custom field is happy.

Creating projects via GEL with the custom field throws an error:

java.lang.NullPointerException at com.niku.odf.object.xbl.XOGCustomObjectInstanceHandler.populateColumnValuesToObjectInstance(XOGCustomObjectInstanceHandler.java:1309) at com.niku.odf.object.xbl.XOGCustomObjectInstanceHandler.getObjectInstance(XOGCustomObjectInstanceHandler.java:1106) at com.niku.odf.object.xbl.XOGCustomObjectInstanceHandler.importCustomObjectInstance(XOGCustomObjectInstanceHandler.java:741) at com.niku.odf.object.xbl.XOGCustomAttributesWriteHandler.postProcess(XOGCustomAttributesWriteHandler.java:168) at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1419) at com.niku.union.xml.dom.DOMWalker.postProcess(DOMWalker.java:210), etc. etc.

I get the same error when I try and XOG in via the (most excellent) XOG and Query Bridge from IT ROI Solutions.

 

When I manually create a project and XOG it out, the XML looks identical to what I'm trying to XOG in, in my script.

 

Here's what my XOG Write looks like when output before I try and execute:

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd">
      <Header action="write" externalSource="NIKU" objectType="project" version="15.2.0.213"/>
      <Projects>
        <Project ... >
        <snip/>
          <CustomInformation>
            <ColumnValue name="fon_impacted_bus">
              <Value>F2-AME</Value>
            </ColumnValue>
        </Project>
      </Projects>
    </NikuDataBus>

Here's what a XOG out from a manually-created project looks like:

<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd">
      <Header action="write" externalSource="NIKU" objectType="project" version="15.2.0.213"/>
      <Projects>
        <Project ...>
          <snip/>
          <CustomInformation>
            <ColumnValue name="fon_impacted_bus">
              <Value>F2-CORP</Value>
            </ColumnValue>
        </Project>
      </Projects>
    </NikuDataBus>

I've confirmed that both values are valid Department IDs.

 

Does anyone have any pointers which might help save my sanity?

[Senthil Kumar Lakshmanan]

Hi.

 

Better to xog-out existing project with multi value lookups and xog-in back to system and check whether you are getting same issue. if not, then build same way in your gel script to load the project.

 

Thanks

Senthil

[Alistair Miller]

Hi Senthil.

 

I should have said that ... yes, I am hitting the same error when I xog out an existing project and then xog it back in.

[Senthil Kumar Lakshmanan]

what is clarity version?

 

Thanks

Senthil

[Senthil Kumar Lakshmanan]

Please try other lower environment also.

 

Thanks

Senthil

[Alistair Miller]

Clarity version is 15.2.0.0213, ondemand.

 

I'll try a different environment and see how I go.

[Velayutham Palaniappan]

Were you able to find out a solution for this? Facing a similar issue for one of the MVL attribute in Project Object.

[Legacy User]

No, we decided to proceed without that field.

[Sharukh Shaik]

Hello !!

Found any solution for this? I see some of MVL attributes are getting copied well while project creation, whereas one MVL attribute is throwing error. It says "Project Object Insert/Update Failed"

Same error when I did xog-out and xog-in back existing project

Thanks
Sharukh