Error while applying Duplicate count on Date Column in Profiling

Six Stars

Error while applying Duplicate count on Date Column in Profiling

Hi

Facing an issue on date columns while applying Duplicate count in profiling, getting Null Pointer Exception.

 

2017-04-25 17:11:39,454 ERROR org.talend.dq.analysis.AnalysisExecutor  - java.lang.NullPointerException

 

java.lang.NullPointerException
at org.mapdb.BTreeMap.put(BTreeMap.java:642)
at org.talend.dataquality.indicators.mapdb.DBMap.put(DBMap.java:197)
at org.talend.dataquality.indicators.impl.IndicatorImpl.handleDrillDownData(IndicatorImpl.java:1385)
at org.talend.dataquality.indicators.impl.DuplicateCountIndicatorImpl.handleDrillDownData(DuplicateCountIndicatorImpl.java:399)
at org.talend.dataquality.indicators.impl.DuplicateCountIndicatorImpl.finalizeComputation(DuplicateCountIndicatorImpl.java:257)
at org.talend.dq.indicators.Evaluator.finalizeIndicators(Evaluator.java:171)
at org.talend.dq.indicators.Evaluator.evaluateIndicators(Evaluator.java:153)
at org.talend.dq.indicators.Evaluator.evaluateIndicators(Evaluator.java:207)
at org.talend.dq.analysis.ColumnAnalysisExecutor.evaluate(ColumnAnalysisExecutor.java:104)
at org.talend.dq.analysis.AnalysisExecutor.runAnalysis(AnalysisExecutor.java:276)
at org.talend.dq.analysis.AnalysisExecutor.execute(AnalysisExecutor.java:145)
at org.talend.dq.analysis.AnalysisExecutorSelector.executeAnalysis(AnalysisExecutorSelector.java:171)
at org.talend.dataprofiler.core.ui.action.actions.RunAnalysisAction$1.runInWorkspace(RunAnalysisAction.java:215)
at org.eclipse.core.internal.resources.InternalWorkspaceJob.run(InternalWorkspaceJob.java:38)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

 

Regards

Krishu

 

 

Fifteen Stars TRF
Fifteen Stars

Re: Error while applying Duplicate count on Date Column in Profiling

I do not use DQ, but based on my experience with DI I suppose the execption is due to a null value on the field you try to compare for a record.


TRF
Six Stars

Re: Error while applying Duplicate count on Date Column in Profiling

I have checked the Nullable and there are no Null values, i got stuck only with the date column.

 

Regards

Krishu

Moderator

Re: Error while applying Duplicate count on Date Column in Profiling

Hello,

Does this issue on file or DB connection? Could you please give us more details to repro your issue? Which talend build version are you using?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Error while applying Duplicate count on Date Column in Profiling


@xdshi wrote:

Hello,

Does this issue on file or DB connection? Could you please give us more details to repro your issue? Which talend build version are you using?

Best regards

Sabrina



Am using Talend Real time Big data 6.3.1v. Am doing column analysis on date column, when i select duplicate count in select indicators am getting NullPointer Exception.

Capture.JPGNullPointer.jpg 

 

Thanks & Regards

Krishu

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