Details
-
Bug
-
Status: Closed
-
Resolution: Fixed
-
6.2.10 EE GA1, 6.2.X EE
-
6.2.x
-
Committed
-
9
-
3
-
Oracle Database 11.2
-
Regression Bug
Description
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)
Attachments
Issue Links
- depends on
-
LPS-43941 Use index by default in Web Content search
- Closed
- is a dependency of
-
LPS-52228 As a web content administrator, I want to search web contents in scheduled status from WCD portlet.
- Closed
- relates
-
LPS-46701 Sorting web content in Web Content Display portlet does not work with Oracle DB
- Closed
-
LPS-55332 Web Content Display portlet cannot display content from the scope of a different page
- Closed
-
LPS-43952 Sorting and filtering of web content does not work with oracle db
- Closed
-
LPE-11753 Web Content Display configuration: User loses the web content List after changing the "Modified Date" column sort.
-
- Closed
-