You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@syncope.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2025/09/23 12:24:00 UTC
[jira] [Commented] (SYNCOPE-1915) Failure when running the Persistence Storage Upgrader against Oracle DBMS
[ https://issues.apache.org/jira/browse/SYNCOPE-1915?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18022152#comment-18022152 ]
ASF subversion and git services commented on SYNCOPE-1915:
----------------------------------------------------------
Commit 23ea47c9f4f917155b401ee16f0ef4edf3d8f427 in syncope's branch refs/heads/master from Francesco Chicchiriccò
[ https://gitbox.apache.org/repos/asf?p=syncope.git;h=23ea47c9f4 ]
[SYNCOPE-1915] Persistence Storage Upgrader: separate JPA schema definition per DBMS
> Failure when running the Persistence Storage Upgrader against Oracle DBMS
> -------------------------------------------------------------------------
>
> Key: SYNCOPE-1915
> URL: https://issues.apache.org/jira/browse/SYNCOPE-1915
> Project: Syncope
> Issue Type: Bug
> Components: core
> Affects Versions: 4.0.1
> Environment: Oracle DBMS
> Reporter: Francesco Chicchiriccò
> Assignee: Francesco Chicchiriccò
> Priority: Major
> Labels: jpa, oracle
> Fix For: 4.0.2, 4.1.0
>
>
> When [running the tool|https://syncope.apache.org/docs/4.0/reference-guide.html#persistence-storage-upgrade] against an Oracle DBMS instance, the following error is raised:
> {code:java}
> org.apache.openjpa.util.UserException: Index name "I_CSSPTPP_TICKETEXPIRATIONPOLICY" is 32-character long. The database allows maximum 30-character for an index name.
> at org.apache.openjpa.jdbc.sql.DBDictionary.checkNameLength(DBDictionary.java:5741) ~[openjpa-4.1.1.jar!/:4.1.1]
> at org.apache.openjpa.jdbc.sql.DBDictionary.getCreateIndexSQL(DBDictionary.java:3868) ~[openjpa-4.1.1.jar!/:4.1.1]
> at org.apache.openjpa.jdbc.schema.SchemaTool.createIndex(SchemaTool.java:1176) ~[openjpa-4.1.1.jar!/:4.1.1]
> at org.apache.syncope.core.persistence.jpa.upgrade.WiserSchemaTool.buildSchema(WiserSchemaTool.java:183) ~[!/:4.0.2-SNAPSHOT]
> at org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:565) ~[openjpa-4.1.1.jar!/:4.1.1]
> at org.apache.syncope.core.persistence.jpa.upgrade.WiserSchemaTool.add(WiserSchemaTool.java:57) ~[!/:4.0.2-SNAPSHOT]
> at org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:372) ~[openjpa-4.1.1.jar!/:4.1.1]
> at org.apache.syncope.core.persistence.jpa.upgrade.GenerateUpgradeSQL.run(GenerateUpgradeSQL.java:346) ~[!/:4.0.2-SNAPSHOT]
> at org.apache.syncope.core.persistence.jpa.upgrade.SyncopeCorePersistenceJPAUpgrader.run(SyncopeCorePersistenceJPAUpgrader.java:56) ~[!/:4.0.2-SNAPSHOT]
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)