OBIEE 11g: UPGCMP-02712

Amusingly, the Usage Tracking components (RPD, Web Catalog) must be upgraded from 10g to 11g (11.1.1.5 for me). Not sure how this was missed, but it was.

I've run through the Upgrade Assistant multiple times, each one failing.



Here's the log:

[2011-09-08T03:07:12.156-04:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] 
[ecid: 0000J97r9aPFw000jzwkno1EQ6_m000004,0] Start 11g Components: false
[2011-09-08T03:07:12.185-04:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] 
[ecid: 0000J97r9aPFw000jzwkno1EQ6_m000004,0] Starting to upgrade BIEE.
[2011-09-08T03:07:12.239-04:00] [Framework] [ERROR] 
[UPGAST-00138] [upgrade.Framework] [tid: 13] [ecid: 0000J97r9aPFw000jzwkno1EQ6_m000004,0] 
upgrade exception occurred
[2011-09-08T03:07:12.239-04:00] [Framework] [ERROR] [] [upgrade.Framework] [tid: 13] 
[ecid: 0000J97r9aPFw000jzwkno1EQ6_m000004,0] 
Cause: An unexpected upgrade exception has occurred. Action: See the secondary error message 
for additional details.
[2011-09-08T03:07:12.239-04:00] [Framework] [ERROR] [] [upgrade.Framework] [tid: 13] 
[ecid: 0000J97r9aPFw000jzwkno1EQ6_m000004,0] 
UPGCMP-02712: Expected oracle.biee.admin:oracleInstance=*,type=BIDomain.OracleInstance,
group=Service Oracle instance, found 2
[2011-09-08T03:07:12.240-04:00] [Framework] [ERROR] [] [upgrade.Framework] [tid: 13] 
[ecid: 0000J97r9aPFw000jzwkno1EQ6_m000004,0] 
UPGCMP-02712: Expected oracle.biee.admin:oracleInstance=*,type=BIDomain.OracleInstance,
group=Service Oracle instance, found 2
[2011-09-08T03:07:12.240-04:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] 
[ecid: 0000J97r9aPFw000jzwkno1EQ6_m000004,0] 
Finished upgrading BIEE with status: Failure.
[2011-09-08T03:07:12.241-04:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] 
[ecid: 0000J97r9aPFw000jzwkno1EQ6_m000004,0] 
Finished upgrading components.
[2011-09-08T03:07:12.241-04:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] 
[ecid: 0000J97r9aPFw000jzwkno1EQ6_m000004,0]   
0 components upgraded with success.
[2011-09-08T03:07:12.241-04:00] [Framework] [NOTIFICATION] [] [upgrade.Framework] [tid: 13] 
[ecid: 0000J97r9aPFw000jzwkno1EQ6_m000004,0]   
1 components upgraded with failure.

My Oracle Support (MOS) didn't turn up any hits on that error number. The Google Machine did though. This OTN Forum post has the same exact problem. It appears that Merlin128 is talking to him or herself. I'm ok with that.

yes it was the web-tier.. or actually any component that creates a second instance...the upgrade utility only works with 1 instance installed.. to temporarily have only one instance.. I was able to change this file. run the upgrade. then change it back...middleware\user_projects\domains\bifoundation_domain\opmn\topology.xml

I tried that, commented out the second ias-instance section and restarted all the services (Linux 64).

Run the Upgrade Assistant, no joy.

With a little more research on MOS, I found note ID 1336567.1 which provides an 11.1.1.3 and 11.1.1.5 RPD. Yay.

To my above comment about how a pre-11g component got in there, the MOS note says:

The UsageTracking.rpd shipped is actually a pre 11.1.1.3 version and cannot be opened in the current versions of OBIEE 11g Administrator. It was shipped inadvertently.

All was not lost, I did find the master note for Usage Tracking Issues, ID 1293415.1.

So, I can't open the Usage Tracking web catalog in Catalog Manager (runcat.sh). I tried to deploy just the Usage Tracking catalog...and the BI Presentation server wouldn't come back up. Upgrade Assistant still doesn't work.

Help?

Update 09/08/2011 13:33 EST

So I thought I could use the Oracle created SampleApp (v105, not v107) and received a similar failure:

[2011-09-08T10:29:57.471-07:00] [Framework] [ERROR] [UPGAST-00138] 
[upgrade.Framework] upgrade exception occurred
[2011-09-08T10:29:57.471-07:00] [Framework] [ERROR] 
[upgrade.Framework] 
Cause: An unexpected upgrade exception has occurred. 
Action: See the secondary error message for additional details.
[2011-09-08T10:29:57.471-07:00] [Framework] [ERROR] [upgrade.Framework] 
UPGCMP-02712: Expected oracle.biee.local:* Oracle instance, found 0
[2011-09-08T10:29:57.471-07:00] [Framework] [ERROR] [upgrade.Framework] 
UPGCMP-02712: Expected oracle.biee.local:* Oracle instance, found 0

That VM has Essbase, amongst other components. I speculate there is some sort of (yet unknown) weirdness going on when you don't have a straight (just OBIEE) install.