OBIEE - The Calendar prompt TimeStamp Issue

The Calendar prompt defaults the date format as timestamp 12:00 AM to the search

This document contains the steps to be followed in applying the oracle patch 9492821 in order to fix the defect 4773.

 

Pre-Requisites: Please note that, you must have 10.1.3.4.1.090414.1900 or later installed and verified to be working before installing this patch.  Stop the Oracle BI Presentation Server.

Installing the patch

1)       Stop the Oracle BI Presentation Server

2)       Make a backup of the following files on the server that Oracle BI is currently installed:

(Please take a backup of the <OracleBI>\web folder)

                                <OracleBI>\web\app\res\b_mozilla\common\datetime.js

                                <OracleBI>\web\app\res\b_mozilla\dashboards\portalscript.js

                                <OracleBI>\web\app\res\b_mozilla\prompts\gfpdefault.js

                                <OracleBI>\web\app\res\b_mozilla\prompts\globalfilterprompt.js

                                <OracleBI>\web\bin\sawmarkup3r.dll

                                <OracleBI>\web\bin\sawmobile3r.dll

                                <OracleBI>\web\bin\sawreport3r.dll

                                <OracleBI>\web\bin\sawsubsystems3r.dll

                                <OracleBI>\web\bin\sawviews3r.dll

                                <OracleBI>\web\msgdb\messages\promptviewtemplates.xml

           Temporarily keep this backup in another location on the hard drive.

3)        Unzip and copy the updated files into the same location as mentioned above - this should overwrite the existing files with the updated version.

4)       Copy the version.txt into the <OracleBI> install directory.

5)       Create and deploy a new analytics. War (or .ear) file

To create and re deploy the new analytic.war file, follow the steps below

                             a)       Navigate to <OracleBI>\web

b)       Set the Java_Home Path <OracleBI>:\OracleBI\web> 

set JAVA_HOME= C:\Program Files\Java\jdk1.6.0_26

(Select the JAVA_HOME by browsing to specified location mentioned above. jdk version may differ. )

c)  Rename the analytics .war file in the location <OracleBI>:\OracleBI\web as copy of analytics.war
 
d)  Create analytics.war file by the command
      jar -cf analytics.war -C app .

          e) Verify that analytics.war file is created in the location <OracleBI>:\OracleBI\web

Redeploy the archive



1)       Start
oc4j console to see the console





2)   Select Application Server Control

3) Login Screen is

displayed ( If the User Name & Password is known , ignore step 4 and 

proceed to step 5. To get the User Name & Password , perform step 4 )

4) Navigate to Start -> OracleBussinesInteligence -> Stop OC4J (Properties)

5)     Provide the correct User Name & Password  

6)      Stop the Services (Oracle BI Java Host, Oracle BI Presentation Server, Oracle BI Server)

7)        Select analytics

8)       Click on Redeploy

9)       Browse the Archive Location and click Next

10)       Click Next

11)       Click on Redploy

12)       The confirmation web page open and you can see the progress

13)     Restart the services ( Oracle BI Server , Oracle BI Presentation Server , Oracle BI Java Host)

Cheers,

 Gautam