SQL5105N error returned on INSERT when using IBM Cloud Object Store (COS)

Symptoms

An error will be returned when inserting into a partitioned table when using IBM COS object store if the partitioning key value includes any special characters. For example, the following example would result in an error since the value for the partitioning column includes special characters.

create datalake table test "(i int) partitioned by (s varchar(20)) location 'db2remote://datalakealias14//test'
insert into test values "(2, 't[]st')"

You might see the following error when doing an insert into a partitioned table in cases where special characters are used in the data that will be used in the file path for the partition data:

SQL5105N  The statement failed because a Big SQL component encountered an 
error.  Component receiving the error: "SCHEDULER".  Component returning the 
error: "SCHEDULER".  Log entry identifier: "[SCL-0-301b1d67d".  Reason: 
"`s3a://iceberger/t2/_TEMP_1696533".  SQLSTATE=58040