So how about it, Alteryx Gurus? Is this a bug, or a chair to keyboard interface error? What can I do to solve this problem?Įrror: Output Data (152): DataWrap2ODBC::SendBatch: Duplicate entry 'aaaaa' for key 'PRIMARY' Insert into mv_employee_employment`(`HR_EMPLID`,`HR_SUPERVISOR_EMPLID`,`HR_EMPLOYMENT_STATUS`,`HR_EMPLOYMENT_TYPE`,`HR_PAYROLL_STATUS`,`HR_TERMINATION_DTTM`,`HR_DEPTID`,`HR_DEPTNAME`,`HR_LASTUPDATE_DTTM`,`HR_REG_TEMP`,`HR_FULL_PART_TIME`,`HR_FTE`,`HR_ACTION_EFFDT`,`HR_ACTION_DT`,`HR_ACTION_CODE`,`HR_ACTION_DESC`,`HR_ACTION_REASON_CODE`,`HR_ACTION_REASON_DESC`,`HR_POSITION_NBR`,`HR_JOB_CODE`,`HR_REPORTS_TO`,`HR_FLSA_STATUS`) Values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) And this causes me to get the Duplicate entry errors. But I can live with this behavior.Īt my " Update Insert if New," step, it appears to me that the warning (which I don't see, but assume is still occurring), is being taken as a reason, to do the insert.
Seems strange to say, "no record found," when a record actually was found. After searching the forums, I found a post that said if your update data is exactly the same as the database data, then you get this warning ( ). I believe the UPDATE must be succeeding because there is no rollback after the statement, but there is a rollback after the INSERT.Īt a different point in my flow, I get a lot of " Warning: Output Data (22): DataWrap2ODBC: No record found" messages. I checked my MySQL logs and I see that both the UPDATE and the INSERT statement are occurring. But that is illogical, because to get a duplicate entry error, there must exist a row that was available to be updated. I continually get a duplicate entry error at this point. At one point in my flow, I am attempting to update the database using the, " Update Insert if new" output option. I have a flow that attempts to keep a database of employee information up to date by merging data from several sources.
0 kommentar(er)
