Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

Scorecard is taking too much time and shows zero output in IDQ
Problem Description
In Informatica Data Quality (IDQ), the scorecard creation on a completed profile is taking long time even for a small batch of data and finally shows no output.​
Cause
This issue occurs because of using the same DIS for Data Quality and EDC.

Scorecards are not running, they are stuck at Add to scorecard state. Profile warehouse is set to a JDBC Oracle connection. They were using same DIS for Data Quality and EDC.

As per one of the known issues, you should not use the same DIS for DQ and EDC, DIS should be different for both.
Solution
To resolve this issue, do as follows:
  • Create a new DIS_Analyst and assign it to Analyst service and restart Analyst.
  • Also, create a separate connection for Profiling warehouse database.
  • After creating the new DIS for IDQ and new profiling warehouse connection, the scorecards are running fine.

More Information
When a resource is executed in Catalog Service, it sets a kind of an EDD task picker in DIS and if the same DIS is used from Analyst Service the same EDD task picker will get re-used for Analyst Service (this task picker is not designed for the Analyst Service) and therefore the issue will occur.


The following exception is thrown in the DIS log:

2018-03-21 18:28:15.426 <DTFPool-3-thread-672> SEVERE: Failed to copy profile org.hibernate.exception.GenericJDBCException: could not execute native bulk manipulation query

at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)

at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)

at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:198)

at org.hibernate.impl.SessionImpl.executeNativeUpdate(SessionImpl.java:1191)

at org.hibernate.impl.SQLQueryImpl.executeUpdate(SQLQueryImpl.java:357)

at com.informatica.profiling.services.apiimpl.dao.ProfileResultManagerDAOImpl.copyTableVerbose(ProfileResultManagerDAOImpl.java:5637)

at com.informatica.profiling.services.apiimpl.dao.ProfileResultManagerDAOImpl.duplicateProfileRun(ProfileResultManagerDAOImpl.java:5244)

at com.informatica.profiling.services.apiimpl.dao.ProfileResultManagerDAOImpl.preprocessAndDuplicateProfileRun(ProfileResultManagerDAOImpl.java:5179)

at com.informatica.profiling.services.apiimpl.dao.ProfileResultManagerDAOImpl.duplicateLatestResultsForScorecard(ProfileResultManagerDAOImpl.java:5094)

at com.informatica.profiling.services.apiimpl.ProfileResultManagerImpl.duplicateProfileForScorecard(ProfileResultManagerImpl.java:940)

at com.informatica.profiling.services.plugin.ProfileResultManagerImpl.duplicateProfileForScorecard(ProfileResultManagerImpl.java:329)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at com.informatica.pcsf.servicesframework.service.impl.ServiceRequestHandler$MethodInvokeRequestHandler.getMethodResult(ServiceRequestHandler.java:787)

at com.informatica.pcsf.servicesframework.service.impl.ServiceRequestHandler$ResilientMethodInvokeRequestHandler.executeRequest(ServiceRequestHandler.java:1076)

at com.informatica.pcsf.servicesframework.service.impl.ServiceRequestHandler$ResilientMethodInvokeRequestHandler.handle(ServiceRequestHandler.java:929)

at com.informatica.pcsf.servicesframework.service.impl.ServiceRequestHandler.handleMethodInvokeRequest(ServiceRequestHandler.java:229)

at com.informatica.pcsf.servicesframework.service.impl.ServiceRequestHandler.onReceiveRequest(ServiceRequestHandler.java:136)

at com.informatica.pcsf.datatransport.impl.RequestHandlerImpl.receiveMSG(RequestHandlerImpl.java:39)

at org.beepcore.beep.core.ChannelImpl.run(ChannelImpl.java:385)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

at java.lang.Thread.run(Thread.java:748)

Caused by: java.sql.SQLException: [informatica][Oracle JDBC Driver][Oracle]ORA-00923: FROM keyword not found where expected

at com.informatica.jdbc.oraclebase.ddcr.b(Unknown Source)

at com.informatica.jdbc.oraclebase.ddcr.a(Unknown Source)

at com.informatica.jdbc.oraclebase.ddcq.b(Unknown Source)

at com.informatica.jdbc.oraclebase.ddcq.a(Unknown Source)

at com.informatica.jdbc.oracle.ddam.t(Unknown Source)

at com.informatica.jdbc.oraclebase.dde3.y(Unknown Source)

at com.informatica.jdbc.oraclebase.dde3._(Unknown Source)

at com.informatica.jdbc.oraclebase.dddz.executeUpdate(Unknown Source)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)

at org.hibernate.engine.query.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:189)

... 22 more

*2018-03-21 18:28:16.999 <EddTaskPicker> SEVERE: [IDP_1004] Profiling exception occured: java.lang.ClassCastException: com.informatica.profiling.services.model.persist.scorecard.impl.ScorecardImpl cannot be cast to com.informatica.metadata.profile.ProfileTask

at com.informatica.profiling.services.apiimpl.EddTaskPicker.mSubmitTaskForExecution(EddTaskPicker.java:393)

at com.informatica.profiling.services.apiimpl.EddTaskPicker.run(EddTaskPicker.java:267)

at java.lang.Thread.run(Thread.java:748)

Applies To
Product: Data Quality; Enterprise Data Catalog; Big Data Quality
Problem Type: Configuration
User Type: Administrator; Business User
Project Phase: Implement; Configure
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:8/11/2019 2:01 PMID:576657
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)