topic Re: Error while store changes into Azure ALDS Gen2 target with Parquet file format in Qlik Replicate

Error while store changes into Azure ALDS Gen2 target with Parquet file format

ifw — Mon, 27 Feb 2023 06:17:38 GMT

While the task is storing changes from MS SQL Server as a source to Azure ALDS Gen2 as a target with Parquet file format, if you do not unselect "stream_position" from Select Change Table Header Columns list, the task seems to be working well, but you will get the following error when you try to open the parquet file.

System.InvalidOperationException: cannot find data type handler to create model schema for [n: header__change_mask, t:FIXED_LEN_BYTE_ARRAY, ct: <not set>, rt: OPTIONAL, c: 0]

Errors - Unexpected Behavior

If not, it works well, which means you can view the parquet without the error like below.

Regards,

Sean

Re: Error while store changes into Azure ALDS Gen2 target with Parquet file format

Steve_Nguyen — Mon, 27 Feb 2023 13:46:00 GMT

@ifw this behavior does not sound correct, better to open a support case so that one of support team and review in detail.

Re: Error while store changes into Azure ALDS Gen2 target with Parquet file format

ifw — Mon, 27 Feb 2023 23:48:02 GMT

Actually, it's not on the production, but it was founded on the VM provisioned by QMI with the scenario Qlik Data Integration.

Re: Error while store changes into Azure ALDS Gen2 target with Parquet file format

Steve_Nguyen — Wed, 01 Mar 2023 17:45:55 GMT

@ifw ,, still best to open a support case.

Re: Error while store changes into Azure ALDS Gen2 target with Parquet file format

ifw — Thu, 02 Mar 2023 00:27:24 GMT

Thank you for your guidance.