on 08-19-2009 12:39 PM
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
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| USING | i_objvers | TYPE 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 | | |
----------------------------------------------------------------------------------------------------
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
issue resolved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.