Resolving ORA-01450

Issue

• When starting a Liferay instance connected to an Oracle Database, the following error is encountered and Liferay does not start :
  
  

  Caused by: com.liferay.portal.kernel.log.LogSanitizerException: Error : 1450, Positi
  
  on : 28, Sql = create index IX_8DE7A0B5 on CPAttachmentFileEntry (classNameId, class
  
  PK, cdnURL, ctCollectionId), OriginalSql = create index IX_8DE7A0B5 on CPAttachmentF
  
  ileEntry (classNameId, classPK, cdnURL, ctCollectionId), Error Msg = ORA-01450: maxi
  
  mum key length (3117) exceeded_ [Sanitized]
  
  

• Caused by: com.liferay.portal.kernel.log.LogSanitizerException: (...) Error Msg = ORA-01450: maxi
  
  mum key length (3117) exceeded_ [Sanitized]

Environment

• DXP 7.4

Resolution

• Set the following value in your portal-ext.properties file: 
  

  database.string.index.max.length[oracle]=1000 

Additional Information

• https://blogs.oracle.com/sql/post/how-to-fix-ora-01450-maximum-key-length-6398-exceeded-errors 

NOTE: 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 will be at your team's discretion.