#1 2012-05-18 16:07:08

budivoj
New member
Registered: 2012-04-27
Posts: 2

Column Set Analysis problem

Tags: [bug, error, mssql]

Hello
there is a problem with  running the Column Set Analysis (Java engine) on the SQL Server 2008 R2. It returns no data.
The analysis finishes with OK in Error Log:
2012-05-18 15:34:56,390 INFO  org.talend.dataprofiler.core.ui.action.actions.RunAnalysisAction  - "Analysis "test" execution code: OK. Duration: 5.30 s.

But before it ends there is also the error message:
2012-05-18 15:30:48,234 ERROR org.talend.dq.indicators.ColumnSetIndicatorEvaluator  - com.microsoft.sqlserver.jdbc.SQLServerException: The cursor type/concurrency combination is not supported.

The analysis runs to the end but returns no results: graphs and tables are empty. The definition was very simple: two  or three nominal columns (even one column) with simple indicators, nothing more, no rules, patterns, filters.

It seems to be the same problem as the one already posted by simonB2012 on 2012-03-03 17:32:31.

Thanks,
David

the rest of the error message:

2012-05-18 15:30:48,234 ERROR org.talend.dq.indicators.ColumnSetIndicatorEvaluator  - com.microsoft.sqlserver.jdbc.SQLServerException: The cursor type/concurrency combination is not supported.

com.microsoft.sqlserver.jdbc.SQLServerException: The cursor type/concurrency combination is not supported.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:170)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.<init>(SQLServerStatement.java:540)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.createStatement(SQLServerConnection.java:1854)
    at org.talend.dq.indicators.ColumnSetIndicatorEvaluator.evaluateBySql(Unknown Source)
    at org.talend.dq.indicators.ColumnSetIndicatorEvaluator.executeSqlQuery(Unknown Source)
    at org.talend.dq.indicators.Evaluator.evaluateIndicators(Unknown Source)
    at org.talend.dq.indicators.Evaluator.evaluateIndicators(Unknown Source)
    at org.talend.dq.indicators.ColumnSetIndicatorEvaluator.evaluateIndicators(Unknown Source)
    at org.talend.dq.analysis.ColumnSetAnalysisExecutor.runAnalysis(Unknown Source)
    at org.talend.dq.analysis.AnalysisExecutor.execute(Unknown Source)
    at org.talend.dq.analysis.AnalysisExecutorSelector.executeAnalysis(Unknown Source)
    at org.talend.dataprofiler.core.ui.action.actions.AnalysisExecutorThread.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

Offline

#2 2012-06-04 05:29:02

shong
Talend team
Registered: 2007-08-29
Posts: 10310
Website

Re: Column Set Analysis problem

Hi
Which version are you using? I can't procedure the problem on v5.1.0.

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

Board footer

Powered by FluxBB