Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

Cisco CTMS TANDBERG Analytics Extension

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

Everyone's tags (4)
1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

Cisco CTMS TANDBERG Analytics Extension

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

12 REPLIES
Cisco Employee

Cisco CTMS TANDBERG Analytics Extension

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

Community Member

Cisco CTMS TANDBERG Analytics Extension

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

Community Member

Cisco CTMS TANDBERG Analytics Extension

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,

Bronze

Cisco CTMS TANDBERG Analytics Extension

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

Cisco Employee

Cisco CTMS TANDBERG Analytics Extension

Emerson,

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

Community Member

Cisco CTMS TANDBERG Analytics Extension

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

Cisco Employee

Re: Cisco CTMS TANDBERG Analytics Extension

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

Community Member

Re: Cisco CTMS TANDBERG Analytics Extension

Hi Magnus,

This is the other error.

Error: Server: The operation has been cancelled.

Was this anything issue with the DB?

Thanks

Cisco Employee

Re: Cisco CTMS TANDBERG Analytics Extension

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

Community Member

Re: Cisco CTMS TANDBERG Analytics Extension

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

Cisco Employee

Re: Cisco CTMS TANDBERG Analytics Extension

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

Community Member

Re: Cisco CTMS TANDBERG Analytics Extension

Thank for you for the quick response

799
Views
0
Helpful
12
Replies
CreatePlease to create content