[
https://issues.apache.org/jira/browse/SYNCOPE-1915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Francesco Chicchiriccò resolved SYNCOPE-1915.
---------------------------------------------
Resolution: Fixed
> 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)
