cancel
Showing results for 
Search instead for 
Did you mean: 

Errro when running report??

Former Member
0 Kudos

Hi all,

When I ran CRM report in BW, I got an error. I tried to check the ABAP error in SE38 but I canot find any request # in ST22. Did I miss something? Here is error:

The URL http://sdcbwqa03.amcc.com:8100/sap/bw/BEx was not called due to an error.

Note

The following error text was processed in the system BWQ : Invalid dynamic line component.

The error occurred on the application server sdcbwqa03_BWQ_00 and in the work process 0 .

The termination type was: RABAX_STATE

The ABAP call stack was:

Form: COPY_SETXX_LINE of program CL_RSR_REQUEST================CP

Form: GET_DATA_CELLS of program CL_RSR_REQUEST================CP

Form: COMPUTE_NOP of program CL_RSR_LIST_CALCULATION=======CP

Form: COMPUTE_ORDER of program CL_RSR_LIST_CALCULATION=======CP

Form: COMPUTE of program CL_RSR_LIST_CALCULATION=======CP

Form: REQUEST_DATA of program CL_RSR_REQUEST================CP

Form: READ_DATA_INTERNAL of program CL_RSR_REQUEST================CP

Form: READ_DATA of program CL_RSR_REQUEST================CP

Form: READ_DATA of program CL_RSR_WWW_VIEW===============CP

Form: RENDER of program CL_RSR_WWW_ITEM===============CP

If the termination type was RABAX_STATE, then you can find more information on the cause of the termination in the system BWQ in transaction ST22.

Thanks.

J.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member188975
Active Contributor
0 Kudos

John,

Do you know the query being used in this web report...can you try to generate and execute it in RSRT in your BWQ system...

Former Member
0 Kudos

Bhanu,

Can you let me know what is RSRT for?

I tried but it is running for 20 minutes and still. It is the same situation when I run it in RRMX. Thanks.

J.

former_member188975
Active Contributor
0 Kudos

RSRT is the transaction for Query monitor. You can use it to regenrate the report and also in case you need to study the report execution in details by setting debugging options. Running a query in RSRT for test purposes is good (and fast, as the output requires minimal formatting)...so, is it still running in RSRT?

Former Member
0 Kudos

Bhanu,

I got an runtime error- TSV_TNEW_BLOCKS_NO_ROLL_MEMORY (it seems no enough system space),right?

No roll storage space of length 1989648 available for interal storage

You attempted to extand the data structure for administration of storage blocks for table itxxxx. The requested storage 1989648 bites was not available in the roll area.

The memory requested was no long available.

Thanks.

J.

former_member188975
Active Contributor
0 Kudos

Correct. Is this a "huge" query...what does the definition look like? Do you have big structures in the query design?

Former Member
0 Kudos

There are 19 free CHARs, 14 KFs, 3 time CHARs, 2 CHARs, 2 Filters, 5 variabes.

Is it normal? It seems that I need to ask for more memor, right?

Thanks

J.

former_member188975
Active Contributor
0 Kudos

In RSRT, type in the query technical name and then click on Technical Details. Do you see any red lights here? How much data does your data target have?

Former Member
0 Kudos

No. There is only 'yellow' light in the Free CHARs section

Thanks.

J.

Former Member
0 Kudos

Hi Bhanu,

Only about 3200 data records; in my testing data, I only have data from Jan, Feb, <b>April (contain 70% of testing data)</b> in 2006 and I can run reports for each month but I<b> cannot run any reports to cover April plus another month</b> (running fine for single periold- April)

Thanks.

J.

Former Member
0 Kudos

Bhanu,

I didn't use 'structur' function.

It was running fine until I added free CHARs from 8 to 18.

Thanks.

J.

0 Kudos

hi John,

RSRT, click 'properties',

- check 'read mode', suggested is 'H query to read when you expand and navigate hierarchies'. check if yours is 'read all data at once', try to change to the suggested mode. (you change free char from 8 to 18)

- 'cache mode', try 'main memory cache without swapping' ?

also try 'execute+debug' and option 'display sql',

and check if the sql statement displayed is make sense,

sometimes it selects some unnecessary char/kf s,

here we may need to regenerate the query, try menu environment->delete old abaps. and 'generate report'.

more about rsrt(bex monitor) function, take a look doc

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/afc59790-0201-0010-9f99-940...

and perhaps check query design and performance

oss note

557870 'FAQ BW Query Performance'

567746 'Composite note BW 3.x performance Query and Web'

Prakash's weblog

/people/prakash.darji/blog/2006/01/27/query-creation-checklist

/people/prakash.darji/blog/2006/01/26/query-optimization

and search RABAX_STATE oss note ?

hope this helps.

Former Member
0 Kudos

AHP,

Thanks for information. The problem is still there.

J.