Error Message:
ODI-1217: Session <session name> (<Session number>) fails with return code 0.
at oracle.odi.runtime.agent.execution.SessionExecutor.closeSession(SessionExecutor.java:2693)
Whenever you start a job it fails immediately without executing it's steps.
Root Cause:
Tablespace is full.
How to confirm?
1. Connect to Database Admin (SYSDBA) where your repositories are created and execute Following Query:
SELECT a.file_name,
substr(A.tablespace_name,1,20) tablespace_name,
trunc(decode(A.autoextensible,'YES',A.MAXSIZE-A.bytes+b.free,'NO',b.free)/1024/1024)
free_mb,
trunc(a.bytes/1024/1024) allocated_mb,
trunc(A.MAXSIZE/1024/1024) capacity,
a.autoextensible ae
FROM (
SELECT
file_id, file_name,
tablespace_name,
autoextensible,
bytes,
decode(autoextensible,'YES',maxbytes,bytes) maxsize
FROM dba_data_files
GROUP
BY file_id, file_name,
tablespace_name,
autoextensible,
bytes,
decode(autoextensible,'YES',maxbytes,bytes)
) a,
(SELECT
file_id,
tablespace_name,
sum(bytes) free
FROM dba_free_space
GROUP BY file_id,
tablespace_name
)
b
WHERE a.file_id=b.file_id(+)
AND
A.tablespace_name=b.tablespace_name(+)
and a.tablespace_name in
('<work repo tablespace name>','<work repo tablespace name>')
ORDER BY A.tablespace_name ASC;
Note: If you don't know your tablespace name then execute following query:
SELECT
ts.tablespace_name,
TO_CHAR(SUM(NVL(fs.bytes,0))/1024/1024,
'99,999,990.99') AS MB_FREE
FROM
dba_free_space fs,
dba_tablespaces ts,
dba_users us
WHERE
fs.tablespace_name(+) =
ts.tablespace_name
AND ts.tablespace_name(+) = us.default_tablespace
and us.username in ('<work repo name>','<master repo name>')
GROUP BY
ts.tablespace_name;
Solution:
Increase tablespace will resolve the issue.
