Web Content Not Visible in Related Asset Window
How To articles are not official guidelines or officially supported documentation. They are community-contributed content and may not always reflect the latest updates to Liferay DXP. We welcome your feedback to improve How To articles!
While we make every effort to ensure this Knowledge Base is accurate, it may not always reflect the most recent updates or official guidelines.We appreciate your understanding and encourage you to reach out with any feedback or concerns.
legacy-article
learn-legacy-article-disclaimer-text
Issue
- The user is unable to tag web content to another web content as a related asset with a DB2 database.
-
Steps to reproduce:
1. Navigate to the web content section.
2. Select a basic web content item and create 2-3 additional web content items (e.g., Demo1, Demo2, and Demo3).
3. Now, click on the first web content that was created (Demo1), click on the related asset, and select the basic web content; no content is visible.
-
Expected Behavior: The selection window should display the available web content.
-
Observed Behavior: The selection window fails to display any web content articles, and the following errors are observed on the Liferay console:
ERROR [http-nio-8080-exec-8] [SqlExceptionHelper:142] DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.26.14
2025-04-22 18:02:44 2025-04-22 12:32:44.812 ERROR [http-nio-8080-exec-8] [IncludeTag:119] Current URL /group/guest/~/control_panel/manage/-/select/infoitem/_com_liferay_journal_web_portlet_JournalPortlet_selectAsset?refererGroupId=20117&_com_liferay_item_selector_web_portlet_ItemSelectorPortlet_0_json=%7B%22desiredItemSelectorReturnTypes%22%3A%22journalarticle%22%2C%22itemSubtype%22%3A%2230601%22%2C%22itemType%22%3A%22com.liferay.journal.model.JournalArticle%22%2C%22mimeTypes%22%3Anull%2C%22multiSelection%22%3Atrue%2C%22refererClassPK%22%3A%2234834%22%2C%22status%22%3A-1%7D&_com_liferay_item_selector_web_portlet_ItemSelectorPortlet_criteria=infoitem&_com_liferay_item_selector_web_portlet_ItemSelectorPortlet_itemSelectedEventName=_com_liferay_journal_web_portlet_JournalPortlet_selectAsset&p_p_auth=PrEFn81R&_null_bodyCssClass=cadmin+dialog-iframe-popup generates exception: com.liferay.portal.kernel.dao.orm.ORMException: javax.persistence.PersistenceException: org.hibernate.exception.DataException: could not extract ResultSet
2025-04-22 18:02:44 com.ibm.db2.jcc.am. SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.26.14
Environment
- Liferay DXP 2024.Q3.12
- DB2 11.5.4
- Java 21
Resolution
- The observed behavior is a known concern that has been addressed by LPD-54293 and LPD-55314
- If a hotfix is required for this issue, please create a support ticket requesting a hotfix by attaching the patch details.
-
Installing Fix Packs and Hotfixes on Liferay DXP will guide you to install this hotfix in the respective environment.
did-this-article-resolve-your-issue