Oracle error after upgrading to Oracle 11.2.0.2

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

We just applied Oracle 11.2.0.2 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:


Messages:
Failed to setValue for key 76 in table 'BUG' in project 'com.mercury.td.tdserver.authentication.CTdSessionContext@7e21fd93'; 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
41 views
Answers (1)
1
Private answer

There is a problem in Oracle 11.2.0.2 and 11.2.0.3 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