Relational Migrator SQLExpection

Leandro_Domingues · 2025-02-03T12:22:31.591Z

Hi everyone, I’m trying to run a snapshot job on a SQL Server, but Relational Migrator executes a part (I believe it’s the initial batch) and then gives a SQL Exception error signaling a Query timeout.

The scenario is a database composed of 3 tables that, according to the MongoDB model, are being transformed into a single collection. The first part, which is an initial insert, runs very well, but when the update process starts, the problem occurs.

image (10)

Has anyone experienced this? Is there any extra configuration?

Best,

Leandro Domingues

Leandro_Domingues · 2025-02-07T11:52:18.415Z

Hi guys, just dropping by to give an update on the RelMig issue.Basically, it was resolved with an internal Debezium parameter so that it wouldn’t time out when executing the query:

migrator.connector.source.common.database.query.timeout.ms: 0

This parameter must be added to the user.properties file, check the location according to the platform you are using: https://www.mongodb.com/docs/relational-migrator/installation/file-location/

We haven’t been able to do the complete migration yet, but that barrier has been overcome!

Best,

Leandro Domingues

system · 2025-02-12T11:52:28.447Z

This topic was automatically closed 5 days after the last reply. New replies are no longer allowed.