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

Error while applying Duplicate count on Date Column in Profiling

krishu — Tue, 25 Apr 2017 13:17:25 GMT

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

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

TRF — Wed, 26 Apr 2017 13:12:28 GMT

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.

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

krishu — Wed, 26 Apr 2017 13:16:05 GMT

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

Regards

Krishu

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

Anonymous — Thu, 27 Apr 2017 09:56:25 GMT

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

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

krishu — Thu, 27 Apr 2017 10:39:10 GMT

@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