Skip to main content
Question

Timeouts on Data integration

  • November 27, 2025
  • 1 reply
  • 11 views

Hi team,

 

I am encountering a timeout issue when moving large tables. The problem seems to be originating from the cleanup stored procedure (clean sp), as smaller tables are processed without incident.

 

Could you please look into this issue?

 

 

1 reply

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+8
  • TimeXtender Xpert
  • November 27, 2025

Hi,

what are the timeout settings for your setup? In 20.10.x you can right-click a data warehouse > edit data warehouse > command timeout in TDI this is a setting in the Portal on your Prepare instance. The command timeout represents the time an operation is allowed to take, the connection timeout represents the time allowed for the establishment of a connection.

What you usually want to do is set up a timeout such that it is long enough to give some headroom for unforeseen slowness, but short enough to be able to throw an error and avoid a process hanging forever.