cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

ORA-600(DBIF_RSQL_SQL_ERROR)

Former Member

on ‎01-27-2009 7:17 AM

0 Kudos

Dear Experts,

In our Development system from the past couple of days we are getting too many ABAP dumps like

RAISE_EXCEPTION( Exception condition "ADD_PARTITION_FAILED" raised.)

DBIF_RSQL_SQL_ERROR

DBIF_RSQL_SQL_ERROR

DBIF_RSQL_SQL_ERROR(Database error text........: "ORA-14400: inserted partition key does not map to any partition" Internal call code.........: "[RSQL/INSR//BIC/B0003314000 ]")

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

[ktfbbssearch-5], [3999], [], [], [], [], [], []"

Database error code........: 600

Triggering SQL statement...: "INSERT into "/BIC/DX_FWPINS2" ( "DIMID",

"SID_X_RSNNO", "SID_X_BILLDOC", "SID_X_RSN", "SID_X_BIL", "SID_0ORG_DOC_CO",

"SID_TEXT1" ) values ( ? , ? , ? , ? , ? , ? , ? )"

Internal call code.........: "[DBDS/NEW DSQL]")

alert_BD1.log

Tue Jan 27 09:56:05 2009

Errors in file /oracle/BD1/saptrace/usertrace/bd1_ora_19340.trc:

ORA-00600: internal error code, arguments: [ktfbbssearch-3], [31999], [31999], [], [], [], [], []

Tue Jan 27 10:04:16 2009

Errors in file /oracle/BD1/saptrace/usertrace/bd1_ora_19340.trc:

ORA-00600: internal error code, arguments: [ktfbbssearch-3], [31999], [31999], [], [], [], [], []

Tue Jan 27 10:11:47 2009

Errors in file /oracle/BD1/saptrace/usertrace/bd1_ora_19346.trc:

ORA-00600: internal error code, arguments: [ktfbbssearch-3], [31999], [31999], [], [], [], [], []

Tue Jan 27 10:14:45 2009

Errors in file /oracle/BD1/saptrace/usertrace/bd1_ora_19340.trc:

ORA-00600: internal error code, arguments: [ktfbbssearch-3], [31999], [31999], [], [], [], [], []

bd1_ora_19340.trc

Dump file /oracle/BD1/saptrace/usertrace/bd1_ora_19340.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production

With the Partitioning and Data Mining options

ORACLE_HOME = /oracle/BD1/102_64

System name: SunOS

Node name: devbiw

Release: 5.10

Version: Generic_118833-36

Machine: sun4u

Instance name: BD1

Redo thread mounted by this instance: 1

Oracle process number: 15

Unix process pid: 19340, image: oracleBD1@devbiw

      • ACTION NAME:(11396) 2009-01-27 09:56:05.095

      • MODULE NAME:(SAPLRSSTATMAN ) 2009-01-27 09:56:05.095

      • SERVICE NAME:(SYS$USERS) 2009-01-27 09:56:05.095

      • SESSION ID:(127.5) 2009-01-27 09:56:05.095

      • 2009-01-27 09:56:05.095

ksedmp: internal or fatal error

ORA-00600: internal error code, arguments: [ktfbbssearch-3], [31999], [31999], [], [], [], [], []

Current SQL statement for this session:

INSERT INTO "RSSTATMANPSA" VALUES( :A0 , :A1 , :A2 , :A3 , :A4 , :A5 , :A6 , :A7 , :A8 , :A9 , :A10 , :A11 , :A12 , :A13 , :A1

4 , :A15 , :A16 , :A17 , :A18 , :A19 )

Oracle version:10.2.0.2.0

NW04ssr1(BI)

Is there any interim patch resolving this kind of issues. As per Oracle and SAP discussion the only option we have is version upgrade.

Please help regarding this one.

Thanks,

Satish.

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (9)

Answers (9)

Former Member
‎02-16-2009 5:03 AM
0 Kudos

while rebuild the tablespace bitmaps using DBMS_SPACE.TABLESPACE_REBUILD_BITMAPS package, __Error is Object no longer exist.__

Thanks

Satish.

Show replies
Show replies
Former Member
‎02-16-2009 5:30 AM
0 Kudos

Hi sathish,

Can u please run Verify db and check db in db13 .

See if there are any corrupt blocks.

I doubt that also.

Regards,

siddhartha

Former Member
‎02-16-2009 4:53 AM
0 Kudos

Hi,

This error bascially implies that the bitmap of the tablespace is corrupted as

Oracle didn't find the information in the bitmap consistent during allocating

new extent.

We have updated the issue to the Oracle Metalink support. They have given us a action plan to perform to rebuild the tablespace bitmaps using DBMS_SPACE.TABLESPACE_REBUILD_BITMAPS

package. But still it is giving error. Please help this regard.

Thanks & Regards,

Satish.K

Show replies
Show replies
Former Member
‎02-12-2009 10:38 AM
0 Kudos

Hi Siddarth,

Interim patches applied....still we are getting same error.

Thanks & Regards,

Satish.K

Show replies
Show replies
fidel_vales
Employee
Employee
‎02-12-2009 12:04 PM
0 Kudos

Hi,

this is an ORA-600 error (internal oracle error)

It is not documented (at least in SAP notes)

Then you need to open an SAP message.

Include in the message

1) list of patches installed (opatch - lsinventory)

2) list of parameters set

3) dump file created by the error

4) how to reproduce it

Former Member
‎02-11-2009 4:31 AM
0 Kudos

Dear Experts,

I have a strange problem with my development server. whenever our developer trying to activate ODS or object or pulling data from ETL , initially we are getting "ORA-03114: not connected to ORACLE" error in ST22(DBIF_RSQL_SQL_ERROR). Then ADD-Partition failed error and finally ORA 600 error(ORA-00600: internal error code, arguments: [ktfbbssearch-5], [3999], [], [], [], [], [], []).

I have been in contact with SAP and Oracle meta link Support about an ORA-00600 😞 internal error code, arguments: [3999], and they have declared it a bug. finally we upgraded from 10.2.0.2.0 to 10.2.0.4.0 After upgradation still we are getting same errors.

has anybody else seen this error before, and if so, did you determine what caused it?

NW04ssr1(BI 70)

Oracle 10g.

Alert log

Errors in file /oracle/BD1/saptrace/usertrace/bd1_ora_29110.trc:

ORA-00600: internal error code, arguments: [ktfbbssearch-5], [3999], [], [], [], [], [], []

Wed Feb 11 09:32:14 2009

Errors in file /oracle/BD1/saptrace/usertrace/bd1_ora_13591.trc:

ORA-00600: internal error code, arguments: [ktfbbssearch-5], [3999], [], [], [], [], [], []

Wed Feb 11 09:35:38 2009

Errors in file /oracle/BD1/saptrace/usertrace/bd1_ora_29215.trc:

ORA-00600: internal error code, arguments: [ktfbbssearch-5], [3999], [], [], [], [], [], []

Wed Feb 11 09:35:40 2009

Errors in file /oracle/BD1/saptrace/usertrace/bd1_ora_29218.trc:

ORA-00600: internal error code, arguments: [ktfbbssearch-5], [3999], [], [], [], [], [], []

Any thoughts on this would be appreciated.

Thanks,

Satish.K

Show replies
Show replies
Former Member
‎02-11-2009 4:41 AM
0 Kudos

Hi satish,

This is a bug in oracle.

After upgrading to oracle 10.2.0.4, have u applied the interim patch level?

please check the note

Note 1137346 - Oracle Database 10g: Patches for Release 10.2.0.4

Note 871096 - Oracle Database 10g: Patch sets/patches for 10.2.0.

Regards,

siddhartha.

Former Member
‎01-28-2009 11:32 AM
0 Kudos

Hi yk,

My SP level is SAPKW70013(BI70). The only alternative is 10.2.0.4 patch upgrade.

Thanks ,

Satish.K

Show replies
Show replies
Former Member
‎01-28-2009 11:16 AM
0 Kudos

Hi,

you can follow the patch instructions given by SAP. Problem is you have some inconsistent meta data

in BW - logical error in the BW application. Workarounds may break while running the system again...

You have to patch and correct the issue.

search service.sap.com for "ORA-14400" and see SAP note 991181 and related!


Symptom

    * The program terminates with database error ORA1440 when you try to load an InfoPackage.

    * When you activate a transfer rule, a termination occurs with error RSAODS001.

Other terms

ORACLE, partitioned  Persistent Staging Area (PSA) tables; ORA-14400
RSAODS001, RSAODS 001, 001(RSARODS)
Reason and Prerequisites

Prerequisites: There is already PSA metadata in the system.
This note improves the stability of the PSA/PSA service.
Solution

This note improves the stability of the PSA/PSA service with regard to inconsistent partitioning administration data.

    * BW 3.0B and BW 3.10 Content

           Implement the attached correction instructions. For SAP BW Releases 3.0B and 3.10, no additional Support Packages will be delivered until further notice.

    * BW 3.50

           Import Support Package 20 for 3.5 (BW 3.50 Patch 20 or SAPKW35020) into your BW system. The Support Package is available once Note 986891, "SAPBWNews BW Support Package 20 NetWeaver'04 Stack 20", which describes this Support Package in more detail, has been released for customers.

    * BW 7.0

           Import Support Package 11 for 7.0 (BW 7.0 Patch 11 or SAPKW70011) into your BW system. The Support Package is available when Note 914305 "SAPBWNews BW 7.0 Support Package 11", which describes this Support Package in more detail, has been released for customers.

bye

yk

Show replies
Show replies
Former Member
‎01-28-2009 4:50 AM
0 Kudos

Hi,

ORA-14400: inserted partition key does not map to any partition

Cause: An attempt was made to insert a record into, a Range or Composite Range object, with a concatenated partition key that is beyond the concatenated partition bound list of the last partition -OR- An attempt was made to insert a record into a List object with a partition key that did not match the literal values specified for any of the partitions.

Action: Do not insert the key. Or, add a partition capable of accepting the key, Or add values matching the key to a partition specification

Hope it helps

Regards

KT

Show replies
Show replies
Former Member
‎01-28-2009 4:39 AM
0 Kudos

Hi satish,

ora - 600 is an oracle internal error.

Please tell me if u have applied interim patches.

Regards,

siddhartha

Show replies
Show replies
Former Member
‎01-27-2009 5:36 PM
0 Kudos

Hai,

This is error ORA-00600 is an internal Oracle error.

You can search in metalink (metalink.oracle.com) with ORA-00600 and the arguments provided you will find various metalink notes.

You can use SAP's metalink id to login the above site. Use SAP Note 758563.

Please check SAP Note 871735 - Current patch set for Oracle 10.2.0.

Regards,

Yoganand.V

Show replies
Show replies
Ask a Question