"Invalid Cursor State" error when trying to output to SQL Server

Question

I am trying to import a table from SQL Server, make a few changes, and then output back to the same table. On the output I am getting the following error:

"Error: Output Data (137): DataWrap2ODBC: [Microsoft][SQL Server Native Client 11.0]Invalid cursor state UPDATE TEST.dbo.users SET"

followed by every field name in the data =? (so first_name=?, last_name =?, etc.).

It says this is occurring on record 2. I filtered out the second record and re-ran the workflow and I am getting the same error still saying it is occurring on the new second record. If I filter to update only one record the workflow runs without any errors, but as soon as there is more than one record on the output there is an error.

It seems to me that there is maybe an issue with a delimiter from one record to the next, but this is very odd because I am also connecting to and pushing back to another table in the same database without issue.

Attached is the configuration for my Output tool.

Any insight into where I may be going wrong?

Thanks!

Invalid Cursor State.png

bpate05 · Answer

Thank you for the reply.

I took text inputs of the metadata for the input and the output data and joined the two on Name, Type, and Size and all 70 fields joined. So it looks like there is no difference in the field names, data types, size, or schema.

mceleavey · Answer

Hi @bpate05 ,

You're updating an existing SQL table so you need to output the exact same columns and they need to be mapped to the columns in the SQL table. You might be right in that a delimiter is throwing the columns. Ensure that all columns in your data match the columns in the table and are mapped accordingly,  and you have no extra columns.

M.