Five 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

 

 

  • Data Quality
4 REPLIES
Seven Stars TRF
Seven 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
Five 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

Five 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