Hi Guys,
My envrionment:
sql2008, BPC7.0 sp7
Has anyone else experienced the following error before?
I am calling the following proc: *RUN_STORED_PROCEDURE = SPRUNCONSO(,[%CATEGORY_SET%],[%GROUPS_SET%],[%SCOPETABLE%],[%LOGTABLE%])
and below is the error I get:
Executing SPRUNCONSO ,[ACTUAL],[C_GRP],[SPSCOPE_218957],[SPLOG_225593]
SPRunConso Version 7.0.116
ERROR CSD-120 No Entity - Method Available
Time to run stored procedure:1.7 sec.
call 1 completed and data posted in 4.0 sec.
Run completed in 4.0 sec.
****************************************************************************************************
End time --->9:48:07 AM - Date:10/8/2010
-
-
SDN library suggeste the following:
-
-
------
CSD-120 ERROR CSD-120 No Entity - Method available
No data found in OWNERSHIP Cube for this method.
Check if you have METHOD in your ownership cube for the selected
CATEGORY - TIME - GROUP
-
-
------
But I dont think there is an issue with the Method because when I try adding %Time_Set% into my sprunconsol logic as follows:
*RUN_STORED_PROCEDURE = SPRUNCONSO(,[%CATEGORY_SET%],[%GROUPS_SET%],[%TIME_SET%],[%SCOPETABLE%],[%LOGTABLE%])
then the consol engine runs but it does not post anything, infact the following is shown in the log file:
-
-
Building sub-query 1
-
-
Query Type:0
Max members:
Executing SPRUNCONSO ,[ACTUAL],[C_GRP],[2010.AUG],[SPSCOPE_179404],[SPLOG_356941]
Time to run stored procedure:1.4 sec.
call 1 completed and data posted in 1.4 sec.
Run completed in 1.5 sec.
****************************************************************************************************
End time --->9:46:55 AM - Date:10/8/2010
Just to add, my sprunconversion works like a dream...
Your input will be greatly appreciated.
Thanks,
Teko
Hi Teko,
Is that correct log?
Executing SPRUNCONSO STATUTORY,ACTUAL,C_GRP,http://2010.AUG,SPSCOPE_179404,SPLOG_356941
Why is there Http://2010.AUG?
It doesn't make sense. That's why I am asking.
James Lim
Add a comment