Server Error on Dataset Preview

Question

Hi, I'm new in Knowage.

I managed to create a data source to connect to my MS SQL SERVER 2014, using JDBC type.

The URL I used is: jdbc:jtds:sqlserver://ITMOBILE-01:1443;databaseName=APMJOC
and driver is: net.sourceforge.jtds.jdbc.Driver.
Connection tested successfully,

Then I try to create a dataset using that data source:
Scope: User
Data set Type: Query
Data Source: <I Selected my data source name>
Edit Query: Select top 100 * from YarnLot
(YarnLot is the name of a table in the database)

When I clicked PREVIEW, there is an error message:
SERVER ERROR
SERVER ERROR

I am quite sure that the query script is correct, SQL Server is running and accessible.

Can anyone suggest, what I need to check?
I've been struggling for 3 days to resolve this.
It works ok for flat file... but creating a dataset from SQL Server is a bit frustrating...

Very appreciate for any help...

Regards
bsetiadi

Comments

bsetiadi,

You can get more details by checking the log files. Take a look at the file [Knowage-Server-CE]/logs/knowage.log and  check if it drives your resolution.

Hope it helps!

Cheers,

Giovanni