powered by Jive Software

Openfire 4.7.4 Migration Script Oracle - Index Identifier too long

Hi,

When updating to Openfire version 4.7.4 with Oracle DB, the migration script fails with:

CREATE INDEX ofMucConversationLog_roomtime_idx ON ofMucConversationLog (roomID, logTime);
-- SQL Command: CREATE INDEX ofMucConversationLog_roomtime_idx ON ofMucConversationLog (roomID, logTime)
-- SQL Error Code: 972
-- SQL Error Message: ORA-00972: identifier is too long

The too long index name is used in resources/database/openfire_oracle.sql and resources/database/upgrade/34/openfire_oracle.sql.

Best regards,
Michael

Which ancient Oracle database version are you using? Don’t current Oracle databases support 128 character identifiers?