cube-js/cube

Refresh key every doesn't work for oracle db

开放

#1,591 创建于 2020年12月13日

 (3 条评论) (0 个反应) (0 位负责人)Rust (1,965 个派生)batch import
driver:oraclehelp wanted

仓库指标

星标
 (19,563 个星标)
PR 合并指标
 (PR 指标待抓取)

描述

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
      });
    }));

贡献者指南