Hi experts,
I have a simple RUNALLOCATION script that appears to work fine until it tries to update the DB. When I cut and paste from the log into MS-SQL I can see it generate all the records as I want. It is the next step that fails -
-- Apply factor
-
update #WHERE2_356854 set amtWHERE = cast(amtWHAT as float) * 1/12, [ENTITY] = 'GLOBAL_INPUT'
--Time to apply factor:0.0 sec.
go
select * from #WHERE2_356854
SIMULATED call 1 completed in 13.7 sec.
SIMULATED Run completed in 15.3 sec.
****************************************************************************************************
End time --->2:47:55 PM - Date:11/11/2009
****************************************************************************************************
Error in RunLogicAgainstSelection: Subscript out of range
I have checked that none of the DEFAULT.lgf files have anything in them and then Validate & Save'd them. I have another WHEN/ENDWHEN script that runs successfully against this App.
This is the script ( 1 version of many 😉
// Allocate annual overheads evenly over months
*XDIM_MEMBERSET ACCOUNT = 61000
*XDIM_MEMBERSET CATEGORY = BUDGET
*XDIM_MEMBERSET PRDGRP=NONE
*XDIM_MEMBERSET CURRENCY=USD,LC
*RUNALLOCATION
*FACTOR=1/COUNT
*DIM ACCOUNT WHAT=61000; WHERE=<<<
*DIM ENTITY WHAT=GLOBAL_INPUT; WHERE=<<<
*DIM TIME WHAT=2009.INPUT; WHERE=BAS(2009.TOTAL)
*ENDALLOCATION
*COMMIT
-
Your help will be appreciated.
Cheers,
Graeme.