# Problem with Redmine

**URL:** <https://www.ruby-forum.com/t/problem-with-redmine/204416>\
**Category:** Rails\
**Created:** [March 11, 2011, 2:31pm UTC](https://www.ruby-forum.com/t/problem-with-redmine/204416 "2011-03-11T14:31:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dubstep](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/cdc98d/32.png) [@dubstep](https://www.ruby-forum.com/u/dubstep)\
**Post date:** [March 11, 2011, 2:31pm UTC](https://www.ruby-forum.com/t/problem-with-redmine/204416/1 "2011-03-11T14:31:21Z")

</div>

I am having a problem getting Redmine to run with Oracle (11.2) backend.  
I get this error (below) because Oracle table names are limited to 30  
characters. Does anyone around here know of a fix or workaround? I’m  
wondering if I can simple change the table name, or if that will break  
the application.

When doing a db migrate to an Oracle db this creates the error below.

I’m so close, but now when I do:

RAILS\_ENV=production rake db:migrate --trace

I get:

# AddOpenIdAuthenticationTables: migrating

– create\_table(:open\_id\_authentication\_associations, {:force=\>true})  
rake aborted!  
An error has occurred, all later migrations canceled:

OCIError: ORA-00972: identifier is too long: CREATE TABLE  
“OPEN\_ID\_AUTHENTICATION\_ASSOCIATIONS” (“ID” NUMBER NOT NULL PRIMARY KEY,  
“ISSUED” NUMBER, “LIFETIME” NUMBER, “HANDLE” VARCHAR2, “ASSOC\_TYPE”  
VARCHAR2, “SERVER\_URL” BLOB, “SECRET” BLOB)  
/opt/redmine-1.1.2/vendor/rails/activerecord/lib/active\_record/connection\_adapters/abstract\_adapter.rb:219:in  
`log' /usr/local/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.3.2/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:1077:in`log’  
/usr/local/lib/ruby/gems/1.8/gems/activerecord-oracle\_enhanced-adapter-1.3.2/lib/active\_record/connection\_adapters/oracle\_enhanced\_adapter.rb:493:in  
`execute' /usr/local/lib/ruby/gems/1.8/gems/activerecord-oracle_enhanced-adapter-1.3.2/lib/active_record/connection_adapters/oracle_enhanced_schema_statements.rb:84:in`create\_table’

Any help is greatly appreciated!

---

<div class="post-metadata">

**Author:** ![mroutley](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/5f9b8f/32.png) [@mroutley](https://www.ruby-forum.com/u/mroutley)\
**Post date:** [March 11, 2011, 4:02pm UTC](https://www.ruby-forum.com/t/problem-with-redmine/204416/2 "2011-03-11T16:02:17Z")

</div>

On Fri, Mar 11, 2011 at 7:31 AM, Matthew R. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> OCIError: ORA-00972: identifier is too long: CREATE TABLE

/usr/local/lib/ruby/gems/1.8/gems/activerecord-oracle\_enhanced-adapter-1.3.2/lib/active\_record/connection\_adapters/oracle\_enhanced\_adapter.rb:493:in

> `execute’

/usr/local/lib/ruby/gems/1.8/gems/activerecord-oracle\_enhanced-adapter-1.3.2/lib/active\_record/connection\_adapters/oracle\_enhanced\_schema\_statements.rb:84:in

> `create\_table’
> 
> Any help is greatly appreciated!

Changing the name is what you will need to do to get it to run under  
Oracle  
11. There will be issues with the application since you are changing a  
table  
name. You are going to have to rework your code so that all the  
relationships are correctly work or else they will be looking for a  
table  
that is not in the database.

If you are the author of the code that uses that table then you have  
some  
work ahead of you. If you are not, then you need to send it back to your  
developers explaining that the table name is too long for Oracle 11 and  
they  
will need to rework the code. Good luck.

B.

---

<div class="post-metadata">

**Author:** ![mroutley](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/5f9b8f/32.png) [@mroutley](https://www.ruby-forum.com/u/mroutley)\
**Post date:** [March 11, 2011, 4:23pm UTC](https://www.ruby-forum.com/t/problem-with-redmine/204416/3 "2011-03-11T16:23:38Z")

</div>

On 11 March 2011 14:52, Bryan C. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> You are going to have to rework your code
> 
> If you are the author of the code that uses that table then you have  
> some work ahead of you. If you are not, then you need to send it back  
> to your developers explaining that the table name is too long for Oracle  
> 11 and they will need to rework the code. Good luck.

It’s not his code… he said, it’s Redmine…

> On Fri, Mar 11, 2011 at 7:31 AM, Matthew R. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:
> 
> I am having a problem getting Redmine to run with Oracle because Oracle table  
> names are limited to 30  
> characters. Does anyone around here know of a fix or workaround? I’m  
> wondering if I can simple change the table name, or if that will break  
> the application.  
> “OPEN\_ID\_AUTHENTICATION\_ASSOCIATIONS” (“ID” NUMBER NOT NULL PRIMARY  
> Any help is greatly appreciated!

You _may_ be able to get away with changing the table name in the  
migration and then editing the model to specify the new table name:

class Mouse \< ActiveRecord::Base  
def self.table\_name() “mice” end  
end

However, according to the release notes, Oracle support should be in  
there:

> **[Changelog 0 6 - Redmine](https://www.redmine.org/projects/redmine/wiki/Changelog_0_6)**
>
> Redmine

but the install notes don’t mention it:

> **[RedmineInstall - Redmine](https://www.redmine.org/projects/redmine/wiki/RedmineInstall)**
>
> Redmine

..but another “but” - it looks like your conflict is with one of the  
plugins that Remine uses:  
/ vendor / plugins / open\_id\_authentication  
…so there may not be much Redmine has to do with it, but it’s an  
open\_id\_authentication

I’m no Oracle admin, but can you use Aliases to help?

> **[Naming Conventions](https://oracle-base.com/articles/misc/naming-conventions)**
>
> Some of the typical naming conventions used for objects in Designer and the database.

Is there any reason why you can’t use mySQL or SQLite?.. might save a  
lot of hassle if you can…
