This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am getting a consistent error when I am trying to output data. I have tried so many things to resolve but I consistently get the same error.
Here is the error: Output Data (2) DataWrap2ODBC::SendBatch: [MySQL][ODBC 5.3(a) Driver][mysqld-5.7.12-enterprise-commercial-advanced-log]Duplicate entry '94771789' for key 'PRIMARY' Insert into `SPER_Requests`(`REQUEST_ID`,`INITIAL_REQUEST_DATE`,`LAST_REQUESTED_DATE`,`REQUEST_TYPE`,`SECURITY_ID`,`SECURITY_ID_TYPE`,`GLOBAL_CUST_ID`,`ADDED_DATE`,`STATUS`,`STATUS_DESC`,`OWNER`,`OWNER_DESC`,`PORTFOLIO_ID`,`NAME`,`LAST_UPDATED_DATE`) Values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Has anyone experienced this? it seems like the database is telling me that what I am trying to enter into it, is already there, but my query is pulling CURRENT dates. Do I need to remove some rows from my database in order to move forward with fresh data?
tl;dr - create a new field that is always changing so that it updates the record in mysql
Definitely late to the game here, but i was having issues with this recently and some pieces that i think helped (not exactly sure why) are:
field types are exactly the same (along with size)
you are inserting the same fields (order doesn't matter)
All of the above is what you've probably already seen in other forums along with correct collation, etc...
BUT the solution that made the biggest difference is making sure SOMETHING changes when you update a record. For this, i use a new field "update_datetime" and i just overwrite the value with the datetimestart() value (or heck, even a random number would work here). It forces the database to update the entire record even nothing material has changed.