I have an issue one connecting the external db. We connect external DB in PEGA. We declare JNDI connection string in JBoss server. It is fine without/with putting schema as dbo in our development environment. But when we move to another environment like SIT, without having schema info "Test Connection" failed. Refer to db_error.PNG and db_error_2.PNG as attached. (removed sensitive info)
Kindly guide me in which attributes or configuration made mandatory as schema field.
The table exists because if i dont put dbo in the schema field, I could not connect and if I put the dbo in the schmea field it works fine. But in another environment it does not matter, whether dbo is put under schema field or not.
May I know where can be the different configuration. and where can I check error stack that you mentioned?