on 03-17-2014 8:22 AM
Hello All,
We are getting below runtime errors
Runtime Errors DBIF_RSQL_SQL_ERROR
Exception CX_SY_OPEN_SQL_DB
Short text
SQL error in the database when accessing a table.
What can you do?
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.
How to correct the error
Database error text........: "Resource limit exceeded. MSGID= Job=753531/IBPADM/WP05""
Internal call code.........: "[RSQL/OPEN/PRPS ]"
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"
"SAPLCATL2" or "LCATL2U17"
"CATS_SELECT_PRPS"
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.
System environment
SAP-Release 700
Application server... "SAPIBP0"
Network address...... "3.14.226.140"
Operating system..... "OS400"
Release.............. "7.1"
Character length.... 16 Bits
Pointer length....... 64 Bits
Work process number.. 5
Shortdump setting.... "full"
Database server... "SAPIBP0"
Database type..... "DB400"
Database name..... "IBP"
Database user ID.. "R3IBPDATA"
Terminal................. "KRSNBRB032"
Char.set.... "C"
SAP kernel....... 721
created (date)... "May 15 2013 01:29:20"
create on........ "AIX 1 6 00CFADC14C00 (IBM i with OS400)"
Database version. "DB4_71"
Patch level. 118
Patch text.. " "
Database............. "V7R1"
SAP database version. 721
Operating system..... "OS400 1 7"
Memory consumption
Roll.... 0
EM...... 12569376
Heap.... 0
Page.... 2351104
MM Used. 5210400
MM Free. 3166288
Information on where terminated
Termination occurred in the ABAP program "SAPLCATL2" - in "CATS_SELECT_PRPS".
The main program was "CATSSHOW ".
In the source code you have the termination point in line 67
of the (Include) program "LCATL2U17".
The termination is caused because exception "CX_SY_OPEN_SQL_DB" occurred in
procedure "CATS_SELECT_PRPS" "(FUNCTION)", but it was neither handled locally
nor declared
in the RAISING clause of its signature.
The procedure is in program "SAPLCATL2 "; its source code begins in line
1 of the (Include program "LCATL2U17 ".
The exception must either be prevented, caught within proedure
"CATS_SELECT_PRPS" "(FUNCTION)", or its possible occurrence must be declared in
the
RAISING clause of the procedure.
To prevent the exception, note the following:
SM21: Log
--------------------------------------------------------------------------------
Database error -904 at PRE access to table PRPS
> Resource limit exceeded. MSGID= Job=871896/VGPADM/WP05
Run-time error "DBIF_RSQL_SQL_ERROR" occurred
----------------------------------------------------------------------------------
Please help
Regards,
Usha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Usha,
Check SAP note 54028- IBMi: SQL904 reason code 7
SAP note 1109573 is also interesting in this context.
Most often deleting the SQL Packages helps to fix the problem, for that you need to stop your SAP system.
Best regards,
Hadi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Usha
Could you check this SAP Notes
1930962 - IBM i: Size restriction of database tables
1966949 - IBM i: Runtime error DBIF_DSQL2_SQL_ERROR in RSDB4UPD
BR
SS
Hi Praty,
Refer SAP Note 54028 - IBM i: SQL0 904 reason code 7, overflow in SQL package
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.