Clarity

Expand all | Collapse all

Create Projects via GEL Script - Custom MVL Field Fails?

  • 1.  Create Projects via GEL Script - Custom MVL Field Fails?

    Posted 08-03-2017 06:35 PM

    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?



  • 2.  Re: Create Projects via GEL Script - Custom MVL Field Fails?

    Broadcom Employee
    Posted 08-03-2017 08:22 PM

    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



  • 3.  Re: Create Projects via GEL Script - Custom MVL Field Fails?

    Posted 08-03-2017 08:29 PM

    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.



  • 4.  Re: Create Projects via GEL Script - Custom MVL Field Fails?

    Broadcom Employee
    Posted 08-03-2017 08:33 PM

    what is clarity version?

     

    Thanks

    Senthil



  • 5.  Re: Create Projects via GEL Script - Custom MVL Field Fails?

    Broadcom Employee
    Posted 08-03-2017 08:43 PM

    Please try other lower environment also.

     

    Thanks

    Senthil



  • 6.  Re: Create Projects via GEL Script - Custom MVL Field Fails?

    Posted 08-03-2017 08:47 PM

    Clarity version is 15.2.0.0213, ondemand.

     

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



  • 7.  Re: Create Projects via GEL Script - Custom MVL Field Fails?

    Posted 10-01-2018 06:46 AM

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



  • 8.  Re: Create Projects via GEL Script - Custom MVL Field Fails?

    Posted 10-07-2018 04:55 PM

    No, we decided to proceed without that field.



  • 9.  RE: Create Projects via GEL Script - Custom MVL Field Fails?

    Posted 12-07-2020 03:42 PM
    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