error in step2 of conversion

khadije

hello
after making my own mapping and checking connection to database I started conversion and faced this error in Console tab:
2015-08-29 10:35:23: (PROGRESS) Starting step 1 of 6: initialization.
2015-08-29 10:35:27: (PROGRESS) Starting step 2 of 6: Extracting log info.
2015-08-29 10:35:27: (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-08-29 10:35:27: (ERROR) [Microsoft][ODBC Text Driver] Syntax error (missing operator) in query expression 'test log'.
2015-08-29 10:35:27: (WARNING) Cancelling execution! Just after running the query.
2015-08-29 10:35:28: (NOTICE) Execution safely terminated

it should be mentioned that my mapping definition is as this:
Attributes tab for Log 

false	concept:name	test log	String	Concept
false	lifecycle:model		String	Lifecycle
false	semantic:modelReference		String	Semantic

properties tab for Log

From	data21.csv AS data21
Where

classifier tab for Log

Activity classifier	concept:name lifecycle:transition
Resource classifier	org:resource

Attributes for trace	concept:name	Case ID	String	Concept
	semantic:modelReference		String	Semantic

properties tab for trace From	data21.csv AS data21
Where
TraceID	Case ID

Attributes tab for event: start event	concept:instance	Case ID	String	Concept
	concept:name	data21.Activity	String	Concept
	lifecycle:transition	"start"	String	Lifecycle
	org:group		String	Organizational
	org:resource	Resource	String	Organizational
	org:role	Agent Position	String	Organizational
	time:timestamp	Start Date [{dd.MM.yy HH:mm}]	Date	Time
	semantic:modelReference		String	Semantic

  properties tab for event: start event

From	data21.cvs AS data21
Where
TraceID	Case ID
EventOrder	timestamp

	Attributes tab for Event:complete event  concept:instance	Case ID	String	Concept
	concept:name	data21.Acitity	String	Concept
	lifecycle:transition	"complete"	String	Lifecycle
	org:group		String	Organizational
	org:resource	Resource	String	Organizational
	org:role	Agent Position	String	Organizational
	time:timestamp	End Date [{dd.MM.yy HH:mm}]	Date	Time
	semantic:modelReference		String	Semantic

properties tab for From	Event:complete event data21.cvs AS data21
Where
TraceID	Case ID
EventOrder	timeatamp

I don't know whats wrong and what should I do. could any one help me??
I would appreciate any comment

JBuijs

Dear khadije,

Are you sure you filled in the properties of teh event log object? It needs a table to run a query, even if none are used to extract event log properties.

If this does not help, could you run the mapping again after setting the console logging detail level to debug? This will print the SQL queries send to the database so I can suggest corrections.

khadije

Hi Dr Buijs
thanks a lot for your help. the properties is filled as above. I made your 2th suggestion and it is all printed in console:
2015-08-31 12:23:56: (PROGRESS) Starting step 1 of 6: initialization.
2015-08-31 12:23:59: (PROGRESS) Starting step 2 of 6: Extracting log info.
2015-08-31 12:23:59: (DEBUG) We are about to run the following query to extract the items for Log:
SELECT test log AS concept_name FROM data21.csv AS data21 
2015-08-31 12:23:59: (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-08-31 12:23:59: (ERROR) [Microsoft][ODBC Text Driver] Syntax error (missing operator) in query expression 'test log'.
2015-08-31 12:23:59: (WARNING) Cancelling execution! Just after running the query.
2015-08-31 12:24:00: (NOTICE) Execution safely terminated
again I appreciate you

khadije

could any one help me? Dr Buijs i'm waiting your help please answer me as soon as possible 

JBuijs

Dear khadije,

Thanks for the extra information, this helps in answering your question.

This shows that the database connection can be made.
Instead of test log I would add ' around it, now it is looking for the columnn test log in the data21.csv table, which likely does not exist. If you add quotes (either ' or ") it will use the value.
Could you try this?

khadije

Dear Buijs 
thanks a lot I made your changes but the error is same as before. may I have defined attributes badly? my data is one excell file with 8 columns named: case id, activity, start date, end date, agent position, customer ID, product and resource respectively.        

JBuijs

Dear Khadije,

I would try to remove the space in the column names, and replace them with underscores. Adjust your mapping accordingly. Spaces in column names usually don't work

khadije

sorry but it dose not work. I have run your oderdemo example successfully but when I run the Multiple Table csv example the same error appears for Log and Trace extracting. is there any other idea?    
thanks for your help

JBuijs

Dear Khadije,

Could you try to use a generic SQL tool, such as SquirrelSQL to run the query as outputted by XESame? That way we can first test whether there is an issue with XESame. Secondly, SquirrelSQL might produce more insightful error messages.