cube-js / cube-js/cube

Refresh key every doesn't work for oracle db

Open
#1,591 3 comments 0 reactions 0 assignees View on GitHub
driver:oracle help wanted
Dominant language
Rust
Stars
20.8k
Forks
2.1k
Avg merge
1d 2h
Merged PRs (30d)
181

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

```sql
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

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

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.