Shiny workflow plots app not working.

[bcow]

@robkooper @mdietze
I’m assuming we want the app working for the pecan demo night right?

When it loads, this error window pops up:

I know I had been mucking around with the bety functions, but even thought I copied them into PEcAn.DB I didn’t delete them from the PEcAn.visualization package so I don’t think that’s the source of the errors. I can double check. Unfortunately I’m not volunteering myself to fix the whole app but I'd be willing to help get it working again.

[robkooper]

Can you open the javascript console and show the error there. Here are the different ways to do that in different browsers: http://webmasters.stackexchange.com/a/77337

[bcow]

Hey that's handy!

Looks like the workflow id isn't getting passed in properly.

Warning: Error in postgresqlExecStatement: RS-DBI driver: (could not Retrieve the result : ERROR:  operator does not exist: bigint >=
LINE 8: WHERE "workflow_id" >=  AND "workflow_id" <=  AND "workflow_...

Here's the full output:

Listening on http://127.0.0.1:48523
Loading required package: scales
Loading required package: ggmap
Loading required package: ggplot2
Loading required package: RCurl
Loading required package: bitops
Loading required package: maps
Loading required package: raster
Loading required package: sp
Warning: no function found corresponding to methods exports from 'raster' for: 'overlay'
Loading required package: data.table

Attaching package: 'data.table'

The following object is masked from 'package:raster':

    shift

Loading required package: earth
Loading required package: plotmo
Loading required package: plotrix

Attaching package: 'plotrix'

The following object is masked from 'package:scales':

    rescale

Loading required package: TeachingDemos
Loading required package: XML
Loading required package: ncdf4
Loading required package: stringr
Loading required package: PEcAn.DB
Loading required package: DBI
Note: the specification for S3 class "AsIs" in package 'DBI' seems equivalent to one from package 'RJSONIO': not turning on duplicate class definitions for this class.
Loading required package: PEcAn.utils
Loading required package: abind
Loading required package: plyr
Loading required package: randtoolbox
Loading required package: rngWELL
This is randtoolbox. For overview, type 'help("randtoolbox")'.
Loading required package: RPostgreSQL
Loading required package: udunits2
Loading required package: lubridate
Note: the specification for S3 class "difftime" in package 'lubridate' seems equivalent to one from package 'DBI': not turning on duplicate class definitions for this class.

Attaching package: 'lubridate'

The following object is masked from 'package:plyr':

    here

The following objects are masked from 'package:data.table':

    hour, mday, month, quarter, wday, week, yday, year

Loading required package: dplyr

Attaching package: 'dplyr'

The following objects are masked from 'package:lubridate':

    intersect, setdiff, union

The following objects are masked from 'package:plyr':

    arrange, count, desc, failwith, id, mutate, rename, summarise,
    summarize

The following objects are masked from 'package:data.table':

    between, last

The following objects are masked from 'package:raster':

    intersect, select, union

The following objects are masked from 'package:stats':

    filter, lag

The following objects are masked from 'package:base':

    intersect, setdiff, setequal, union

Read 95 items
Warning: Error in postgresqlExecStatement: RS-DBI driver: (could not Retrieve the result : ERROR:  operator does not exist: bigint >=
LINE 8: WHERE "workflow_id" >=  AND "workflow_id" <=  AND "workflow_...
                            ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
)
Stack trace (innermost first):
    91: postgresqlExecStatement
    90: dbSendQuery
    89: dbSendQuery
    88: db_query_fields.PostgreSQLConnection
    87: db_query_fields
    86: update.tbl_sql
    85: update
    84: tbl_sql
    83: tbl.src_postgres
    82: tbl
    81: update
    80: inner_join.tbl_sql
    79: inner_join
    78: function_list[[k]]
    77: withVisible
    76: freduce
    75: _fseq
    74: eval
    73: eval
    72: withVisible
    71: %>%
    70: runs
    69: get_run_ids
    68: reactive var_names [/home/dietze/pecan/shiny/workflowPlot/server.R#30]
    57: var_names
    56: updateSelectInput
    55: updateSelectizeInput
    54: observerFunc [/home/dietze/pecan/shiny/workflowPlot/server.R#35]
     1: runApp

[serbinsh]

I have been having similar issues on this end

[ashiklom]

@bcow @serbinsh Can you confirm that this is still an issue? From the NACP tutorial, the workflow app ran fine-ish -- I think there were some errors because too many people were using it at once, but it didn't hit the errors described here.

[mdietze]

I don't think we handed out the same IP to more than 2 people for the tutorial so I don't think load was the issue

[ashiklom]

I'm gonna close this because the latest version of the WorkflowPlot app (using code from #1594) seems to be working fine on the VM and test-pecan.