RDB-List when processed with Wait shape not finding jdbc driver
We have a scenario where we queue the case to wait shape. So ideally when the wait time has reached, system is suppose to resume the flow and make Connect-SQL call.
The issue is, when wait shape is processing Connect-SQL, we are seeing the below error.
Problem encountered when getting connection for database externaldb: code: 0 SQLState: 08001 Message: No suitable driver found for jdbc:oracle:thin..........
However, when I resume the wait manually (user choose to continue process), I do not see this error and RDB-List executes just fine.
Note: this is only happening in one env. Moreover, we moved our external db from oracle to redshift. We did not see this when we are using the redshift. Apparently, we are seeing this only after we moved to oracle
***Edited by Moderator Marissa to update platform capability tags; update SR Details****
here is why, in your web node, I can see this setting
whereas in the util node (which runs agent processes) does not have oracle driver class, only redshit class.
Maybe util node did not restart to take effect.
Keep up to date on this post and subscribe to comments
- I am having an error when using an RDB-List or Obj-Browse method. Every other time I run the activity to access this table I get the following error:
- ORA-00942: table or view does not exist, when trying to execute RDB-List method.
- Date format issue- RDB-List
- Performance of Obj-Browse and RDB-list