Skip to content

Unable to connect to Cube SQL API from another Cube instance #7995

@zcpp

Description

@zcpp

While connecting to a Cube SQL API from another Cube instance, there will be a connection error:

Error while loading DB schema
error: Unable to parse: ParserError("Expected equals sign or TO, found: ZONE") QUERY: SET TIME ZONE 'UTC' at Parser.parseErrorMessage

image

To Reproduce
Steps to reproduce the behavior:

  1. Start cube instance A connects to a database and create some models. A is hosting in Server 1 with exporting PG port 10001;
  2. Start another cube instance B in Server 2 and connects to SQL API of cube instance A as a PG datasource (with connecting to Svr1's port 10001).

Expected behavior
Connect successfully and the data measures/schema from A can be loaded for creating model in B.

May be related to #5512

Metadata

Metadata

Assignees

No one assigned

    Labels

    api:sqlIssues related to SQL API

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      close