cube icon indicating copy to clipboard operation
cube copied to clipboard

Published 20 hours ago • verified publisher icon cube-js

SQL API DevExpress support: Dashboard component returns an error

Open schlechtOptimiziert opened this issue 2 years ago • 6 comments

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

Error It returned following error message: image

schlechtOptimiziert avatar Jun 14 '22 07:06 schlechtOptimiziert

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

paveltiunov avatar Jun 14 '22 16:06 paveltiunov

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

schlechtOptimiziert avatar Jun 17 '22 12:06 schlechtOptimiziert

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

Thanks

ovr avatar Jun 29 '22 08:06 ovr

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

schlechtOptimiziert avatar Jul 01 '22 09:07 schlechtOptimiziert

  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.

ovr avatar Jul 06 '22 09:07 ovr

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

schlechtOptimiziert avatar Aug 03 '22 05:08 schlechtOptimiziert