Error While Running ETL For Argus Mart: ORA-20010: ORA-20001: Unable to access Argus Safety table/view meddra_user.who_drug_dict. Check all required grants are present
(Doc ID 2833899.1)
Last updated on DECEMBER 17, 2024
Applies to:
Oracle Life Sciences Argus Mart - Version 8.2.3 and laterInformation in this document applies to any platform.
Symptoms
On : Argus Mart 8.2.3 version, Initial ETL (Extract, Transform & Load Data) Process is failing with below errors in logs
ERROR
23 SCN_POPULATE_WHOB01_TABLES oracle.javatools.icons.OracleIcons$LazyIcon@2fd154b5 00:45 13:18:19 13:19:04 SCN_POPULATE_WHOB01_TABLES Version 001 554 20010 ODI-1217: Session SCN_POPULATE_WHOB01_TABLES (554) fails with return code 20010.
ODI-1226: Step PRC_populate_whob01_tables fails after 1 attempt(s).
ODI-1232: Procedure PRC_populate_whob01_tables execution fails.
ODI-1228: Task Procedure-PRC_populate_whob01_tables-Command 0 fails on the target connection DS_AM_ARGUSMART.
Caused By: java.sql.SQLException: ORA-20010: ORA-20001: Unable to access Argus Safety table/view meddra_user.who_drug_dict. Check all required grants are present
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 893
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 937
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 937
-- ERROR while processing p_populate_who_tables at 15-Dec-2021 13:19:04
ORA-06512: at "AM_MART_USER.PKG_SM_LOGGING", line 103
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 946
ORA-06512: at line 3
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:447)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1055)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:624)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:253)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:613)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:214)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:38)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:891)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1194)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1835)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1790)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:301)
at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:205)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:142)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:28)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)
at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:206)
at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:117)
at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:886)
at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2225)
at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:610)
at oracle.odi.runtime.agent.processor.impl.QueuedSessionsExecutor$3.doAction(QueuedSessionsExecutor.java:439)
at oracle.odi.runtime.agent.processor.impl.QueuedSessionsExecutor$3.doAction(QueuedSessionsExecutor.java:386)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
at oracle.odi.runtime.agent.processor.impl.QueuedSessionsExecutor.doProcessStartAgentTask(QueuedSessionsExecutor.java:385)
at oracle.odi.runtime.agent.processor.impl.QueuedSessionsExecutor$QueuedTask.doExecute(QueuedSessionsExecutor.java:720)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
at oracle.odi.runtime.agent.processor.impl.QueuedSessionsExecutor.dequeueAndRunSession(QueuedSessionsExecutor.java:225)
at oracle.odi.runtime.agent.processor.impl.QueuedSessionsExecutor$1.run(QueuedSessionsExecutor.java:164)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
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: Error : 20010, Position : 0, Sql = BEGIN
pkg_sm_stage_util.p_set_context(-1);
pkg_sm_dtos.p_populate_who_tables('WHOB01');
END;, OriginalSql = BEGIN
pkg_sm_stage_util.p_set_context(-1);
pkg_sm_dtos.p_populate_who_tables('WHOB01');
END;, Error Msg = ORA-20010: ORA-20001: Unable to access Argus Safety table/view meddra_user.who_drug_dict. Check all required grants are present
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 893
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 937
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 937
-- ERROR while processing p_populate_who_tables at 15-Dec-2021 13:19:04
ORA-06512: at "AM_MART_USER.PKG_SM_LOGGING", line 103
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 946
ORA-06512: at line 3
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:499)
... 36 more
0 0 0 0 0
23 SCN_POPULATE_WHOB01_TABLES oracle.javatools.icons.OracleIcons$LazyIcon@2fd154b5 00:45 13:18:19 13:19:04 SCN_POPULATE_WHOB01_TABLES Version 001 554 20010 ODI-1217: Session SCN_POPULATE_WHOB01_TABLES (554) fails with return code 20010.
ODI-1226: Step PRC_populate_whob01_tables fails after 1 attempt(s).
ODI-1232: Procedure PRC_populate_whob01_tables execution fails.
ODI-1228: Task Procedure-PRC_populate_whob01_tables-Command 0 fails on the target connection DS_AM_ARGUSMART.
Caused By: java.sql.SQLException: ORA-20010: ORA-20001: Unable to access Argus Safety table/view meddra_user.who_drug_dict. Check all required grants are present
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 893
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 937
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 937
-- ERROR while processing p_populate_who_tables at 15-Dec-2021 13:19:04
ORA-06512: at "AM_MART_USER.PKG_SM_LOGGING", line 103
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 946
ORA-06512: at line 3
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:495)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:447)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1055)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:624)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:253)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:613)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:214)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:38)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:891)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1194)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1835)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1790)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:301)
at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:205)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:142)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:28)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)
at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:206)
at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:117)
at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:886)
at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2225)
at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:610)
at oracle.odi.runtime.agent.processor.impl.QueuedSessionsExecutor$3.doAction(QueuedSessionsExecutor.java:439)
at oracle.odi.runtime.agent.processor.impl.QueuedSessionsExecutor$3.doAction(QueuedSessionsExecutor.java:386)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
at oracle.odi.runtime.agent.processor.impl.QueuedSessionsExecutor.doProcessStartAgentTask(QueuedSessionsExecutor.java:385)
at oracle.odi.runtime.agent.processor.impl.QueuedSessionsExecutor$QueuedTask.doExecute(QueuedSessionsExecutor.java:720)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
at oracle.odi.runtime.agent.processor.impl.QueuedSessionsExecutor.dequeueAndRunSession(QueuedSessionsExecutor.java:225)
at oracle.odi.runtime.agent.processor.impl.QueuedSessionsExecutor$1.run(QueuedSessionsExecutor.java:164)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
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: Error : 20010, Position : 0, Sql = BEGIN
pkg_sm_stage_util.p_set_context(-1);
pkg_sm_dtos.p_populate_who_tables('WHOB01');
END;, OriginalSql = BEGIN
pkg_sm_stage_util.p_set_context(-1);
pkg_sm_dtos.p_populate_who_tables('WHOB01');
END;, Error Msg = ORA-20010: ORA-20001: Unable to access Argus Safety table/view meddra_user.who_drug_dict. Check all required grants are present
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 893
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 937
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 937
-- ERROR while processing p_populate_who_tables at 15-Dec-2021 13:19:04
ORA-06512: at "AM_MART_USER.PKG_SM_LOGGING", line 103
ORA-06512: at "AM_STAGE_USER.PKG_SM_DTOS", line 946
ORA-06512: at line 3
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:499)
... 36 more
0 0 0 0 0
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |