cube-js/cube

Refresh key every doesn't work for oracle db

Open

#1591 aperta il 13 dic 2020

Vedi su GitHub
 (3 commenti) (0 reazioni) (0 assegnatari)Rust (1965 fork)batch import
driver:oraclehelp wanted

Metriche repository

Star
 (19.563 star)
Metriche merge PR
 (Merge medio 5g 16h) (138 PR mergiate in 30 g)

Descrizione

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

Guida contributor