VERIFIED SOLUTION i

Resolve 'ORA-00933: SQL command not properly ended' in Portrait Dialogue

Product Feature: Visual Dialogue

 

Issue

While testing an 'Export as txt' and 'FTP template' having SQL queries in it, Oracle is showing error ORA-00933: SQL command not properly ended
 
ORA_00933_error.png

Cause

This could be caused by domain query getting edited automatically while testing the template. In this case, a 'ORDER BY' clause gets appended at the bottom of the domain query in Dialogue Admin.

Following is a screenshot of the dialog server error log from the time of error.
 
Dialog server error log

Resolution

UPDATED: May 24, 2017
This has been identified as a defect and fixed in Portrait Dialogue v6.1 SP3 so upgrading to Portrait Dialogue v6.1 SP3 or a later release should help.