Where is error?
All names of table are below 30 s
SRC CODE
select
SWMET_RESULTSMONITORING.EURBDCODE C1_EURBDCODE_,
SWMET_RESULTSMONITORING.ALTERNATERBD C2_ALTERNATERBD,
SWMET_RESULTSMONITORING.ECOLOGICALSTATUSDESCRIPTION C3_ECOLOGICALSTATUSDESCRIPTION,
SWMET_RESULTSMONITORING.CHEMICALSTATUSDESCRIPTION C4_CHEMICALSTATUSDESCRIPTION,
SWMET_RESULTSMONITORING.PROTECTEDAREASTATUSDESCRIPTION C5_PROTECTEDAREASTATUSDESCRIPTION,
SWMET_RESULTSMONITORING.SUBUNITDIFFERENCES C6_SUBUNITDIFFERENCES
from RAPORTYUE.SWMET_RESULTSMONITORING SWMET_RESULTSMONITORING
where (1=1)
TRG CODE
insert into "C_0SWMET_ResultsMonitoring*"
(
C1_EURBDCODE_,
C2_ALTERNATERBD,
C3_ECOLOGICALSTATUSDESCRIPTION,
C4_CHEMICALSTATUSDESCRIPTION,
C5_PROTECTEDAREASTATUSDESCRIPTION,
C6_SUBUNITDIFFERENCES
)
values
(
:C1_EURBDCODE_,
:C2_ALTERNATERBD,
:C3_ECOLOGICALSTATUSDESCRIPTION,
:C4_CHEMICALSTATUSDESCRIPTION,
:C5_PROTECTEDAREASTATUSDESCRIPTION,
:C6_SUBUNITDIFFERENCES
)
ODI-1227: Task SrcSet0 (Loading) fails on the source ORACLE connection RAP_UE_SRC.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
at oracle.odi.query.JDBCTemplate.executeQuery(JDBCTemplate.java:189)
at oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:94)
at oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:1)
at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:70)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:745)