on 04-18-2006 7:27 PM
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.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
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.
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.
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
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.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.