Virtualization using Teradata Data Source

Support
1

We have added the teradata datasource to stardog but unable to create a virtual graph on it.
Facing the following issue even when the connection is not closed:
Failed to create Virtual Graph "Virtualization_TeraData": 000012: Exception while reading tables from 'null.demo_user' for data source TeraData_Demo: [Teradata JDBC Driver] [TeraJDBC 16.20.00.13] [Error 1095] [SQLState HY000] Cannot call a method on closed connection.
Tried using teradata jdbc version 4 and 16.

2

Hi Bhargavi,

I wonder if too much time has elapsed since the data source was created. Stardog uses a connection pool so it is possible that the connection has timed out. This can be mitigated with the following data source options:

testOnBorrow=true
validationQuery=SELECT 1

Otherwise, if the error happens right away, can you describe your environment? Is this running in the cloud? Where is the Teradata server in relation to it? Is there a firewall in between that could be interfering with the connections? Do you have access to the stardog.log? Can run try creating the virtual graph in Studio and when the red error rectangle pops up, click "Download" and share the stacktrace that's returned?

-Paul

3

Hi Paul,

I was able to create virtual graph without auto-generating mappings, but when I am trying to auto-generate mappings while or after creating virtual graph I am getting a error like this -
"Failed to create Virtual Graph "test_virtual_graph": 000012: Table 'STARDOG_TERADATA.Inventory' not found".
Even when we have table - Inventory in database, the error is saying we can't find it.
Yes I am running it in cloud and have no access to stardog.log, so I am sharing you the stacktrace that's returned.
2025-04-04T11_36_19.600931Z.txt (9.6 KB)