Refresh Schema error

Help and How-To

I get this error:

Refresh Schema Failed
The table probably no longer exists. Please use the change connection flow.

When I click Refresh Schema on some tables. Can anyone help diagnose/fix?

Some info:

I confirmed the table exists. In Sisense, "Preview Data" returns the expected values.
I'm working on a Live Model.
Some tables can refresh schema as normal.
My datamodel has 52 tables.
Sisense L23.9.

Tim von Ahsen

Posted 1 year ago·Last reply 6 months ago

5 comments

Tim von Ahsen

OP1 year ago

I've diagnosed it:

In the .smodel json, each dataset has a "schemaName" property. Also, each table in the dataset has a "schemaName" property.

When you load data or add new tables to your model, it uses table.schemaName.

But Refresh Schema uses datasets.schemaName.

When schemaName is the same for both, everything works fine. But if they differ (e.g. if a single datasource has tables from two different schemas), then Refresh Schema fails (unless the table also exists in the other schema).

Question for Sisense: Presumably this is a bug. Refresh Schema should use table.schemaName, not dataset.schemaName. Are you aware? Has it been fixed in later versions (I found it on 23.9)?

Tim von Ahsen

OP1 year ago

I created a new livemodel with one of the tables that's playing up (and nothing else in it). I can refresh schema just fine there.