on 03-11-2013 7:07 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Kailash,
Aditionally,Kindly also review/implement the sap notes-
1750024
1716040
1697692
1776070
Hope this helps.
Best Regards,
Nandita
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.