Posted by Alessandro Vernet on
URL: https://discuss.orbeon.com/Column-username-not-found-error-when-searching-or-showing-form-summary-tp4657308p4657315.html

It should just work out-of-the-box. Could you try editing the log4j.xml to set the SQLProcessor in debug mode:

    <category name="org.orbeon.oxf.processor.sql.SQLProcessor">
        <priority value="debug"/>
    </category>

Then restart Tomcat, access the summary page again, and the faulty SQL should show in the orbeon.log. Could you copy-paste it here?

Alex