search

cube-js / cube

📊 Cube — The Semantic Layer for Building Data Applications
https://cube.dev
Other
17.69k stars 1.75k forks source link

SQL API DevExpress support: Dashboard component returns an error #4758

Open schlechtOptimiziert opened 2 years ago

schlechtOptimiziert commented 2 years ago

Description We tried to connect to Cube.js's SQL/PostgreSQL API via a DevExpress Dashboard component.

Error It returned following error message: image

paveltiunov commented 2 years ago

Hey @schlechtOptimiziert ! Could you please try the latest version to see if the issue still persists?

schlechtOptimiziert commented 2 years ago

Hey @paveltiunov ! Yes the Problem still comes up. I used the latest tag to ensure it is the latest, but still. image

ovr commented 2 years ago

@schlechtOptimiziert Could you give a try with v0.30.28? We fixed an issue with extended query for PostgreSQL protocol.

Thanks

schlechtOptimiziert commented 2 years ago

image image @ovr Na, didn't seem to work, but at least it is an other error. Progress.

ovr commented 2 years ago

  1. SQL API follows PostgreSQL 14 spec, and there is no column called proisagg (it was removed in PostgreSQL 11). You need to upgrade the library (driver).

  2. Related to the second query, it's a bug.

schlechtOptimiziert commented 2 years ago

Description Hi,

so I reached out to DevExpress and it seems to work fine for them now. The Ticket: Cube.js and DevExpress BI

I tried to connect it to Cube.js but that did not seem to work 100%. It found the Table but not the rows.

What I did image I tried to get the Tables and got this Error. Than I pressed the ok Button. image It found my Test Table but I does not seem to find the Columns. image