Francesco Chicchiriccò created SYNCOPE-1915:
-----------------------------------------------
Summary: 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ò
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)
