Column Set Analysis problem

Highlighted
One Star

Column Set Analysis problem

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)
Community Manager

Re: Column Set Analysis problem

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

Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read