topic Replicate not Ignoring setIgnoreCaseflag advanced odbc properties for FileFormats and Stages in Qlik Replicate

Replicate not Ignoring setIgnoreCaseflag advanced odbc properties for FileFormats and Stages

fayaz_syed_two — Mon, 18 Mar 2024 01:56:47 GMT

Hi,

I am using a flat file as source and target snowflake.

QR is installed in Linux and controlled from QEM on windows.

In trying to force qlik replicate from creating tables (target table as well as control tables and audit table), I set the setIgnoreCaseflag in odbc advanced properties. But QR when attempting to create stages and file formats, is not able to do this and throws the following error. Please note databasename and schemaname have been obscured.

Failed (retcode -1) to execute statement: CREATE STAGE "<databasename>"."<schemaname>"."ATTREP_IS_HUB_DEV_LAND_RAW_3677768a_31f4_4dc6_945b_39644e208068" FILE_FORMAT = (format_name = "<schemaname>"."ATTREP_FF_HUB_DEV_LAND_RAW_3677768a_31f4_4dc6_945b_39644e208068" ); [1022502] (ar_odbc_stmt.c:5066)

Re: Replicate not Ignoring setIgnoreCaseflag advanced odbc properties for FileFormats and Stages

DesmondWOO — Mon, 18 Mar 2024 03:06:27 GMT

Hi @fayaz_syed_two ,

Could you tell me which Replicate version you are currently using?

Regards,
Desmond

Re: Replicate not Ignoring setIgnoreCaseflag advanced odbc properties for FileFormats and Stages

fayaz_syed_two — Mon, 18 Mar 2024 03:23:26 GMT

Hi Desmond,

Its V2023.1.1.1 SR1 latest applied. QR on Linux.

Re: Replicate not Ignoring setIgnoreCaseflag advanced odbc properties for FileFormats and Stages

DesmondWOO — Mon, 18 Mar 2024 04:25:46 GMT

Hi @fayaz_syed_two ,

I can also reproduce a similar problem on Replicate V2023.5.0.701. When I enable the "setIgnoreCaseflag" internal parameter, Replicate generates an error.

I would recommend stopping the user of this parameter and submitting a support ticket with following information:
- Diagnostic package
- Task log with verbose logging on TARGET_LOAD and TARGET_APPLY

Thanks,
Desmond

Re: Replicate not Ignoring setIgnoreCaseflag advanced odbc properties for FileFormats and Stages

festergard_sq — Wed, 15 Jan 2025 07:10:55 GMT

Hi @fayaz_syed_two,

Did you ever get a solution to this issue?

Re: Replicate not Ignoring setIgnoreCaseflag advanced odbc properties for FileFormats and Stages

sureshkumar — Wed, 15 Jan 2025 07:15:46 GMT

Hello @fayaz_syed_two

The issue has been identified as a bug in 2023.11 and fixed it latest service patch of 2023.11. (SP5).

I would request you to please upgrade to latest service patch available in 2023.11 and test the behavior.

Regards,

Suresh