cancel
Showing results for 
Search instead for 
Did you mean: 

DBIF_RSQL_SQL_ERROR CX_SY_OPEN_SQL_DB

Former Member
0 Kudos

Hi,

We are on BI 7.0 with oracle database.

We are getting the following error

DBIF_RSQL_SQL_ERROR

CX_SY_OPEN_SQL_DB

Short text

SQL error in the database when accessing a table.

What happened?

One of the columns addressed in a table or view

does not exist in the database.

table) exists in the ABAP/4 Dictionary, but not in

the database.

What can you do?

If this error occurred in Open SQL, there is an inconsistency

between the ABAP Data Dictionary and the database. You can resolve this

by converting the table in the database to the definition in the ABAP

Data Dictionary. To do this, call Transaction SE11 and then select

Utilities --> Database utility.

Note which actions and input led to the error.

For further help in handling the problem, contact your SAP administrator

.

You can use the ABAP dump analysis transaction ST22 to view and manage

termination messages, in particular for long term reference.

Thanks,

Rajiv

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

hi every one

i am new in BW and i face error message like the original message

the error message is

----------------------------------

Runtime Errors     DBIF_RSQL_SQL_ERROR
Except.            CX_SY_OPEN_SQL_DB
Date and Time      22.05.2013 02:39:07

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|Short text                                                                                    |
|SQL error in the database when accessing a table.                                         |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|Missing RAISING Clause in Interface                                                           |
|Program                             SAPLRSAOS                                         |
|Include                             LRSAOSF01                                         |
|Row                                 979                                               |
|Module type                         (FORM)                                            |
|Module Name                         RSISOSMAP_MULTI_GET                               |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|Trigger Location of Exception                                                                 |
|Program                             SAPLRSAOS                                         |
|Include                             LRSAOSF01                                         |
|Row                                 991                                               |
|Module type                         (FORM)                                            |
|Module Name                         RSISOSMAP_MULTI_GET                               |

----------------------------------------------------------------------------------------------------

----------------------------------------------------------------------------------------------------

|Source Code Extract                                                                           |

----------------------------------------------------------------------------------------------------

|Line |SourceCde                                                                               |

----------------------------------------------------------------------------------------------------

|  961|  ENDIF.                                                                                |
|  962|  LOOP AT l_t_oltpsourcet ASSIGNING <l_s_oltpsourcet>.                                  |
|  963|READ TABLE l_t_langu                                                                |
|  964|WITH KEY table_line = <l_s_oltpsourcet>-langu                                       |
|  965|TRANSPORTING NO FIELDS BINARY SEARCH.                                               |
|  966|IF sy-subrc = 0. APPEND <l_s_oltpsourcet> TO e_t_oltpsourcet. ENDIF.                |
|  967|  ENDLOOP.                                                                              |
|  968|  SORT e_t_oltpsourcet BY oltpsource logsys objvers.                                    |
|  969|ENDFORM.                           " RSOLTPSOURCET_MULTI_GET                        |
|  970|*&---------------------------------------------------------------------*                |
|  971|*&  Form  RSISOSMAP_MULTI_GET                                                       |
|  972|*&---------------------------------------------------------------------*                |
|  973|*  Select oltpsourcemap for all header entries                                          |
|  974|*----------------------------------------------------------------------*                |
|  975|*  -->i_FULL_TABLE  text                                                            |
|  976|*  -->i_T_HEADER  text                                                              |
|  977|*  <--E_T_ISOSMAP  text                                                             |
|  978|*----------------------------------------------------------------------*                |
|  979|FORM rsisosmap_multi_get                                                                |
|  980|  USINGi_objversTYPE rsobjvers                                                  |
|  981|       i_full_table TYPE rs_bool                                                    |
|  982|       i_t_header   TYPE rsaos_t_oltpsource_header                                  |
|  983|  CHANGING e_t_isosmap  TYPE rsaos_t_isosmap.                                           |
|  984|                                                                                        |
|  985|  REFRESH e_t_isosmap.                                                                  |
|  986|  CHECK NOT i_t_header IS INITIAL OR                                                    |
|  987|        i_full_table = rsaos_c_flag-on.                                             |
|  988|                                                                                        |
|  989|  IF i_full_table = rsaos_c_flag-off.                                                   |
|  990|* Select for all entries in header table                                                |
|>>>>>|SELECT * FROM rsisosmap                                                             |
|  992|INTO CORRESPONDING FIELDS OF TABLE e_t_isosmap                                      |
|  993|FOR ALL ENTRIES IN i_t_header                                                       |
|  994|WHERE oltpsource = i_t_header-oltpsource AND                                        |
|  995|      logsys = i_t_header-logsys AND                                        |
|  996|      objvers= i_objvers.                                                       |
|  997|  ELSE.                                                                                 |
|  998|* Select everything                                                                     |
|  999|SELECT * FROM rsisosmap                                                             |
| 1000|INTO CORRESPONDING FIELDS OF TABLE e_t_isosmap                                      |
| 1001|WHERE objvers = i_objvers.                                                          |
| 1002|  ENDIF.                                                                                |
| 1003|  SORT e_t_isosmap BY oltpsource logsys.                                                |
| 1004|ENDFORM.                         " RSISOSMAP_MULTI_GET                              |
| 1005|*&---------------------------------------------------------------------*                |
| 1006|*&  Form  rsbasidoc_get                                                             |
| 1007|*&---------------------------------------------------------------------*                |
| 1008|* Fetch RSABSIDOC RLOGSY = Myself from Database                                         |
| 1009|*----------------------------------------------------------------------*                |
| 1010|*  <--E_T_RSBASIDOC  text                                                           |

----------------------------------------------------------------------------------------------------

Former Member
0 Kudos

issue resolved

Former Member
0 Kudos

Hi,

I have the same problem.

Please, how did you solve it?

Thank you very much

Former Member
0 Kudos

If the issue is happening during data load to cube, drop the index and reload again.

This will solve your problem

Former Member
0 Kudos

Hi

I am facing same problem, please help me.

Rgds

GAnesh

Former Member
0 Kudos

Can ypu please post the section in st22 which says how to correct the error.please let us know what program you r running.

Please let us know what is your BI System patch level.

Please check Below three notes

1236334 Runtime error DBIF_RSQL_SQL_ERROR during load to PSA

1162821 DataSource (OSOA): Replication SQL error: Dump in source sys

1102641 Consult: Dump during insert in PSA table due to incorr vals

Thanks

Rishi Abrol

Former Member
0 Kudos

Hi Rishi,

The level is 17.A BW Job was run.

How to correct the error:

Database error text........: "ORA-00904: "/BIC/ZPLTVAR": invalid identifier"

Internal call code.........: "[RSQL/INSR//BIC/B0000338000 ]"

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

If the error occures in a non-modified SAP program, you may be able to

find an interim solution in an SAP Note.

If you have access to SAP Notes, carry out a search with the following

keywords:

"DBIF_RSQL_SQL_ERROR" "CX_SY_OPEN_SQL_DB"

"GP4CKD3RF4QXKVE2CNYX3G9YOO9" or "GP4CKD3RF4QXKVE2CNYX3G9YOO9"

"INSERT_ODS"

If you cannot solve the problem yourself and want to send an error

notification to SAP, include the following information:

1. The description of the current problem (short dump)

To save the description, choose "System->List->Save->Local File

(Unconverted)".

2. Corresponding system log

Display the system log by calling transaction SM21.

Restrict the time interval to 10 minutes before and five minutes

after the short dump. Then choose "System->List->Save->Local File

(Unconverted)".

3. If the problem occurs in a problem of your own or a modified SAP

program: The source code of the program

In the editor, choose "Utilities->More

Utilities->Upload/Download->Download".

4. Details about the conditions under which the error occurred or which

actions and input led to the error.

The exception must either be prevented, caught within proedure

"INSERT_ODS" "(FORM)", or its possible occurrence must be declared in the

RAISING clause of the procedure.

Thanks,

Rajiv

Former Member
0 Kudos

Hi ,

Please check this Note

Note 1327130 - ORA-00904: invalid identifier

Thanks

Rishi Abrol

Former Member
0 Kudos

This message was moderated.