Runtime Error DBIF_DSQL2_OBJ_UNKNOWN

[Former Member]

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

[Former Member]

hi,

try this note 159510 will help u.

regards

ajai

[Former Member]

Hi,

The above note did not work.

Thanks,

priyanka ravishankar

[fidel_vales]

Hi,

I do not know DB2.

Are you sure the table you are trying to query exist on the DB2 system?

Are you sure the user that connects to the DB2 has authorizations to read such table?

14 EXEC SQL.

>>>>> select column_name

16 into :e_part_key

17 <b>from user_part_key_columns</b>

18 where name = :i_tablnm

19 ENDEXEC.

As mentioned before, I do not know DB2. I do know that the table user_part_key_columns exist in Oracle, but I do not know if it exist on DB2.