While trying to upload assignments to our questionnaire, 3 of the ~35000 assignments failed. The invalid assignment file contains this:
One or more handlers failed when publishing 1 events. First event source id: cb1bc6d299a241099273dca94fc9ef15. (EventHandlerException: could not insert: [WB.Core.BoundedContexts.Headquarters.Assignments.AssignmentGps][SQL: INSERT INTO assignment_geo_answers (assignment_id, QuestionId, RosterVector, Latitude, Longitude, timestamp) VALUES (?, ?, ?, ?, ?, ?) returning Id])
One or more handlers failed when publishing 1 events. First event source id: bf8ee6932e744139abcfb175d72a09d5. (EventHandlerException: could not insert: [WB.Core.BoundedContexts.Headquarters.Assignments.AssignmentGps][SQL: INSERT INTO assignment_geo_answers (assignment_id, QuestionId, RosterVector, Latitude, Longitude, timestamp) VALUES (?, ?, ?, ?, ?, ?) returning Id])
One or more handlers failed when publishing 1 events. First event source id: 6c8b3db104c74a67b0c4918639e98412. (EventHandlerException: could not insert: [WB.Core.BoundedContexts.Headquarters.Assignments.AssignmentGps][SQL: INSERT INTO assignment_geo_answers (assignment_id, QuestionId, RosterVector, Latitude, Longitude, timestamp) VALUES (?, ?, ?, ?, ?, ?) returning Id])
I don’t see any obvious errors in the GPS data that we are pre-loading. About 2000 assignments have the preloaded GPS data missing, but only these 3 fail. How can I locate the problem assignments?
Twice today while testing our preload data and creating assignment, got a screen saying xxx assignments successfully created, only to find no assignments.
Dear @ashwinikalantri ,
I know you are an experienced Survey Solutions user, but I have tried to reproduce this issue and the system works fine for me. Could you please verify that you are looking for assignments in the workspace where you created them.
@vfedoseev, yes, I am looking in the same workspace. As you can see in the screenshot of the logs below, the assignments were created but the assignment numbers say 0-0
Hello @ashwinikalantri , you wrote that you think that having 3 duplicate records in the uploaded assignments file was causing the problem. This is unexpected. Survey Solutions does not control for the presence of duplicate data in the uploaded assignments, unless it relates to identification of subordinate records (such as, for example, id of a person within a household), and you should get a different error message with that being the case.
Could you please elaborate? And possibly retry uploading just the three records that were causing the issue?
Dear @ashwinikalantri thank you very much for the helpful details. This explains why the corresponding assignments were not created, though the errors entries are not informative. I’d anticipate a PL0006 error for such a case.
