cube-js/cube

Refresh key every doesn't work for oracle db

Open

#1.591 aberto em 13 de dez. de 2020

Ver no GitHub
 (3 comments) (0 reactions) (0 assignees)Rust (1.965 forks)batch import
driver:oraclehelp wanted

Métricas do repositório

Stars
 (19.563 stars)
Métricas de merge de PR
 (Mesclagem média 5d 16h) (138 fundiu PRs em 30d)

Description

Describe the bug Im using Cube.js in windows env with oracle db. the connection is up.

To Reproduce

After launching the cube server, (npm run dev) i got

Error querying db: scheduler-c97ed59a-7aed-4951-a832-1cade1474c4c
--
"SELECT 1"
--
{}
Error: ORA-00923: mot-clé FROM absent à l'emplacement prévu ....

Expected behavior

After searching i change the refresh script but i got the same error later with

SELECT FLOOR((((cast (systimestamp at time zone 'UTC' as date) - date '1970-01-01') * 86400)) / 10)

Screenshots If applicable, add screenshots to help explain your problem.

Version: [e.g. 0.4.5]

Additional context

Workaround: I change the script RefreshScheduler.js

      await orchestratorApi.executeQuery({
        ...sqlQuery,
        preAggregations: [],
        query: 'SELECT 1', // TODO get rid off it
        continueWait: true,
        renewQuery: true,
        requestId: context.requestId
      });
    }));

Guia do colaborador