There is no parameter error when running macro

[gina6912]

Hi All,

I have a macro that copies csv files into Redshift tables and am struggling with some of the errors. What do these mean, and how can I resolve?

Error: Rename_batch_macro (16): Record #1: Tool #12: DataWrap2ODBC::SendBatch: [Amazon][Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState 42P02] ERROR: there is no parameter $-32737
Insert into schema_name.table_name (x,x,x) Values (?,?,?)

Error: Rename_batch_macro (16): Record #2: Tool #12: DataWrap2ODBC::SendBatch: [Amazon][Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState 42P02] ERROR: there is no parameter $-32768
Insert into schema_name.table_name (x,x,x) Values (?,?,?)

When I try copying in without a batch script in a regular workflow, I get another similar error:

Error: Output Data (2): DataWrap2ODBC::SendBatch: [Amazon][Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState 42P02] ERROR: there is no parameter $-32767
 Insert into schema_name.table_name (x,x,x) Values (?,?,?)

I have tried copying in some of the rows instead of the entire file, but could not find a specific issue. One warning I got was this: ConvError: Rename_batch_macro (16): Record #3: Tool #4: createdDtTime: "3/27/2020 0:30" is not a valid DateTime, but the 0:XX format worked for some other files.