Automatic clear cache

choracy69

Hello,

I have question about automatic clear cache.

I want to use: clearQueryCache with runcat.sh

I created catmancredentials.properties, like:

Login=weblogicPwd=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.propertiesclearQueryCache         Clears the query cacheDescriptionClears the query cache in the Presentation ServerFor more information, please see the Oracle Business Intelligence SuiteEnterprise Edition's Presentation Services Administration Guide.Syntaxruncat.cmd/runcat.sh -cmd clearQueryCache        -online <OBIPS url> -credentials <credentials properties file>Basic ArgumentsOptional ArgumentsCommon Arguments-online <OBIPS url>-credentials <credentials properties file>ExampleTo 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

Pedro F

Hi,

In your catmancredentials.properties file, change the parameters "login" and "pwd" to be all lowercases, such as:

login=xxxx

pwd=xxx

Give it a go that way.

choracy69

Thanks for response.

Unfortunately it still doesn't work.

[Mon Oct 23 07:48:25 CEST 2017]: BIFNDN_LABEL =BIFNDN_11.1.1.9.0BIFNDNBP_LINUX.X64_151118.0155[Mon Oct 23 07:48:25 CEST 2017]: # Command : -cmd clearQueryCache -online http://test.obiee.com:9704/analytics/saw.dll? -credentials /ORACLdE/fmw/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalogmanager/catmancredtials.properties[Mon Oct 23 07:48:25 CEST 2017]:[Mon Oct 23 07:48:25 CEST 2017]: clearQueryCache        Clears the query cache[Mon Oct 23 07:48:25 CEST 2017]:[Mon Oct 23 07:48:25 CEST 2017]: Description[Mon Oct 23 07:48:25 CEST 2017]: Clears the query cache in the Presentation Server[Mon Oct 23 07:48:25 CEST 2017]:[Mon Oct 23 07:48:25 CEST 2017]: For more information, please see the Oracle Business Intelligence SuiteEnterprise Edition's Presentation Services Administration Guide.[Mon Oct 23 07:48:25 CEST 2017]:[Mon Oct 23 07:48:25 CEST 2017]: Syntax[Mon Oct 23 07:48:25 CEST 2017]: runcat.cmd/runcat.sh -cmd clearQueryCache[Mon Oct 23 07:48:25 CEST 2017]:     -online <OBIPS url> -credentials <credentials properties file>[Mon Oct 23 07:48:25 CEST 2017]:[Mon Oct 23 07:48:25 CEST 2017]: Basic Arguments[Mon Oct 23 07:48:25 CEST 2017]:[Mon Oct 23 07:48:25 CEST 2017]: Optional Arguments[Mon Oct 23 07:48:25 CEST 2017]:[Mon Oct 23 07:48:25 CEST 2017]: Common Arguments[Mon Oct 23 07:48:25 CEST 2017]: -online <OBIPS url>[Mon Oct 23 07:48:25 CEST 2017]: -credentials <credentials properties file>[Mon Oct 23 07:48:25 CEST 2017]:[Mon Oct 23 07:48:25 CEST 2017]: Example[Mon Oct 23 07:48:25 CEST 2017]: To clear OBIPS query cache:[Mon Oct 23 07:48:25 CEST 2017]: runcat.cmd/runcat.sh -cmd clearQueryCache -online http://localhost:8080/analytics/saw.dll -credentials c:\oracle\catmancredentials.properties[Mon Oct 23 07:48:25 CEST 2017]:[Mon Oct 23 07:48:25 CEST 2017]: ------------------------------------------------------------------------------------------------------------------------------[Mon Oct 23 07:48:25 CEST 2017]: Unable to login to http://test.obiee.com:9704/analytics/saw.dll?

I tried script like:

with full file path:

./runcat.sh -cmd clearQueryCache -online http://test.obiee.com:9704/analytics/saw.dll? -credentials /ORACLE/fmw/instances/instance1/bifoundation/OracleBIPresentationServicesComponent/coreapplication_obips1/catalogmanager/catmancredtials.properties

or short file path (runcat.sh is in the same folder with catmancredtials:

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

Can I change the script and give login and password directly? Without properties file but in script?

choracy69

Ok, it's working.

I have wrong properties file name, my mistake.