-
Type:
Bug
-
Status: Resolved
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 5.5
-
Fix Version/s: 5.5.0-HF11, 5.6-RC2, 5.6
-
Component/s: CMF (deprecated), Directory
-
Environment:Oracle
-
Tags:
-
Backlog priority:200
The directory table name "casemanagement_mailbox_sync_state" is 33 characters, that is too long for some databases.
In Oracle for instance, the limit is 30 characters - the table creation won't work.
General error:
org.nuxeo.ecm.directory.DirectoryException: Table 'Table(casemanagement_mailbox_sync_state)' creation failed: ORA-00972: identifier is too long
at org.nuxeo.ecm.directory.sql.SQLHelper.createTable(SQLHelper.java:176)
at org.nuxeo.ecm.directory.sql.SQLHelper.setupTable(SQLHelper.java:118)
at org.nuxeo.ecm.directory.sql.SQLDirectory.<init>(SQLDirectory.java:156)
at org.nuxeo.ecm.directory.sql.SQLDirectoryProxy.getDirectory(SQLDirectoryProxy.java:49)
at org.nuxeo.ecm.directory.sql.SQLDirectoryProxy.getSession(SQLDirectoryProxy.java:86)
at org.nuxeo.ecm.directory.DirectoryServiceImpl.open(DirectoryServiceImpl.java:272)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long
...
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:301)
at org.nuxeo.ecm.directory.sql.SQLHelper.createTable(SQLHelper.java:168)
... 29 more
- depends on
-
-
- Resolved
-
