troubleshooting
  • q

    quiet-branch-92681

    09/01/2021, 6:19 PM
    @great-boots-39022 tried again from scratch, seeing a different error now that doesn't look related to the db issues. I followed the "Install Evidence" instructions with no modifications -- here's the ouput https://pastebin.com/fbDQsKst I thought maybe it needed a db config to work, so I followed the instructions to setup a pg connection. Same issue, here's the config file and output - https://pastebin.com/rypUcqmy Thinking something might be broken in evidence - seeing a WARN error when running npm install that says request lib is deprecated. The error when I run npm run dev says "11:12:49 AM [vite] Error when evaluating SSR module /node_modules/@evidence-dev/db-orchestrator/index.cjs: ReferenceError: require is not defined" Wondering if the two might be related? LMK what you think.
  • g

    green-waitress-78824

    09/02/2021, 11:46 AM
    Hello! I'm having issues connecting to a managed postgres database hosted on Digital Ocean. Have the
    database.config.json
    file configured per the docs, but am getting the attached error. As a low confidence hypothesis, usually DO requires me to specify
    sslmode = require
    when connecting to the DB. Is there a way I can trigger similar functionality here? If relevant, I'm running Evidence on WSL (Ubuntu).
  • a

    aloof-businessperson-41965

    09/02/2021, 12:29 PM
    hi there, I’m getting an issue with my firstquery. I’m running an M1 Mac using Chrome Version 92.0.4515.159. I’m getting this 500 error when trying to view it in the browser. Any help would be super 🙂
  • g

    glamorous-restaurant-29758

    10/18/2021, 6:23 PM
    Hello! I am trying to install evidence on my Macbook Pro and I am running into this error when i run
    npm run dev
  • g

    glamorous-restaurant-29758

    10/18/2021, 6:23 PM
    SyntaxError: Named export ‘transformWithEsbuild’ not found. The requested module ‘vite’ is a CommonJS module, which may not support all module.exports as named exports. CommonJS modules can always be imported via the default export, for example using:
  • g

    glamorous-restaurant-29758

    10/18/2021, 6:24 PM
    any clue on what this can be?
  • s

    square-solstice-63582

    11/13/2021, 4:47 PM
    Hello, I am having problems installing evidence on my mac.
    $ npx degit evidence-dev/template my-project
    $ npm install
    WARN @evidence-dev/evidence@0.1.0 requires a peer of @evidence-dev/db-orchestrator@^0.1.8 but none is installed. You must install peer dependencies yourself.
    ...
    npm WARN mdsvex@0.9.8 requires a peer of svelte@3.x but none is installed. You must install peer dependencies yourself.
    Did the move to a single repository break something?
  • l

    lively-nest-93395

    11/18/2021, 3:56 AM
    Hello, I’ve encountered a problem while deploying the tutorial project to Netlify in accordance with the documentation. Netlify uses npm6.x by default, resulting in a failed build; this problem is resolved if I specify the NODE VERSION and NPM VERSION in env variables.
  • b

    brainy-raincoat-5393

    12/27/2021, 4:21 AM
    how to open page with 'hide queries' options?
  • b

    brainy-raincoat-5393

    12/30/2021, 2:14 AM
    I want to create file evidence.service for leasing my evidence project. created /etc/systemd/system/evidences.service file like this:
    [Unit]
    Description=Service Systemd File to Run Evidence project
    After=network.target
    
    [Service]
    User=james
    Group=james
    WorkingDirectory=/home/user/evidence
    Environment="PATH=/home/user/.nvm/versions/node/v14.17.6/bin"
    ExecStart=//home/user/.nvm/versions/node/v14.17.6/bin/npm run preview
    
    [Install]
    WantedBy=multi-user.target
    but error
    Dec 30 02:09:50 ionos-com npm[22690]: npm ERR! syscall spawn sh
    Dec 30 02:09:50 ionos-com npm[22690]: npm ERR! path /home/user/evidence
    Dec 30 02:09:50 ionos-com npm[22690]: npm ERR! errno -2
    Dec 30 02:09:50 ionos-com npm[22690]: npm ERR! enoent spawn sh ENOENT
    Dec 30 02:09:50 ionos-com npm[22690]: npm ERR! enoent This is related to npm not being able to find a fi>
    Dec 30 02:09:50 ionos-com npm[22690]: npm ERR! enoent

    resolved

    • npm, node, node-waf install path to /usr/local/bin/ • project.service file for systemd like:
    [Unit]
    Description=Service Systemd File to Run Evidence project 
    After=network.target
    
    [Service]
    User=user
    Group=user
    WorkingDirectory=~user/project directory
    ExecStart=npm run preview  
    
    [Install]
    WantedBy=multi-user.target
  • n

    nice-river-95380

    12/30/2021, 7:40 PM
    Hi all, love this project and I’ll give a proper introduction shortly but hoping for some quick handholding through my inability to read. I’m trying to format a value as USD and a bit confused looking at the docs. On the format tags page, it suggests changing the column alias (I think)? But on the text components / value page there’s the
    fmt
    parameter. I’ve tried a variety of ways but am not having luck. Can someone point me towards an example?
  • b

    brainy-raincoat-5393

    01/02/2022, 12:50 PM
    Hi all, I try to add hyperlink in result table. but just text. How can I do?
  • w

    white-yacht-51026

    01/03/2022, 9:42 PM
    Hi everyone, I am currently trying to connect to Redshift data warehouse from my local machine. I followed all instructions in the Docs, but now I am getting an error saying that my first query is attempting to point at a different database than what I have specified in the
    .evidence/database.config.json
    file. The database it says it is trying to connect to happens to also be the name of my postgres user on my local machine, so I am wondering if the library is somehow getting confused reading in the environment variables. Any advice on how to troubleshoot this issue? Attaching a screenshot for reference…
  • m

    miniature-rose-88367

    02/22/2022, 10:13 PM
    Hello team! 👋
  • m

    miniature-rose-88367

    02/22/2022, 10:13 PM
    I'm trying to connect to my db using the template project but I'm failing. I can get the template project to run, but not to connect to the db. My setup: • OS - Windows • database - Postgres - hosted via Heroku • npm - v8.3.1 • node - v16.14.0 • @evidence-dev/db-orchestrator version - 0.1.12 I'm pretty proficient at SQL, but I'm only an amateur programmer - so any help appreciated. I've done the standard trawl of stack overflow, but didn't find anything that I could use
  • m

    miniature-rose-88367

    02/22/2022, 10:14 PM
    1. attempting without ssl=True
  • m

    miniature-rose-88367

    02/22/2022, 10:14 PM
    2. attempting with SSL = True
  • m

    miniature-rose-88367

    02/22/2022, 10:16 PM
    contents of database.config.json:
    {
    	"keyFilename": "./.evidence/XXXXXXXXXX.json",
    	"projectId": "XXXXXXXXX",
    	"location": "US",
    	"host": "<http://ec2-52-207-74-100.compute-1.amazonaws.com|ec2-52-207-74-100.compute-1.amazonaws.com>",
    	"database": "dfuor4d59t7r46",
    	"port": 5432,
    	"user": "[my username]",
    	"password": "[my pw]",
    	"ssl": true    // ONLY INCLUDED FOR ATTEMPT 2 - THIS COMMENT IS NOT IN MY JSON
    }
    evidence.config.json
    {
      "database": "postgres"
    }
  • m

    miniature-rose-88367

    02/24/2022, 4:06 PM
    Struggling to get the format tags to work. In my .md file:
    ```bike_query
    
    select
        date_trunc('minute', timestamp)::timestamp as timestamp_date,
        case 
            when num_bikes_available < 5 then cast(num_bikes_available as text)
            else '5+'
        end as bikes_available_group, 
        count(*) / (sum(count(*)) over (partition by timestamp)) as stationsavailable_pct
    from station_status_log
    group by timestamp, bikes_available_group 
    order by timestamp, bikes_available_group
    limit 300
    <AreaChart data={data.bike_query} x=timestamp_date y=stationsavailable_pct series=bikes_available_group fmt=pct sort =false title='Percent of Stations with each number of Bikes available' yAxisTitle='% of Stations' xAxisTitle='Date & Time' />``` Would expect this to format my y axis as %, but it doesnt seem to?
  • s

    steep-painting-61056

    03/14/2022, 2:47 PM
    Hi, I'm working on building out my first report with evidence. I've created a query to group costs on a bunch of facets and then trying a bar graph based on the query. Are there limits to how much aggregation evidence does locally? I'm essentially creating a query of line items and then want to roll those items up in graphs.
  • s

    steep-painting-61056

    03/14/2022, 2:48 PM
    The numbers are off by an order of magnitude, the resultset has ~1200 rows.
  • c

    clever-optician-78717

    03/14/2022, 3:12 PM
    Hello, is there any real code sample on how to use custom EChart object, but passing the data object from SQL result? Tried to follow the docs on https://docs.evidence.dev/components/charts/custom-charts#echarts-component but can't figure out this part "we recommend building a composable chart and passing in an
    options
    object for the specific features you need." I ended up hardcoding the result for now 😅
  • m

    miniature-rose-88367

    04/01/2022, 5:15 PM
    Setting up an end to end data stack on a hobby project of mine: Website -> Segment -> Snowflake -> dbt -> Evidence • I'm getting a slightly odd error I don't understand.
    ✓ user_frequency from cache
    ✓ top_user from cache
    ✗ untitled Queries require a title
    ◦ As far as I can tell, I've only got two queries in my markdown file. And there is only one .md file which has any queries (see thread) • The query caching is proving a bit annoying the way I'm developing right now. ◦ Understand the benefit of the feature generally to increase speed ◦ I'm not sure how common a pattern this is, but I'm currently working on my dbt project and my evidence project simultaneously. This means the Snowflake db I'm querying is changing. However, I think Evidence looks at the sql I've written in my markdown, sees it hasn't changed, so grabs that data from the cache. ◦ Possible idea to allow the user to turn off query caching for development. Perhaps a
    npm run dev --nocache
    or something similar
  • m

    microscopic-byte-35682

    04/21/2022, 10:41 AM
    Hi, is theer a way to setup externalauthenticator for Snowflake, instead of regular user/password pair?
  • w

    wonderful-spoon-81382

    04/22/2022, 7:51 PM
    Hi All! I wonder if anyone had any success connecting to Oracle database. I'm trying to use the "mysql" connection, but I get the error "connect ETIMEDOUT". I'd appreciate any feedback. Thanks!
  • c

    curved-gold-77020

    06/13/2022, 6:00 PM
    Hi Everyone! I'm trying to install Evidence on a Windows machine and running into SSL issues. I receive this error when running
    npx degit
    per instructions: "! could not download https://github.com/evidence-dev/template/archive/52632358be19ad186b7c0715606cba25f03e68ef.tar.gz" I even tried adding the
    -m=git
    parameter and got a host key verification error: "Host key verification failed. fatal: Could not read from remote repository." I'm behind a corporate proxy which is verifying all SSL traffic, so I think that's the issue, but wondering if there is an alternative installation method I could try?
  • g

    green-waitress-78824

    08/06/2022, 7:29 PM
    Hello! I'm trying to connect Evidence to cube.js via Postgres for a hobby project. Happy to have this be not supported, but wanted to ask about the error I'm running into in case there is a way to work around it. The connection tests as successful, but I cannot get any queries to return results- instead getting a "Cannot read properties of undefined (reading 'evidenceType')" error.
  • b

    best-king-86949

    11/16/2022, 4:21 PM
    👋 Hello, team!
  • b

    best-king-86949

    11/16/2022, 4:25 PM
    I'm working through the demo and I'm having an issue with the line chart. Everything sems to be working but the chart component. ln50 <BarChart data = {orders_by_month} y=sales_usd0k title = 'Sales by Month, USD' /> The chart renders with the expected title and y values but no data. I tried adding x=date <BarChart data = {orders_by_month} x=date y=sales_usd0k title = 'Sales by Month, USD' /> but still nothing. Any suggestions?