Skip to Content
0
Former Member
Oct 28, 2007 at 07:04 PM

Runtime Error DBIF_DSQL2_OBJ_UNKNOWN

269 Views

Hello Team,

I have BW 3.5 running in Oracle Database and i have connected a DB2 Data warehouse system as Source system using DB Connect and when i try to run Infosource i get the below short dump error.

Runtime Error DBIF_DSQL2_OBJ_UNKNOWN

Except. CX_SY_NATIVE_SQL_ERROR

ShrtText

Table does not exist in database.

What happened?

The table or view name used does not

exist in the database.

The error occurred in the current database connection "JVDWINT".

Error analysis

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

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

neither

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

"GET_PARTITION_KEY" "(FORM)"

.

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:

Triggering SQL statement: "select column_name from user_part_key_columns where

name = ? "

Database error code ....: "-204"

Information on where terminated

The termination occurred in the ABAP program "SAPLRSDU_PART_ORA" in

"GET_PARTITION_KEY".

The main program was "RSABW_START_NEW ".

The termination occurred in line 15 of the source code of the (Include)

program "LRSDU_PART_ORAF03"

of the source code of program "LRSDU_PART_ORAF03" (when calling the editor

150).

Processing was terminated because the exception "CX_SY_NATIVE_SQL_ERROR"

occurred in the

procedure "GET_PARTITION_KEY" "(FORM)" but was not handled locally, not

declared in the

RAISING clause of the procedure.

The procedure is in the program "SAPLRSDU_PART_ORA ". Its source code starts in

line 10

of the (Include) program "LRSDU_PART_ORAF03 ".

Source Code Extract

Line SourceCde

1 *----


*

2 * INCLUDE LRSDU_PART_ORAF03 *

3 *----


*

4

5 *----


*

6 * FORM GET_PARTITION_KEY *

7 *----


*

8 * Bestimmt den Partitionierungs-Key einer Tabelle

9 *----


*

10 FORM get_partition_key

11 USING i_tablnm TYPE rsd_tablnm

12 CHANGING e_part_key TYPE rsd_fieldnm.

13

14 EXEC SQL.

>>>>> select column_name

16 into :e_part_key

17 from user_part_key_columns

18 where name = :i_tablnm

19 ENDEXEC.

20

21 IF sy-subrc <> 0.

22 CLEAR e_part_key.

23 ENDIF.

24

25 ENDFORM. " GET_PARTITION_KEY

26

27

28 *----


*

29 * FORM GET_PARTITION_INFO *

30 *----


*

31 * Informationen über die Partitionierungs einer Tabelle lesen

32 *----


*

33 FORM get_partition_info

34 USING i_tablnm TYPE rsd_tablnm