Schedule Purge All Cache not working

983223 · May 3, 2020 12:35AM

Schedule Purge All Cache not working

************

Dears,

what is the credential should I put during creating "PurgeCache" Connection Pool in Physical Layer ?

is`t necessary to be 'credential ' for BIPLATFORM Schema ?

or any DB connection will be fine ?

because every time I try with any DB connection many errors happens ..

like below screenshots , would you pls. advice.

Joel Acha · May 3, 2020 12:43AM

You need to use the fully qualified connection pool name. Quick tip, right click your connection pool and copy. Paste into a text editor and you should see the name there amongst other metadata.

983223 · May 3, 2020 12:59AM

Thanks for sharing Mr.Joel,

But the same error happen again ..

any other advice will be much appreciated ..

Gianni Ceresa · May 3, 2020 4:19AM

The error is explicit: it could find your connection pool properly, but it can't find a datasource matching the name you put inside that connection pool.

You have to review your connection pool settings as, right now, the DDR can find it but can't do much more from there.

You aren't posting a single hint on what version and OS etc. you have, so up to you fix the connection pool info.

983223 · May 4, 2020 12:35AM

Thanks for your comments Mr.Gianni,

Pls. check below ver.12.2.1.4.0

OS. Linux on "Oracle Exalytics"

regarding Data Source connectivity what kind of properties should I check !?

would you pls. share clear steps for :

Build correct odbc connection

use it to build Conn Pool

Thanks

[Deleted User] · May 4, 2020 6:30AM

Yes but where does that connection pool point to? Is there really an ODBC called "DEV_BIPLATFORM" existing on the operating system? And does it really point to your BI server?

The problem is at a very basic level.

Oracle Analytics Forum

Categories

Schedule Purge All Cache not working

Answers