Hello there. This is my first time being involved in a service pack update and I'm wondering if anyone else has had issues upgrading to v15.2.35.
Here is the short version, as short as I can make it, which you will see, is not very short.
We were getting analytics full load errors first. We checked many things, based on TessNet's help and finally found the issue. In v15.2.34 of Tessitura there is a new requirement that the Analytics Web Application Server has NodeJs version 14.x as well as .NET 6.x installed in order for the installation of this step to succeed. Once these are installed on the server this step in Tessitura Installation Manager (TIM) should be re-attempted. We were not looking at the v15.2.34 requirements as we were jumping to v15.2.35.
We installed the required components and re-installed the analytics portion of the upgrade. We are no longer seeing the original error but now the Seats and Tickets cube will not process. TessNet replied with the following, which we have now done, but the load is still going and it has been almost 5 hours. Since this is my first upgrade, is this normal? Is anyone else running into these issues upgrading to v15.2.35?
Sometimes building the cube directly can give us a little more information on why the job is failing. Can you please try the following steps for your Seats and Tickets cube?
I apologize for the length of this post. But hopefully this might be helpful to others.
Thank you,
Jena Tunnell
Jena,
We are running 15.2.34 but we also did have an issue with "Seats and Tickets" .
What helped us resolve it is increasing the Query timeout setting in the Sisense server console.
You can find it by opening: Sisense Server Console
Open options
Click on "More Settings.."
Adjust Query Timeout, ours is currently set to 1800
Thank you, Ruslan. I will give that a try now.
There is a second place with timeout setting which I left out:
C:\Program Files\Sisense\DataConnectors\DotNetContainer\Connectors\MS-SQL\Sisense.Connectors.MsSqlConnector.dll.config
Increase timeout value from default 300 (5 minutes) to 3600 (1 hour)