Data migrate from MongoDb to Sql server

[ZuhaibRana]

i am trying to migrate data from MongoDb to Sql server. MongoDb using as a Source and Sql server using as a target in qlik replicate. i am getting following errors.

1

Task 'Mongo db to sql server' encountered a recoverable error

2

Stream component 'st_0_Mongodb' terminated
Stream component failed at subtask 0, component st_0_Mongodb
Error executing source loop

3

Capture loop failed
Failed to start MongoDB watcher.

4

An error occurred during capture changes

5

Failed to start Change Processing from specified time (Timestamp{value=7108998699761532928, seconds=1655192743, inc=0})

[john_wang]

Hello @ZuhaibRana ,

From the error messages looks like your MongoDB source Server is not ready for CDC. Please refer to Qlik Doc, the MongoDB Server must be set up in a replica set configuration . MongoDB does not support watch() function if it's a single node config.

BTW, could you please let me know what's the MongoDB server version? is it an on-premise or Atlas.

Hope this helps.

John.

[ZuhaibRana]

Mongo Db version: 4.0.28 

you are saying this is CDC issue. But i am using without CDC. 

[john_wang · Accepted solution]

Hello @ZuhaibRana ,

Thanks for your update.

The error message is relevant to CDC. if you are intending to run Full Load only then please turn off both "Apply Changes" and "Store Changes", for example the task setting:

Hope this helps.

Regards,

John.

[ZuhaibRana]

Problem Solved Thanks

[john_wang]

Hello @ZuhaibRana ,

Glad to hear that. can you click "Accept as Solution" , it's helpful for others as well.

thanks,

John.

[ZuhaibRana]

now again getting same errors. 

[john_wang]

Hello @ZuhaibRana ,

You ever mentioned 5 errors. which error you are facing after you turn off the CDC?

Can you share a piece of task log file (obfuscating sensitive information as needed)? If you are not sure which information is sensitive, I'd like to suggest you open a support case and attach the task log file, our support team will help.

Regards,

John.

[ZuhaibRana]

@john_wang  I have solved the problem.

Thanks

[Sehwag]

Hey ,can you please share your solutions with all steps from scratch .
I shall be greatful ...

1

Task 'Mongo db to sql server' encountered a recoverable error

2

Stream component 'st_0_Mongodb' terminated
Stream component failed at subtask 0, component st_0_Mongodb
Error executing source loop

3

Capture loop failed
Failed to start MongoDB watcher.

4

An error occurred during capture changes

5

Failed to start Change Processing from specified time (Timestamp{value=7108998699761532928, seconds=1655192743, inc=0})