topic Re: Value and Pattern Indicators issue in Data Quality

Value and Pattern Indicators issue

AAA999 — Tue, 11 Jun 2019 20:57:17 GMT

Gurus,

Having issues when using value and pattern frequency indicators in data profiling for certain columns. All other indicators seems to be working fine.

Error:

WARN com.hp.hpl.jena.rdf.model.impl.RDFDefaultErrorHandler - unknown-source: {W136} Relative URIs are not permitted in RDF: specifically <ont-policy.rdf>

Execution Engine: Sql

Can anyone please provide a solution?

Thanks

Re: Value and Pattern Indicators issue

Anonymous — Mon, 17 Jun 2019 05:08:22 GMT

Hello,

Could you please clarify in which Talend DQ version/edition you are?

Is there any more error message in your error log? Are you able to use value and pattern frequency indicators in data profiling by executing on Java engine?

Best regards

Sabrina

Re: Value and Pattern Indicators issue

AAA999 — Mon, 17 Jun 2019 15:47:42 GMT

I am using Talend Studio enterprise 7.0.1?

Additional Error

2019-06-17 10:41:47,128 ERROR org.talend.dq.analysis.AnalysisExecutor - Query not executed for indicator: "Value Low Frequency". the query is: SELECT * FROM (SELECT "t1", COUNT(*) AS c FROM "XXX"."XXX" t GROUP BY "t1" ORDER BY c ASC) WHERE ROWNUM <= 30

2019-06-17 10:41:46,032 ERROR org.talend.commons.exception.CommonExceptionHandler - java.sql.SQLException: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit.

value and pattern frequency indicators in data profiling by executing on Java Engine profiling is also having issues?

Thanks