Author Message
MarkusCzernek
Joined: Mar 13, 2009
Messages: 2
Offline
Hi,
Pregame:
I have a Breeze GP Cluster with EngagementDesigner 3.8.0.1.105001 up and running.
I configured seven JDBC Sources hosted on three different database servers.
Some of them are Postgres the others are MSSQL.
For both database engines the JDBC Drivers are installed in Breeze.
For all seven JDBC Sources the "TestConnection" is executed successfully.
Breeze has been rebooted several times after the JDBC Source were configured.

Issue:
When I create a new Workflow in ED using the ReadFromDB task, I get only two of my seven configured databases for selection.
The two JDBCSource which I can select from drop down is one Postgres and one MSSQL. So I know that both drivers are installed correctly. (Screenshots are attached)
Why I do not get the other five databases for selection?
I didn't find any restrictions in the documentation.

Any hints?
Thanks
Markus

  • [Thumb - ReadFromDB.png]

  • [Thumb - JDBCSources.png]

MarkusCzernek
Joined: Mar 13, 2009
Messages: 2
Offline
Addition:
In the EngagmentDesigner Logfile I get this output:



ct","properties":{}},"variables":[],"schemaId":"uuidGlobalVariables1234567890","title":"GlobalVariables"}
2021-11-10 09:50:20,886 [WebContainer : 14] EngagementDesigner INFO - EngagementDesigner-3.8.0.1.105001 - getJDBCConfiguration: providerName = PostgresJDBC83
2021-11-10 09:50:20,886 [WebContainer : 14] EngagementDesigner INFO - EngagementDesigner-3.8.0.1.105001 - getJDBCConfiguration: providerName = postgresJDBC
2021-11-10 09:50:20,886 [WebContainer : 14] EngagementDesigner INFO - EngagementDesigner-3.8.0.1.105001 - getJDBCConfiguration: ausJDBCDataSource name = ContactManager1
2021-11-10 09:50:20,888 [WebContainer : 14] EngagementDesigner INFO - EngagementDesigner-3.8.0.1.105001 - getJDBCConfiguration: ausJDBCDataSource name = ContactManager2
2021-11-10 09:50:20,888 [WebContainer : 14] EngagementDesigner INFO - EngagementDesigner-3.8.0.1.105001 - getJDBCConfiguration: ausJDBCDataSource name = ContactManager3
2021-11-10 09:50:20,888 [WebContainer : 14] EngagementDesigner INFO - EngagementDesigner-3.8.0.1.105001 - getJDBCConfiguration: ausJDBCDataSource name = BL
2021-11-10 09:50:20,888 [WebContainer : 14] EngagementDesigner INFO - EngagementDesigner-3.8.0.1.105001 - getJDBCConfiguration: providerName = MSSQL
2021-11-10 09:50:20,888 [WebContainer : 14] EngagementDesigner INFO - EngagementDesigner-3.8.0.1.105001 - getJDBCConfiguration: ausJDBCDataSource name = MSSQLTest2
2021-11-10 09:50:20,888 [WebContainer : 14] EngagementDesigner INFO - EngagementDesigner-3.8.0.1.105001 - getJDBCConfiguration: ausJDBCDataSource name = MSSQLM
2021-11-10 09:50:20,888 [WebContainer : 14] EngagementDesigner INFO - EngagementDesigner-3.8.0.1.105001 - writeResponse_doPropertyFill {"returnString":[["BL","MSSQLM"]],"returnValue":true}


Here we see that the JDBC configuration is read for all configured sources, but in the result list I get only two of them.

Why?

How can I use all of my configured JDBC sources?

Markus
Krishnakumar(KK)
Joined: Jul 15, 2016
Messages: 32
Offline
Hi Markus,
Could you please check if the following properties are available for the missing datasources.

Url
Validation query
Username
Password

If anyone of them is missing/blank then that datasource will not be added to the list.
Go to:   
Mobile view