Replicate not Ignoring setIgnoreCaseflag advanced odbc properties for FileFormats and Stages

[fayaz_syed_two]

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)

[DesmondWOO]

Hi @fayaz_syed_two ,

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

Regards,
Desmond

[fayaz_syed_two]

Hi Desmond,

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

[DesmondWOO]

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