cancel
Showing results for 
Search instead for 
Did you mean: 

Refresh Schema error

Tim
10 - ETL
10 - ETL

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.
3 REPLIES 3

Tim
10 - ETL
10 - ETL

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.

Tim
10 - ETL
10 - ETL

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)?

DRay
Community Team Member
Community Team Member

Hi @Tim,

Thank you for following this up. I'll ask around and see what I can find out.

David Raynor (DRay)