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