Purpose (problem description)

This page provides information about the Mainframe analysis error:

SQL Error: ERROR:  could not extend file "base/12002/t12_530455": No space left on device.
SQL Error: HINT:  Check free disk space..
SQL Error: CONTEXT:  SQL statement "create local temporary table TMP_DELOBJPAR as.
SQL Error:    select wobj.INTERNAL_OBJECT_ID as INTERNAL_OBJECT_ID, aop.SOURCE_ID as SOURCE_ID.
SQL Error:    from AMT_OBJPRO aop join TMP_WK_OBJECTSTATUS wobj.
SQL Error:                          on aop.SOURCE_ID = wobj.INTERNAL_OBJECT_ID.
SQL Error:     and  aop.PROP = 0 .
SQL Error:     and wobj.STATUS in ('I', 'U') .
SQL Error:     union.
SQL Error:     select wobj.INTERNAL_OBJECT_ID as INTERNAL_OBJECT_ID, aop.SOURCE_ID as SOURCE_ID.
SQL Error:       from AMT_OBJPRO aop join TMP_WK_OBJECTSTATUS wobj.
SQL Error:                             on aop.SOURCE_ID = wobj.INTERNAL_OBJECT_ID.
SQL Error:       and aop.PROP = 1 .
SQL Error:       and wobj.STATUS = 'I'".
SQL Error: PL/pgSQL function amt_f_maj_param(integer) line 15 at SQL statement.
SQL Error: SQL statement "select AMT_F_MAJ_PARAM (I_IDSESSION)".
SQL Error: PL/pgSQL function amt_f_maj_objmain(integer) line 106 at SQL statement.
SQL Error: SQL statement "select AMT_F_MAJ_OBJMAIN (I_IDSESSION)".
SQL Error: PL/pgSQL function amt_f_maj_kb_obj(integer) line 24 at SQL statement.
SQL Error: SQL statement "select AMT_F_MAJ_KB_OBJ (I_IDSESSION)".
SQL Error: PL/pgSQL function amt_f_maj_kb(integer) line 22 at SQL statement.
SQL Error: SQL statement "select AMT_F_MAJ_KB (I_IDSESSION)".
SQL Error: PL/pgSQL function cache_flushdata(integer) line 35 at SQL statement (Severity 1, Msg No 1).
Procedure call failed: ?fr_test_app_local.CACHE_FLUSHDATA,I_IDSESSION

Observed in CAST AIP
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
8.1.x(tick)
8.0.x(tick)
7.3.x(tick)
7.2.x(tick)
7.0.x(tick)
Observed on RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS3(tick)
CSS2(tick)
CSS1(tick)
Step by Step scenario
  1. Run Analysis
Action Plan
  1. Check if there is enough free space.  There is not enough space, on the machine, and hence it is throwing such error.
    1. Cross check if you have enough free space as suggested in our official document for 7.3 x. [Ideally if the comparison is completed, you must have at least double free space as available at the beginning of the analysis]
  2. If there is not enough disk space then you can move the CSS data files to a new file system. For this follow the procedure mentioned in RDBMS Information - CAST Storage Service - How to move the CSS datafiles when getting messages - No Space left on device - CACHE FLUSHDATA
    1. Run the Analysis again.
  3. If the issue still exists,contact CAST Technical Support with the following Relevant Input

Relevant Input

Sherlock with source code

Notes/comments

Reference call - 28843

Related Pages