cancel
Showing results for 
Search instead for 
Did you mean: 

Virtual provider 0TCT_VC01 - ST03N Gives Dump

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos
Former Member
0 Kudos

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

Former Member
0 Kudos

There should be some more details on to this error besides the SQL err statement you posted??

Hope it Helps

Chetan

@CP.

Answers (0)