Short Dump when I try to display table .

[Former Member]

Hi all,

     We recently installed ECC, first two days it was working fine, after two days i created a table and try to insert a record its giving a dump and some standard tables also giving dump.

  pls help me, thanks in advance.

  The screen shot of the dump is.

 

[Former Member]

Not yet resolved pls help ..!

[Sriram2009]

Hi Radhu

1. Have you run the SGEN on your ECC system?

2. Both dump are error in different programs(On 09/08/2014 text file & Screen shot attachment ), better you do the full restart and then try again

Regards

Sriram

[Former Member]

What is the use of it ..?

Which one should I select ..?

[Former Member]

I have done full restart many times ..!

[former_member188883]

Hi Raghu,

Please share results from DBCC CHECKDB.

There seems to be a potential I/O problem.

Regards,

Deepak Kori

[Sriram2009]

Check this SAP links why SGEN useful or not?

Using the SAP Load Generator - SAP Load Generator - SAP Library

[Former Member]

Hi Deepak Kori,

How can execute this ..?

I'm not familiar with this ..!

if possible explain steps ..!

Thanks ,

Raghu.

[Sriram2009]

Hi

Refer the SAP Note for DBCC check

142731: DBCC checks of SQL Server

BR

SS

[Former Member]

Hi ,

This what i got when i run the command .

Msg 8921, Level 16, State 1, Line 1

Check terminated. A failure was detected while collecting facts.

Possibly tempdb out of space or a system table is inconsistent. Check

previous errors.

Msg 823, Level 24, State 2, Line 1

The operating system returned error 23(Data error (cyclic redundancy

check).) to SQL Server during a read at offset 0x00000d2c89c000 in

file 'D:\SR5DATA2\SR5DATA2.ndf:MSSQL_DBCC7'. Additional messages in

the SQL Server error log and system event log may provide more detail.

This is a severe system-level error condition that threatens database

integrity and must be corrected immediately. Complete a full database

consistency check (DBCC CHECKDB). This error can be caused by many

factors; for more information, see SQL Server Books Online.

[Sriram2009]

Hi Raghu

1. You MS Sql Temp DB out of space increase the Temp DB space,

2  you have keep a eye on transaction log

and then run the DBCC check

BR

SS

[Former Member]

How to increase ..?

[Sriram2009]

Hi

You can search this thing in net, kindly check this Microsoft link

How to change the size of tempdb in SQL Server 6.5 (ISQL/w)

BR

SS

[Former Member]

Hi,

tempdb has still 290 mb available space.

but msdb available space is 0.30 mb..!

[Sriram2009]

Hi

You can define the Temp DB auto growth minimum size should be 350 Mb, base on usage DB size will increase. in our BI System we have defined 20 GB and free disk free space 90 gb refer this SAP note
1174635 - TempDB sizing in SAP BW systems on Microsoft SQL Server

for your reference check the screen shot

BR

SS

[Former Member]

I'm getting this dump also

can any one tell what is the reason ..?

I'm not a basis guy, can any one tell the steps need to be followed to resolve this issue .!

plsss,

[divyanshu_srivastava3]

Hi Raghu,

The above problem says that the issue is with hardware or system problems

Goto SQL manager and look for event logs at that date and time given in dump.

One of the most probable reason is some problem at database level.

Check Error message 823 may indicate hardware problems or system problems in SQL Server

Don't do anything if you are not comfortable with DB and BASIS.

Ask concerned person to look into this.

Divyanshu

[divyanshu_srivastava3]

Also, if you want to it own your own, share sql alert logs and check tool:sqlliosim

How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem

[Former Member]

Hi Divyanshu,

thanks for your information.

If that the case(Hard ware failure), I should not be able to create the entries for all tables ...! But I'm able to create new entries for the table which i created in the beginning (When every thing working fine ).

don't have basis people .

[divyanshu_srivastava3]

Hi Raghu,

But you always have sap support.

Open an incident with SAP and give them remote connection.

Refer below link on how to setup this.

Remote Connections | SAP Support Portal

Divyanshu

[divyanshu_srivastava3]

The error is about resource short.

Either the code you are using is not optimised or you have not set optimum parameters for you DB or OS.

Share full dump and with windows version and mssql version.

Cheers,

Divyanshu

[Former Member]

Hi Divyanshu,

I attached the dump file PFA

dump.txt.zip

[divyanshu_srivastava3]

Hi Raghu,

1st update your kernel and DBSL.

The problem is in constructor call, so 1st update the kernel before changing thing on application and DB level.

Also, how have you setup up memory parameters - adjust using below standard notes

http://service.sap.com/sap/support/notes/1518419

http://service.sap.com/sap/support/notes/88416

Also, just do some more analysis, for eg, what else is running on your system and DB at the time of these dumps. May be your parameters are find but extra load causing these dumps.

Divyanshu

[divyanshu_srivastava3]

Use this: http://service.sap.com/sap/support/notes/568768 to find other causes.

Check SQL event logs and SM21 at that time.

Divyanshu

[Sriram2009]

Hi Raghu

In your MS Sql 2005 Server service pack is SP3, you can apply the latest service pack SP4

BR

SS

[Sriram2009]

Hi Raghu

1. After installation of ECC have you define the memory parameters based on your OS / DB?
Could you share the your SAP & OS /DB version details?

2. Just do the full restart and then try again with same option to insert a record

BR

SS

[Former Member]

Hi Sriram,

Thanks for your quick reply,

see the screen shot below for details,

[Sriram2009]

This message was moderated.