DBIF_RSQL_INVALID_REQUEST

[Former Member]

Hi gurus,

one of the user getting the runtime error DBIF_RSQL_INVALID_REQUEST. When i analyze the dump it is stating as database interface problem.

and in TMS CCMS alert viewer its showing an system which was not added to the domain. which is also showing the same dump. I was really stuck up with this issue

Your suggestions in resolving this issue will be highly appreciated

High priority

Thanks,

Kiran

[Former Member]

Please send the trace file & the dump details.

Regards,

Sam

[Former Member]

Hi SAM,

abap dump is as follows:

Runtime Errors DBIF_RSQL_INVALID_REQUEST

Date and Time 12.03.2008 11:30:30

Short text

Invalid request.

What happened?

The current ABAP/4 program terminated due to

an internal error in the database interface.

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.

Error analysis

An invalid request was made to the SAP database interface in a statement

in which the table "KONV " was accessed.

How to correct the error

Start the work process involved and repeat the action that lead to the

error.

If the error position is in a program that you can change, you can try

to create preliminary solution: Reformulate the database command by

varying the properties such as individual record access instead of

input/output via internal tables, the structure of the selection

conditions (WHERE clause), nested SELECT loops instead of FOR ALL

ENTRIES and other such variations.

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

Check the entries in the developer trace of the work process involved

(transaction ST11).

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_INVALID_REQUEST" " "

"SAPLV61A" or "LV61AA11"

"KONV_EINLESEN"

System environment

SAP-Release 700

Application server... "os1gvzg"

Network address...... "10.10.30.24"

Operating system..... "Windows NT"

Release.............. "5.2"

Hardware type........ "2x Intel 80686"

Character length.... 16 Bits

Pointer length....... 32 Bits

Work process number.. 1

Shortdump setting.... "full"

Database server... "OS1GVZG"

Database type..... "MSSQL"

Database name..... "RT1"

Database user ID.. "rt1"

Char.set.... "C"

SAP kernel....... 700

created (date)... "Aug 29 2006 00:18:21"

create on........ "NT 5.0 2195 Service Pack 4 x86 MS VC++ 13.10"

Database version. "SQL_Server_8.00 "

Patch level. 75

Patch text.. " "

Database............. "MSSQL 7.00.699 or higher, MSSQL 8.00.194"

SAP database version. 700

Operating system..... "Windows NT 5.0, Windows NT 5.1, Windows NT 5.2"

Memory consumption

Roll.... 8176

EM...... 8361792

Heap.... 0

Page.... 32768

MM Used. 3704704

MM Free. 474448

User and Transaction

Client.............. 100

User................ "MUBEENM"

Language key........ "E"

Transaction......... "VA02 "

Program............. "SAPLV61A"

Screen.............. "SAPMV45A 0102"

Screen line......... 27

Information on where terminated

Termination occurred in the ABAP program "SAPLV61A" - in "KONV_EINLESEN".

The main program was "SAPMV45A ".

In the source code you have the termination point in line 82

of the (Include) program "LV61AA11".

Source Code Extract

Line SourceCde

52 ix_tkomv_v = sy-tabix. "remember the index

53 if sy-subrc eq 0.

54 if generell_lesen ne 'X'.

55 exit.

56 endif.

57 * there are already fitting entries in TKOMV,

58 * but a 'general read' is requested

59 sort_tkomv = yes. "sort is necessary

60 endif.

61 endif.

62

63 generell_lesen = space.

64

65 * structured conditions (KDUPL set) like cumulation

66 refresh xkumko.

67

68 * determine the right index of TKOMV if necessary

69 if ix_tkomv_v is initial.

70 read table tkomv with key knumv = komk-knumv

71 binary search

72 transporting no fields.

73 ix_tkomv_v = sy-tabix. "index always not initial now

74 if sy-subrc eq 0.

75 * there are already fitting entries

76 sort_tkomv = yes. "sort is necessary

77 endif.

78 endif.

79

80 * get pricing result from database table

81 ENHANCEMENT-SECTION KONV_EINLESEN_02 SPOTS ES_SAPLV61A.

>>>>> select * into table hkomv

83 from konv

84 where knumv = komk-knumv

85 order by primary key.

86 END-ENHANCEMENT-SECTION.

87 * internal optimization: for the db system no sort of the result

88 * should be necessary here, because the KONV is a cluster table

89 * (records are already in the right order)

90

91 lines_of_hkomv = sy-dbcnt. "remember number of hits