Error with Import XML File to Create New Request 9.14.0004 (550 Views)
Reply
Advisor
Frankie_Kings
Posts: 26
Registered: ‎04-08-2010
Message 1 of 4 (550 Views)
Accepted Solution

Error with Import XML File to Create New Request 9.14.0004

Hello Team, this is Frank.

We upgraded to PPM 9.14.004 last month.  I see that that the Import Request from XML process is now a core system menu dropdown option. 

Previously to this release, we have been using the 'ITGXMLGenerator.9.1.xla' to create the XML file from an Excel template with the data to create a request.

With 9.14.004, I use the Generator to create the xml file (normal/no problems).

I then select the new dropdown option in PPM to import the xml file.

The resulting message indicates "Import completed successfully" but when I view the log it shows a  java.lang.NullPointerException

There is also no indication that a new request number has been created (as the previous process indicated).

Can you help determine what the exception may be or can I no longer use the Generator to create the XML file?

Are there now additional changes to the import process that we must do or create?

Thanks for any assistance you can provide or let me know if you need more information.  

 

 

 

Trusted Contributor
jsalass
Posts: 113
Registered: ‎03-12-2012
Message 2 of 4 (546 Views)

Re: Error with Import XML File to Create New Request 9.14.0004

Hi Frankie,

 

I have seen that the  import doesn’t happen if there are any required fields enabled in the initial request page even though they are populated. Would you mind trying disabling those fields

 

Also the xml structure have to be like this


<?xml version="1.0" encoding="utf-8"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified"
xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="requests">
<xs:complexType>
<xs:sequence>
<xs:element minOccurs="0" maxOccurs="unbounded" name="request">
<xs:complexType>
Enhancements, Integrations, Certifications, and Fixes in PPM Center 9.12 283
<xs:sequence>
<xs:element minOccurs="1" maxOccurs="1" name="requestType"
type="xs:string"/>
<xs:element minOccurs="0" maxOccurs="unbounded" name="field">
<xs:complexType>
<xs:sequence>
<xs:element minOccurs="0" name="token" type="xs:string"/>
<xs:element minOccurs="0" name="tableValue">
<xs:complexType>
<xs:sequence>
<xs:element minOccurs="0" maxOccurs="unbounded"
name="tableColumn">
<xs:complexType>
<xs:sequence>
<xs:element minOccurs="0" name="columnToken"
type="xs:string"/>
<xs:element minOccurs="0" maxOccurs="unbounded"
name="cellValue" type="xs:string"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element minOccurs="0" name="value" type="xs:string"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
<xs:attribute name="date_format" type="xs:string" use="optional"/>
</xs:complexType>
</xs:element>
</xs:schema>

 

and then be sure you have the demand managemen import request access grant.

 

Hope this helps!

Advisor
Frankie_Kings
Posts: 26
Registered: ‎04-08-2010
Message 3 of 4 (534 Views)

Re: Error with Import XML File to Create New Request 9.14.0004

Hi, I removed all required fields from the initial request page but still got the same 'java' error when I tried the import.

Here is what my XML file looks like

 

  <?xml version="1.0" encoding="UTF-16" ?>
- <request>
  <requestType>HEB - Enhancement/Bug/Initiative Request</requestType>
  <identifier>101056</identifier>
- <common:simpleField>
  <common:token>REQ.DESCRIPTION</common:token>
  <common:stringValue>THIS IS A TEST EXAMPLE</common:stringValue>
  </common:simpleField>
- <common:simpleField>
  <common:token>REQ.P.REQUESTOR_NAME</common:token>
  <common:stringValue>Trainer User</common:stringValue>
  </common:simpleField>
  </request>
  </di:itg_dataImport>
 
Do you see any immediate differences with our file that could still be causing the error?   I see that there are some differences between the one you use and ours so if there is way to describe an overview on how I would go about editing this file so I can try to match to your format that would be appreciated.  I could try that next.  Thanks much!  
 
Advisor
Frankie_Kings
Posts: 26
Registered: ‎04-08-2010
Message 4 of 4 (443 Views)

Re: Error with Import XML File to Create New Request 9.14.0004

Hello, after much review we have determined that we had a Request Type Rule that was conflicting  with a field that was being populated when the xml importer executed to create the request.  We turned off the rule and was able to run the XML Importer successfully.  Thanks for everyone's help.

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.