-
Type:
Bug
-
Status: Closed
-
Resolution: Fixed
-
Affects Version/s: 6.1.X EE, 6.2.X EE, 7.0.0 M3
-
Fix Version/s: 6.1.X EE, 6.2.2 CE GA3 , 6.2.4 CE GA5, 6.2.X EE, 7.0.0 M1
-
Component/s: Portal Configuration
-
Branch Version/s:6.2.x, 6.1.x
-
Backported to Branch:Committed
-
Story Points:14
-
Databases:Oracle Database 10.1, Oracle Database 10.2, Oracle Database 11.1, Oracle Database 11.2, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012
-
Git Pull Request:
1. Start the portal on Oracle database
2. Add a Basic web content, fill in the Title and Content fields
3. Click on the Abstract tab and add text to the Summary field that is longer than 4000 characters (you can copy the example from the attached file)
4. Try saving the article, you won't be able as warned by the client side validator logic, due to the too long value
5. Delete characters from the entered text so that it's a little bit shorter than 4000 characters, and try saving again
Result: You will get an error message and an exception in the log with ORA-01461 error.
The cause of the issue is that the Summary field is localized which means we can set different translations for it. This is done by putting it into an XML context that holds the localization information before storing it. Because of this additional text being added to the value at the server side, it will exceed the VARCHAR2(4000) limit that is the type of the database column, and will be automatically converted to LONG by JDBC, but the database will not be able to handle this "cast" and throw the error.
- causes
-
LPS-46022 Calendar portlet's CalendarBooking description is not upgraded to TEXT data type
- Closed
-
LPS-47261 Unable to get assetEntries using Oracle
- Closed
- relates
-
LPS-45646 Data migration from hsql to SQL server fails
- Closed
-
LPS-54312 In Oracle DB, localized VARCHAR2 fields can exceed their maximum length
- Closed
-
LPE-11382 Localized VARCHAR2 fields can exceed their maximum length
-
- Closed
-
-
LPE-12020 Localized VARCHAR2 fields can exceed their maximum length - development component
-
- Closed
-
-
LPE-13639 Error migrating from Postgres to Oracle when content of the "summary" field in web content is greater than 4000 characters
-
- Closed
-
-
LPS-40069 Error when adding too many translations to a Web Content using Oracle: Column "title" has type VARCHAR2(4000), but it should be CLOB as for "content"
- Verified
-
LPS-54793 Find an alternative to storing localised fields as an XML in a DB column
-
- Closed
-