cancel
Showing results for 
Search instead for 
Did you mean: 

Error while execting Tcodes ST04,ST03,DB12,DB02

Former Member
0 Kudos

Hi Experts,

I had installed QAS & DEV instances successfully on one windows host.Below are the syste details.

OS :- Windows 2003 64 bit Standard Edition

Database :- Oracle 10.2.0.2

SAP :- R/3 4.7 Enterprise Ext. 200 SR1

Support Pack :-

SAP_Basis 6.20 Level 41

SAP_APPL 470 Level 21

SAP_ABA 6.20 Level 41

I am facing problem while executing transactions related to database i.e st04,st03,db12,db02.

After executing this transactions I received followng dumps.

1) Runtime Errors DBIF_DSQL2_SQL_ERROR

Exception CX_SY_NATIVE_SQL_ERROR

Database error text........: "ORA-00904: "KEY": invalid identifier"

Triggering SQL statement...: "FETCH NEXT "

Internal call code.........: "DBDS/NEW DSQL"

2) Runtime Errors RAISE_EXCEPTION

Exception condition "DB_RELEASE_UNKNOWN" raised

Error analysis

A RAISE statement in the program "SAPLSORA" raised the exception

condition "DB_RELEASE_UNKNOWN".

Since the exception was not intercepted by a superior program

in the hierarchy, processing was terminated.

3)Runtime Errors BCD_ZERODIVIDE

Exception CX_SY_ZERODIVIDE

An exception occurred. This exception is dealt with in more detail below

. The exception, which is assigned to the class 'CX_SY_ZERODIVIDE', was neither

caught nor passed along using a RAISING clause, in the procedure

"SKOM_CT_PERF_BUF_REDO" "(FUNCTION)"

.

Since the caller of the procedure could not have expected this exception

to occur, the running program was terminated.

The reason for the exception is:

In the current program "SAPLSKOM", an arithmetic operation ('DIVIDE',

'/', 'DIV', or 'MOD') with a type P operand attempted to divide

by 0.

4) Runtime Errors COMPUTE_BCD_OVERFLOW

Exception CX_SY_ARITHMETIC_OVERFLOW

Error analysis

An exception occurred. This exception is dealt with in more detail below

. The exception, which is assigned to the class 'CX_SY_ARITHMETIC_OVERFLOW',

was neither

caught nor passed along using a RAISING clause, in the procedure

"SKOM_CT_PERF_BUF_LIB" "(FUNCTION)"

.

Since the caller of the procedure could not have expected this exception

to occur, the running program was terminated.

The reason for the exception is:

An overflow has been determined in the current arithmetical operation

containing operands of type P. Possible causes include:

1. The results field of type P is to small and the result does not fit

into it.

places.

2. The result or partial result has more than 31 decimal places.

Thanks,

Sachin

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member251078
Participant
0 Kudos

Hello,

Please have a look into the note 582427, this could resolve your issue.

Hope this helps

Regards

Dileep

Former Member
0 Kudos

Hello,

check the note

Note 1046396 - ST04N: Submonitor: Top SQL Statements: DBIF_DSQL2_SQL_ERROR

markus_doehr2
Active Contributor
0 Kudos

According to the Oracle 10g upgrade guide you need at least Basis support package level 44 (you have 41) - see page 16 of that guide.

Markus

Former Member
0 Kudos

Hi Markus,

There is no upgrade takes place.

Both instances are newly installed.

Thanks,

Sachin

markus_doehr2
Active Contributor
0 Kudos

Yes - but to run Oracle 10g on a 6.20 based release you need the minimum Basis support package 44 to get the full CCMS functionality.

Markus

Former Member
0 Kudos

Hi Markus,

Please suggest me a document or SAP Note.

Thanks,

Sachin

markus_doehr2
Active Contributor
0 Kudos

check note 868681 - Oracle Database 10g: Database Release Check

<...>

Check the level of your Basis support package using this table:

SAP Release (SAP_BASIS) Basis Support Package Level

46C SAPKB46C48

46D SAPKB46D38

6.10 SAPKB61041

6.20 SAPKB62044

6.40 SAPKB64009

<...>

Markus

Former Member
0 Kudos

Hi Markus,

I have seen the note#741119, it asks to apply pack SAPKB64004, but its says its valid for Release 640 only. My release is 640 currently:

Software Component Name SAP_BASIS

Software Component Release 620

Support Package Level 0041

Highest Imported Support Package SAPKB62041

Short Description of Software Component SAP Basis Component

Support Package type Basis Support Pkg.

My question is, can i apply the pack directly on release 620? The prequisite to this pack says, the release should be 640. This forum helped me a lot, hoping you guys will solve my this issue as well.

Regards.

former_member204746
Active Contributor
0 Kudos

Refer to Markus' note:

868681 - Oracle Database 10g: Database Release Check

Check the level of your Basis support package:

6.20 SAPKB62044

so now, apply SAP BASIS support back 2.0 42, 43 and 44.