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?
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).
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
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).
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.