on 03-31-2008 10:29 AM
Hi,
Have installed BI7.0 Technical contents and have loaded query statistics data using process chain. Everything is working fine except for one scenario.
In one of SAP docs its specified that 0TCT_VC01 is used to take delta statistic records from database view RSDDSTAT_OLAP. When there are no new delta statistics available in this view (i.e, once all data are loaded into basic cube), a dump is seen in ST03N transaction when BI workload for the current day is selected. Dump says "SAPSQL_SQLS_INVALID_CURSOR"
Has anyone faced this issue?
Regards,
Vidhya.A
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chetan,
Thanks for the reply!
Have already done all the steps specified like "activating the direct access". I am able to see the correct values in ST03.
The only problem happens in one scenario where,
Scenarion1 : Load the process chain TCT* to get all report statistics - this gets all delta records from database view and hence no delta record is available for the virtual cube to read and hence we get a dump in st03n transaction.
If a execute a report then new statistics data would be available in Database view and virtual provider can read those. In this case there wouldn't be any dump. My issue is with the first scenario only.
Hope the issue is clear.
Regards,
Vidhya.A
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.