[. . . ] TANDBERG Analytics Extension Administrator guide D14668. 01 September 2010 Introduction Contents Contents. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 Document Revision History . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 New feature overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . [. . . ] This can occur after a fresh installation of Microsoft SQL Server or after installing a SQL server service pack. This generic error message asks you to look in the logs for further information. Look for an SQL Network Interfaces: Error Locating Server/Instance Specified message in log-AdminWeb. txt. Refer to the Analytics Extension installation guide for information on troubleshooting connection errors. Figure 3: The generic "An error has occurred" message ETL job failures Cannot insert the value NULL into column. . . For some video networks with high MCU activity, the ETL job may fail with an error message: Cannot insert the value NULL into column , , PeakAudioCallBitrate Cannot insert the value NULL into column , , PeakVideoCallBitrate Cannot insert the value NULL into column , , PeakActualVideoCalls This bug only occurs in Analytics extension version 1. 0, and is fixed for version 1. 1. Customers encountering this problem can contact TANDBERG Support to obtain the patch. TANDBERG Analytics Extension Admin guide 15 Troubleshooting Figure 4: The "Cannot insert the value NULL into column. . . " bug as seen in the "Log ETL jobs" panel. Multiple "Error: Internal error: The operation terminated unsuccessfully. " Getting multiple Error: Internal error: The operation terminated unsuccessfully. messages in the same ETL job indicates that there have been major changes in the TMS database since you last ran the job (Figure 5), and that the Analytics Extension is unable to extract data because of schema changes or changes in constraints. These errors can occur if you have used the reconfiguration tool to replace the source database with an entirely different TMS database. As described in Analytics Extension Reconfiguration section, the wizard tool should not be used for such changes. To fix the problem, use the reconfiguration tool again to return the source database to the original TMS database. Figure 5: Multiple "Error: Internal error: The operation terminated unsuccessfully. " messages from the same failed ETL job. Client Connectivity Issues Microsoft Excel and Windows Authentication Initialization of the data source failed When connecting to a data warehouse Cube in environments where Integrated Authentication is not available or fails, Excel will run into authentication problems. The user will not be warned about this when creating the connection to Analysis Services and the connection will apparently be created properly. However, later when the user tries to use the connection in a Pivot Table or Pivot Chart, the user will get an Initialization of the data source failed error. A workaround to the problem is appending the connection string manually: 1. Append the text string in the "connection string" field with ";password=<your password>". Note the semicolon in front. TANDBERG Analytics Extension Admin guide 16 Troubleshooting Example: If the user account is named "peter. jones", the connection string might look like this: Provider=MSOLAP. 3;Persist Security Info=True;User ID=REPORTING\peter. jones;Initial Catalog=tmsng_dwhAsDb;Data Source=analytics. reporting. tms. lab;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error If the password of the account is "ENGLAND66", the modified string should look like this: Provider=MSOLAP. 3;Persist Security Info=True;User ID=REPORTING\peter. jones;Initial Catalog=tmsng_dwhAsDb;Data Source=analytics. reporting. tms. lab;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error;password=ENGLAND66 Checking the "Save password" box will make the changes to the connection string persistent. However, note that the connection string is stored unencrypted in an XML file on the local disk. Figure 6: Manually appending the connection string The LocaleIdentifier property XML for Analysis parser: The LocaleIdentifier property is not overwritable and cannot be assigned a new value After creating a connection, the error message XML for Analysis parser: The LocaleIdentifier property is not overwritable and cannot be assigned a new value may appear when you try to utilize the connection in a pivot table or chart. This issue only TANDBERG Analytics Extension Admin guide 17 Troubleshooting applies to certain combinations of old versions of Excel and SSAS. The following Microsoft Connect page describes a workaround Error when creating an Excel Pivot Table from a SSAS project. Right click the connection in the Select Data Source window and select Open with > Notepad (Figure 7) to edit the connection file as described in the Microsoft Connect page, . Locate the <odc:ConnectionString> element, and append ";Locale Identifier=1033" (note the semicolon) to the end of the elements content (Figure 8). The connection is now updated and ready for use. Figure 7: Opening the connection for editing TANDBERG Analytics Extension Admin guide 18 Troubleshooting Figure 8: Appending the connection string TANDBERG Analytics Extension Admin guide 19 Logs Logs If you experience difficulties with the TANDBERG Analytics Extension, technical support may ask you to supply log files along with a description of your issue. [. . . ] THE DISCLAIMERS AND LIMITATIONS OF LIABILITY ABOVE WILL NOT BE AFFECTED IF ANY REMEDY PROVIDED HEREIN FAILS OF ITS ESSENTIAL PURPOSE. This License represents the complete agreement concerning this license, supersedes all prior agreements, and may be amended only by a writing executed by duly authorized representatives of both parties. The provisions of any order document used by Licensee shall be of no effect (notwithstanding any provisions in such order document to the contrary), except for the number of users, pricing and ship-to information. Any terms in Licensees order document which are inconsistent with the terms of this License are not accepted by TANDBERG and the terms of this License will prevail. [. . . ]