cancel
Showing results for 
Search instead for 
Did you mean: 

SPM Job failed due to internal memory issues

Former Member
0 Kudos

Hello Experts,


System: GRC V10 with SP 08

I have a problem regarding the firefighter job that runs every 4 hours (program GRAC_SPM_LOG_SYNC_UPDATE)

The last month the job is being cancelled with error message :

TSV_TNEW_PAGE_ALLOC_FAILED:No storage space available for extending the internal table

As per SNOTE 1617487, We reduced parameters 1121 (Batch size for User sync), 1122 (Batch size for Role sync) and 1123 (Batch size for Profile sync) from 1000 to 500 and then even as low as 100.

We have also increased our memory parameters significantly. still the same issue

(ztta/roll_area, ztta/roll_extension, abap/heap_area_total, abap/heap_area_dia, abap/heap_area_nondia, em/initial_size_MB)

Before i check this problem from the Basis side, because depending on the message it is a Basis problem, is there any other optimization I can perform

Best regards,

Kailash

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Dear Kailash,

Kindly change the Timestamp value
for task Change_log in GRACTASKEXECSTMP to current timestamp in UTC/GMT
time. For your refernce a Z report is given  which could be used for
changing timestamp.

After this kindly check know that the current log are getting fetched?


REPORT  ZEAM_SYNC_TIMESTAMP_UPDATE.

DATA ls_taskexecstmp TYPE gractaskexecstmp.
SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE title.
PARAMETER : lv_conn TYPE grfncciconnector-connector  MATCHCODE OBJECT grac_connectorid.
PARAMETER :  dt_upd TYPE timestamp .
SELECTION-SCREEN END OF BLOCK b1.
   ls_taskexecstmp-task_name      = 'CHANGE_LOG'  .
    ls_taskexecstmp-connector      = lv_conn .
    ls_taskexecstmp-last_exec_date = dt_upd .
    ls_taskexecstmp-purge_date     =  0 .

    MODIFY gractaskexecstmp FROM ls_taskexecstmp .

    ls_taskexecstmp-task_name      = 'SPM_ACTION_USAGE'  .
    ls_taskexecstmp-connector      = lv_conn .
    ls_taskexecstmp-last_exec_date = dt_upd .
    ls_taskexecstmp-purge_date     =  0 .

    MODIFY gractaskexecstmp FROM ls_taskexecstmp .

    ls_taskexecstmp-task_name      = 'SPM_ACT_USAGE_NEW'.
    ls_taskexecstmp-connector      = lv_conn .
    ls_taskexecstmp-last_exec_date = dt_upd .
    ls_taskexecstmp-purge_date     =  0 .

    MODIFY gractaskexecstmp FROM ls_taskexecstmp .

Thanks & Regards,

Ashish

Former Member
0 Kudos

Thanks Ashish.

Issue is now resolved. SAP provided Z-program to fetch data from target systems with date-time selection. That program also updates timestamp table.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Kailash,

Aditionally,Kindly also review/implement the sap notes-

1750024
1716040

1697692
1776070

Hope this helps.

Best Regards,

Nandita

Former Member
0 Kudos

Thanks Nandita.

I will apply these SNOTES and let you know the outcome.

Thanks

Kailash

Former Member
0 Kudos

Hi Nandita,

I implemented these SNOTES but I am still facing same issue.

Any other options?