-
Type:
Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: 7.0.X, 7.1.X, Master
-
Fix Version/s: 7.0.0 DXP FP66, 7.0.X, 7.1.10 DXP FP5, 7.1.10.1 SP1, 7.1.2 CE GA3, 7.1.X, Master
-
Component/s: Dynamic Data Mapping
-
Branch Version/s:7.0.x
-
Backported to Branch:Committed
-
Story Points:0.25
-
Fix Priority:3
-
Git Pull Request:
Description
When accessing the web content templates, you get an error saying templates are unavailable and that the request has too many parameters when you have many structures and are using SQL Server.
Steps to reproduce
1. Set up SQL Server (I used a Windows 2012 Server VM preloaded with it and created a database)
2. Set up portal-ext.properties to connect to the SQL Server (I used these properties)
terms.of.use.required=false users.reminder.queries.enabled=false setup.wizard.enabled=false browser.launcher.url= passwords.default.policy.change.required=false jdbc.default.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver jdbc.default.url=jdbc:sqlserver://192.168.168.133;databaseName=lrdb_master_2 jdbc.default.username=sa jdbc.default.password=test hibernate.show_sql=true
3. Start up bundle and go to Control Panel > Server Administration > Scripts
4. Add and run the attached " Add Structures Script.txt ", it should succeed successfully after a minute or so and having added 2100 structures
5. Go to Site > Content > Web Content
6. Click on the Templates tab
Results of Testing
Actual Result: "Web Content is temporarily unavailable." is displayed and there is this error in the logs:
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
Expected Result: Templates are displayed without errors.
Errors/Logs
16:10:43,880 ERROR [http-nio-8080-exec-9][JDBCExceptionReporter:234] The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request. 16:10:43,882 ERROR [http-nio-8080-exec-9][PortletRequestDispatcherImpl:265] Unable to dispatch request: com.liferay.portal.kernel
- causes
-
LPS-86872 When clicking on Manage Templates for a Structure, the Portlet Title no longer specifies the current structure whose templates we are viewing
- Closed
-
LPS-87101 Templates are shared between data definitions that are copies of one another.
- Closed
- is duplicated by
-
LPS-86411 Only the web content templates sharing the same structure are shown upon creating a template.
- Closed