Error while executing a data function
The data funtion throws an error while executing it with more data. if i unfilter one year's data, the data function works perfect. This is the error message
TIBCO Enterprise Runtime for R returned an error: 'Error in seq(min(well.data[[col.oilcum]]), cumoil.max, by = cumoil.by : wrong sign in 'by' argument'.
at Spotfire.Dxp.Data.DataFunctions.Executors.LocalFunctionClient.OnExecuting()
at Spotfire.Dxp.Data.DataFunctions.Executors.AbstractFunctionClient.<RunFunction>d__0.MoveNext()
at Spotfire.Dxp.Data.DataFunctions.Executors.SPlusFunctionExecutor.<ExecuteFunction>d__0.MoveNext()
at Spotfire.Dxp.Data.DataFunctions.DataFunctionExecutorService.<ExecuteFunction>d__6.MoveNext()
(2) Answers
You may want to consider using syntax similar to this, if generation of a descending sequence makes sense in the context of your analysis:
seq(
from = min(well.data),
to = cumoil.max,
by = ifelse( min(well.data) <= cumoil.max, cumoil.by, (-1) * cumoil.by ) )
This is the result, using the data objects from the example in my first response:
>
>
> seq(
+ from = min(well.data),
+ to = cumoil.max,
+ by = ifelse( min(well.data) <= cumoil.max, cumoil.by, (-1) * cumoil.by ) )
[1] 150 145 140 135 130 125 120 115 110 105 100
>
>
TERR returns this error when a call to seq() in the script specifies a value for its "by" argument that is inconsistent with the relationship between its "from" argument and its "to" argument.
For example, when the value of the "from" argument is less than the value of the "to" argument, the value for the "by" argument must be negative.
The following example illustrates this:
~~~~~~~~~~~~~~~~~~
TIBCO Software Inc. Confidential Information
Copyright (C) 2011-2017 TIBCO Software Inc. ALL RIGHTS RESERVED
TIBCO Enterprise Runtime for R version 4.3.0 for Microsoft Windows 64-bit
Type 'help()' for help.
Type 'q()' to quit.
>
>
>
> # 'Error in seq(min(well.data), cumoil.max, by = cumoil.by :
> # wrong sign in 'by' argument'.
>
>
> well.data <- 15:17 * 10
>
> cumoil.max <- 97
>
> cumoil.by <- 5
>
>
> well.data
[1] 150 160 170
>
> min( well.data )
[1] 150
>
> cumoil.max
[1] 97
>
> cumoil.by
[1] 5
>
>
> seq( from = min(well.data), to = cumoil.max, by = cumoil.by )
Error in seq(from = min(well.data), to = cumoil.max, by = cumoil.by) : wrong sign in 'by' argument
>
>
> # This fails:
>
> seq( from = 150, to = 97, by = 5 )
Error in seq(from = 150, to = 97, by = 5) : wrong sign in 'by' argument
>
>
> # This works:
>
> seq( from = 150, to = 97, by = -5 )
[1] 150 145 140 135 130 125 120 115 110 105 100
>
>
>
> # The following command opens the help file for
> # the seq() method that is used in this scenario:
>
> ?seq.default
Starting httpd help server ... done.
>
>
~~~~~~~~~~~~~~~~~~