Page 1 of 1

Range Lookup Compile Error

Posted: Thu Apr 03, 2008 7:39 am
by mikegohl
I get a compile error in a range lookup. Does any one have any ideas?

##################################################################
#### STAGE: Lookup_3
## Operator
transform
## Operator options
-table
-range "StartItem <= Item AND EndItem > Item"
-keep
-allow_dups
-flag run
-name 'V0S3_LookupItemsRangeRef_MJG_Lookup_3'

## General options
[ident('Lookup_3'); jobmon_ident('Lookup_3')]
## Inputs
0< [] 'Range_Description:Range_Description.v'
1< [view (
StartItem, ">=", Range_Description.EndItem, "<",0)=Warehouse;
)] 'Warehouse:Warehouse.v'
## Outputs
0> [] 'Lookup_3:Warehouse_Items.v'

Here are the errors:

#W IIS-DSEE-TOSH-00049 15:39:12(008) <main_program> Parameter specified but not used in flow: DSPXWorkingDir [osl/osl.C:621]
##E IIS-DSEE-TOSH-00003 15:39:12(009) <main_program> Syntax error: Error in "transform" operator: Error in operator arg: In field "StartItem": Expected ";", got: ",", line 14
[osl/osl.C:135]
##E IIS-DSEE-TOSH-00003 15:39:12(010) <main_program> Syntax error: Error in "transform" operator: Error in operator arg: In field "StartItem": Expected ";", got: ",", line 14
[osl/osl.C:135]
##E IIS-DSEE-TCOS-00029 15:39:12(011) <main_program> Creation of a step finished with status = FAILED. [osh.C:1081] (LookupItemsRangeRef_MJG.Lookup_3)

Posted: Thu Apr 03, 2008 5:16 pm
by ray.wurlod
Can you post how the ranges were specified in the Lookup stage?

Posted: Thu Apr 03, 2008 6:00 pm
by mikegohl
Resolved. I changed the key and recompiled with not problem. I changed it back to the exact same key and range. It compiled an ran fine. No idea why.