Error while applying Duplicate count on Date Column in Profiling

[krishu]

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

[TRF]

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.

[krishu]

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

Regards

Krishu

[Anonymous]

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

[krishu]

---

@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.

 

Thanks & Regards

Krishu