Hello All,
Looking for help where the insert statement is not writing a newly added field data to sql table field.
I added a new field to JDBC flow insert statement called for eg:"User Access" along with all other previously added columns . When I test the JDBC , manually entering values all values get inserted into SQL table with out issues including the newly added column. But when I am executing via flow by entering data in the form, all the other values get inserted in to the SQL table except for the newly added value for "User Access".
- When I check flow executions, it shows values for all the fields. the insert statement also have all values . When I copy the insert statement with values directly to SQL and execute, it writes to the table and all the columns.
- I tried to move the columns around in the flow insert and tried to execute and the result is the same all other field values are written except for the newly added field value.
- Checked for column name type etc and they are all good.
Unable to figure what is done wrong that the newly added field value is not getting inserted. Please advise.
TIA
