title

java.sql.SQLException: Illegal mix of collations for operation 'UNION'

NOTE: Be sure to take a backup of your database prior to making any changes. Always test the changes in a lower environment before making changes in production. Making manual changes to the database is not...

Identifying the license information for components used in Liferay DXP

legacy

Issue I need to know the license information for components used in Liferay DXP. My security scan tool is flagging Liferay components with license not found errors. Environment Liferay DXP Resolution Liferay can provide...

Is it possible to disable the /combo/ present when loading the sites?

legacy How To

Issue When loading the sites, we always notice a /combo/ component at the beginning. Is it possible to disable it? Environment All environments Resolution The combo requests will disappear if you use the property...

Database level changes in Quarterly Releases

legacy

Issue What are the database-level changes from DXP 2023 Q4.0 to DXP 2024 Q2.0? Are there any additions of new tables, fields, and modifications to the existing tables? Environment Liferay DXP [all versions]...

Unable to include JSP

legacy Troubleshooting

Issue The following errors are encountered when the user accesses the portal, which increases the log size. ERROR [https-jsse-nio-0.0.0.0-8443-exec-29][DynamicIncludeUtil:81] java.io.IOException: Unable to include...

CDN caching of images and JSON files

legacy

Issue Are the images and JSON files served from Liferay cached at CDN in Liferay Cloud? Environment Liferay Cloud- PaaS Resolution According to Google's documentation, images (including JPEG and PNG) are cached...

Outbound connections from Liferay DXP

legacy

Issue As a Liferay DXP administrator, I would like to know which outbound connections Liferay DXP can potentially establish in order to only let it connect a restricted set of IPs. Environment Quarterly Release:...

"Custom Field" data for Navigation Menu is not included, while fetching it from 'Navigation Menus Headless API'

legacy Troubleshooting

Issue When trying to fetch the details of the "Navigation Menus" via the 'getNavigationMenu' Headless API, the 'Custom Field' data is not included in it. Steps to reproduce: 1. Navigate to Control Panel >...

java.lang.Error: factory already defined when starting up 2024.Q2 with JDK 17

legacy Troubleshooting

Issue Start up an environment with Liferay DXP 2024.Q2 and JDK 17. The following error message appears: ERROR [io.undertow.servlet.request] (ServerService Thread Pool -- 78) UT015005: Error invoking method...

Logs rotation based on size in Liferay DXP 7.4

legacy How To

Issue Configuring log rotation for logs based on the size. Environment Liferay DXP 7.4 Resolution The logs can be rotated based on size by making a small adjustment in the portal-log4j.xml file. Extract...

How can I check the progress of an upgrade?

legacy How To

Issue Is there a way to check the progress of an upgrade while it is still happening? Environment Quarterly Release 2024.Q1 2023.Q4 2023.Q3 DXP 7.4 DXP 7.3 DXP 7.2 DXP 7.1 Resolution The simplest way to do this would be...

Missing default Store

legacy Troubleshooting

Issue When trying to perform an upgrade, the following error appears in logs: ERROR [main][DBUpgrader:70] Missing default Store Environment Quarterly Release: 2023.Q3, 2023.Q4, 2024.Q1, 2024.Q2 Liferay DXP 7.4...

JBoss and JDK 21 compatibility

legacy

Issue JBoss EAP 7.4 is not compatible with Java 21 based on this Red Hat JBoss Enterprise Application Platform (EAP) 7 Supported , therefore, the customer is looking for an appropriate path for the upgrade, either...

"SAX Security Manager could not be setup" Warns

legacy Troubleshooting

Issue We are finding many Warns "SAX Security Manager could not be setup" in the Liferay logs. How can we resolve these messages? Environment Liferay Quarterly Release 2024 Resolution The observed behavior is a...

Why doesn't the upgrade log show the core upgrade completed message?

legacy

Issue When tailing the upgrade log in a new terminal separate from where the upgrade was initiated, the following logs indicating the completion of an upgrade may not be printed: Completed Liferay core upgrade process in...

DB Upgrade to a Q2 release using JDK 21 results in an error

legacy Troubleshooting

Issue The following error is being encountered when trying to upgrade to a Q2 release running ./db_upgrade_client.sh and using JDK 21 JVM arguments: [-Dfile.encoding=UTF8, -Duser.country=US, -Duser.language=en,...

Integrity constraint violation: unique constraint or index violation: IX_

legacy Troubleshooting

Issue When trying to start a clean Liferay bundle with the Hypersonic database and no portal-ext.properties, the following exception is being encountered: 2024-07-22 18:47:13.741 ERROR...

Libraries missing in DXP 7.3 update 36

legacy Troubleshooting

Issue We have observed a couple of errors, while building our project for DXP 7.3 u36, since there are libraries missing. Especially the library com.liferay.petra.string which is missing for u36. Are those libraries...

Some redirects executed from a custom module are not performed in JBoss EAP/Wildfly

legacy Troubleshooting

Issue Given a custom module with a portlet component which includes the following code: ... @Override public void doView(RenderRequest renderRequest, RenderResponse renderResponse) throws IOException,...

'Pages' option is not visible under the 'Site Builder', after the upgrade

legacy Troubleshooting

Issue The 'Pages' option is not visible under the 'Site Builder' Steps to Reproduce: Start any DXP 7.4 Update 42 with any Database Navigate to Site Builder> Pages> Create a few pages. After following the above steps,...

Compatibility of Spring 6.x with Quarterly Releases

legacy

Issue According to article https://github.com/spring-projects/spring-framework/wiki/Spring-Framework-Versions , Spring 6.x will have JDK from 17-23. Since Liferay DXP 2024 Q2 supports JDK 21 as the recommended...

Are The Layout Parallel Render Portal Properties Deprecated in Liferay 7.3?

legacy How To

Issue Migrating from Liferay 7.2 to Liferay 7.4, you may notice that the layout parallel rendering properties have been deprecated. The following logging during the upgrade can be seen noting that the properties are...

How to Enable Cookies Banner for Specific Sites

legacy

Issue Is it possible to enable cookies for a specific site? Environment Liferay DXP 7.4 Resolution The ability to configure cookies on a per-site basis in Liferay requires defining a virtual host. If a site does...

I am getting "Someone may be trying to circumvent the permission checker" while accessing Password Policies

legacy Troubleshooting

Issue When I try to access Control Panel → Password Policies, I get "Password Policies is temporarily unavailable." I get the following error message: 2024-07-30 13:15:07.411 ERROR...

"Unable to persist buffered increment value" Error in Liferay Logs

legacy Troubleshooting

Issue I am seeing the following errors thrown regularly in my Liferay console logs. How can I resolve this? ERROR [BufferedIncrement-default-2][BufferedIncrementRunnable:54] Unable to persist buffered increment...

session.test.cookie.support portal property

legacy

Issue Can we disable session.test.cookie.support in the portal-ext.properties file as it enables the user authentication process when an iframe is used? Environment Liferay DXP Resolution This property is related...

Upgrading to a Quarterly Release fails due to Elasticsearch exceptions in the logs

legacy Troubleshooting

Issue When upgrading to a Quarterly Release, coming from an old DXP version, the upgrade fails because of some Elasticsearch errors that can be seen in the logs: ERROR [main][ROOT:47] bundle...

Two locations to set up Password Reset Notification Templates

legacy

Issue There are 2 places in where the 'Password Reset Notification' template is present. One is in the Sign-In widget (Configuration > Set-up) and the other is in Control Panel > Instance Settings > Email. The...

No minification of clay files impacting page load response times

legacy

Issue We see more number of Clay UI related network calls in the browser network tab in clean instance of Liferay and they are not getting cached also. It has JS and CSS files which are not minified into fewer combo...

There was an error when loading the "text" field

legacy Troubleshooting

Issue 'There was an error when loading the "text" field' is showing if user clicks on any portlet inside System Settings and Instance Settings. Environment 2024.Q1 2024.Q2 Resolution This behavior is only...

Which table saves Email User data into the database?

legacy

Issue Which database table stores the email user configuration data? Environment Liferay DXP 7.4 Resolution The PortalPreferenceValue table stores email configuration data (Instance settings->Email->Email...

sun.awt.Win32GraphicsEnvironment ClassCastException in the logs

legacy Troubleshooting

Issue We started to see the below exception in our logs: Exception in thread "AWT-EventQueue-0" java.lang.ClassCastException: sun.java2d.HeadlessGraphicsEnvironment cannot be cast to...

How to resolve "Attempting to upgrade table UserGroupGroupRole by adding a temporary column" DB2 database upgrade errors

legacy Troubleshooting

Issue When trying to upgrade Liferay DXP from a 7.4 U release to 2024.q1.3 using a DB2 11.5 database, we encountered the following errors relating to the UserGroupGroupRole table: INFO [ServerService Thread Pool --...

Unable to login without the sameSiteCookies="none"

legacy Troubleshooting

Issue Without the sameSiteCookies="none" setting up, some vital cookies (e.g., JSESSIONID) are not created at all, preventing portal access. Environment Liferay DXP Resolution This article:...

How to create schedulers in DXP 7.4 and above?

legacy Troubleshooting

Issue We've been using the below classes in our project to create schedulers: com.liferay.portal.kernel.scheduler.StorageType com.liferay.portal.kernel.scheduler.StorageTypeAware After upgrading to a...

Batch Error encountered during upgrade using SQL Server 2019

legacy Troubleshooting

Issue When upgrading from Liferay 7.2 to Liferay 7.4, the following error may be encountered during the upgrade process when using SQL Server 2019 with MSSQL JDBC Jar Version 12.X ERROR [main][DBUpgrader:79] null...

How to disable error messages?

legacy How To

Issue How to disable 'Your Request failed to complete' error messages? Environment Liferay DXP 7.4 Resolution Please note: The following information involves customizations or implementation ideas that are beyond...

Table already exists upgrade error

legacy Troubleshooting

Issue An upgrade is failing with a java.sql.SQLSyntaxErrorException: Table [table name] already exists error Environment Quarterly Releases DXP 7.4 DXP 7.3 DXP 7.2 Resolution NOTE: Be sure to take a backup of...

Is there a recommended Quarterly Release version to upgrade to?

legacy

Issue We want to update our project to a Quarterly Release version. Is there a recommended version? For stability, which Quarterly Release version is currently recommended? Environment Liferay DXP Quarterly Releases...

Database connection issue: Failed to validate connection

legacy Troubleshooting

Issue We are getting some slowness when browsing through DXP and following message is showed in log: HikariPool-1 - WARN … Failed to validate connection … Possibly consider using a shorter maxLifetime value....

Issue in Workflow node ASSIGNMENTS option

legacy Troubleshooting

Issue We have a portal with multiple custom roles based on business rules and when trying to select roles in the Workflow node ASSIGNMENTS option the portal crashes. The problem lies in the endpoint that lists...

java.lang.StringIndexOutOfBoundsException: begin 0, end -1, length 1

legacy Troubleshooting

Issue While upgrading to Liferay DXP 7.4, following errors were observed in the logs: ERROR [http-nio-8080-exec-21][OpenIdConnectSessionValidationFilter:53] java.lang.StringIndexOutOfBoundsException: begin 0, end...

View only permission for custom Field does not include frontend restrictions

legacy Troubleshooting

Issue Facing issues while using 'View' only permissions for 'Custom Field', able to see and even edit the details even after View only permission. Steps to reproduce: 1. Navigate to Control Panel > Roles, and create...

Feature flag LPS-170809/163118/166126 is not available for company 0

legacy Troubleshooting

Issue After trying to upgrade to DXP 2023.Q4.4, the database upgrade script is failing with the following errors in the logs: Feature flag LPS-170809 is not available for company 0 Feature flag LPS-163118 is not...

Why are Tomcat's URLRewriteFilter files missing from 7.4?

legacy

Liferay Support does not recommend or endorse specific third-party products over others. The information provided about products not created by Liferay is for reference purposes only, and any implementation of these principles...

Unsatisfied Reference - Unresolved Declarative Service

legacy Troubleshooting

Issue When upgrading to the Liferay DXP 7.4, navigate to the Control Panel > System > Gogo Shell and execute the ds:unsatisfied command, then getting the Unsatisfied Reference - Unresolved Declarative Service and...

ConfigurationBeanDeclaration related errors

legacy How To

Issue While upgrading from 7.3 to 2024.Q1, we receive errors regarding ConfigurationBeanDeclaration. Environment The information in this article is relevant if you have any implementations with...

Info about new parameters for SamlSpIdpConnectionLocalService.addSaml and updateSaml

legacy

Issue We are upgrading our code from 7.3 to 2024Q1.7, we found a new parameter for the two following methods: 1. _samlSpIdpConnectionLocalService.addSamlSpIdpConnection() 2....

Failed upgrade process com.liferay.dynamic.data.mapping.internal.upgrade.v4_0_0.DDMStructureUpgradeProcess

legacy Troubleshooting

Issue You might encounter an issue when upgrading from 7.2 to 7.4 where the upgrade step for module com.liferay.dynamic.data.mapping.service fails due to a NoSuchGroupException: 2024-05-22 13:18:39.512 INFO...

Audit portlet only available for Administrators

legacy How To

Issue After upgrading to U78+ you might encounter a behavior where the Audit portlet is only available for Administrators, whereas before U78 you could create a regular role with access to it The reason behind this...

Idle Database connections in Liferay

legacy

Issue Why number of idle connections are increasing more than my connection pool size? Does Liferay clears idle connections? If not then how to clear these idle connections from Liferay? What is the...

Need to get values from System Configuration

legacy Troubleshooting

NOTE: The following resolution requires customization and should only be implemented at the discretion of your team. Liferay Support will not be able to assist with designing or implementing customizations. Issue...

Recommended locale settings for the database

legacy

Please be aware that the page you are viewing has been machine translated from Japanese into English and may contain some translation errors. If you observe any issues with the translation, please contact us. Issue...

'Your request failed to complete' while saving the values of Mail settings under Instance settings

legacy Troubleshooting

Issue Issue while saving the values entered for mail settings under instance settings wherein the values do not get saved and the error says: 'Your request failed to complete'.Steps to reproduce: 1. Start the...

Minimum required IAM policies for S3

legacy

Please be aware that the page you are viewing has been machine translated from Japanese into English and may contain some translation errors. If you observe any issues with the translation, please contact us. Issue...

Liferay Marketplace cannot be accessed via Control Panel

legacy Troubleshooting

Issue When accessing Liferay Marketplace via Control Panel, the page does not load anything. Environment Liferay DXP 7.3. Resolution Check that your environment can access the URL https://web.liferay.com/marketplace,...

TemplateException: Unsupported template manager ftl

legacy Troubleshooting

Issue Our environment is not stable, pages don't load properly and we are not even able to log-in. In the log file, these errors are shown: 2024-04-30 16:52:27.467 ERROR...

Custom 'renderUrl' is not working for Liferay DXP 2023.Q4.4

legacy Troubleshooting

Issue Start the server. Navigate to Product Menu > Site Builder > Pages, and create two pages with the names 'Add Blog' and 'Blog Page' with URLs 'add-blog' and 'blog-page'. (Could also be configure the Page name and...

Migrate delta data after the Upgrade Process

legacy

Issue Our website is running and in parallel, we are performing the upgrade process with the cloned database schema. Now, we want to migrate delta data (the changed/updated data) for out-of-the-box Liferay...

API to update custom field settings

legacy How To

Please be aware that the page you are viewing has been machine translated from Japanese into English and may contain some translation errors. If you observe any issues with the translation, please contact us. Issue...

Development and Tooling