AO broken on Oracle

Many users find themselves encountering ORA-00972 when attempting to access a table that has a large column length.

... ORA-00972 in which trying to get data from DBMS tables with 31 or more characters in the column name, throws ORA-00972. This can happen even if the ORA_OBJECT_NAME domain is defined as VARCHAR(30) as opposed to VARCHAR(31)

AO_60DB71_ISSUERANKINGLOG_ID_SEQ is longer than 30 characters at 32 characters.

build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] 2011-11-11 21:37:37,632 JiraImportTaskExecutionThread-1 ERROR admin 1297x22x1 ti27su 127.0.0.1 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] Error importing data: com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin GreenHopper(com.pyxis.greenhopper.jira) #5.8.4-SNAPSHOT:Error executing update for SQL statement 'DROP SEQUENCE AO_60DB71_ISSUERANKINGLOG_ID_SEQ'
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] com.atlassian.activeobjects.spi.ActiveObjectsImportExportException: There was an error during import/export with plugin GreenHopper(com.pyxis.greenhopper.jira) #5.8.4-SNAPSHOT:Error executing update for SQL statement 'DROP SEQUENCE AO_60DB71_ISSUERANKINGLOG_ID_SEQ'
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.ImportExportErrorServiceImpl.newImportExportSqlException(ImportExportErrorServiceImpl.java:32)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.SequenceUtils.executeUpdate(SequenceUtils.java:33)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.SequenceUtils.executeUpdate(SequenceUtils.java:43)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.OracleSequencesAroundImporter.dropSequence(OracleSequencesAroundImporter.java:115)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.OracleSequencesAroundImporter.dropAllSequences(OracleSequencesAroundImporter.java:100)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.OracleSequencesAroundImporter.doBefore(OracleSequencesAroundImporter.java:61)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.OracleSequencesAroundImporter.before(OracleSequencesAroundImporter.java:39)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.dbexporter.importer.AbstractImporter.importNode(AbstractImporter.java:46)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.dbexporter.DbImporter.importData(DbImporter.java:73)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.ActiveObjectsBackup.restore(ActiveObjectsBackup.java:155)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.jira.bc.dataimport.DefaultDataImportService.restoreActiveObjects(DefaultDataImportService.java:347)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:479)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:209)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:65)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:28)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:147)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.FutureTask.run(FutureTask.java:138)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.FutureTask.run(FutureTask.java:138)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.multitenant.impl.DefaultMultiTenantManager.runForTenant(DefaultMultiTenantManager.java:61)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.multitenant.juc.MultiTenantExecutors$WrappedRunnable.run(MultiTenantExecutors.java:160)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at java.lang.Thread.run(Thread.java:662)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] Caused by: java.sql.SQLException: ORA-00972: identifier is too long
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer]
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1814)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1779)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:277)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:196)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] at com.atlassian.activeobjects.backup.SequenceUtils.executeUpdate(SequenceUtils.java:29)
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] ... 24 more
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] 2011-11-11 21:37:37,636 JiraImportTaskExecutionThread-1 INFO admin 1297x22x1 ti27su 127.0.0.1 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] Importing data is 100% complete...
build 11-Nov-2011 21:37:37 [INFO] [talledLocalContainer] 2011-11-11 21:37:37,636 JiraImportTaskExecutionThread-1 INFO admin 1297x22x1 ti27su 127.0.0.1 /secure/admin/XmlRestore.jspa [jira.bc.dataimport.DefaultDataImportService] JIRA Data Import has finished.
build 11-Nov-2011 21:37:37 .
build 11-Nov-2011 21:37:37 . ______ TEST FAILURE ______
build 11-Nov-2011 21:37:37 .
build 11-Nov-2011 21:37:37 . java.lang.AssertionError: Failed to restore JIRA data from [/opt/bamboo-agent/xml-data/build-dir/GH-TPM58-TPMORACLE/greenhopper-integration-test/target/jira/home/import/test-data.zip]. See logs for details.
build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.AdministrationImpl.restoreData(AdministrationImpl.java:423)
build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.AdministrationImpl.restoreData(AdministrationImpl.java:368)
build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.AdministrationImpl.restoreData(AdministrationImpl.java:352)
build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.AdministrationImpl.restoreData(AdministrationImpl.java:296)
build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.AdministrationImpl.restoreData(AdministrationImpl.java:290)
build 11-Nov-2011 21:37:37 . at it.com.atlassian.greenhopper.api.RankResourceTest.setUpTest(RankResourceTest.java:44)
build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.FuncTestCase.setUp(FuncTestCase.java:168)
build 11-Nov-2011 21:37:37 . at junit.framework.TestCase.runBare(TestCase.java:132)
build 11-Nov-2011 21:37:37 . at com.atlassian.jira.functest.framework.FuncTestCase.runBare(FuncTestCase.java:300)
build 11-Nov-2011 21:37:37 . at junit.framework.TestResult$1.protect(TestResult.java:110)
build 11-Nov-2011 21:37:37 . at junit.framework.TestResult.runProtected(TestResult.java:128)
build 11-Nov-2011 21:37:37 . at junit.framework.TestResult.run(TestResult.java:113)
build 11-Nov-2011 21:37:37 . at junit.framework.TestCase.run(TestCase.java:124)
build 11-Nov-2011 21:37:37 . at junit.framework.TestSuite.runTest(TestSuite.java:243)
build 11-Nov-2011 21:37:37 . at junit.framework.TestSuite.run(TestSuite.java:238)
build 11-Nov-2011 21:37:37 . at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:83)
build 11-Nov-2011 21:37:37 . at org.apache.maven.surefire.junit4.JUnit4TestSet.execute(JUnit4TestSet.java:62)
build 11-Nov-2011 21:37:37 . at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:140)
build 11-Nov-2011 21:37:37 . at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:127)
build 11-Nov-2011 21:37:37 . at org.apache.maven.surefire.Surefire.run(Surefire.java:177)
build 11-Nov-2011 21:37:37 . at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
build 11-Nov-2011 21:37:37 . at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
build 11-Nov-2011 21:37:37 . at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
build 11-Nov-2011 21:37:37 . at java.lang.reflect.Method.invoke(Method.java:597)
build 11-Nov-2011 21:37:37 . at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:345)
build 11-Nov-2011 21:37:37 . at org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:1009)
build 11-Nov-2011 21:37:37 .
build 11-Nov-2011 21:37:37 . ______________________________ Starting HTML dump
build 11-Nov-2011 21:37:37 . URL : http://localhost:2990/jira/secure/admin/XmlRestore!finish.jspa
build 11-Nov-2011 21:37:37 . HTTP METHOD : GET
build 11-Nov-2011 21:37:37 . HTTP SC : 200
build 11-Nov-2011 21:37:37 . HTTP MSG : OK
build 11-Nov-2011 21:37:37 . Request Headers :
build 11-Nov-2011 21:37:37 . ________________
build 11-Nov-2011 21:37:37 . Cookie : JSESSIONID=AFC8AEF9B215D62635E33AB8135073EF;atlassian.xsrf.token=B81K-KFOU-I9XI-SF5D|5695b6165f239c625fb471e35f384ffe9da49036|lin
build 11-Nov-2011 21:37:37 . Accept-Encoding : gzip
build 11-Nov-2011 21:37:37 . User-Agent : httpunit/1.5.4-atlassian-patched
build 11-Nov-2011 21:37:37 . Response Headers :
build 11-Nov-2011 21:37:37 . ________________
build 11-Nov-2011 21:37:37 . EXPIRES : Thu, 01 Jan 1970 00:00:00 GMT
build 11-Nov-2011 21:37:37 . X-ASESSIONID : ti27su
build 11-Nov-2011 21:37:37 . DATE : Sat, 12 Nov 2011 03:37:37 GMT
build 11-Nov-2011 21:37:37 . CONTENT-TYPE : text/html;charset=UTF-8
build 11-Nov-2011 21:37:37 . CACHE-CONTROL : no-cache, no-store, must-revalidate
build 11-Nov-2011 21:37:37 . TRANSFER-ENCODING : chunked
build 11-Nov-2011 21:37:37 . X-AUSERNAME : admin
build 11-Nov-2011 21:37:37 . SERVER : Apache-Coyote/1.1
build 11-Nov-2011 21:37:37 . X-AREQUESTID : 1297x23x1
build 11-Nov-2011 21:37:37 . X-SERAPH-LOGINREASON : OK
build 11-Nov-2011 21:37:37 . PRAGMA : no-cache
build 11-Nov-2011 21:37:37 . Last Successful Response Body :
build 11-Nov-2011 21:37:37 . ________________
build 11-Nov-2011 21:37:37 . <!DOCTYPE html>
build 11-Nov-2011 21:37:37 .
build 11-Nov-2011 21:37:37 .
build 11-Nov-2011 21:37:37 .
build 11-Nov-2011 21:37:37 .
build 11-Nov-2011 21:37:37 .
build 11-Nov-2011 21:37:37 .
build 11-Nov-2011 21:37:37 .
build 11-Nov-2011 21:37:37 .
build 11-Nov-2011 21:37:37 .
build 11-Nov-2011 21:37:37 .
build 11-Nov-2011 21:37:37 .
build 11-Nov-2011 21:37:37 .
build 11-Nov-2011 21:37:37 .
build 11-Nov-2011 21:37:37 .
build 11-Nov-2011 21:37:37 .
build 11-Nov-2011 21:37:37 . <html>