TERR function does not work for On-Demand data table?
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 warning that 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 the DNA_Wells_OD data 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.