DBIF_RSQL_INVALID_RSQL

[Former Member]

Hi All,

While executing a Custom Transaction, We are getting a dump which states DBIF_RSQL_INVALID_RSQL error.

We are actually executing the transaction for fetching Archived data and we are facing this issue.

We have recently migrated to ECC6.0 from 4.6C.We didn't get this problem before.It is coming only after the migration.

Please do provide me some inputs on this.

Thanks in Advance,

Prathima

[Former Member]

Hi prathima,

Can you provide more details of the dump.

And also the program code?

Regards,

Atish

[Former Member]

Hi Atish,

When the transaction was run in the background ,the job was canceeled and following is the spool for that:

11/02/2007 13:26:49 Archive file 002113-003FI_DOCUMNT is being processed

11/02/2007 13:26:50 Archive file 002115-001/PBS/CFIF is being processed

11/02/2007 13:26:52 Archive file 002073-003FI_DOCUMNT is being processed

11/02/2007 13:26:52 Archive file 002113-003FI_DOCUMNT is being processed

11/02/2007 13:26:52 Archive file 002115-001/PBS/CFIF is being processed

11/02/2007 13:28:09 Archive file 002073-004FI_DOCUMNT is being processed

11/02/2007 13:28:45 Archive file 002113-003FI_DOCUMNT is being processed

11/02/2007 13:31:45 Archive file 002115-001/PBS/CFIF is being processed

11/02/2007 13:32:40 Archive file 002073-004FI_DOCUMNT is being processed

11/02/2007 13:32:41 Archive file 002115-001/PBS/CFIF is being processed

11/02/2007 13:32:41 Archive file 002073-004FI_DOCUMNT is being processed

11/02/2007 13:32:41 Archive file 002113-003FI_DOCUMNT is being processed

11/02/2007 13:32:42 Archive file 002115-001/PBS/CFIF is being processed

11/02/2007 13:35:35 Archive file 002073-004FI_DOCUMNT is being processed

11/02/2007 13:35:36 Archive file 002113-004FI_DOCUMNT is being processed

11/02/2007 13:37:50 Archive file 002115-001/PBS/CFIF is being processed

11/02/2007 13:39:47 Archive file 002073-004FI_DOCUMNT is being processed

11/02/2007 13:39:49 Archive file 002113-004FI_DOCUMNT is being processed

11/02/2007 13:39:51 Archive file 002115-001/PBS/CFIF is being processed

11/02/2007 13:40:29 Archive file 002073-004FI_DOCUMNT is being processed

11/02/2007 13:40:30 Archive file 002113-004FI_DOCUMNT is being processed

11/02/2007 13:40:53 Archive file 002115-001/PBS/CFIF is being processed

11/02/2007 13:41:43 Archive file 002073-004FI_DOCUMNT is being processed

11/02/2007 13:41:43 Archive file 002113-004FI_DOCUMNT is being processed

11/02/2007 13:41:43 Archive file 002115-001/PBS/CFIF is being processed

11/02/2007 13:42:15 Archive file 002073-004FI_DOCUMNT is being processed

11/02/2007 13:42:15 Archive file 002113-004FI_DOCUMNT is being processed

11/02/2007 13:42:15 Archive file 002115-001/PBS/CFIF is being processed

11/02/2007 13:42:22 Archive file 002073-004FI_DOCUMNT is being processed

11/02/2007 13:42:22 Archive file 002113-004FI_DOCUMNT is being processed

11/02/2007 13:42:22 Archive file 002115-001/PBS/CFIF is being processed

11/02/2007 13:43:11 Archive file 002073-004FI_DOCUMNT is being processed

11/02/2007 13:43:12 Archive file 002113-004FI_DOCUMNT is being processed

11/02/2007 13:43:14 Archive file 002115-001/PBS/CFIF is being processed

11/03/2007 10:13:00 ABAP/4 processor: DBIF_RSQL_INVALID_RSQL

11/03/2007 10:13:00 Job cancelled

Thanks

[Former Member]

Have you checked with Basis regarding the space availabilty.

Regards,

Atish

[Former Member]

It is in the production system that we are facing this issue,We are not authorized to check there .

[Former Member]

Have you looked in ST22 as to the reason for the DBIF_RSQL_INVALID_RSQL ?... that may explain it further e.g. could be a select with too big a "where" clause generated for it.

Jonathan

[Former Member]

Hi,

This is nothing related to ABAP

Contact ur DB administrator and BASIS guy.

*reward if solved*

[Former Member]

But Sreejith why cant this be related to performance issue. as our client is trying to fetch huge data.

[Former Member]

Hi,

This dump generaes becuase of improper calling of fields from table to itab when using SELECT

Make sure that your itab must be synch with the fields of table

Regards

Shiva

[Former Member]

Hi,

if it is performance related u will get dumps:

TIME_OUT / TSV_NEW_PAGE ALLOCATIONFAILED.

I had encountered a similar issue which was DB inconsistency.

[Former Member]

You can use transaction ST22 to examine the dump. That will show you the code that caused the dump. Please post that code.

Rob

[former_member772174]

Hi,

this sounds like a database problem, e.g. tablespace too small oder rollback segment problem.

Look i ST22, you'll find some Database error message, give this to the Administrator.