Skip to main content
To homepage To homepage
Solved

Issue of data source connection

  • February 13, 2024
  • 8 replies
  • 131 views
J
Starter

Hi,

I try to connect data source to ODX from TimeXtender Portal. I tried with different data provider (Postgresql and CSV). Both data source are stored in the same machine as ODX server and TimeXtender Server.

 

While I got the error of “Test connection request timed out. Please make sure your ODX server is running and try again.”.

  1. The TimeXtender server and ODX server are both running.
  2. I checked the connection with command, and it is ok. 
    Test-NetConnection timextender-repositories.database.windows.net -Port 1433

Best answer by junwei

Christian Hauggaard wrote:

Hi @junwei can you please provide an update? did you get a chance to try increasing the timeout settings in the Postgresql and CSV providers?

Hi @Christian Hauggaard, sorry for me late reply. The issue is fixed by creating database from TimeXtender instead of directly creating in SQL Server.

View original
Did this topic help you find an answer to your question?

8 replies

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @junwei 

Please try to increase the timeouts on the relevant ODX instance by editing the instance, increasing the values then click Save, and try to Test the connection again. 

 

J
Starter
  • junwei
  • Author
  • Starter
  • 3 replies
  • February 13, 2024
Christian Hauggaard wrote:

Hi @junwei 

Please try to increase the timeouts on the relevant ODX instance by editing the instance, increasing the values then click Save, and try to Test the connection again. 

 

Hi @Christian Hauggaard , 

Thanks for your answer. I tried to increase both connection and command timeout to 10000. But I still have the same error.

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

@junwei are you able to test the connection in TimeXtender (rather than the portal)? Does this work or does it also timeout?

J
Starter
  • junwei
  • Author
  • Starter
  • 3 replies
  • February 13, 2024
Christian Hauggaard wrote:

@junwei are you able to test the connection in TimeXtender (rather than the portal)? Does this work or does it also timeout?

@Christian Hauggaard yes, it is the same error.

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Thomas Lind
  • Community Manager
  • 1076 replies
  • February 14, 2024

Hi @junwei 

What exactly are you pointing at with the data sources.

If you open TimeXtender, can you see the ODX and open it?

If so can you see the data sources added there?

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @junwei 

Can you please try to increase the timeout settings in the Postgresql and CSV providers?

The timeout setting can be found under Misc section for the data source connections

Then please execute the synchronize task for the data sources and then try to test the connection again from TimeXtender desktop by editing the data source and selecting Test Connection

 

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @junwei can you please provide an update? did you get a chance to try increasing the timeout settings in the Postgresql and CSV providers?

J
Starter
  • junwei
  • Author
  • Starter
  • 3 replies
  • Answer
  • February 29, 2024
Christian Hauggaard wrote:

Hi @junwei can you please provide an update? did you get a chance to try increasing the timeout settings in the Postgresql and CSV providers?

Hi @Christian Hauggaard, sorry for me late reply. The issue is fixed by creating database from TimeXtender instead of directly creating in SQL Server.

Christian Hauggaard
1 person likes this
  • Christian Hauggaard
    Christian Hauggaard

Reply


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings