Shopping Portlet: Adding more than 666 items in shopping cart causes portlet to break

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.1.20 EE GA2
• Fix Version/s: 6.1.X EE, 6.2.2 CE GA3 , 6.2.X EE, 7.0.0 M1
• Component/s: Business Productivity, Util, Util > Shopping
• Labels:
  • QA-TP
  • ee-ts
  • liferay-fixpack-platform-13-6210
• Branch Version/s:
  6.2.x, 6.1.x
• Backported to Branch:
  Committed
• Story Points: 5
• Git Pull Request: https://github.com/hhuijser/liferay-portal/pull/1693

Description

When one adds more than 666 items in the shopping cart via the shopping portlet, the portlet breaks indicating that the "portlet is temporarily unavailable." A stacktrace is then rendered indicating that too much data is being written in the column of the DB.

The issue only occurs with Oracle.

Steps to Reproduce

1. Launch clean Liferay 6.1 GA2 EE bundle.
2. Add shopping portlet to the page.
3. Steps to Reproduce:
4. Create an item.
5. Order a quantity of 666 items of the one you created and notice this succeeds.
6. Order a quantity of 667 items and notice the issue that occurs