topic Report Writer in Application Development and Automation Discussions

Report Writer

Former Member — Tue, 20 May 2008 13:02:35 GMT

I have a Report writer Report "Statutory Income Statement". The output is based on Company code and Profit Centre Group. The report has a drilldown report assigned to it "RGGD1300 - Totals record display GD13".

When I Click on a line item for a Profit centre, I am able to drill down to transaction GD13, but when I click on a line item for a Profit Centre Group, I get ABAP dump as below.

"Runtime Error DBIF_RSQL_INVALID_RSQL

Exception CX_SY_OPEN_SQL_DB"

The termination occurred in the ABAP program "GP_GLX_ZZA01T" in "FETCH".

The main program was "RGGD1300 ".

L_COUNTER = 0.

C_S_CURSOR-SUBRC = 0.

WHILE I_PACKAGE_SIZE EQ 0 OR

L_COUNTER LT I_PACKAGE_SIZE.

FETCH NEXT CURSOR C_S_CURSOR-CURSOR

INTO CORRESPONDING FIELDS OF TABLE G_T_RECORDS

PACKAGE SIZE L_PSIZE.

Please Help.

Any valuable suggestions will be rewarded.

Thanks

Subin.

Re: Report Writer

Former Member — Tue, 20 May 2008 13:10:16 GMT

It sounds like a buffering issue with the database. Did you contact your basis team for this?

Re: Report Writer

Former Member — Wed, 21 May 2008 05:59:57 GMT

When I Click on a line item for a Profit centre, I am able to drill down to transaction GD13, but when I click on a line item for a Profit Centre Group, I get ABAP dump as below.

"Runtime Error DBIF_RSQL_INVALID_RSQL

Exception CX_SY_OPEN_SQL_DB"

The termination occurred in the ABAP program "GP_GLX_ZZA01T" in "FETCH".

The main program was "RGGD1300 ".

L_COUNTER = 0.

C_S_CURSOR-SUBRC = 0.

WHILE I_PACKAGE_SIZE EQ 0 OR

L_COUNTER LT I_PACKAGE_SIZE.

FETCH NEXT CURSOR C_S_CURSOR-CURSOR

INTO CORRESPONDING FIELDS OF TABLE G_T_RECORDS

PACKAGE SIZE L_PSIZE.

Please Help.

Any valuable suggestions will be rewarded.

Thanks

Subin.

Re: Report Writer

Former Member — Wed, 28 Oct 2009 03:48:02 GMT

No comments