Hi folks, there is a lot of Analytics talk on this forum, so I thought I'd throw this out in case anyone has seen it. We're on v15.0.3 and installing Analytics for the first time. The server is a newly set up Windows 2016 & SQL Server 2016 Std. I'm on the TIM installation steps. The Data Warehouse installed OK, but the Web Application fails. Below is the error which leaves me pretty clueless. I do have a support ticket open, but one of you may know the answer right away. Let me know if you can shed any light on this error, shown in full below.Thanks,...Dave
Installing 'Analytics Web Application' using C:\ProgramData\TessituraTemp\Tools\Nant\Nant.exe. -----------------------------------------------------------------------------------------------------------------------------
NAnt 0.91 (Build 0.91.3881.0; alpha2; 8/17/2010)Copyright (C) 2001-2010 Gerry Shawhttp://nant.sourceforge.netBuildfile: file:///C:/ProgramData/TessituraTemp/Tools/Installer.buildTarget framework: Microsoft .NET Framework 4.0Target(s) specified: tim.install.web [macrodef] "buildFileList" New or Modified. Compiling. [macrodef] "addEnvironment" New or Modified. Compiling.tim.install.web:install.analytics.web:propertyguard: [httpPing] Connecting to URL tessituraservices.tco.corp/.../TessituraWeb [httpPing] Successfully connected.[checkPort] Connecting to localhost on port 4433[checkPort] Successfully connected. [exec] [exec] Pinging TCOStats.tco.corp [::1] with 32 bytes of data: [exec] Reply from ::1: time<1ms [exec] Reply from ::1: time<1ms [exec] Reply from ::1: time<1ms [exec] Reply from ::1: time<1ms [exec] [exec] Ping statistics for ::1: [exec] Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), [exec] Approximate round trip times in milli-seconds: [exec] Minimum = 0ms, Maximum = 0ms, Average = 0ms[iisappexists] IIS Website "TessituraAnalytics" exists on server.installwebserver:[checkdrivespace] Drive has more than 3000000 KB available. [copy] Copying 1 file to 'C:\ProgramData\Sisense\PrismFeature.xml'. [copy] Copying 'C:\ProgramData\TessituraTemp\Components\TessituraAnalytics\Installer\PrismFeature.xml' to 'C:\ProgramData\Sisense\PrismFeature.xml'. [copy] Created directory 'C:\ProgramData\Sisense'. [xmlpoke] Attempting to load XML document in file 'C:\ProgramData\Sisense\PrismFeature.xml'. [xmlpoke] XML document in file 'C:\ProgramData\Sisense\PrismFeature.xml' loaded successfully. [xmlpoke] Selecting nodes with XPath expression '//*[local-name()='InstallationType'][*[local-name()='Name'] = 'PrismWeb_Feature']/*[local-name()='Selected']|//*[local-name()='InstallationType'][*[local-name()='Name'] = 'PrismWeb_Feature']/*[local-name()='IsChecked']|//*[local-name()='Feature'][*[local-name()='Id'] = 'IIsFeature']/*[local-name()='Selected']'. [xmlpoke] Found '3' nodes matching XPath expression '//*[local-name()='InstallationType'][*[local-name()='Name'] = 'PrismWeb_Feature']/*[local-name()='Selected']|//*[local-name()='InstallationType'][*[local-name()='Name'] = 'PrismWeb_Feature']/*[local-name()='IsChecked']|//*[local-name()='Feature'][*[local-name()='Id'] = 'IIsFeature']/*[local-name()='Selected']'. [xmlpoke] Updating nodes with value 'true'. [xmlpoke] Updating node '0'. [xmlpoke] Updating node '1'. [xmlpoke] Updating node '2'. [xmlpoke] Updated all nodes successfully. [xmlpoke] Attempting to save XML document to 'C:\ProgramData\Sisense\PrismFeature.xml'. [xmlpoke] XML document successfully saved to 'C:\ProgramData\Sisense\PrismFeature.xml'. [xmlpoke] Attempting to load XML document in file 'C:\ProgramData\Sisense\PrismFeature.xml'. [xmlpoke] XML document in file 'C:\ProgramData\Sisense\PrismFeature.xml' loaded successfully. [xmlpoke] Selecting nodes with XPath expression '//*[local-name()='Feature'][*[local-name()='Id'] = 'IIsExpressFeature']/*[local-name()='Selected']'. [xmlpoke] Found '1' nodes matching XPath expression '//*[local-name()='Feature'][*[local-name()='Id'] = 'IIsExpressFeature']/*[local-name()='Selected']'. [xmlpoke] Updating nodes with value 'false'. [xmlpoke] Updating node '0'. [xmlpoke] Updated all nodes successfully. [xmlpoke] Attempting to save XML document to 'C:\ProgramData\Sisense\PrismFeature.xml'. [xmlpoke] XML document successfully saved to 'C:\ProgramData\Sisense\PrismFeature.xml'. [echo] Installing Tessitura Analytics Web Application. This installation will run for about 30 minutes.BUILD FAILEDExternal Program Failed: C:\ProgramData\TessituraTemp\Components\TessituraAnalytics\Installer\SiSense.7.1.3.10025.exe (return code was 1)Total time: 8.6 seconds. : Success : True, Message : Exit Code : 1
What are the hardware setup? Like RAM, Drive space etc.... do you have a separate port, SSL cert? Any of these can fail an IIS install especially in 15.1.
Hi Dave,
We have it running in v15.0.4 – when I first installed it, I had to switch to using the offline installer. For some reason, even though the particular server I was using wasn’t blocked outbound, it couldn’t download the SiSense components. Basically, what I did was download the SiSense offline installer, then replaced the smaller SiSense.7.1.3.10025.exe with the full installer (it has the same name) in the \Components\TessituraAnalytics\Installer folder. I don’t know for sure if that will solve it, but it worked for me after I initially received an error on that same step.
Good luck!
Thanks,David
One more thing... since TASK has been retired, you can find the Analytics offline installer on this page in the System Administration section: https://www.tessituranetwork.com/Support/Documentation/Tessitura-v15_1.
Hey Dave!
In all likelihood this is an authentication failure. Check the analytics license password you used in TIM and be sure it's the UNENCRYPTED version of the password. The one sent to you by Tessitura will be the encrypted password. Note also... if you change any analytics values in TIM you will need to reinstall the Tessitura Web (On The Go) Web Service at a minimum. There is reference to this in the documentation.
After resolving that I ran into issues with some of the other Analytics Server installs. I ended up reinstalling all the Application Server web services and all the Analytics Server components before I got to a point where all the installations succeeded and Analytics was running.
For what it's worth... While I did eventually get past all the installation issues I'm now at a point where Analytics runs, but all my default dashboards show 0 results. There seems to be a locked filter applied on each of them that filters to constituent -999999. I suspect that I've got a configuration issue somewhere. Maybe with the Division setup? I have a ticket in with support but responses are pretty slow these days.
I'll keep you posted on progress.
Hi David,
This error is best resolved through a support ticket. It is known to our support teams and they have a list of potential causes and resolutions to help you through it.
Best,Chris
External Program Failed: C:\ProgramData\TessituraTemp\Components\TessituraAnalytics\Installer\SiSense.7.1.3.10025.exe (return code was 1)
Thanks everyone for your helpful comments. Dan, I checked the encryption you suggested, and sure enough it was wrong! I must have encrypted the encrypted password and used that. Once fixed, the install continued beyond that error. Now I have the one below. I'll update the support ticket with this new info, and as Chris mentioned hopefully the support folks can point me in the right direction here. Thanks everyone. Below is part of the new TIM error - we have a trust problem now.
...Dave
installwebserver: [echo] Skipping Analytics Web Server install: installer version (7.1.3.10025) is equal to or less than installed version (7.1.3.10025) post.web.install: propertyguard: addserver: Adding Elasticube Server to Tessitura Analytics. API URL: https://localhost:4433 Server address: tcostats.tco.corp --------------------------------------------------------------------------------- HTTP request failed: GET localhost:4433/.../servers The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. Waiting 2 seconds then retrying operation. Attempt 1 of 3. --------------------------------------------------------------------------------- --------------------------------------------------------------------------------- HTTP request failed: GET localhost:4433/.../servers The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. Waiting 4 seconds then retrying operation. Attempt 2 of 3. --------------------------------------------------------------------------------- --------------------------------------------------------------------------------- HTTP request failed: GET localhost:4433/.../servers The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. Waiting 6 seconds then retrying operation. Attempt 3 of 3. --------------------------------------------------------------------------------- BUILD FAILED - 0 non-fatal error(s), 18 warning(s) INTERNAL ERROR System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> System.Se