Thank you @Sergio Ribeiro for the fast response.
The credential is correct and updated. In the manage data source, we can actually get a success message box when we test the connection and our Pentaho reports are working as well. Only on the CDE dashboard, we are getting the error.
Please note that we have implemented a multi-tenant architecture in our DB and the credential we use to connect is the correct account for that schema.
I also want to add that we are using the custom driver class name, do you think it has something to do with the error?
Here are the actual errors in Catalina.out
16:21:41,270 ERROR [SchemaUpdate] could not get database metadata java.sql.SQLException: ORA-28000: the account is locked
16:21:42,456 ERROR [SchemaUpdate] could not complete schema update java.sql.SQLException: ORA-28000: the account is locked
Thank you so much!