A dynamic lookup XOG in action fails after the xml file has been edited by an xml formatter

Products

• Clarity PPM On Premise

Issue/Introduction

A dynamic lookup XOG in action fails after the xml file has been edited by an xml formatter

Steps to Reproduce:

1. Create a dynamic query lookup
2. Query can be as simple as: select * from prtask where prprojectid= 5007881
3. XOG out the dynamic query lookup
4. XOG it back in and it is successful.
5. Get the XOGed out file
6. Edit it with notepad ++
7. If you have not got an xml formatter pluggin, install it: XML tools
8. Once edited, go to Pluggins > XML Tools > Pretty Print with lines
9. Reformats the file 
10. Use this file to XOG in

Expected Result: The XOG in action is successful

Actual Result: The XOG in action fails with NSQL Syntax exception: NSQL_SYNTAX_ERROR_TEXT_EMPTY

Environment

Release: ESPCLA99000-14.3-Clarity-Extended Support Plus
Component:

Cause

This is caused by CLRT-81062

Resolution

After a careful review of the defect Sustaining Engineering has decided that no changes will be done on the affected area and therefore the defect has been closed as Will Not Fix

Workaround:
The query section has changed from:

<nsql databaseId="Niku" dbVendor="all">
<![CDATA[SELECT

to:
<nsql databaseId="Niku" dbVendor="all"><![CDATA[SELECT

Edit the file manually and make sure it is on the same line