Conversion Problems - Execute the Querie
Could somebody help me.
I followed the XeSame - example. My settings you can see in the both screenshots.
The connection to the mySQL DB works.
When I execute the conversion I get the following Errors:
2015-03-09 15:23:14: (PROGRESS) Starting step 1 of 5: initialization.2015-03-09 15:23:15: (PROGRESS) Starting step 2 of 5: Extracting log info.
2015-03-09 15:23:15: (DEBUG) We are about to run the following query to extract the items for Log: SELECT 'TestLog' AS [concept_name], 'standard' AS [lifecycle_model], 'Generation Details' AS [Generation_Details], 'Joos Buijs' AS [Generation_Details_Author], NOW() AS [Generation_Details_generated_on] FROM events.csv AS events WHERE orderID < 100
2015-03-09 15:23:15: (ERROR) There is an error in the query (turn on 'debug' mode to see it) to fetch the information for Log. Please make sure that the query syntax is valid for the source database.
2015-03-09 15:23:15: (ERROR) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[concept_name], 'standard' AS [lifecycle_model], 'Generation Details' AS [Genera' at line 1
2015-03-09 15:23:15: (WARNING) Cancelling execution! Just after running the query.
2015-03-09 15:23:15: (NOTICE) Execution safely terminated
I also tried a connection to a postgreSQL 9.4 DB, but it doesn't work, too.It' s another Error Code, but similar --> "the event.csv could not find"
What is my mistake?
Thanks
Marcel
Answers
-
Hi, I am using MySQL and my setting for 'URL to database' at Connection tab is something like:jdbc:mysql://IP:PORT/database_name?user=USERNAME&password=PASSWORD Then you can click on Test connection to see if it's ok.
-
Dear Marcel,
The query in the example is written for the Windows connection to CSV files.
Since you're using MySQL (I'm assuming that you imported the csv files to the corresponding tables), the query does not work. Off the top of my head, it might have something to do with the '[' and ']', as specified in the "SQL Query Columns Seperator" in the connection settings tab. You might want to try to have both of these seperator fields empty.
Please let us know if this works.
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
- 393 - Usage
- 287 - Development
- 9 RapidProM
- 1 - Usage
- 7 - Development
- 54 ProM5
- 19 - Usage
- 187 Event Logs
- 32 - ProMimport
- 75 - XESame