ABAP DUMP issue related to SQL error 3114

[rahul_yedapally]

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.

[Brindavan_M]

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.

• Web-server or listener process is not running
• Missing entry to the tnsnames.ora
• Network issues
• Problems with connection pooling

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

[JamesZ]

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