on 05-07-2015 6:27 PM
Dear All,
facing below issue when we run transaction assignmnets
transaction SUIM > ROLES > By transaction assignent > SA38 blows up with short dump. SQL error 3114 when accessing table "AGR_TEXTS"
Note number : 1431798 (Oracle 11.2.0 -Database Parameter Settings ). check this notes
I read the note, but what memory parameter are you specifically referring to.
Hi ,
This happens because a user-written program has not logged on.It might be also happen if communication trouble causes a disconnection and the work process went stale process.
In ST22 if the dumps occurred frequently then check which work process ID log by choosing display log in SM50 and check the process whether it updating or not. if not then kill the process. The might be resolved. This will happen the user start working in portal system and accessing the back-end transaction and kept or closed in the middle.
Still if you faced the dumps frequently after killing the work process, then excute the command is >SQL
ALTER SYSTEM KILL SESSION or ALTER SYSTEM DISCONNECT SESSION or restart the system and clean the shared memory cleanipc.
I hope it might be helpful
Thanks,
BM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The error indicates SAP work process lost database connection.
Can you attach the oracle alert log?
Also the short dump logs the sap work process trace from which sap application server, please attach
the dev_w* trace as well.
Best regards,
James
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.