Oracle error after upgrading to Oracle

  • Questions
  • Oracle error after upgrading to Oracle
Question ID: 104963

We just applied Oracle and now we are getting errors when trying to update defects or tests.

The error in the project is:

Exception from HRESULT: 0x8004025C

In the log file, I see this error:

Failed to setValue for key 76 in table 'BUG' in project ''; Failed SQL: /* ~~QC */ UPDATE BUG SET BG_DEV_COMMENTS=/*P*/'### Clob! Begins with : BG_BUG_VER_STAMP=BG_BUG_VER_STAMP+1, BG_VTS=/*P*/'2013-04-12 10:38:19' where BG_BUG_ID=/*P*/76 [Mercury][Oracle JDBC Driver][Oracle]ORA-00604: error occurred at recursive SQL level 1 ORA-20000: Oracle Text error: DRG-50610: internal error: drexdsync DRG-10607: index meta data is not ready yet for queuing DML ORA-06512: at "CTXSYS.SYNCRN", line 1 ORA-06512: at line 1 ;

Marked as spam
Posted by (Questions: 122, Answers: 3)
Asked on April 12, 2013 8:15 pm
Answers (1)
Private answer

There is a problem in Oracle and where the maximum schema length has been reduced from 30 characters to 29 character. The simple fix is to copy the project to a name that is less than 30 characters. Remember that a schema name is the domain name and underscore then the project name then _db. (Ex. domain_myproject_db ) So make sure the total length is no more than 29 characters.

Oracle has this listed as BUG 11822454 and may have a fix for it. Have your DBA check with the Oracle support team for more information.

Marked as spam
Posted by (Questions: 3, Answers: 168)
Answered on April 12, 2013 8:20 pm