Intermittent error running SQL stored proc in ADF pipeline: "Incorrect syntax near ','"

We are using an ADF pipeline to copy from a Synapse Link Data Lake to an Azure SQL database. The pipeline has a Mapping Data Flow inside a loop for each table we wish to copy. Prior to running the Data Flow we run a SQL stored proc. to create the sink table (if it does not exist) using the model.json file created by Synapse Link to build dynamic SQL.
Occasionally we see this stored proc. fail with "Incorrect syntax near ','". The stored proc. activity has a retry count of 5 - whenever we see a failure the first retry invariably works without error.
Any ideas on what could be going wrong here? I have compared the activity inputs for a failure and a success - they are identical.