Jump to content
We've recently updated our Privacy Statement, available here. ×

TERR function does not work for On-Demand data table


Georgi Koemdzhiev

Recommended Posts

Hello, I am trying to implement the TERR R function part of the "Simple Decline Curve Analysis Data Function for TIBCO Spotfire" - DCA-hyperbolic fittingV1.2.sfd. The function is run on an On-Demand data table.Currently, in my analysis file I have the following data tables:

- DNA_Wells (In-database data table)

- DNA_Wells_OD(On-Demand data table)

- result (data table that is output from the TERR function)

The workflow is the following. The user selects a well from a Map chart that is using the In-Database data table DNA_Wells. As a result of that, the DNA_Wells_OD table is being populated with the well's details that the user selected on the map. The problem is that the TERR function that I have to be invoked and the result data table should be populated but that does not happen (i.e. the result data table is empty) and I do not see any errors being shown in the notification area (i.e. using the Analyst).

 

There is a warningthat is being generated (see the notification bell)when I select a well on the map which sais the following:

Invalid property value

An invalid property value was returned from the server and ignored

 

Data function Untitled debug output

Unmarshalling 2 input parameters.

Input 'col.Date', sent by inline XML

POSIXct(0)

- attr(*, "tzone")= chr "UTC"

Input 'col.Production', sent by inline XML

num(0)

- attr(*, "Csingle")= logi TRUE

Done unmarshalling input parameters.

Marshalling 5 output parameters.

Output 'Hyp.qi', sent by inline XML

data.frame w/ 1 obs. of 1 variables:

$Hyp.qi: num NA

Output 'Hyp.b', sent by inline XML

data.frame w/ 1 obs. of 1 variables:

$Hyp.b: num NA

Output 'Hyp.Di.daily', sent by inline XML

data.frame w/ 1 obs. of 1 variables:

$Hyp.Di.daily: num NA

Output 'Hyp.Di.annual', sent by inline XML

data.frame w/ 1 obs. of 1 variables:

$Hyp.Di.annual: num NA

Output 'result', sent by inline XML

data.frame w/ 0 obs. of 4 variables:

$time.days: num(0)

$time.months: num(0)

$production: num(0)

$theo: num(0)

Done marshalling output parameters.

 

I have changed the 2 inputs of the TERR function to take an input from 2 columns from theDNA_Wells_ODdata table (here is a screenshot of one of my inputs:

 

Can somebody let me know what I could be missing out I am not really sure why my TERR function is not being executed.

Link to comment
Share on other sites

  • 4 months later...

Hello Georgi,

Sorry for the delay.

As configured the parameters, the R function waits you select at least one row as a parameter to be executed. Note that "Marked rows" have 0 rows.

If you want to pass as parameter a data frame to R function change "Filtered Rows" to "Current filtering". It is possible to combine both methods of parameters, Filtered Rows, and Marked Rows.

Let me know if this worked for you.

Regards.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...