MYsql to Sql server

[ZuhaibRana]

Hi,

First of all thanks in advance.

I am trying to migrate data from MySQL to SQL SERVER in Qlik Replicate. I am using MySQL as a source and SQL SERVER as a target. During this process  I am getting following error.

Stream component 'st_0_SSMS target' terminated
Cannot initialize subtask
Failed while preparing stream component 'st_0_SSMS target'.
The Stream Component cannot register at State Manager
The State Manager cannot allocate new agent
The State Manager cannot allocate agent for component 'st_0_SSMS target'

[SwathiPulagam]

Hi @ZuhaibRana ,

The above message doesn't give enough information.

Can you attach the task log file with Target_apply in trace?

Thanks,

Swathi

[lyka]

Hello,

When you test the target endpoint, is it successful? As requested by Swathi, please attach the complete task log for review.

Thanks

Lyka

[ZuhaibRana]

When i create new task problem solved

[lyka · Accepted solution]

Hi Zuhaib,

Thats great news.  Ive seen a similar issue like this and its related to metadata corruption thats why creating a new task helped solve the issue since the metadata files are freshly created.

Thanks

Lyka