Error while viewing Relational Store Settings in DNG703
-
<o:p> </o:p>
We have upgrade DNG to 703 M33 in our test environment. We are in the process of configuring LQE by following these steps Installing and enabling LQE relational store - IBM Documentation . Getting error while viewing JDBC connection details. Refer the screen shots
Relational Store Settings
Current status:CRLQE1190E The relational storage provider is not available.
Sep 19, 2023, 3:22:50 PM
Unable to create a JDBC connection.
2 answers
Hi Karthick, have you installed and configured your datawarehouse in this environment? It is done through JTS setup at Setting up the database - IBM Documentation
If you have, then the datawarehouse connection properties should get prefilled. Did this happen for you or you had to manually setup the connection properties via the dbconnection.properties file?
Comments
Hi Ernest,
We have set up DNG702 long ago and now upgraded to 703M33. I can view the schema/users in Oracle DB. I have seen the details are auto-populated to the Relational store setting page. I am getting an error while clicking the page. Do I need to update/set the path (JDBC driver path) in the lqe/rs properties files?
or I misunderstood the Datawarehouse setup.
It is good it is prefilling. For the password, can you enter it manually (and erase whatever was there for password)
Hi Ernest, That's the trick. I can proceed further after changing the password. I will get in touch with you in case of any other issues.