topic MYsql to Sql server in Qlik Replicate

MYsql to Sql server

ZuhaibRana — Thu, 09 Jun 2022 06:43:18 GMT

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'

Re: MYsql to Sql server

SwathiPulagam — Thu, 09 Jun 2022 14:44:14 GMT

Hi @ZuhaibRana ,

The above message doesn't give enough information.

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

Thanks,

Swathi

Re: MYsql to Sql server

lyka — Fri, 10 Jun 2022 16:25:59 GMT

Hello,

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

Thanks

Lyka

Re: MYsql to Sql server

ZuhaibRana — Mon, 13 Jun 2022 05:55:21 GMT

When i create new task problem solved

Re: MYsql to Sql server

lyka — Mon, 13 Jun 2022 14:39:26 GMT

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