SNAP_NO_NEW_ENTRY - Short Dump

[Former Member]

Hi All,

In solution manager 7.0 NW2004s Windows 2003, Oracle 10g....

I got an error when I login

SNAP_NO_NEW_ENTRY - Short Dump

I can't go any transaction code like SM21, ST22, SE14 I can't delete SNAP data, how do I do even I can;'t run any transaction code

please help

angeline

[Former Member]

Your logs are full...

1. backup the transaction logs
2. then adjust the database the gain space in your logs disk

Regards,

Sergio Maziano

[Former Member]

If you cannot start any transaction which you are otherwise authorized for, then this dump is occuring prior to authentication.

This would be an error in the logon program (you have to contact SAP for that via a customer message as you cannot access it yourself...) or you tried to access it, in which case you cause a "lock out" to protect itself from being modified.

Please post the program name and variables with code lines of the dump?

Cheers,

Julius

[Former Member]

Hi J, and others

ok here is final status...

I have 2 month old database image which is I restore today...

I just trun off all instance and restore old database partition.... basically I had installed database in different partition, and today I just restore it

After restore dispatcher is stopped...

here is ABAP trace log

-

---

NiBufReceive starting

MsINiRead: received 114 bytes

MSG received, len 110+4, flag 3, from MSG_SERVER , typ 0, key -

Received 4 bytes from MSG_SERVER

Received opcode MS_NOOP from msg_server, reply MSOP_OK

MsOpReceive: ok

MsSendKeepalive : keepalive sent to message server

NiIRead: hdl 3 recv would block (errno=EAGAIN)

Sat Jan 09 15:02:39 2010

NiIPeek: peek for hdl 3 timed out (r; 1000ms)

NiIRead: read for hdl 3 timed out (1000ms)

DpHalt: no more messages from the message server

DpHalt: sync with message server o.k.

detach from message server

***LOG Q0M=> DpMsDetach, ms_detach () [dpxxdisp.c 12168]

NiBufSend starting

NiIWrite: hdl 3 sent data (wrt=110,pac=1,MESG_IO)

MsINiWrite: sent 110 bytes

MsIDetach: send logout to msg_server

MsIDetach: call exit function

DpMsShutdownHook called

NiBufISelUpdate: new MODE -- (r-) for hdl 3 in set0

SiSelNSet: set events of sock 1388 to: ---

NiBufISelRemove: remove hdl 3 from set0

SiSelNRemove: removed sock 1388 (pos=3)

SiSelNRemove: removed sock 1388

NiSelIRemove: removed hdl 3

MBUF state OFF

AdGetSelfIdentRecord: > <

AdCvtRecToExt: opcode 60 (AD_SELFIDENT), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

AdCvtRecToExt: opcode 40 (AD_MSBUF), ser 0, ex 0, errno 0

blks_in_queue/wp_ca_blk_no/wp_max_no = 1/300/17

LOCK WP ca_blk 1

make DISP owner of wp_ca_blk 1

DpRqPutIntoQueue: put request into queue (reqtype 1, prio LOW, rq_id 15)

MBUF component DOWN

NiICloseHandle: shutdown and close hdl 3 / sock 1388

NiBufIClose: clear extension for hdl 3

MsIDetach: detach MS-system

cleanup EM

EsCleanup ....

EmCleanup() -> 0

Es2Cleanup: Cleanup ES2

***LOG Q05=> DpHalt, DPStop ( 151132) [dpxxdisp.c 10421]

Good Bye .....

[Former Member]

Again,

When I check log; dev_w0

Sat Jan 09 15:31:25 2010

M calling db_connect ...

C Prepending D:\usr\sap\SOL\DVEBMGS00\exe to Path.

C Oracle Client Version: '10.2.0.2.0'

C Client NLS settings: AMERICAN_AMERICA.UTF8

C Logon as OPS$-user to get SAPSR3's password

C Connecting as /@SOL on connection 0 (nls_hdl 0) ... (dbsl 700 250407)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 00000000128420C0 000000000A786380 000000000A78BBA8

C Attaching to DB Server SOL (con_hdl=0,svchp=000000000A78BA68,srvhp=0000000012861118)

C Starting user session (con_hdl=0,svchp=000000000A78BA68,srvhp=0000000012861118,usrhp=000000000A786B98)

C *** ERROR => OCI-call 'OCISessionBegin' failed with rc=1033

[dboci.c 4532]

C Detaching from DB Server (con_hdl=0,svchp=000000000A78BA68,srvhp=0000000012861118)

C *** ERROR => CONNECT failed with sql error '1033'

[dbsloci.c 11044]

[peter_dzurov]

Hello,

I think your OPS$ mechanism does not work...

check sap note [400241|https://service.sap.com/sap/support/notes/400241]

and also note:

50088 Creating OPS$ users on Windows NT/Oracle

[JPReyes]

Usually even if you get a dump at logon you should be able to call SE38 and run RSSNAPDL which will delete the old entries from the SNAP table.

Try it, Also make sure that all the housekeeping jobs are scheduled so this doesn't happen again.

Regards

Juan

[Former Member]

Hi Juan,

for my User ID, it login direct ABAP dump screen and nothing i can do, even I tried SAP* as well... same thing...

I know RSSNAPDL program to delete SNAP table empty, but my bad-luck, I can't even run that program... same se38 doesn't work at all

[ImtiazKaredia]

Might be there is problem with your oracle database.

Check if your database is working fine, tablespace is not 100% or it is not archiver stuck.

[ImtiazKaredia]

There is one more thread for database connection error, are these two related, if so please use only one thread.

[Former Member]

Hi Karedia,

I think you are right, I belived its oracle problem but how can i check archived is stuck in que...

is there anyitng i can resolve that problem through Oracle... becuase I can't access any tcode everytime its giv eme ABAP runtime error...

Thank

[ImtiazKaredia]

Your system will be in archiver stuck if the disk space is 100%, where the offline archive logs are generated

Directory will be DRIVE:\oracle\<DBSID>\oraarch

But this is less likely to be the cause.

Check the tablespace space using brtools.

Also check the dev* files like dev_w0 in the work directory of the instance.