topic Re: GENERATE_SUBPOOL_DIR_FULL in Application Development and Automation Discussions

GENERATE_SUBPOOL_DIR_FULL

Former Member — Mon, 19 Jun 2006 07:57:56 GMT

Hii All,

Our ABAP Consultant had created report for free stock.

It has been working fine till last week, we have gone live in last december.

From last week we are getting this dump 9 times out of 10.

Error analysis

A RAISE statement in the program "CL_ALV_TABLE_CREATE===========CP " raised the

exception

condition "GENERATE_SUBPOOL_DIR_FULL".

Since the exception was not intercepted by a superior program

in the hierarchy, processing was terminated.

Pls Help.

Regards,

Viren.

Re: GENERATE_SUBPOOL_DIR_FULL

Former Member — Mon, 19 Jun 2006 08:00:50 GMT

just refer dhruv raj answer...

Re: GENERATE_SUBPOOL_DIR_FULL

Former Member — Mon, 19 Jun 2006 08:03:59 GMT

Hi,

This is because there is a restriction on number dynamic tables that can be created and this happens when use the method for create the table.

Look at these weblogs

/people/ravikumar.allampallam/blog/2005/05/31/expand-the-list-of-columns-in-a-report-dynamically

/people/subramanian.venkateswaran2/blog/2004/11/19/dynamic-internal-table

Regards,

Ravi

Re: GENERATE_SUBPOOL_DIR_FULL

Former Member — Mon, 19 Jun 2006 08:16:31 GMT

Hi Virendrasinh,

Check out the following thread.

Hope it helps,

Reward points if helpful,

Rgds,

Sumana

Re: GENERATE_SUBPOOL_DIR_FULL

athavanraja — Mon, 19 Jun 2006 08:27:42 GMT

if you are on WAS you can use the following code sample which will help you to avoid this limitation.

LOOP AT it_fieldcat INTO is_fieldcat .
        CLEAR op_len .
        op_len = is_fieldcat-outputlen .
        comp-name = is_fieldcat-fieldname.
        comp-type = cl_abap_elemdescr=>get_c( op_len ).
        APPEND comp TO comp_tab.
        CLEAR : is_fieldcat , comp .
      ENDLOOP .

      CLEAR struct_type .

      CALL METHOD cl_abap_structdescr=>create
        EXPORTING
          p_components = comp_tab
          p_strict     = cl_abap_structdescr=>false
        RECEIVING
          p_result     = struct_type.

*      struct_type = cl_abap_structdescr=>create( comp_tab ).
      CLEAR tab_type .
      CALL METHOD cl_abap_tabledescr=>create
        EXPORTING
          p_line_type  = struct_type
          p_table_kind = cl_abap_tabledescr=>tablekind_std
*    P_UNIQUE     = ABAP_FALSE
*    P_KEY        =
*    P_KEY_KIND   = KEYDEFKIND_DEFAULT
        RECEIVING
          p_result     = tab_type .
      CLEAR : dref, dref1 .
      CREATE DATA dref1 TYPE HANDLE tab_type.

      ASSIGN dref1->* TO <outtab>.

      CREATE DATA dref TYPE HANDLE struct_type.

      ASSIGN dref->* TO <l_line>.

Regards

Raja

Re: GENERATE_SUBPOOL_DIR_FULL

Former Member — Mon, 19 Jun 2006 08:48:06 GMT

Hi Raja/Sumana/Kishan/Ravi,

thanks for your immidiate reply.

my real problem is that i am not able to run report once.

why the same problem was not coming for all these six months.

pls help.

Regards,

Viren.