driver:oraclehelp wanted
Repository metrics
- Stars
- (19,563 stars)
- PR merge metrics
- (Avg merge 5d 16h) (138 merged PRs in 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
});
}));