Web Content Display configuration: User loses the web content List after changing the "Modified Date" column sort.

• Type: Regression Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.2.10 EE GA1, 6.2.X EE
• Fix Version/s: 6.2.3 CE GA4, 6.2.X EE
• Component/s: Content Display Widgets > Web Content Display widget, ~[Archived] WCM > Publication
• Labels:
  • 6.2.x-only
  • liferay-fixpack-portal-45-6210
• Branch Version/s:
  6.2.x
• Backported to Branch:
  Committed
• Story Points: 9
• Fix Priority: 3
• Databases:
  Oracle Database 11.2
• Git Pull Request: https://github.com/hhuijser/liferay-portal-ee/pull/1462

Steps to reproduce this issue:

1 . - Put a Web Content Display on a page
2 . - Click the "Select Web Content"
3 . - The results are showed correctly
4 . - Click on the "Modified Date" date column to invert the sort.
5 . - The list disappears(blank page)
6 . - You return to the Web Contet Page an press "Select Web Content"
7 . - The list disappears(blank page) ever for this user and for all the browsers.

Note: We try to delete the cache/cookies browser and the problem persists.

You can see in logs:

14:46:07,190 ERROR [ajp-apr-8015-exec-98][JDBCExceptionReporter:82] ORA-00918: column ambiguously defined_ [Sanitized]
14:46:07,201 ERROR [ajp-apr-8015-exec-98][IncludeTag:129] Current URL /informacio?p_p_id=86&p_p_lifecycle=0&p_p_state=pop_up&p_p_col_id=column-1&p_p_col_pos=1&p_p_col_count=2&_86_struts_action=%2Fportlet_configuration%2Fedit_configuration&_86_redirect=%2Finformacio&_86_returnToFullPageURL=%2Finformacio&_86_portletResource=56_INSTANCE_kZ2biZtGdNDr&_86_resourcePrimKey=148834_LAYOUT_56_INSTANCE_kZ2biZtGdNDr&_86_%20&yui_patched_v3_11_0_1_1394804927190_656=1394804941258 generates exception: com.liferay.portal.kernel.exception.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query
java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined_ [Sanitized]
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:886)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1175)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1296)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3657)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1495)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
        at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
        at org.hibernate.loader.Loader.doQuery(Loader.java:802)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
        at org.hibernate.loader.Loader.doList(Loader.java:2542)