Schedule Purge All Cache not working

Question

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

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.

[Deleted User] · Answer

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.

983223 · Answer

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

Gianni Ceresa · Answer

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.