RSQL database error

[Former Member]

I am working for upgrade project i.e from 4.6c to ECC 6

I had come across with an error "ERROR IN MODULE RSQL databse".

How to solve this can anyone help me out.

[Former Member]

Hi Shalini,

If this error also consists of the text tablespace error or something related to Tablespace, Your Basis Consultants can help you in this.

Regards,

Sai

[JanStallkamp]

Hi.

Carefully read the short dump. Most likely you will find some detailed information there. Search for some of the mentioned terms here in the SDN and in SAP Notes. Without further details it is quite hard to tell what happend.

Best regards,

Jan Stallkamp

[Former Member]

Hi

I can find some information saying "This restriction applies to some statement and table types as well as to tables with additional attributes such as activated table logging.

And its showing some SAP Notes to check if its an non modified SAP program

"DBIF_RSQL_INVALID_RSQL"

[JanStallkamp]

Hi.

So you are not getting a short dump but getting an error in a syntax check? Is there any information given which restriction is meant? Are you using something 'strange' in a table definiton or do you have a very complicated SQL statement?

DBIF_RSQL_INVALID_RSQL is an error message from the database interface. Searching for SAP Notes would be my approach here.

Best regards,

Jan Stallkamp

[Former Member]

Hi

Ita a short dump and the information i gave in my previous message is shown in dump itself.

I dnt find any restrictions

[Former Member]

Hi Shalini,

This dump has several causes like exceeding the maximum size of the statement; Repeated execution of the Open SQL statement with different range tables leads to generation of a large number of different SQL statements which the database can no longer handle.

If multiple range tables are the cause for your dump then you need reformulate the code using the FOR ALL ENTRIES statement. My Suggestion would be to ask your BASIS consultants to increase the tablespace. If your dump is still not resolved check the above possibilities of fine tuning the code.

Regards,

Sai

[JanStallkamp]

I think without knowing the SQL statement that causes the dump we cannot give a solution here. Increasing tablespaces is something that might help in some cases but not on every database type. And without being sure what the cause of error is I wouldn't play around with DB configuration. Maybe it helps if you ask this question in one of the DB/OS forums.

Best regards,

Jan Stallkamp

[Former Member]

Hi,

This error comes when there is error in SQL command i.e. select command,there might be mismatch of data types for fields specified in select command.

[Former Member]

Hi,

Have u changed/edited any data base table as part of upgradtion which are used in ur program.?

Revrt back ,

Regards,

Naveen