I am executing full load ETL but it is going in error. Can anyone tell why is it happening.
Session SDE_JG_ADREVENUE_FS (63253) fails with return code ODI-1298.[[
ODI-1217: Session SDE_JG_ADREVENUE_FS (63253) fails with return code ODI-1298.
ODI-1226: Step SDE_JG_ADREVENUE_FS fails after 1 attempt(s).
ODI-1227: Task SERIAL-MAP_MAIN- fails on the source connection <Empty Value>.
ODI-1298: Serial task "SERIAL-MAP_MAIN- (60)" failed because child task "SERIAL-EU-ServerAaina220OracleBI_UNIT (70)" is in error.
ODI-1298: Serial task "SERIAL-EU-ServerAaina220OracleBI_UNIT (70)" failed because child task "Insert new rows-LKM SQL to Oracle JG-Load FILTER_AP (80)" is in error.
Caused By: oracle.odi.runtime.agent.exception.ExecutionEngineException: java.sql.SQLNonTransientConnectionException: [FMWGEN][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.
at oracle.odi.runtime.agent.execution.sql.concurrent.FastJDBCRecordSet.call(FastJDBCRecordSet.java:276)
at oracle.odi.runtime.agent.execution.sql.concurrent.FastJDBCRecordSet.call(FastJDBCRecordSet.java:37)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLNonTransientConnectionException: [FMWGEN][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.