legacy-knowledge-base
公開されました Sep. 10, 2025

すべてのロケールを追加すると、最大文字数を超えてしまう

written-by

Sivakumar Perumal

How To articles are not official guidelines or officially supported documentation. They are community-contributed content and may not always reflect the latest updates to Liferay DXP. We welcome your feedback to improve How To articles!

While we make every effort to ensure this Knowledge Base is accurate, it may not always reflect the most recent updates or official guidelines.We appreciate your understanding and encourage you to reach out with any feedback or concerns.

legacy-article

learn-legacy-article-disclaimer-text

問題

  • このプロパティでLiferay DXP 7.4を起動した場合、以下のエラーが発生します。
    locales.enabled=ar_SA,eu_ES,bg_BG,ca_AD,ca_ES,zh_CN,zh_TW,hr_HR,cs_CZ,da_DK,nl_NL,nl_BE,en_US,en_GB,en_AU,et_EE,fi_FI,fr_FR,fr_CA,gl_ES,de_DE,el_GR,iw_IL,hi_IN,hu_HU,in_ID,it_IT,ja_JP,kk_KZ,ko_KR,lo_LA,lt_LT,nb_NO,fa_IR,pl_PL,pt_BR,pt_PT,ro_RO,ru_RU,sr_RS,sr_RS_latin,sl_SI,sk_SK,es_ES,sv_SE,ta_IN,th_TH,tr_TR,uk_UA,vi_VN
    2022-04-27 07:35:53.879 ERROR [main][JDBCExceptionReporter:234] ORA-12899: value too large for column "LR_OWNER"."ROLE_"."DESCRIPTION" (actual: 9680, maximum: 4000)_ [Sanitized]
    2022-04-27 07:35:53.881 WARN [main][PortalInstanceLifecycleListenerManagerImpl:162] Unable to register portal instance {"mvccVersion": 2, "companyId": 20101, "userId": 0, "userName": "", "createDate": "Wed Apr 27 06:53:37 GMT 2022", "modifiedDate": "Wed Apr 27 07:21:59 GMT 2022", "webId": "liferay.com", "mx": "liferay.com", "homeURL": "", "logoId": 0, "system": false, "maxUsers": 0, "active": true, "name": "Liferay DXP", "legalName": "Liferay DXP, Inc.", "legalId": "", "legalType": "", "sicCode": "", "tickerSymbol": "", "industry": "", "type": "", "size": ""}
    com.liferay.portal.kernel.log.LogSanitizerException: org.springframework.dao.QueryTimeoutException: could not update: [com.liferay.portal.model.impl.RoleImpl#43509]; SQL [update Role_ set mvccVersion=?, modifiedDate=?, description=? where roleId=? and mvccVersion=?]; nested exception is org.hibernate.QueryTimeoutException: could not update: [com.liferay.portal.model.impl.RoleImpl#43509]
    at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:647) ~[spring-orm.jar:4.3.22.RELEASE]
    ... 74 more
    Caused by: com.liferay.portal.kernel.log.LogSanitizerException: Error : 12899, Position : 71, Sql = UPDATE Role_ SET mvccVersion = :1 , modifiedDate = :2 , description = :3 WHERE roleId = :4 AND mvccVersion = :5 AND Role_.ctCollectionId = 0, OriginalSql = UPDATE Role_ SET mvccVersion = ?, modifiedDate = ?, description = ? WHERE roleId = ? AND mvccVersion = ? AND Role_.ctCollectionId = 0, Error Msg = ORA-12899: value too large for column "LR_OWNER"."ROLE_"."DESCRIPTION" (actual: 9680, maximum: 4000)_ [Sanitized]
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:910) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3865) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3845) ~[ojdbc8.jar:12.2.0.1.0]
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1061) ~[ojdbc8.jar:12.2.0.1.0]
    at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61) ~[hikaricp.jar:?]
    at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java) ~[hikaricp.jar:?]
    at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2595) ~[hibernate-core.jar:3.6.10.Final]
    at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2495) ~[hibernate-core.jar:3.6.10.Final]
    at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2822) ~[hibernate-core.jar:3.6.10.Final]
    at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:113) ~[hibernate-core.jar:3.6.10.Final]
    at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273) ~[hibernate-core.jar:3.6.10.Final]
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265) ~[hibernate-core.jar:3.6.10.Final]
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:185) ~[hibernate-core.jar:3.6.10.Final]
    at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) ~[hibernate-core.jar:3.6.10.Final]
    at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) ~[hibernate-core.jar:3.6.10.Final]
    at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) ~[hibernate-core.jar:3.6.10.Final]
    at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383) ~[hibernate-core.jar:3.6.10.Final]
    at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133) ~[hibernate-core.jar:3.6.10.Final]
    at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:663) ~[spring-orm.jar:4.3.22.RELEASE]
    ... 74 more

Environment

  • Liferay DXP 7.4

解決策

  • 観測された動作は、既知の問題 LPS-152963 であり、DXP 7.4 の次期アップデートで修正される予定です。 Hotfixが必要な場合は、チケットをお出しください。

追加情報

did-this-article-resolve-your-issue

legacy-knowledge-base