Error DBIF_RSQL_SQL_ERROR

Hi all,

We have ecc6 sr3 , oracle 10.2.0.2.0 , win server 2003, In our PRD server our abapers had facing the dump.

For your Information I am forwarding ST22 log below

st22 log----

Runtime Errors DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

I also go to T-code db02 for increase tablespace but how to increase the tablespace tell me.

Please kindly guide me to resolve this issue

Aftab

SAP Managed Tags:
Windows Server

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

Hi,

Can you please let us know what changes you did before the system raises this dump.

Did you check for any space issues? Did you check for any entries in the

system log Tx SM21?

Read,

SAP Note 830576 - Parameter recommendations for Oracle 10g

Cheers

Deepanshu

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Sharma,

here is the log of SM21

12:05:18 BTC 007 650 ABAPDEV BY L Database error 600 requires database administrator to intervene

12:05:18 BTC 007 650 ABAPDEV BY 4 Database error 600 at UPD access to table ZSTRN

12:05:18 BTC 007 650 ABAPDEV BY 0 > ORA-00600: internal error code, arguments: [kturbleurec1],

12:05:18 BTC 007 650 ABAPDEV BY 0 > [], [], [], [], [], [], []

12:05:19 BTC 007 650 ABAPDEV AB 0 Run-time error "DBIF_RSQL_SQL_ERROR" occurred

12:05:19 BTC 007 650 ABAPDEV AB 1 > Short dump "091103 120519 prdsap_P RD_00 " generated

12:05:19 BTC 007 650 ABAPDEV D0 1 Transaction Canceled 00 671 ( DBIF_RSQL_SQL_ERROR

12:12:54 DIA 000 650 TCL01 SEU_ BY M SQL error 3113 occurred; work process in reconnect status

20091103120519prdsap_PRD_00 ABAPDEV 650 )

Here also the log of DB02

PSAPSR3 40,040.00 4,948.13 88 YES 200,000.00 164,908.13 18 20 156,926 188,124 ONLINE PERMANENT

PSAPSR3700 58,400.00 340.50 99 YES 160,000.00 101,940.50 36 16 801 10,640 ONLINE PERMANENT

PSAPUNDO 9,160.00 176.00 98 YES 10,000.00 1,016.00 90 1 20 935 ONLINE UNDO

SYSTEM 840.00 8.50 99 YES 10,000.00 9,168.50 8 1 1,204 2,761 ONLINE PERMANENT

rgds

aftab

Hi Aftab,

12:05:19 BTC 007 650 ABAPDEV AB 0 Run-time error "DBIF_RSQL_SQL_ERROR" occurred

Please double click on same and get more information.

Cheers

Deepanshu

ORA-00600: internal error code, arguments: kturbleurec1,

You have got a serious problem with your Oracle database.

Start with SAP note 376755.

Here is the description of that error

Runtime Errors DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

Date and Time 03.11.2009 13:25:48

Short text

SQL error in the database when accessing a table.

What happened?

An exceptional situation has occurred in the ORACLE software,

possibly due to an error.

This is not an error in an application program.

How to correct the error

Database error text........: "ORA-00600: internal error code, arguments:

[kturbleurec1], [], [], [], [], [], [], []"

Internal call code.........: "[RSQL/178/ZSTRN ]"

Please check the entries in the system log (Transaction SM21).

If the error occures in a non-modified SAP program, you may be able to

find an interim solution in an SAP Note.

If you have access to SAP Notes, carry out a search with the following

keywords:

"DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"

"ZAHS_DBCON_STOCK_TRANSFER" or "ZAHS_DBCON_STOCK_TRANSFER"

"START-OF-SELECTION"

User and Transaction

Client.............. 650

User................ "ABAPDEV"

Language key........ "E"

Transaction......... " "

Transactions ID..... "5152C8DE0C88F12084B5005056C00008"

Program............. "ZAHS_DBCON_STOCK_TRANSFER"

Screen.............. "SAPMSSY0 1000"

Screen line......... 6

Information on where terminated

Termination occurred in the ABAP program "ZAHS_DBCON_STOCK_TRANSFER" - in

"START-OF-SELECTION".

The main program was "ZAHS_DBCON_STOCK_TRANSFER ".

In the source code you have the termination point in line 178

of the (Include) program "ZAHS_DBCON_STOCK_TRANSFER".

The program "ZAHS_DBCON_STOCK_TRANSFER" was started as a background job.

Job Name....... "ZAHS_DBCON_STOCK_TRANSFER"

Job Initiator.. "ABAPDEV"

Job Number..... 12302400

rgds

aftab

Hi Aftab,

In the meantime please open message OSS message with SAP.

Cheers

Deepanshu

Hi,

could u plz tell me that what would be the next step to do ?

Did you install the latest interim patches for 10.2.0.2? If no, then I'd do that before the system is harmed more.

Markus

Hi Markus,

We have resorted the backup, DB and MMC is workiing fine but after sometime the DB automatically shutdown. The dump of ST22 is in my previous post

We got the following error in trace file below:

===================

Thu Sep 03 11:11:24 2009

Errors in file g:\oracle\prd\saptrace\background\prd_arc0_5804.trc:

ORA-19504: failed to create file "F:\ORACLE\PRD\ORAARCH\PRDARCHARC06509_0684514945.001"

ORA-27044: unable to write the header block of file

OSD-04008: WriteFile() failure, unable to write to file

O/S-Error: (OS 112) There is not enough space on the disk.

Thu Sep 03 11:11:24 2009

ARC0: Error 19504 Creating archive log file to 'F:\ORACLE\PRD\ORAARCH\PRDARCHARC06509_0684514945.001'

ARC0: Failed to archive thread 1 sequence 6509 (19504)

ARCH: Archival stopped, error occurred. Will continue retrying

Thu Sep 03 11:11:25 2009

Errors in file g:\oracle\prd\saptrace\background\prd_arc0_5804.trc:

ORA-16038: log 1 sequence# 6509 cannot be archived

ORA-19504: failed to create file ""

ORA-00312: online log 1 thread 1: 'E:\ORACLE\PRD\ORIGLOGA\LOG_G11M1.DBF'

ORA-00312: online log 1 thread 1: 'E:\ORACLE\PRD\MIRRLOGA\LOG_G11M2.DBF'

===================

Also we didnt apply the intrim patches yet,

You mean the after applying these intrim patches this problem may solve ??

Aftab

> We got the following error in trace file below:

> ===================

> Thu Sep 03 11:11:24 2009

> Errors in file g:\oracle\prd\saptrace\background\prd_arc0_5804.trc:

> ORA-19504: failed to create file "F:\ORACLE\PRD\ORAARCH\PRDARCHARC06509_0684514945.001"

> ORA-27044: unable to write the header block of file

> OSD-04008: WriteFile() failure, unable to write to file

> O/S-Error: (OS 112) There is not enough space on the disk.

As you can see - the error is pretty obvious. Your filesystem is full.

Interim patches should be ALWAYS installed. Especially a fix for 10.2.0.2 is necessary to prevent the database from doing block corruptions.

Markus

OK we r downloading intrim patches then after we apply that.

But the strange thing is that all drives have more than 50GB free space avaliable ..................

aftab

> OK we r downloading intrim patches then after we apply that.

good!

> But the strange thing is that all drives have more than 50GB free space avaliable ..................

Then you may have problems on your storage backend. You may also have already run into certain corruptions. Check the windows event log also for possible pointers to storage problems.

Markus

When we started the DB and SA P .The following error will appera in OS Event log

After every 2-3 min

SAP-Basis System: Transaction Canceled 00 560 ( ABAPDEV 650 )

Initializing PGA for process QMNC in instance prd.

Initializing PGA for process ARC2 in instance prd.

..............

then after somtimes 5-10 min the db will automatically shutdown ....

aftab

hi,

plz tell us about error

SAP-Basis System: Transaction Canceled 00 560 ( ABAPDEV 650 )

we stuck this is comming time and again

unable to download patches due to slow connection

regard

> SAP-Basis System: Transaction Canceled 00 560 ( ABAPDEV 650 )

a transaction of user ABAPDEV was cancelled. Check the SAP syslog.

> we stuck this is comming time and again

so that user is cancelling transactions again and again.

> unable to download patches due to slow connection

Check again your filesystem, the free space is misleading if you e. g. use compressed directories (never compress disks on a SAP server).

Markus

a transaction of user ABAPDEV was cancelled. Check the SAP syslog.

all users r locked,

SAP syslog is

SAP-Basis System: Transaction Canceled 00 560 ( ABAPDEV 650 )

Background processing: Failed to activate authorization check for user ABAPDEV

Check again your filesystem, the free space is misleading if you e. g. use compressed directories (never compress disks on a SAP server).

we checked no drive is in compression mode all drive are OK

plz suggest me something more ..................our PRD is DOWN

regrads

> plz suggest me something more ..................our PRD is DOWN

1. Open a priority very high call @ SAP.

2. check the Oracle alert log

Markus

here is the DB02 log

tablespace name size(Mb) used(Mb) Free space(%) total size(Mb) total use files

PSAPSR3 40,040.00 4,936.56 88 200,000.00 18 20

PSAPSR3700 58,400.00 339.38 99 160,000.00 36 16

PSAPSR3USR 20 18.13 9 10,000.00 0 1

PSAPTEMP 2,000.00 2,000.00 0 10,000.00 0 1

PSAPUNDO 9,160.00 7,576.44 17 10,000.00 16 1

SYSAUX 240 48.44 80 10,000.00 2 1

SYSTEM 840 8.5 99 10,000.00 8 1

see the used space , is it fine

aftab

And your filesystem with your archive logs?

Markus

Ask a Question

Top Q&A Solution Author

User

Count