Forum Discussion

ge5536's avatar
ge5536
Helper I
5 years ago
Solved

The credentials provided for the Oracle source are invalid

Hello! I'm having some 'odd' error on a handful of our scheduled refreshes. They are returning the following error: 'The credentials provided for the Oracle source are invalid' If you do a 'Test...
Data Refreshes
Oracle Database
Report Server
  • josef78's avatar
    josef78
    5 years ago

    Please, try update your server&desktop to latest release January 2021 which addressing this issue

Anonymous's avatar
Anonymous
Not applicable
5 years ago

ge5536 


Did you make sure the used credential has the permission to access all data in the Oracle source?

 

Paul Zheng

  • ge5536's avatar
    ge5536
    Helper I
    5 years ago

    Hello Paul,

    Yes, users are able to run the reports without any issues from their desktop application or the queries from SQL Developer/Toad. There were no firewall rule changes, and as I mentioned before, we have dashboards hitting the same data source and using the same credentials where one will refresh without an issue and the other will fail.

    The only environment change I have noticed is Windows Server patching on 1/17 - our refreshes began to fail at a very high % after that. I know there's another user having a similar issue hitting Sharepoint data sources after they recently patched their servers.

    This appears to be an MS issue - not local. Should I be engaging MS Support? And how would I go about doing that? I kind of need this resolved ASAP 😄

    Thank you!

  • ge5536's avatar
    ge5536
    Helper I
    5 years ago

    Anonymous Hey Paul, any updates on this? Another thread had mentioned an internal ticket about a similar issue? Is it related to what I'm encountering?

    I'm currently reverting the security patches we applied in our test environment and hoping this will resolve the issue. Any tips/assistance would be greatly appreaciated (or a link to where I can submit a support case).

    Thanks!