topic RSQL database error in Application Development and Automation Discussions

RSQL database error

Former Member — Wed, 09 Jul 2008 06:12:44 GMT

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.

Re: RSQL database error

Former Member — Wed, 09 Jul 2008 06:23:40 GMT

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

Re: RSQL database error

JanStallkamp — Wed, 09 Jul 2008 06:25:29 GMT

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

Re: RSQL database error

Former Member — Wed, 09 Jul 2008 06:29:48 GMT

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.

Re: RSQL database error

Former Member — Wed, 09 Jul 2008 06:40:04 GMT

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"

Re: RSQL database error

JanStallkamp — Wed, 09 Jul 2008 06:50:30 GMT

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

Re: RSQL database error

Former Member — Wed, 09 Jul 2008 06:58:21 GMT

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

I dnt find any restrictions

Re: RSQL database error

Former Member — Wed, 09 Jul 2008 07:01:26 GMT

Hi,

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

Revrt back ,

Regards,

Naveen

Re: RSQL database error

Former Member — Wed, 09 Jul 2008 07:02:37 GMT

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

Re: RSQL database error

JanStallkamp — Wed, 09 Jul 2008 08:15:08 GMT

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