Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Automatic clear cache

choracy69Oct 20 2017 — edited Oct 23 2017

Hello,

I have question about automatic clear cache.

I want to use: clearQueryCache with runcat.sh

I created catmancredentials.properties, like:

Login=weblogic

Pwd=password

Next I add this file in runcat location, for me is:

/ORACLE/fmw/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalogmanager

I opened terminal, change location to /ORACLE/fmw/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalogmanager and try to run script as follow:

./runcat.sh -cmd clearQueryCache -online http://test.obiee.com:9704/analytics/saw.dll -credentials catmancredentials.properties

And it return message:

BIFNDN_LABEL =BIFNDN_11.1.1.9.0BIFNDNBP_LINUX.X64_151118.0155

# Command : -cmd clearQueryCache -online http://test.obiee.com:9704/analytics/saw.dll? -credentials catmancredentials.properties

clearQueryCache         Clears the query cache

Description

Clears the query cache in the Presentation Server

For more information, please see the Oracle Business Intelligence Suite

Enterprise Edition's Presentation Services Administration Guide.

Syntax

runcat.cmd/runcat.sh -cmd clearQueryCache

        -online <OBIPS url> -credentials <credentials properties file>

Basic Arguments

Optional Arguments

Common Arguments

-online <OBIPS url>

-credentials <credentials properties file>

Example

To clear OBIPS query cache:

runcat.cmd/runcat.sh -cmd clearQueryCache -online http://localhost:8080/analytics/saw.dll -credentials c:\oracle\catmancredentials.properties

------------------------------------------------------------------------------------------------------------------------------

Unable to login to http://test.obiee.com:9704/analytics/saw.dll?

Why I get this message?  I have added valid login data.

Oracle Business Intelligence 11.1.1.9.6

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details