Can not run sample R/dashDB script "Server Memory Usage"

55 Views Asked by At

Tried to run the server memory usage sample script as advised in the Youtube video: https://www.youtube.com/watch?v=PtEfRv_xuOA.

  1. Clicked on "Analytics"
  2. Clicked on "R Scripts"
  3. Clicked on "Server Memory Usage"

I don't get any plot, only console output:

Loading required package: RODBC, ibmdbR ...

Attaching package: ‘arules’

The following objects are masked from ‘package:base’:

    %in%, write 

Loading required package: rpart, rpart.plot ...

Error in ida.data.frame("SAMPLES.SHOWCASE_SYSUSAGE") : 

  Table SAMPLES.SHOWCASE_SYSUSAGE does not exist

Execution halted
Warning message:
closing unused RODBC handle 1 

mv: cannot stat `/mnt/blumeta0/home/dash8199//.psovPazrgsoFeO6urEt07ZL/1482955766453/output/*': No such file or directory
1

There are 1 best solutions below

0
On

that's concerning. I assume you are using a dashDB entry plan instance in Bluemix. I can't reproduce it with my instances there. But there are multiple physical servers driving the dashDB entry plan instances overall. Which dashDB server are you using? Just provide the URL of the dashDB web console that you get when you launch dashDB. Do you see the table SHOWCASE_SYSUSAGE in schema SAMPLES at all in TABLES page in the web console?