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

Document ID : KB000004348
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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

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