This is actually not an error it's just a warning and as such won't cause the graph failure. However, the graph (or the component) cannot inform you whether the fields in the DBOutputTable are compatible with the fields in the database and that may cause an error (if they don't match). This warning is there because the driver cannot provide this compatibility check and is more or less useless (the information itself). There is already a ticket
in our system and this warning will be probably removed in some of our future releases.
So if the component is set correctly, then the records are successfully written into the database as you can see when you check the database via some external tool.
The reason why you are getting some invalid values from the DBExecute
is that it is not designed for input and select statements. For these operations you should always use DBInputTable
. It is quite hard to set the DBExecute to read/write information from/to a database. Therefore we have three basic database components. So if you want to load the records from the database, please use the DBInputTable.