AnsweredAssumed Answered

Create Projects via GEL Script - Custom MVL Field Fails?

Question asked by TEAConsulting on Aug 3, 2017
Latest reply on Oct 7, 2018 by AlistairMiller

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?

Outcomes