Build Failed Custom Table (Timedout)

If someone good give me some direction, that would be great!

Last week, we upgraded our Sisense verision from 7.0.2 to 8.0.0. It was pretty smooth and worked out fine.

We tried to build a cube after and the build has failed every time since then. The build fails with the details stating, "The timeout period elapsed prior to completion of the operation". This is specifically with a custom table that we created with SQL. Prior to the upgrade we did, the cube would build fine and with no hiccups. The build would take about 30 minutes then, now it timeouts at about 6 hours.

Everything else (other elasticubes, other tables, other custom tables/columns, etc.) builds fine. We do not have a problem with our ODBC connection. The table that the custom table is using, builds fine too.

I am wondering if the SQL is not compatible with this new version? Maybe it just needs written a different way? I will attach pictures at the bottom here to give more details. But, if anyone has any ideas, that would be very helpful!

Thanks

Nathan Giusti September 10, 2019 13:33

Does this happen with full builds? Has it never completed since the upgrade?

Corey Price September 10, 2019 13:39

This happens with full builds and schema changes.

It has never completed since the upgrade.

Sisense Sisense October 11, 2019 12:38 (Edited October 11, 2019 12:38)

Hi, did you find a solution?

We are also facing the same problem.

Michael Becker October 11, 2019 12:42

Hi Guys,

I think that there are some issues behind Custom SQL that will be fixed in upcoming version. Other than that I suggest copying syntax, then creating that table from scratch and removing old one, that could help.

Build Failed Custom Table (Timedout)

Comments

Didn't find what you were looking for?