Skip to Content
0
Former Member
Nov 11, 2009 at 06:01 AM

Subscript out of range

37 Views

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.