topic Re: Replicate Store changes task error: peform_row_lookup(...) failed to look up change data for table in Qlik Replicate

Replicate Store changes task error: peform_row_lookup(...) failed to look up change data for table

bilzekek — Thu, 22 Sep 2022 09:15:41 GMT

Hi,

I have a Replicate task running with "store changes" enabled. In the task, I have configured a table specific filter, to only include rows where language = 'EN' (See below).

Source is MS SQL server and the specific table has two columns for key:

I have enabled the task and it has been running for a few hours, but I am now getting an error, as shown below

My guess is that Replicate has to lookup another column in the table because of a long string, but has an issue with a row that contains empty value in key column 'Language'. Because I have the filter, it probably doesn't have an effect on the target, but it is quite annoying to keep receiving the error.

If my assumption is correct, is there anything I can do here ?

otherwise, what is the issue here ?

Re: Replicate Store changes task error: peform_row_lookup(...) failed to look up change data for table

SachinB — Thu, 22 Sep 2022 09:50:04 GMT

Hello @bilzekek ,

Most likely the PK value was in a section of the log record beyond the 8000 byte limit of the API that we use.

If the error continues to happen, you may need to convert to using the direct access method of reading the transaction log and switch to backups only.

If the issue still did not resolve, We would request to create case and attach required logs and diagnostic package for our analysis, We will take it further

Regards,

Sachin B

Re: Replicate Store changes task error: peform_row_lookup(...) failed to look up change data for table

bilzekek — Thu, 22 Sep 2022 10:28:29 GMT

Hi Sachin B,

Thanks for the response.

Can you guide me to how I convert to use direct access ? is this an end-point setting?

Re: Replicate Store changes task error: peform_row_lookup(...) failed to look up change data for table

SachinB — Thu, 22 Sep 2022 12:06:08 GMT

Hello @bilzekek ,

To configure direct access method, set the source endpoint to "Replicate has file-level access to the backup log file " in the advanced settings.

https://help.qlik.com/en-US/replicate/November2021/Content/Replicate/Main/SQL%20Server/SQLServerDBSource_AdvProps.htm#Setting%20advanced%20connection%20properties

We would also request you to create a support ticket in order to deep dive the issue.

Regards,

Sachin B

Re: Replicate Store changes task error: peform_row_lookup(...) failed to look up change data for table

bilzekek — Thu, 22 Sep 2022 12:08:42 GMT

Hi Sachin,

Thanks, will do this 🙂