Cisco CTMS TANDBERG Analytics Extension

Answered Question
Aug 22nd, 2012
User Badges:

Greetings                  


I have managed to create the Analytic Database running the PrepareDatabase script and this worked and going to plan


When I try to create the Analysis Database running the PrepareAnalysisServiceDatabase run into below issue


===================================

Cannot execute script.

===================================

Object reference not set to an instance of an object. (ConnectionDlg)

------------------------------

Program Location:

   at Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.UpdateInstanceLabel()

   at Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.Sync(UIConnectionInfo ci)

   at Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.DoOneTimeInitialization()

   at Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.TryToConnect(IWin32Window parent, UIConnectionInfo& connectInfo, IDbConnection& connection)

   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptAndResultsEditorControl.Connect()

   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptAndResultsEditorControl.EnsureConnectionForResults()

   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptAndResultsEditorControl.OnExecScript(Object sender, EventArgs a)




Our Setup

-----------------------------------------------------------------------------------------

We are running SQL 2008 R2 Standard


Autentication: SQL

PrepareDatabaseDB Name: tmsng_dwh

Attempeted PrepareAnalysisServiceDatabase DB Name: tmsng_dwhasdb


Script we are trying to run

-----------------------------------------------------------------------------------------


<!-- NOTE: Replace all instances of tmsng_dwhAsDb with the name of the DWH   -->

<!-- database + 'AsDb'. The default value will thus be 'tmsng_dwhAsDb'. It  -->

<!-- is important that these names match, as the installer depends on this  -->

<!-- convention being followed. Also update tms to match the service -->

<!-- user that will own the relational database.                            -->


<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" Transaction="true">

   

    <Create xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

        <ObjectDefinition>

            <Database xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2">

                <ID>tmsng_dwhAsDb</ID>

                <Name>tmsng_dwhAsDb</Name>

                <Language>1033</Language>

                <Collation>Latin1_General_CI_AS</Collation>

                <DataSourceImpersonationInfo>

                    <ImpersonationMode>ImpersonateServiceAccount</ImpersonationMode>

                </DataSourceImpersonationInfo>

            </Database>

        </ObjectDefinition>

    </Create>


    <Create xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

        <ParentObject>

            <DatabaseID>tmsng_dwhAsDb</DatabaseID>

        </ParentObject>

        <ObjectDefinition>

            <Role xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2">

                <ID>Owner</ID>

                <Name>Owner</Name>

                <Description />

                <Members>

                    <Member>

                        <Name>tms</Name>

                    </Member>

                </Members>

            </Role>

        </ObjectDefinition>

    </Create>


    <Create xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

        <ParentObject>

            <DatabaseID>tmsng_dwhAsDb</DatabaseID>

        </ParentObject>

        <ObjectDefinition>

            <DatabasePermission xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2">

                <ID>OwnerRolePermission</ID>

                <Name>Owner</Name>

                <RoleID>Owner</RoleID>

                <Process>true</Process>

                <ReadDefinition>Allowed</ReadDefinition>

                <Read>Allowed</Read>

                <Administer>true</Administer>

            </DatabasePermission>

        </ObjectDefinition>

    </Create>   

   

</Batch>


SQL DB.png

SQLDB 2.png

Correct Answer by Kjetil Ree about 4 years 12 months ago

Hi,


That's because you run the 'PrepareAnalysisServiceDatabase.xmla' script in the Database Engine. You have to connect to Analysis Services, and then run the script.


I see that our documentation isn't exactly clear about this. I'll get the Cisco TMSAE installation guide updated.


Regards,

Kjetil

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
Correct Answer
Kjetil Ree Wed, 08/22/2012 - 08:46
User Badges:
  • Cisco Employee,

Hi,


That's because you run the 'PrepareAnalysisServiceDatabase.xmla' script in the Database Engine. You have to connect to Analysis Services, and then run the script.


I see that our documentation isn't exactly clear about this. I'll get the Cisco TMSAE installation guide updated.


Regards,

Kjetil

Neelesh Bhoola Wed, 08/22/2012 - 08:56
User Badges:

Great thank you for the response i will give it another go and will let you know

Emerson Telan Wed, 08/22/2012 - 20:02
User Badges:

Hi Kjetil,


Yes you are right. I am also about to install and configure the TMS - Analytics Extension ver 1.1 but seems the Manual guide is not so very clear and not straight forward.

Hope you could also update



Thank you,

mahkrish Wed, 08/22/2012 - 20:29
User Badges:
  • Bronze, 100 points or more

Hi, FYI Cisco TMSAE 1.2 is the latest available in download website.

Kjetil Ree Wed, 08/22/2012 - 23:32
User Badges:
  • Cisco Employee,

Emerson,


Make sure to read the 1.2 manuals - they have been much improved since 1.1.

Emerson Telan Sat, 08/25/2012 - 03:24
User Badges:

Hi Kjetil,


You are right. Anway, while running the ETL Job I got this Error.


Error: Errors in the OLAP storage engine: A loop involving the member with the key 4, was detected in the parent-child relationship between the 'Key Folder' attribute and the 'Parent Folder Id' attribute.


Are you familiar on that?


Thanks

Magnus Ohm Sat, 08/25/2012 - 23:25
User Badges:
  • Cisco Employee,

Hi Emerson


Is this the whole and only stack you see? Are there any more information in the error?


/Magnus


Sent from Cisco Technical Support iPad App

Emerson Telan Sun, 08/26/2012 - 17:55
User Badges:

Hi Magnus,


This is the other error.


Error: Server: The operation has been cancelled.


Was this anything issue with the DB?


Thanks

Kjetil Ree Tue, 08/28/2012 - 00:47
User Badges:
  • Cisco Employee,

Hi Emerson,


That's defect CSCtz49248 you're seeing. Please open a TAC case to get it resolved, and reference the bug ID. You have some old 'junk' data that needs to be deleted from the tmsng database manually.


Regards,

Kjetil

Neelesh Bhoola Fri, 08/31/2012 - 01:23
User Badges:

Hi Kjetil


I seem to have run into another issue hope you can asssit -



1. PrepareDatabase.sql & run_on_bis_dev1: The original SQL Script and my modified version, note I’ve taken out the password

2. PrepareAnalysisServiceDatabase.xmla – I didn’t save my modified version, but it ran to success, modified as per documentation.


So, here is where I am:


1. Created 'tmsng_dwh' on BIS DEV 1: The datawarehouse DB (via prepareDatabase.sql)

2. Executed PrepareAnalysisServiceDatabase.xmla on AV DEV1 (made modifications as per documentation)

Both ran to success.


3. Ran up the installer on the app server, it prompts for the datawarehouse db (created on BIS DEV1), details completed as per documentation instructions: “When prompted for the data warehouse Database information, be sure to enter the same values used in the PrepareDatabase.sql file for the Database Name (Figure 16).”


I enter details and receive an error that analysis services aren’t running - well they aren’t! not on BIS DEV1! they are running on AV DEV1(tried entering the AV DEV1 analysis details, but it then complains that it can’t find the datawarehouse db).


Suspect this is because we have the analysis instance is running on a different host to the datawarehouse db? Is this supported?


Many Thanks

Neelesh

Kjetil Ree Fri, 08/31/2012 - 02:04
User Badges:
  • Cisco Employee,
Suspect this is because we have the analysis instance is running on a different host to the datawarehouse db? Is this supported?

Hi,

That is correct: Analysis Services and the datawarehouse SQL Database instance must run on the same host and have the same instance name. Your setup is not supported.


Regards,

Kjetil

Actions

This Discussion

Related Content