ERROR in Module RSQL &include &P9

[Former Member]

Hi Experts,

I have an issue with Solman 7.1, when accessing the transaction solman_workcenter the Gui displays :

“ 500 Sap Internal ERROR

ERROR: Error in module RSQL of the Database interface &INCLUDE &P9 (termination RABAX_STATE).”

In the ST22 trans. Displays

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

Category               ABAP Programming Error

Runtime Errors         DBIF_RSQL_INVALID_RSQL

1. Except.                CX_SY_OPEN_SQL_DB

ABAP Program CL_POWL_QUERY_ACCESSOR========CP

Application Component  CA-GTF-SGF-POW

Date and Time          25.10.2013 12:04:05

Short text

    Error in module RSQL of the database interface

What happened?

    Error in the ABAP Application Program

    The current ABAP program "CL_POWL_QUERY_ACCESSOR========CP" had to be

     terminated because it has

    come across a statement that unfortunately cannot be executed.

Error analysis

    An exception occurred that is explained in detail below.

    The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

     in

    procedure "GET_VISIBLE_QUERIES" "(METHOD)", nor was it propagated by a RAISING

     clause.

    Since the caller of the procedure could not have anticipated that the

    exception would occur, the current program is terminated.

    The reason for the exception is:

    The SQL statement generated from the SAP Open SQL statement violates a

    restriction imposed by the underlying database system of the ABAP

system.

On the ST11

Viewing the dev_w# log, I have this:

A  ABAP Program CL_POWL_QUERY_ACCESSOR========CP        .

A  Source CL_POWL_QUERY_ACCESSOR========CM003      Line 92.

A  Error Code DBIF_RSQL_INVALID_RSQL.

A  Module $Id: //bas/720_REL/src/krn/runt/absapsql.c#18 $ SAP.

A  Function ab_HandleRsqlErrors Line 702.

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

And on the SM21 trans for the system logs I have this

Details Page 2 Line 26 System Log: Local Analysis of grp-dcs                  1

Time Type Nr  Clt User         TCode Grp N Text

12:04:05 DIA 001 400 SOLMAN_ADMIN       AB  0 Run-time error "DBIF_RSQL_INVALID_RSQL" occurred

Run-time error "DBIF_RSQL_INVALID_RSQL" occurred

Details

Recording at local and central time........................ 25.10.2013 12:04:05

Task...... Process                     User......   Terminal Session TCode Program  Cl Problem cl          Package 11328      Dialog work process No. 001 SOLMAN_ADMIN 10.1.25.       1       SAPMHTTP T  Transaction Problem SABP

I need help with this error, right now I can´t access to my work center, I appreciate it your help and knowledge about this, I’ve looking on service sap without lucky .

1. Regards.

[Former Member · Accepted solution]

Can you attach full dump to message? Also provide component versions and SPs installed. What actions have been performed before you are faced with this issue?

[Former Member · Accepted solution]

Hi Roman

Thanks for your reply,

There are attached the log files, in the other hand, I’ve trying implementing Sap notes for powl error without no results, the solman is already configured at system preparation, basic configuration, managed system configuration, technical monitoring, and data volume management.

Here is the sp levels

SAP_BASIS         702         0009      SAPKB70209      SAP Basis Component

SAP_ABA            702         0009      SAPKA70209      Cross-Application Component

CTS_PLUG          200         0001      SAPK-20001INCTSPLUG               SAP CTS Plugin

PI_BASIS             702         0009      SAPK-70209INPIBASIS   Basis Plug-In

ST-PI     2008_1_700       0008      SAPKITLRD8       SAP Solution Tools Plug-In

GW_CORE          200         0000 -         SAP GW CORE 200

SAP_BS_FND    702         0007      SAPK-70207INSAPBSFND            SAP Business Suite Foundation

SAP_BW              702         0009      SAPKW70209     SAP Business Warehouse

SAP_AP               700         0026      SAPKNA7026

WEBCUIF            701         0006      SAPK-70106INWEBCUIF               SAP Web UI Framework

BBPCRM              701         0006      SAPKU70106      BBPCRM

BI_CONT             706         0002      SAPK-70602INBICONT   Business Intelligence Content

CPRXRPM           500_702               0005      SAPK-50005INCPRXRPM              SAP Portfolio and Project Management 5.0 (ABAP)

IW_BEP               200         0000           -         Backend Event Provider

IW_FND              250         0000           -         SAP IW FND 250

ST           710         0004      SAPKITL704        SAP Solution Manager Tool

ST-BCO 710         0002      SAPK-71002INSTBCO     ST-BCO 710: Add-On Installation

SOCO    101         0001      SAPK-10101INSOCO       SAP Solution Composer Server

ST-A/PI 01Q_700              0001      SAPKITAB7K      Servicetools for other App./Netweaver 04

ST-ICO  150_700               0031      SAPK-1507VINSTPL

ST-SER  701_2010_1       0018      SAPKITLOSI        SAP Solution Manager Service Tools

I checked all parameters for the ICM, ran again the SPRO options, in fact I configured again the technical system for the solman landscape with no successful

dev_w1.txt.zip

icf_1.txt.zip

[Former Member · Accepted solution]

Please update DBMS client library (lib_dbsl) to latest patch level and check again.

[Former Member · Accepted solution]

thanks, let me try and tell you then.

[Former Member · Accepted solution]

Hi,

I updated the Kernel and the client library, the problem still exist at the same way.

regards.

[Former Member · Accepted solution]

Can you attach log file (dev_wX) again?

[Former Member · Accepted solution]

thanks for your help Roman, here is the log file attached.

Best regards and thanks again.

dev_w0.txt.zip

[Former Member · Accepted solution]

Please perform instructions as described in SAP Note 1414232 - DBSL (MSS): Maximum buffer size for array operations.

[Former Member · Accepted solution]

Ok, i'll check an comment to you.

[Former Member · Accepted solution]

Thankyou!!!

It was correct with that note.

Again thanks for your help!

Best regards.

[drupp]

Did you ever figure out the solution to this?

Also getting the runtime error DBIF_RSQL_INVALID_RSQL

error text: ab_HandleRsqlErrors