Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE upgrade from 11.1.1.7.0 to 11.1.1.9.0

Received Response
1
Views
1
Comments
3146575
3146575 Rank 1 - Community Starter

Hi,

I upgraded my OBIEE 11.1.1.7 to 11.1.1.9, after successful up-gradation of various components

BIPLATFORM & MDS schema 11.1.1.9.0

WebLogic 10.3.6.0

Oracle Business Intelligence 11.1.1.9.0

not all reports are working fine on the newer version (11.1.1.9.0), which were running accurately on older version.

Error Codes : OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

Error shown is : "No fact table exists at the requested level of detail"

However, I feel this is not the case since if there is no fact table it shouldn't be working on older version either. Also because at time when I rebuild the same report from scratch its working okay.

Regards,

Sohaib

Answers

  • handat
    handat Rank 5 - Community Champion

    Try shutting down weblogic, delete everything in the tmp directory and then start weblogic up again.