Refresh key every doesn't work for oracle db
- 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
Assessment
This issue has not been assessed yet.