DBIF_DSQL2_SQL_ERROR & ORA-02019

[Former Member]

I have an user reporting with this Database connection problem to "POSSE_DW"? I beleive this is relates to Database link problem? In SAP I am not quite sure how to look at the database links? can someone please tell me way to see teh all the database links? and where to start for an issues like this? This is the first I am dealing with this kind of an error.

Logs

ST22 Dump:

What happened?

Error 2019 occurred in the current database connection "POSSE_DW".

How to correct the error

Database error text........: "ORA-02019: connection description for remote

database not found#ORA-06512: at line 1#ORA-06512: at

"EXTERNAL_USERS.FINDWASSAPPOBJID", line 17"

Database error code .......: 2019

Triggering SQL statement...: "FETCH NEXT "

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

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

SM21 Logs:

Run-time error "DBIF_DSQL2_SQL_ERROR" occurred

> Short dump "070720 075722 sph03 GABDON " generated

Database error 2019 at FET

> ORA-02019: connection description for remote database not

> found#ORA-06512: at line 1#ORA-06512: at

> "EXTERNAL_USERS.FINDWASSAPPOBJID", line 17

Thanks In Advance

Kumar

[markus_doehr2]

Is this a BW system with external data source?

--

Markus

[Former Member]

this was syntax error. We resovled on our own.

Thanks in anyway.

Kumar

[Former Member]

HI Kumar,

We are also facing a similar issue.

Can you please let me know how did you resolve this issue ?

Regards

Hemant Khemani