Duplicate values Event_ID and Case_ID

Help Process Mining
1

Hi,

I am using the Order-to-Cash template for SAP that has been created by UiPath to apply Process Mining on this process for our company.

I have been able to load all the data without any failure, but when I select ‘Apply to dashboards’ I receive the error that the fields EventId and CaseID in the table __pmt_input_EventLog contain duplicate values.

When I check the tables Sales_order_item_event_log_base and Sales_order_item_end_to_end_events there are no duplicate values for these fields.

Where can I find the configuration for creating the table ‘__pmt_input_EventLog’ and how to solve this issue?

Kind regards,

Roy

2

@roy.van.buuren

check if there are any blank rows as such

cheers

3

Hi @Anil_G,

Thanks for the feedback, the thing is that I can’t find the sql query script within the transformations that relates to the creation of the table __pmt_input_EventLog.

When I check the event tables ‘Sales_order_item_end_to_end_events’ and ‘Sales_order_item_event_log_base’ they do not contain blank rows.

Kind regards,

Roy

4

Hello,

@roy.van.buuren please file a support ticket as this might require more specific details for investigation.

Thank you!

5

Please also double check the record count of the tables and number of unique values for Sales_order_item_ID and Event_ID in the Sales_order_item_end_to_end_events table.

7

Hi @cristina.avram

I indeed checked for duplicate Event_Id’s and these are not present within Sales_order_item_end_to_end_events.

There are duplicate values for Sales_order_item_ID, but I would expect this because otherwise there could not be made a flow of events. Or do you mean duplicates of the combination of

I will register a support ticket.

Kind regards.

Roy
[/quote]