![]() T13:58:46.992668Z 15 Query set 15 Execute UPDATE `mv_employee_role_info` SET `AD_TITLE`='None', `HR_SUPERVISORY_LEVEL`='SPVSRY', `HR_MANAGER_LEVEL`='7', `HR_JOB_CODE`='cccccc', `HR_LASTUPDATE_DTTM`=' 00:00:00', `HR_MANAGER_LEVEL_DESCR`='Supervisor', `HR_TITLE`='Super-Water Quality Lab' WHERE `HR_EMPLID`='aaaaa' T13:58:46.977052Z 15 Query SELECT `HR_EMPLID`, `AD_TITLE`, `HR_SUPERVISORY_LEVEL`, `HR_MANAGER_LEVEL`, `HR_JOB_CODE`, `HR_LASTUPDATE_DTTM`, `HR_MANAGER_LEVEL_DESCR`, `HR_TITLE` FROM `mv_employee_role_info` 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |