Forum Discussion
0x80040e4 error on refresh
Hi Jorismo,
The table SLA Violations used to have a unique value for each Ticket Number. For some reason (this could be in the source database) the ticket number in the table SLA Violations is not unique anymore. There are duplicate values. This is a problem in the one side of a one-to-many relationship. Basically it links by the ticket number from a table where ticket number exists multiple times, to the SLA Violation table where it tries to look up the Ticket number and finds more than one row.
You should look at the source (in edit query or your source system) , figure out why you have a duplicate value, and try to solve it for the future.
Hope this helps.
Impactful IndividualHi Jorismo,
The table SLA Violations used to have a unique value for each Ticket Number. For some reason (this could be in the source database) the ticket number in the table SLA Violations is not unique anymore. There are duplicate values. This is a problem in the one side of a one-to-many relationship. Basically it links by the ticket number from a table where ticket number exists multiple times, to the SLA Violation table where it tries to look up the Ticket number and finds more than one row.
You should look at the source (in edit query or your source system) , figure out why you have a duplicate value, and try to solve it for the future.
Hope this helps.
Ok, I made an adjustment in my query.
Now the ticketnumber is received from the original Ticket_number table.
Problem solved, thanks for your help!