ODI报错

三月 08, 2024 1:20:09 下午 oracle.odi.mapping
信息: Start generation of map physical design: MapPhysicalDesign New_Mapping.物理
三月 08, 2024 1:20:09 下午 oracle.odi.mapping
信息: Finished generation of map physical design: MapPhysicalDesign New_Mapping.物理
三月 08, 2024 1:20:09 下午 null
INFO: New data source: [essbase/*******@jdbc:oracle:thin:@127.0.0.1:1521/orcl]
三月 08, 2024 1:20:09 下午 oracle.odi.runtime.agent.execution.sql.SQLCommand
警告: SQLCommand execution failure: ORA-12504: TNS: 监听程序在 CONNECT_DATA 中未获得 SERVICE_NAME

Failed query text:

INSERT
/*+ APPEND PARALLEL */
INTO ESSBASE.CES_USERS_TARGET
(
NAME ,
PARENT ,
OBJTYPE ,
OBJVALUE
)
SELECT
CES_USERS.NAME ,
CES_USERS.PARENT ,
CES_USERS.OBJTYPE ,
CES_USERS.OBJVALUE
FROM
ESSBASE.CES_USERS@"j_lt_src" CES_USERS

三月 08, 2024 1:20:09 下午 oracle.odi.agent
警告: 代理Internal遇到错误: ODI-1226: 步骤物理_STEP 在经过 1 次尝试后失败。
三月 08, 2024 1:20:09 下午 oracle.odi.agent
严重: 会话New_Mapping_物理_SESS (14) 失败, 返回代码为 ODI-1298。
ODI-1217: 会话New_Mapping_物理_SESS (14) 失败, 返回代码为 ODI-1298。
ODI-1226: 步骤物理_STEP 在经过 1 次尝试后失败。
ODI-1240: 执行Insert new rows-IKM Oracle Insert-Load CES_USERS_TARGET操作时流物理_STEP失败。此流加载目标表CES_USERS_TARGET。
ODI-1298: 串行任务 "SERIAL-MAP_MAIN- (40)" 由于子任务 "SERIAL-EU-j_lt_tar_UNIT (70)" 出错而失败。
ODI-1298: 串行任务 "SERIAL-EU-j_lt_tar_UNIT (70)" 由于子任务 "Insert new rows-IKM Oracle Insert-Load CES_USERS_TARGET (80)" 出错而失败。
ODI-1228: 任务Insert new rows-IKM Oracle Insert-Load CES_USERS_TARGET在目标连接target上失败。
Caused By: java.sql.SQLException: ORA-12504: TNS: 监听程序在 CONNECT_DATA 中未获得 SERVICE_NAME

   at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:510)
   at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:462)
   at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1105)
   at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:551)
   at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
   at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:656)
   at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:230)
   at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:42)
   at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:929)
   at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1280)
   at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1921)
   at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1876)
   at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:304)
   at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:208)
   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:216)
   at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:128)
   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.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
   at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
   at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
   at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)
   at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$1400(StartSessRequestProcessor.java:74)
   at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:702)
   at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
   at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)
   at java.lang.Thread.run(Thread.java:748)
Caused by: Error : 12504, Position : 249, Sql =
INSERT
/*+ APPEND PARALLEL */
INTO ESSBASE.CES_USERS_TARGET
(
NAME ,
PARENT ,
OBJTYPE ,
OBJVALUE
)
SELECT
CES_USERS.NAME ,
CES_USERS.PARENT ,
CES_USERS.OBJTYPE ,
CES_USERS.OBJVALUE
FROM
ESSBASE.CES_USERS@"j_lt_src" CES_USERS
, OriginalSql =
INSERT
/*+ APPEND PARALLEL */
INTO ESSBASE.CES_USERS_TARGET
(
NAME ,
PARENT ,
OBJTYPE ,
OBJVALUE
)
SELECT
CES_USERS.NAME ,
CES_USERS.PARENT ,
CES_USERS.OBJTYPE ,
CES_USERS.OBJVALUE
FROM
ESSBASE.CES_USERS@"j_lt_src" CES_USERS
, Error Msg = ORA-12504: TNS: 监听程序在 CONNECT_DATA 中未获得 SERVICE_NAME

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:514)
... 30 more

三月 08, 2024 1:20:09 下午 oracle.odi.agent
严重: 代理遇到错误: ODI-1217: 会话New_Mapping_物理_SESS (14) 失败, 返回代码为 ODI-1298。 Caused by: ODI-1226: 步骤物理_STEP 在经过 1 次尝试后失败。
三月 08, 2024 1:20:09 下午 oracle.odi.mapping
信息: Start generation of map physical design: MapPhysicalDesign New_Mapping.物理
三月 08, 2024 1:20:09 下午 oracle.odi.mapping
信息: Finished generation of map physical design: MapPhysicalDesign New_Mapping.物理
三月 08, 2024 1:20:09 下午 null
INFO: New data source: [essbase/*******@jdbc:oracle:thin:@127.0.0.1:1521/orcl]
三月 08, 2024 1:20:09 下午 oracle.odi.runtime.agent.execution.sql.SQLCommand
警告: SQLCommand execution failure: ORA-12504: TNS: 监听程序在 CONNECT_DATA 中未获得 SERVICE_NAME

Failed query text:

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:514)
... 30 more

三月 08, 2024 1:20:09 下午 oracle.odi.agent
严重: 代理遇到错误: ODI-1217: 会话New_Mapping_物理_SESS (14) 失败, 返回代码为 ODI-1298。 Caused by: ODI-1226: 步骤物理_STEP 在经过 1 次尝试后失败。
解决方法：加载知识模块修改如下