To prevent spam users, you can only post on this forum after registration, which is by invitation. If you want to post on the forum, please send me a mail (h DOT m DOT w DOT verbeek AT tue DOT nl) and I'll send you an invitation in return for an account.
No XES file as output but no errors,too.
Hello,
I used the XESame 1.1 tool delivered with ProM 6.1 to generate a XES file for the XESame example data 'orderDemo'. The connection to the database worked after clicking on test connection and after clicking on 'excecute conversion' the console log shows that everything worked fine (in case I started the program as admin, otherwise it didn't work).
Here's the console log:
2012-06-16 17:29:38: (PROGRESS) Starting step 1 of 6: initialization.
2012-06-16 17:29:39: (PROGRESS) Starting step 2 of 6: Extracting log info.
2012-06-16 17:29:39: (PROGRESS) Starting step 3 of 6: Extracting traces.
2012-06-16 17:29:40: (PROGRESS) Starting step 4 of 6: Extracting Event: OrderCreation.
2012-06-16 17:29:40: (PROGRESS) Starting step 5 of 6: Extracting Event: OrderDelivery.
2012-06-16 17:29:40: (PROGRESS) Starting step 6 of 6: Converting Cache DB to XES.
2012-06-16 17:29:40: (PROGRESS) Mapping execution completed after 2 seconds, 435 milliseconds
The output event log location is: .\eventlog.xes
Strange is that after changing this location the entry remains '.\eventlog.xes'. However, after clicking on 'change event log file location' the last selected folder appears. Is that normal behaviour of the tool?
The real problem is now the tool doesn't store the file in my filesystem. I can't find an eventlog.xes in the location I specified and even by using the windows search functionality I couldn't figure out where it is. So I guess it wasn't generated. No errors appeared. What can I do ? Any ideas?
Best,
Herbie
I used the XESame 1.1 tool delivered with ProM 6.1 to generate a XES file for the XESame example data 'orderDemo'. The connection to the database worked after clicking on test connection and after clicking on 'excecute conversion' the console log shows that everything worked fine (in case I started the program as admin, otherwise it didn't work).
Here's the console log:
2012-06-16 17:29:38: (PROGRESS) Starting step 1 of 6: initialization.
2012-06-16 17:29:39: (PROGRESS) Starting step 2 of 6: Extracting log info.
2012-06-16 17:29:39: (PROGRESS) Starting step 3 of 6: Extracting traces.
2012-06-16 17:29:40: (PROGRESS) Starting step 4 of 6: Extracting Event: OrderCreation.
2012-06-16 17:29:40: (PROGRESS) Starting step 5 of 6: Extracting Event: OrderDelivery.
2012-06-16 17:29:40: (PROGRESS) Starting step 6 of 6: Converting Cache DB to XES.
2012-06-16 17:29:40: (PROGRESS) Mapping execution completed after 2 seconds, 435 milliseconds
The output event log location is: .\eventlog.xes
Strange is that after changing this location the entry remains '.\eventlog.xes'. However, after clicking on 'change event log file location' the last selected folder appears. Is that normal behaviour of the tool?
The real problem is now the tool doesn't store the file in my filesystem. I can't find an eventlog.xes in the location I specified and even by using the windows search functionality I couldn't figure out where it is. So I guess it wasn't generated. No errors appeared. What can I do ? Any ideas?
Best,
Herbie
Answers
-
Hi Herbie,
You could try/check the following things:
1) did you enter a mapping for the log, trace and event levels? Looking at your running time it seems that no data is selected
2) If you entered a mapping, are you sure that traces are returned? You can set the message level to verbose to see all data beeing selected from the data source, put in the cache database and later on translated to an event log. Please go back to the original message level when you have fixed it for better performance.
The output event log location should work but changing the textfield should not be possible, only by pressing the button and using the file selector works.
Also, if I'm right and no data was selected from the database then no file will be created (however, a warning message should be displayed, I'll write it down as an enhancement).
Let me know if this helps!
Joos Buijs
Senior Data Scientist and process mining expert at APG (Dutch pension fund executor).
Previously Assistant Professor in Process Mining at Eindhoven University of Technology -
Hey,
1) I opened the Order_demo.mapping file that includes a mapping for the example files. I see a directory log with subdirectory trace and 3 entries Event: OrderCreation, Event: OrderDelivery, OrderLine_Details
2) Here's the new log:
2012-06-18 08:04:06: (DEBUG) We are about to run the following query to extract the items for Log:
SELECT 'demo log' AS [concept_name], 'standard' AS [lifecycle_model] FROM orderline.csv AS orderline
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:name with value demo log) into the cache DB for the Log item with ID 0
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (lifecycle:model with value standard) into the cache DB for the Log item with ID 0
2012-06-18 08:04:06: (PROGRESS) Starting step 3 of 6: Extracting traces.
2012-06-18 08:04:06: (DEBUG) We are about to run the following query to extract the items for Trace:
SELECT DISTINCT ID AS [traceID], 'orderline: ' & orderline.ID AS [concept_name], '' AS [OrderLine_Details], pricetotal AS [OrderLine_Details_TotalAmount], quantity AS [OrderLine_Details_Quantity], price AS [OrderLine_Details_Price], description AS [OrderLine_Details_Description] FROM orderline.csv AS orderline
2012-06-18 08:04:06: (VERBOSE) We will insert a new trace with traceID 0.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:name with value orderline: 0) into the cache DB for the Trace item with ID 0
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (OrderLine_Details with value ) into the cache DB for the Trace item with ID 0
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (TotalAmount with value 99.9800) into the cache DB for the Attribute item with ID 3
2012-06-18 08:04:06: (VERBOSE) We will update attribute 3 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Quantity with value 1) into the cache DB for the Attribute item with ID 3
2012-06-18 08:04:06: (VERBOSE) We will update attribute 3 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Price with value 99.9800) into the cache DB for the Attribute item with ID 3
2012-06-18 08:04:06: (VERBOSE) We will update attribute 3 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Description with value John Denver's life Album (15 CD premium pack)) into the cache DB for the Attribute item with ID 3
2012-06-18 08:04:06: (VERBOSE) We will update attribute 3 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new trace with traceID 1.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:name with value orderline: 1) into the cache DB for the Trace item with ID 1
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (OrderLine_Details with value ) into the cache DB for the Trace item with ID 1
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (TotalAmount with value 24.8600) into the cache DB for the Attribute item with ID 9
2012-06-18 08:04:06: (VERBOSE) We will update attribute 9 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Quantity with value 1) into the cache DB for the Attribute item with ID 9
2012-06-18 08:04:06: (VERBOSE) We will update attribute 9 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Price with value 24.8600) into the cache DB for the Attribute item with ID 9
2012-06-18 08:04:06: (VERBOSE) We will update attribute 9 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Description with value Children Music Collection 2010 (3 CD + 2 DVD holiday pack)) into the cache DB for the Attribute item with ID 9
2012-06-18 08:04:06: (VERBOSE) We will update attribute 9 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new trace with traceID 2.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:name with value orderline: 2) into the cache DB for the Trace item with ID 2
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (OrderLine_Details with value ) into the cache DB for the Trace item with ID 2
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (TotalAmount with value 35.3600) into the cache DB for the Attribute item with ID 15
2012-06-18 08:04:06: (VERBOSE) We will update attribute 15 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Quantity with value 1) into the cache DB for the Attribute item with ID 15
2012-06-18 08:04:06: (VERBOSE) We will update attribute 15 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Price with value 35.3600) into the cache DB for the Attribute item with ID 15
2012-06-18 08:04:06: (VERBOSE) We will update attribute 15 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Description with value Trance collection of the decade (4 CD mixed)) into the cache DB for the Attribute item with ID 15
2012-06-18 08:04:06: (VERBOSE) We will update attribute 15 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new trace with traceID 3.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:name with value orderline: 3) into the cache DB for the Trace item with ID 3
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (OrderLine_Details with value ) into the cache DB for the Trace item with ID 3
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (TotalAmount with value 419.9900) into the cache DB for the Attribute item with ID 21
2012-06-18 08:04:06: (VERBOSE) We will update attribute 21 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Quantity with value 1) into the cache DB for the Attribute item with ID 21
2012-06-18 08:04:06: (VERBOSE) We will update attribute 21 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Price with value 419.9900) into the cache DB for the Attribute item with ID 21
2012-06-18 08:04:06: (VERBOSE) We will update attribute 21 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Description with value Lego Death Star (10188)) into the cache DB for the Attribute item with ID 21
2012-06-18 08:04:06: (VERBOSE) We will update attribute 21 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new trace with traceID 4.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:name with value orderline: 4) into the cache DB for the Trace item with ID 4
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (OrderLine_Details with value ) into the cache DB for the Trace item with ID 4
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (TotalAmount with value 579.9900) into the cache DB for the Attribute item with ID 27
2012-06-18 08:04:06: (VERBOSE) We will update attribute 27 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Quantity with value 1) into the cache DB for the Attribute item with ID 27
2012-06-18 08:04:06: (VERBOSE) We will update attribute 27 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Price with value 579.9900) into the cache DB for the Attribute item with ID 27
2012-06-18 08:04:06: (VERBOSE) We will update attribute 27 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Description with value Lego Ultimate Collector's Millennium Falcon (10179)) into the cache DB for the Attribute item with ID 27
2012-06-18 08:04:06: (VERBOSE) We will update attribute 27 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new trace with traceID 5.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:name with value orderline: 5) into the cache DB for the Trace item with ID 5
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (OrderLine_Details with value ) into the cache DB for the Trace item with ID 5
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (TotalAmount with value 249.9900) into the cache DB for the Attribute item with ID 33
2012-06-18 08:04:06: (VERBOSE) We will update attribute 33 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Quantity with value 1) into the cache DB for the Attribute item with ID 33
2012-06-18 08:04:06: (VERBOSE) We will update attribute 33 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Price with value 249.9900) into the cache DB for the Attribute item with ID 33
2012-06-18 08:04:06: (VERBOSE) We will update attribute 33 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Description with value Lego Republic Dropship with AT-OT Walker (10195)) into the cache DB for the Attribute item with ID 33
2012-06-18 08:04:06: (VERBOSE) We will update attribute 33 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new trace with traceID 6.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:name with value orderline: 6) into the cache DB for the Trace item with ID 6
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (OrderLine_Details with value ) into the cache DB for the Trace item with ID 6
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (TotalAmount with value 159.9800) into the cache DB for the Attribute item with ID 39
2012-06-18 08:04:06: (VERBOSE) We will update attribute 39 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Quantity with value 2) into the cache DB for the Attribute item with ID 39
2012-06-18 08:04:06: (VERBOSE) We will update attribute 39 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Price with value 79.9900) into the cache DB for the Attribute item with ID 39
2012-06-18 08:04:06: (VERBOSE) We will update attribute 39 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Description with value Hiking shoes size 28) into the cache DB for the Attribute item with ID 39
2012-06-18 08:04:06: (VERBOSE) We will update attribute 39 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new trace with traceID 7.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:name with value orderline: 7) into the cache DB for the Trace item with ID 7
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (OrderLine_Details with value ) into the cache DB for the Trace item with ID 7
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (TotalAmount with value 24.9500) into the cache DB for the Attribute item with ID 45
2012-06-18 08:04:06: (VERBOSE) We will update attribute 45 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Quantity with value 1) into the cache DB for the Attribute item with ID 45
2012-06-18 08:04:06: (VERBOSE) We will update attribute 45 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Price with value 24.9500) into the cache DB for the Attribute item with ID 45
2012-06-18 08:04:06: (VERBOSE) We will update attribute 45 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Description with value Pink sun glasses) into the cache DB for the Attribute item with ID 45
2012-06-18 08:04:06: (VERBOSE) We will update attribute 45 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new trace with traceID 8.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:name with value orderline: 8) into the cache DB for the Trace item with ID 8
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (OrderLine_Details with value ) into the cache DB for the Trace item with ID 8
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (TotalAmount with value 159.9500) into the cache DB for the Attribute item with ID 51
2012-06-18 08:04:06: (VERBOSE) We will update attribute 51 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Quantity with value 1) into the cache DB for the Attribute item with ID 51
2012-06-18 08:04:06: (VERBOSE) We will update attribute 51 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Price with value 159.9500) into the cache DB for the Attribute item with ID 51
2012-06-18 08:04:06: (VERBOSE) We will update attribute 51 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Description with value Comfort IV Child carrier) into the cache DB for the Attribute item with ID 51
2012-06-18 08:04:06: (VERBOSE) We will update attribute 51 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new trace with traceID 9.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:name with value orderline: 9) into the cache DB for the Trace item with ID 9
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (OrderLine_Details with value ) into the cache DB for the Trace item with ID 9
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (TotalAmount with value 19.9500) into the cache DB for the Attribute item with ID 57
2012-06-18 08:04:06: (VERBOSE) We will update attribute 57 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Quantity with value 1) into the cache DB for the Attribute item with ID 57
2012-06-18 08:04:06: (VERBOSE) We will update attribute 57 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Price with value 19.9500) into the cache DB for the Attribute item with ID 57
2012-06-18 08:04:06: (VERBOSE) We will update attribute 57 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Description with value Bike helmet "Dora the Explorer"-edition) into the cache DB for the Attribute item with ID 57
2012-06-18 08:04:06: (VERBOSE) We will update attribute 57 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new trace with traceID 10.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:name with value orderline: 10) into the cache DB for the Trace item with ID 10
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (OrderLine_Details with value ) into the cache DB for the Trace item with ID 10
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (TotalAmount with value 107.2500) into the cache DB for the Attribute item with ID 63
2012-06-18 08:04:06: (VERBOSE) We will update attribute 63 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Quantity with value 5) into the cache DB for the Attribute item with ID 63
2012-06-18 08:04:06: (VERBOSE) We will update attribute 63 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Price with value 21.4500) into the cache DB for the Attribute item with ID 63
2012-06-18 08:04:06: (VERBOSE) We will update attribute 63 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Description with value Hardhat) into the cache DB for the Attribute item with ID 63
2012-06-18 08:04:06: (VERBOSE) We will update attribute 63 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new trace with traceID 11.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:name with value orderline: 11) into the cache DB for the Trace item with ID 11
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (OrderLine_Details with value ) into the cache DB for the Trace item with ID 11
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (TotalAmount with value 35.3600) into the cache DB for the Attribute item with ID 69
2012-06-18 08:04:06: (VERBOSE) We will update attribute 69 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Quantity with value 1) into the cache DB for the Attribute item with ID 69
2012-06-18 08:04:06: (VERBOSE) We will update attribute 69 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Price with value 35.3600) into the cache DB for the Attribute item with ID 69
2012-06-18 08:04:06: (VERBOSE) We will update attribute 69 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Description with value Wheel assortment (55 pieces)) into the cache DB for the Attribute item with ID 69
2012-06-18 08:04:06: (VERBOSE) We will update attribute 69 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new trace with traceID 12.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:name with value orderline: 12) into the cache DB for the Trace item with ID 12
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (OrderLine_Details with value ) into the cache DB for the Trace item with ID 12
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (TotalAmount with value 54.4500) into the cache DB for the Attribute item with ID 75
2012-06-18 08:04:06: (VERBOSE) We will update attribute 75 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Quantity with value 1) into the cache DB for the Attribute item with ID 75
2012-06-18 08:04:06: (VERBOSE) We will update attribute 75 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Price with value 54.4500) into the cache DB for the Attribute item with ID 75
2012-06-18 08:04:06: (VERBOSE) We will update attribute 75 to be a meta attribute.
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (Description with value Destruction hammer) into the cache DB for the Attribute item with ID 75
2012-06-18 08:04:06: (VERBOSE) We will update attribute 75 to be a meta attribute.
2012-06-18 08:04:06: (PROGRESS) Starting step 4 of 6: Extracting Event: OrderCreation.
2012-06-18 08:04:06: (DEBUG) We are about to run the following query to detect the traceID type: SELECT orderline.ID FROM orderline.csv AS orderline INNER JOIN orderheader.csv AS orderheader ON orderheader.ID = orderline.orderID WHERE orderline.ID LIKE '123456ABCDEFG'
2012-06-18 08:04:06: (DEBUG) We are about to run the following query to extract the items for Event: OrderCreation:
SELECT orderline.ID AS [traceID], '0' AS [orderAttribute], 'order ' & orderHeader.ID AS [concept_instance], 'Order Create' AS [concept_name], 'complete' AS [lifecycle_transition], orderheader.createdBy AS [org_resource], orderheader.createdOn AS [time_timestamp] FROM orderline.csv AS orderline INNER JOIN orderheader.csv AS orderheader ON orderheader.ID = orderline.orderID WHERE (orderline.ID IN (11, 12, 3, 2, 1, 10, 0, 7, 6, 5, 4, 9, 8))
2012-06-18 08:04:06: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 0
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:instance with value order 0) into the cache DB for the Event item with ID 0
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:name with value Order Create) into the cache DB for the Event item with ID 0
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 0
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (org:resource with value Mrs Van der Aalst) into the cache DB for the Event item with ID 0
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-01-01 11:00:00.000) into the cache DB for the Event item with ID 0
2012-06-18 08:04:06: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 1
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:instance with value order 0) into the cache DB for the Event item with ID 1
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:name with value Order Create) into the cache DB for the Event item with ID 1
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 1
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (org:resource with value Mrs Van der Aalst) into the cache DB for the Event item with ID 1
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-01-01 11:00:00.000) into the cache DB for the Event item with ID 1
2012-06-18 08:04:06: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 2
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:instance with value order 0) into the cache DB for the Event item with ID 2
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:name with value Order Create) into the cache DB for the Event item with ID 2
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 2
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (org:resource with value Mrs Van der Aalst) into the cache DB for the Event item with ID 2
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-01-01 11:00:00.000) into the cache DB for the Event item with ID 2
2012-06-18 08:04:06: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 3
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:instance with value order 1) into the cache DB for the Event item with ID 3
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (concept:name with value Order Create) into the cache DB for the Event item with ID 3
2012-06-18 08:04:06: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 3
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (org:resource with value Eric) into the cache DB for the Event item with ID 3
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-01-12 16:45:00.000) into the cache DB for the Event item with ID 3
2012-06-18 08:04:07: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 4
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:instance with value order 1) into the cache DB for the Event item with ID 4
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:name with value Order Create) into the cache DB for the Event item with ID 4
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 4
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (org:resource with value Eric) into the cache DB for the Event item with ID 4
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-01-12 16:45:00.000) into the cache DB for the Event item with ID 4
2012-06-18 08:04:07: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 5
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:instance with value order 1) into the cache DB for the Event item with ID 5
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:name with value Order Create) into the cache DB for the Event item with ID 5
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 5
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (org:resource with value Eric) into the cache DB for the Event item with ID 5
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-01-12 16:45:00.000) into the cache DB for the Event item with ID 5
2012-06-18 08:04:07: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 6
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:instance with value order 2) into the cache DB for the Event item with ID 6
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:name with value Order Create) into the cache DB for the Event item with ID 6
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 6
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (org:resource with value Mrs Fletcher) into the cache DB for the Event item with ID 6
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-01-24 09:00:00.000) into the cache DB for the Event item with ID 6
2012-06-18 08:04:07: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 7
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:instance with value order 2) into the cache DB for the Event item with ID 7
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:name with value Order Create) into the cache DB for the Event item with ID 7
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 7
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (org:resource with value Mrs Fletcher) into the cache DB for the Event item with ID 7
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-01-24 09:00:00.000) into the cache DB for the Event item with ID 7
2012-06-18 08:04:07: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 8
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:instance with value order 2) into the cache DB for the Event item with ID 8
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:name with value Order Create) into the cache DB for the Event item with ID 8
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 8
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (org:resource with value Mrs Fletcher) into the cache DB for the Event item with ID 8
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-01-24 09:00:00.000) into the cache DB for the Event item with ID 8
2012-06-18 08:04:07: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 9
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:instance with value order 2) into the cache DB for the Event item with ID 9
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:name with value Order Create) into the cache DB for the Event item with ID 9
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 9
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (org:resource with value Mrs Fletcher) into the cache DB for the Event item with ID 9
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-01-24 09:00:00.000) into the cache DB for the Event item with ID 9
2012-06-18 08:04:07: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 10
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:instance with value order 3) into the cache DB for the Event item with ID 10
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:name with value Order Create) into the cache DB for the Event item with ID 10
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 10
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (org:resource with value Boudewijn) into the cache DB for the Event item with ID 10
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-02-04 19:35:00.000) into the cache DB for the Event item with ID 10
2012-06-18 08:04:07: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 11
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:instance with value order 3) into the cache DB for the Event item with ID 11
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:name with value Order Create) into the cache DB for the Event item with ID 11
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 11
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (org:resource with value Boudewijn) into the cache DB for the Event item with ID 11
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-02-04 19:35:00.000) into the cache DB for the Event item with ID 11
2012-06-18 08:04:07: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 12
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:instance with value order 3) into the cache DB for the Event item with ID 12
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:name with value Order Create) into the cache DB for the Event item with ID 12
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 12
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (org:resource with value Boudewijn) into the cache DB for the Event item with ID 12
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-02-04 19:35:00.000) into the cache DB for the Event item with ID 12
2012-06-18 08:04:07: (PROGRESS) Starting step 5 of 6: Extracting Event: OrderDelivery.
2012-06-18 08:04:07: (DEBUG) We are about to run the following query to detect the traceID type: SELECT delivery.orderlineID FROM delivery.csv AS delivery WHERE delivery.orderlineID LIKE '123456ABCDEFG'
2012-06-18 08:04:07: (DEBUG) We are about to run the following query to extract the items for Event: OrderDelivery:
SELECT delivery.orderlineID AS [traceID], '0' AS [orderAttribute], 'delivery ' & delivery.ID AS [concept_instance], 'Order Delivery' AS [concept_name], 'complete' AS [lifecycle_transition], delivery.acceptedBy AS [org_resource], delivery.deliveredOn AS [time_timestamp] FROM delivery.csv AS delivery WHERE (delivery.orderlineID IN (11, 12, 3, 2, 1, 10, 0, 7, 6, 5, 4, 9, 8))
2012-06-18 08:04:07: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 1
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:instance with value delivery 0) into the cache DB for the Event item with ID 13
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:name with value Order Delivery) into the cache DB for the Event item with ID 13
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 13
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (org:resource with value Anne) into the cache DB for the Event item with ID 13
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-01-15 15:35:00.000) into the cache DB for the Event item with ID 13
2012-06-18 08:04:07: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 2
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:instance with value delivery 1) into the cache DB for the Event item with ID 14
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:name with value Order Delivery) into the cache DB for the Event item with ID 14
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 14
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (org:resource with value Wil) into the cache DB for the Event item with ID 14
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-01-17 15:03:00.000) into the cache DB for the Event item with ID 14
2012-06-18 08:04:07: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 0
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:instance with value delivery 2) into the cache DB for the Event item with ID 15
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:name with value Order Delivery) into the cache DB for the Event item with ID 15
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 15
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (org:resource with value Mrs Van der Aalst) into the cache DB for the Event item with ID 15
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-01-21 18:43:00.000) into the cache DB for the Event item with ID 15
2012-06-18 08:04:07: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 3
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:instance with value delivery 3) into the cache DB for the Event item with ID 16
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:name with value Order Delivery) into the cache DB for the Event item with ID 16
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 16
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (org:resource with value Eric) into the cache DB for the Event item with ID 16
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-01-28 17:54:00.000) into the cache DB for the Event item with ID 16
2012-06-18 08:04:07: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 4
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:instance with value delivery 4) into the cache DB for the Event item with ID 17
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:name with value Order Delivery) into the cache DB for the Event item with ID 17
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 17
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (org:resource with value Eric) into the cache DB for the Event item with ID 17
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-01-28 17:54:00.000) into the cache DB for the Event item with ID 17
2012-06-18 08:04:07: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 5
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:instance with value delivery 5) into the cache DB for the Event item with ID 18
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:name with value Order Delivery) into the cache DB for the Event item with ID 18
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 18
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (org:resource with value Eric) into the cache DB for the Event item with ID 18
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-01-28 17:54:00.000) into the cache DB for the Event item with ID 18
2012-06-18 08:04:07: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 6
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:instance with value delivery 6) into the cache DB for the Event item with ID 19
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:name with value Order Delivery) into the cache DB for the Event item with ID 19
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 19
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (org:resource with value Mrs Fletcher) into the cache DB for the Event item with ID 19
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-02-01 11:03:00.000) into the cache DB for the Event item with ID 19
2012-06-18 08:04:07: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 7
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:instance with value delivery 7) into the cache DB for the Event item with ID 20
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:name with value Order Delivery) into the cache DB for the Event item with ID 20
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 20
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (org:resource with value Mrs Fletcher) into the cache DB for the Event item with ID 20
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-02-05 14:07:00.000) into the cache DB for the Event item with ID 20
2012-06-18 08:04:07: (VERBOSE) We will insert a new event (with order value 0) into the cache DB for trace 9
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:instance with value delivery 8) into the cache DB for the Event item with ID 21
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (concept:name with value Order Delivery) into the cache DB for the Event item with ID 21
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (lifecycle:transition with value complete) into the cache DB for the Event item with ID 21
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (org:resource with value Mrs Fletcher) into the cache DB for the Event item with ID 21
2012-06-18 08:04:07: (VERBOSE) We will insert a new attribute (time:timestamp with value 2010-02-05 14:07:00.000) into the cache DB for the Event item with ID 21
2012-06-18 08:04:07: (PROGRESS) Starting step 6 of 6: Converting Cache DB to XES.
2012-06-18 08:04:07: (VERBOSE) ---- Contents of table XLog
2012-06-18 08:04:07: (VERBOSE) Column 1 is JDBC type 4, which the DBMS calls INTEGER
ID
0
2012-06-18 08:04:07: (VERBOSE) ---- Contents of table XTrace
2012-06-18 08:04:07: (VERBOSE) Column 1 is JDBC type 12, which the DBMS calls VARCHAR
Column 2 is JDBC type 4, which the DBMS calls INTEGER
TRACEID, LOGID
0, 0
1, 0
2, 0
3, 0
4, 0
5, 0
6, 0
7, 0
8, 0
9, 0
10, 0
11, 0
12, 0
2012-06-18 08:04:07: (VERBOSE) ---- Contents of table XEvent
2012-06-18 08:04:07: (VERBOSE) Column 1 is JDBC type 4, which the DBMS calls INTEGER
Column 2 is JDBC type 12, which the DBMS calls VARCHAR
Column 3 is JDBC type 12, which the DBMS calls VARCHAR
ID, TRACEID, ORDERVALUE
0, 0, 0
1, 1, 0
2, 2, 0
3, 3, 0
4, 4, 0
5, 5, 0
6, 6, 0
7, 7, 0
8, 8, 0
9, 9, 0
10, 10, 0
11, 11, 0
12, 12, 0
13, 1, 0
14, 2, 0
15, 0, 0
16, 3, 0
17, 4, 0
18, 5, 0
19, 6, 0
20, 7, 0
21, 9, 0
2012-06-18 08:04:07: (VERBOSE) ---- Contents of table XAttribute
2012-06-18 08:04:07: (VERBOSE) Column 1 is JDBC type 4, which the DBMS calls INTEGER
Column 2 is JDBC type 4, which the DBMS calls INTEGER
Column 3 is JDBC type 12, which the DBMS calls VARCHAR
Column 4 is JDBC type 4, which the DBMS calls INTEGER
Column 5 is JDBC type 4, which the DBMS calls INTEGER
Column 6 is JDBC type 12, which the DBMS calls VARCHAR
Column 7 is JDBC type 12, which the DBMS calls VARCHAR
Column 8 is JDBC type 12, which the DBMS calls VARCHAR
Column 9 is JDBC type 16, which the DBMS calls BOOLEAN
ID, LOGID, TRACEID, EVENTID, ATTRIBUTEID, XKEY, XVALUE, XTYPE, ISMETA
0, 0, null, null, null, concept:name, demo log, String, false
1, 0, null, null, null, lifecycle:model, standard, String, false
2, null, 0, null, null, concept:name, orderline: 0, String, false
3, null, 0, null, null, OrderLine_Details, , String, true
4, null, null, null, 3, TotalAmount, 99.9800, String, false
5, null, null, null, 3, Quantity, 1, String, false
6, null, null, null, 3, Price, 99.9800, String, false
7, null, null, null, 3, Description, John Denver's life Album (15 CD premium pack), String, false
8, null, 1, null, null, concept:name, orderline: 1, String, false
9, null, 1, null, null, OrderLine_Details, , String, true
10, null, null, null, 9, TotalAmount, 24.8600, String, false
11, null, null, null, 9, Quantity, 1, String, false
12, null, null, null, 9, Price, 24.8600, String, false
13, null, null, null, 9, Description, Children Music Collection 2010 (3 CD + 2 DVD holiday pack), String, false
14, null, 2, null, null, concept:name, orderline: 2, String, false
15, null, 2, null, null, OrderLine_Details, , String, true
16, null, null, null, 15, TotalAmount, 35.3600, String, false
17, null, null, null, 15, Quantity, 1, String, false
18, null, null, null, 15, Price, 35.3600, String, false
19, null, null, null, 15, Description, Trance collection of the decade (4 CD mixed), String, false
20, null, 3, null, null, concept:name, orderline: 3, String, false
21, null, 3, null, null, OrderLine_Details, , String, true
22, null, null, null, 21, TotalAmount, 419.9900, String, false
23, null, null, null, 21, Quantity, 1, String, false
24, null, null, null, 21, Price, 419.9900, String, false
25, null, null, null, 21, Description, Lego Death Star (10188), String, false
26, null, 4, null, null, concept:name, orderline: 4, String, false
27, null, 4, null, null, OrderLine_Details, , String, true
28, null, null, null, 27, TotalAmount, 579.9900, String, false
29, null, null, null, 27, Quantity, 1, String, false
30, null, null, null, 27, Price, 579.9900, String, false
31, null, null, null, 27, Description, Lego Ultimate Collector's Millennium Falcon (10179), String, false
32, null, 5, null, null, concept:name, orderline: 5, String, false
33, null, 5, null, null, OrderLine_Details, , String, true
34, null, null, null, 33, TotalAmount, 249.9900, String, false
35, null, null, null, 33, Quantity, 1, String, false
36, null, null, null, 33, Price, 249.9900, String, false
37, null, null, null, 33, Description, Lego Republic Dropship with AT-OT Walker (10195), String, false
38, null, 6, null, null, concept:name, orderline: 6, String, false
39, null, 6, null, null, OrderLine_Details, , String, true
40, null, null, null, 39, TotalAmount, 159.9800, String, false
41, null, null, null, 39, Quantity, 2, String, false
42, null, null, null, 39, Price, 79.9900, String, false
43, null, null, null, 39, Description, Hiking shoes size 28, String, false
44, null, 7, null, null, concept:name, orderline: 7, String, false
45, null, 7, null, null, OrderLine_Details, , String, true
46, null, null, null, 45, TotalAmount, 24.9500, String, false
47, null, null, null, 45, Quantity, 1, String, false
48, null, null, null, 45, Price, 24.9500, String, false
49, null, null, null, 45, Description, Pink sun glasses, String, false
50, null, 8, null, null, concept:name, orderline: 8, String, false
51, null, 8, null, null, OrderLine_Details, , String, true
52, null, null, null, 51, TotalAmount, 159.9500, String, false
53, null, null, null, 51, Quantity, 1, String, false
54, null, null, null, 51, Price, 159.9500, String, false
55, null, null, null, 51, Description, Comfort IV Child carrier, String, false
56, null, 9, null, null, concept:name, orderline: 9, String, false
57, null, 9, null, null, OrderLine_Details, , String, true
58, null, null, null, 57, TotalAmount, 19.9500, String, false
59, null, null, null, 57, Quantity, 1, String, false
60, null, null, null, 57, Price, 19.9500, String, false
61, null, null, null, 57, Description, Bike helmet "Dora the Explorer"-edition, String, false
62, null, 10, null, null, concept:name, orderline: 10, String, false
63, null, 10, null, null, OrderLine_Details, , String, true
64, null, null, null, 63, TotalAmount, 107.2500, String, false
65, null, null, null, 63, Quantity, 5, String, false
66, null, null, null, 63, Price, 21.4500, String, false
67, null, null, null, 63, Description, Hardhat, String, false
68, null, 11, null, null, concept:name, orderline: 11, String, false
69, null, 11, null, null, OrderLine_Details, , String, true
70, null, null, null, 69, TotalAmount, 35.3600, String, false
71, null, null, null, 69, Quantity, 1, String, false
72, null, null, null, 69, Price, 35.3600, String, false
73, null, null, null, 69, Description, Wheel assortment (55 pieces), String, false
74, null, 12, null, null, concept:name, orderline: 12, String, false
75, null, 12, null, null, OrderLine_Details, , String, true
76, null, null, null, 75, TotalAmount, 54.4500, String, false
77, null, null, null, 75, Quantity, 1, String, false
78, null, null, null, 75, Price, 54.4500, String, false
79, null, null, null, 75, Description, Destruction hammer, String, false
80, null, null, 0, null, concept:instance, order 0, String, false
81, null, null, 0, null, concept:name, Order Create, String, false
82, null, null, 0, null, lifecycle:transition, complete, String, false
83, null, null, 0, null, org:resource, Mrs Van der Aalst, String, false
84, null, null, 0, null, time:timestamp, 2010-01-01 11:00:00.000, Date, false
85, null, null, 1, null, concept:instance, order 0, String, false
86, null, null, 1, null, concept:name, Order Create, String, false
87, null, null, 1, null, lifecycle:transition, complete, String, false
88, null, null, 1, null, org:resource, Mrs Van der Aalst, String, false
89, null, null, 1, null, time:timestamp, 2010-01-01 11:00:00.000, Date, false
90, null, null, 2, null, concept:instance, order 0, String, false
91, null, null, 2, null, concept:name, Order Create, String, false
92, null, null, 2, null, lifecycle:transition, complete, String, false
93, null, null, 2, null, org:resource, Mrs Van der Aalst, String, false
94, null, null, 2, null, time:timestamp, 2010-01-01 11:00:00.000, Date, false
95, null, null, 3, null, concept:instance, order 1, String, false
96, null, null, 3, null, concept:name, Order Create, String, false
97, null, null, 3, null, lifecycle:transition, complete, String, false
98, null, null, 3, null, org:resource, Eric, String, false
99, null, null, 3, null, time:timestamp, 2010-01-12 16:45:00.000, Date, false
100, null, null, 4, null, concept:instance, order 1, String, false
101, null, null, 4, null, concept:name, Order Create, String, false
102, null, null, 4, null, lifecycle:transition, complete, String, false
103, null, null, 4, null, org:resource, Eric, String, false
104, null, null, 4, null, time:timestamp, 2010-01-12 16:45:00.000, Date, false
105, null, null, 5, null, concept:instance, order 1, String, false
106, null, null, 5, null, concept:name, Order Create, String, false
107, null, null, 5, null, lifecycle:transition, complete, String, false
108, null, null, 5, null, org:resource, Eric, String, false
109, null, null, 5, null, time:timestamp, 2010-01-12 16:45:00.000, Date, false
110, null, null, 6, null, concept:instance, order 2, String, false
111, null, null, 6, null, concept:name, Order Create, String, false
112, null, null, 6, null, lifecycle:transition, complete, String, false
113, null, null, 6, null, org:resource, Mrs Fletcher, String, false
114, null, null, 6, null, time:timestamp, 2010-01-24 09:00:00.000, Date, false
115, null, null, 7, null, concept:instance, order 2, String, false
116, null, null, 7, null, concept:name, Order Create, String, false
117, null, null, 7, null, lifecycle:transition, complete, String, false
118, null, null, 7, null, org:resource, Mrs Fletcher, String, false
119, null, null, 7, null, time:timestamp, 2010-01-24 09:00:00.000, Date, false
120, null, null, 8, null, concept:instance, order 2, String, false
121, null, null, 8, null, concept:name, Order Create, String, false
122, null, null, 8, null, lifecycle:transition, complete, String, false
123, null, null, 8, null, org:resource, Mrs Fletcher, String, false
124, null, null, 8, null, time:timestamp, 2010-01-24 09:00:00.000, Date, false
125, null, null, 9, null, concept:instance, order 2, String, false
126, null, null, 9, null, concept:name, Order Create, String, false
127, null, null, 9, null, lifecycle:transition, complete, String, false
128, null, null, 9, null, org:resource, Mrs Fletcher, String, false
129, null, null, 9, null, time:timestamp, 2010-01-24 09:00:00.000, Date, false
130, null, null, 10, null, concept:instance, order 3, String, false
131, null, null, 10, null, concept:name, Order Create, String, false
132, null, null, 10, null, lifecycle:transition, complete, String, false
133, null, null, 10, null, org:resource, Boudewijn, String, false
134, null, null, 10, null, time:timestamp, 2010-02-04 19:35:00.000, Date, false
135, null, null, 11, null, concept:instance, order 3, String, false
136, null, null, 11, null, concept:name, Order Create, String, false
137, null, null, 11, null, lifecycle:transition, complete, String, false
138, null, null, 11, null, org:resource, Boudewijn, String, false
139, null, null, 11, null, time:timestamp, 2010-02-04 19:35:00.000, Date, false
140, null, null, 12, null, concept:instance, order 3, String, false
141, null, null, 12, null, concept:name, Order Create, String, false
142, null, null, 12, null, lifecycle:transition, complete, String, false
143, null, null, 12, null, org:resource, Boudewijn, String, false
144, null, null, 12, null, time:timestamp, 2010-02-04 19:35:00.000, Date, false
145, null, null, 13, null, concept:instance, delivery 0, String, false
146, null, null, 13, null, concept:name, Order Delivery, String, false
147, null, null, 13, null, lifecycle:transition, complete, String, false
148, null, null, 13, null, org:resource, Anne, String, false
149, null, null, 13, null, time:timestamp, 2010-01-15 15:35:00.000, Date, false
150, null, null, 14, null, concept:instance, delivery 1, String, false
151, null, null, 14, null, concept:name, Order Delivery, String, false
152, null, null, 14, null, lifecycle:transition, complete, String, false
153, null, null, 14, null, org:resource, Wil, String, false
154, null, null, 14, null, time:timestamp, 2010-01-17 15:03:00.000, Date, false
155, null, null, 15, null, concept:instance, delivery 2, String, false
156, null, null, 15, null, concept:name, Order Delivery, String, false
157, null, null, 15, null, lifecycle:transition, complete, String, false
158, null, null, 15, null, org:resource, Mrs Van der Aalst, String, false
159, null, null, 15, null, time:timestamp, 2010-01-21 18:43:00.000, Date, false
160, null, null, 16, null, concept:instance, delivery 3, String, false
161, null, null, 16, null, concept:name, Order Delivery, String, false
162, null, null, 16, null, lifecycle:transition, complete, String, false
163, null, null, 16, null, org:resource, Eric, String, false
164, null, null, 16, null, time:timestamp, 2010-01-28 17:54:00.000, Date, false
165, null, null, 17, null, concept:instance, delivery 4, String, false
166, null, null, 17, null, concept:name, Order Delivery, String, false
167, null, null, 17, null, lifecycle:transition, complete, String, false
168, null, null, 17, null, org:resource, Eric, String, false
169, null, null, 17, null, time:timestamp, 2010-01-28 17:54:00.000, Date, false
170, null, null, 18, null, concept:instance, delivery 5, String, false
171, null, null, 18, null, concept:name, Order Delivery, String, false
172, null, null, 18, null, lifecycle:transition, complete, String, false
173, null, null, 18, null, org:resource, Eric, String, false
174, null, null, 18, null, time:timestamp, 2010-01-28 17:54:00.000, Date, false
175, null, null, 19, null, concept:instance, delivery 6, String, false
176, null, null, 19, null, concept:name, Order Delivery, String, false
177, null, null, 19, null, lifecycle:transition, complete, String, false
178, null, null, 19, null, org:resource, Mrs Fletcher, String, false
179, null, null, 19, null, time:timestamp, 2010-02-01 11:03:00.000, Date, false
180, null, null, 20, null, concept:instance, delivery 7, String, false
181, null, null, 20, null, concept:name, Order Delivery, String, false
182, null, null, 20, null, lifecycle:transition, complete, String, false
183, null, null, 20, null, org:resource, Mrs Fletcher, String, false
184, null, null, 20, null, time:timestamp, 2010-02-05 14:07:00.000, Date, false
185, null, null, 21, null, concept:instance, delivery 8, String, false
186, null, null, 21, null, concept:name, Order Delivery, String, false
187, null, null, 21, null, lifecycle:transition, complete, String, false
188, null, null, 21, null, org:resource, Mrs Fletcher, String, false
189, null, null, 21, null, time:timestamp, 2010-02-05 14:07:00.000, Date, false
2012-06-18 08:04:07: (PROGRESS) Mapping execution completed after 1 seconds, 607 milliseconds
Best,
Herbie
-
That looks correct...
Joos Buijs
Senior Data Scientist and process mining expert at APG (Dutch pension fund executor).
Previously Assistant Professor in Process Mining at Eindhoven University of Technology -
hmm strange... are there any known problems with Win 7 64 Bit OS?
-
The only thing I can think of is that XESame does not have the right to write the event log at the location you tell it to. This is a Windows 7 security issue...
Also, if the location of the event log is not updated, even after closing and restarting XESame, this means that XESame can also not write its persistent values in the workspace file (located in the .ProM folder located in your user folder).
Did you try running XESame as administrator???
Joos Buijs
Senior Data Scientist and process mining expert at APG (Dutch pension fund executor).
Previously Assistant Professor in Process Mining at Eindhoven University of Technology -
Yes, I always run it as admin.
-
Recognized another strange error. When trying to import files in ProM 6.1 nothing happens. (Detailed: Open ProM6.1, having installed some plugins like the alpha miner and so on before, clicking on import..., selecting an example xes file of the ProM website and clicking OK in the file selection dialog, nothing happens then).
But when using the older ProM version 5.2 and importing a mxml file everything works fine...
Don't know what's the problem but the newer versions of the tools don't seem to be working stable for every user. Perhaps I'll try to get an older XESame version and try again,too.
-
Both errors do indicate that ProM and XESame (which use the same underlying code) can not write or update the necessary files in the .ProM folder. I would investigate that further if I were you.
Joos Buijs
Senior Data Scientist and process mining expert at APG (Dutch pension fund executor).
Previously Assistant Professor in Process Mining at Eindhoven University of Technology
Howdy, Stranger!
Categories
- 1.6K All Categories
- 45 Announcements / News
- 225 Process Mining
- 6 - BPI Challenge 2020
- 9 - BPI Challenge 2019
- 24 - BPI Challenge 2018
- 27 - BPI Challenge 2017
- 8 - BPI Challenge 2016
- 68 Research
- 1K ProM 6
- 394 - Usage
- 288 - Development
- 9 RapidProM
- 1 - Usage
- 7 - Development
- 54 ProM5
- 19 - Usage
- 187 Event Logs
- 32 - ProMimport
- 75 - XESame