Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Schedule Purge All Cache not working

Received Response
1
Views
5
Comments
983223
983223 Rank 1 - Community Starter

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.

1.jpg2.jpg3.jpg4.jpg5.jpg

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    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
    983223 Rank 1 - Community Starter

    Thanks for sharing Mr.Joel,

    But the same error happen again ..

    any other advice will be much appreciated ..

    6.jpg

  • 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
    983223 Rank 1 - Community Starter

    Thanks for your comments Mr.Gianni,

    Pls. check below ver.12.2.1.4.0

    OS. Linux on "Oracle Exalytics"

    7-ver.jpg

    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]
    [Deleted User] Rank 2 - Community Beginner

    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.