This discussion is archived
5 Replies Latest reply: Jun 27, 2013 11:43 AM by user13823711 RSS

BI Publisher Upgrade

user13823711 Newbie
Currently Being Moderated

Hi,

 

  Did any one successfully upgraded BI publisher from 10.1.3.4 to 11.1.1.5.I am looking only upgrade of BI publisher.

 

  Thanks in Advance.

  • 2. Re: BI Publisher Upgrade
    Sasi Nagireddy Expert
    Currently Being Moderated

    Hello User,

     

    Yes i have upgraded that by using the ua.bat command from

    Navigate to <OBIEE_MW_HOME>/Oracle_BI1/bin/ua.bat . This batch file is the Upgrade

     

     

     

    Assistant wizard. Launch the wizard by double clicking on it.

     

    Thanks,

  • 3. Re: BI Publisher Upgrade
    user13823711 Newbie
    Currently Being Moderated


    Looks like above link is not working.Can you please repost.

  • 4. Re: BI Publisher Upgrade
    user13823711 Newbie
    Currently Being Moderated

    I followed upgrading using ua.bat file.

     

    1) Placed the 10g BI pulisher Repository(all files) in custom folder C:\BIPublisher.I unzipped the code which I got from 10g BI publisher

    2)Ran ua.bat file C:\OBI11g_Middleware\Oracle_BI1\bin and choosed "Upgrade Oracle BI Publisher Repository"->RPD Directory: C:\BI Publisher ->RPD Directory:C:\OBI11g_Middleware\user_projects\domains\bifoundation_domain\config\bipublisher\repository -> Port:7001,Username:weblogic,pwd:*** ->At Examine Step it showed Succeeded -> At upgrade step it failed with above error.

     

    Pasting Errors I found in log:

     

    [2013-05-30T17:36:28.691-05:00] [xdo] [ERROR] [] [oracle.xdo] [tid: 13] [ecid: 0000Jvr_MeW6IRt_Kd1Fie1HdxGJ000004,0] JavaCrypto: written new keyfile to:C:\OBI11g_Middleware\user_projects\domains\bifoundation_domain\config\bipublisher\repository\Admin\/Security/.symder

    [2013-05-30T17:36:28.691-05:00] [Framework] [ERROR] [UPGAST-00138] [upgrade.Framework] [tid: 13] [ecid: 0000Jvr_MeW6IRt_Kd1Fie1HdxGJ000004,0] upgrade exception occurred

    [2013-05-30T17:36:28.691-05:00] [Framework] [ERROR] [] [upgrade.Framework] [tid: 13] [ecid: 0000Jvr_MeW6IRt_Kd1Fie1HdxGJ000004,0] Cause: An unexpected upgrade exception has occurred. Action: See the secondary error message for additional details.

    [2013-05-30T17:36:28.691-05:00] [Framework] [ERROR] [] [upgrade.Framework] [tid: 13] [ecid: 0000Jvr_MeW6IRt_Kd1Fie1HdxGJ000004,0] oracle.xdo.XDOException: java.lang.NumberFormatException: For input string: "DS"

     

    Please post me if you have faced this issue.

  • 5. Re: BI Publisher Upgrade
    user13823711 Newbie
    Currently Being Moderated

    Nagireddy,

     

      I was able to successfully upgrade BI publisher 10g to 11g.But did you face any upgrade issues.

     

       1) When you apply filter for BI report,after upgradation I don't see report heading appearing.But by default it has it's heading.Only when I apply filter header will be missed and I see blank space followed by report content.I see this issue only in IE and not in Mozilla.

       2) It's not allowing to update existing report.In Report level -> Action-> Edit Report -> Edit.Then it asks me to open/save .doc file(Because my report layout choosed was .doc in 10g).But I dont find a way to edit the existing reports.

     

       Any ideas?