Cisco CTMS TANDBERG Analytics Extension

[Neelesh Bhoola]

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>

[Kjetil Ree · Accepted solution]

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]

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

[Emerson Telan]

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]

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

[Kjetil Ree]

Emerson,

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

[Emerson Telan]

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]

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]

Hi Magnus,

This is the other error.

Error: Server: The operation has been cancelled.

Was this anything issue with the DB?

Thanks

[Kjetil Ree]

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]

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]

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

[Neelesh Bhoola]

Thank for you for the quick response