Hi ,
One of my production server is throwing TIME OUT dumps. When I chacked,it is showing:
The program "/SDF/RSORADLD_NEW" has exceeded the maximum permitted runtime.
I have checked corresponding work process log which is stating that is releted to some SQL error.
-
user = DDIC
client = 000
terminal = sappt014
report = /SDF/RSORADLD_NEW
ThAlarmHandler: return from signal handler
OCIStmtFetch(OCI_FETCH_NEXT) failed with -1=OCI_ERROR
SQL error 1013:
SQL cancelled; calling registered fct. at 0x400000000156c
program canceled
reason = max run time exceeded
user = DDIC
client = 000
terminal = sappt014
report = /SDF/RSORADLD_NEW
TH VERBOSE LEVEL FULL
RABAX: level LEV_RX_PXA_RELEASE_MTX entered.
RABAX: level LEV_RX_PXA_RELEASE_MTX completed.
RABAX: level LEV_RX_COVERAGE_ANALYSER entered.
RABAX: level LEV_RX_COVERAGE_ANALYSER completed.
RABAX: level LEV_RX_SAVE_SHMLOCKS entered.
RABAX: level LEV_RX_SAVE_SHMLOCKS completed.
RABAX: level LEV_RX_RESET_SHMLOCKS entered.
RABAX: level LEV_RX_RESET_SHMLOCKS completed.
RABAX: level LEV_RX_ROLLBACK entered.
RABAX: level LEV_RX_ROLLBACK completed.
RABAX: level LEV_RX_DB_ALIVE entered.
RABAX: level LEV_RX_DB_ALIVE completed.
RABAX: level LEV_RX_COMMIT entered.
RABAX: level LEV_RX_COMMIT completed.
RABAX: level LEV_RX_SNAP_SYSLOG entered.
RABAX: level LEV_RX_SNAP_SYSLOG completed.
RABAX: level LEV_RX_RESET_PROGS entered.
RABAX: level LEV_RX_RESET_PROGS completed.
RABAX: level LEV_RX_STDERR entered.
ABAP Program /SDF/RSORADLD_NEW .
Source /SDF/RSORADLD_NEW Line 1596.
Error Code TIME_OUT.
Module $Id: //bas/701_REL/src/krn/th/thhiserv.c#2 $ SAP.
Function ThTimeout Line 1707.
RABAX: level LEV_RX_STDERR completed.
RABAX: level LEV_RX_RFC_ERROR entered.
RABAX: level LEV_RX_RFC_ERROR completed.
RABAX: level LEV_RX_RFC_CLOSE entered
-
So there are basically two things:
1) Program which is executing that time is /SDF/RSORADLD_NEW
2) There is SQL error message 1013 at that time.
Please suggest how to correct these dumps.
Thanks & Regards,
Hitesh Kumar