Passthrough (passthru) no longer works (and neither does the posted fix)

[LoriHalsey]

Passthrough no longer works, fix doesn't work either

Hello - we just upgraded our test replicate services to 2021.11.0.349. We tested a full load of one of our tasks. There is one table that has a passthrough filter, which failed. Found this KB, and followed the instructions to add the line to the .cfg file:https://community.qlik.com/t5/Knowledge/Filter-for-last-90-days-of-data-in-Qlik-Replicate/ta-p/18807...

But the service will not start with that line in the .cfg file. If I comment out the new line, the service starts just fine. What gives?

Attaching the .cfg file that causes services to not start (had to rename to .cfg.txt so I could upload it). I have the line commented out for now so other tasks can be tested.

Thanks,

Lori Halsey

[LoriHalsey]

Hello - we just upgraded our test replicate services to 2021.11.0.349. We tested a full load of one of our tasks. There is one table that has a passthrough filter, which failed. Found this KB, and followed the instructions to add the line to the .cfg file:https://community.qlik.com/t5/Knowledge/Filter-for-last-90-days-of-data-in-Qlik-Replicate/ta-p/18807...

But the service will not start with that line in the .cfg file. If I comment out the new line, the service starts just fine. What gives?

Attaching the .cfg file that causes services to not start (had to rename to .cfg.txt so I could upload it). I have the line commented out for now so other tasks can be tested.

Thanks,

Lori Halsey

[Alan_Wang · Accepted solution]

Hi Lori,

You left out a comma causing incorrect syntax. There should be a comma after the word "false"

"enable_execute_user_defined_commands": false
"enable_passthrough_filter": true

"enable_execute_user_defined_commands": false,
"enable_passthrough_filter": true

Thanks,

Alan

[LoriHalsey]

oh jeez, can't believe I missed that. Thank you!

Trying it again.

[LoriHalsey]

Thanks for the quick responses everyone. Yes, that comma made a difference. I was able to start the service, and reload the table that had passthru logic successfully.

Lori