AX 2012 R2 - Analysis Service Extension was not configured. An unknown issue occurred.

This question is answered

Hey all,

I am having an issue where core AX is installed, SSRS & EP are installed, but when trying to install SSAS it errors out with the following:

2013-03-15 09:17:39Z === Starting execution phase ===
2013-03-15 09:17:39Z Executing 'Analysis Services configuration' this pass.
2013-03-15 09:17:39Z Analysis Services configuration
2013-03-15 09:17:39Z Queueing for installation: Components
2013-03-15 09:17:39Z Component installation task completed successfully.
2013-03-15 09:17:39Z === Setting up Components ===
2013-03-15 09:17:39Z Checking the following prerequisites:
2013-03-15 09:17:39Z Common Property Install Path set to 'C:\Program Files\Microsoft Dynamics AX\60'.
2013-03-15 09:17:39Z Installation Path retrieved from registry. Value: 'C:\Program Files\Microsoft Dynamics AX\60'
2013-03-15 09:17:39Z Running Msiexec.exe with these parms:  /i "\\server1\ax media\AX\AX 2012 R2\MSI\Components64\Components64.msi" /qb! /l*v "C:\Program Files\Microsoft Dynamics AX\60\Setup Logs\2013-03-15 09-15-48\Components64 Log.txt" DIRECTEXECUTE=1 /norestart INSTALLDIR="C:\Program Files\Microsoft Dynamics AX\60" INSTALLDIR32="E:\Program Files (x86)\Microsoft Dynamics AX\60" ADDLOCAL="AnalysisServicesExtensions,NetBusinessConnector,ReportingServicesExtensions,ModelManagement,ClientConfig"
2013-03-15 09:17:39Z Running synchronously.
2013-03-15 09:17:50Z Common Property Install Path set to 'C:\Program Files\Microsoft Dynamics AX\60'.
2013-03-15 09:17:50Z Installation Path retrieved from registry. Value: 'C:\Program Files\Microsoft Dynamics AX\60'
2013-03-15 09:17:52Z Checking if Client SDK call to generate WCF configuration is required ...
2013-03-15 09:17:52Z Skipping call to client SDK API. WCF settings already present in the registry.
2013-03-15 09:17:52Z Client SDK Call done.
2013-03-15 09:17:52Z === Setting up Analysis Services configuration ===
2013-03-15 09:17:52Z Creating a record in the BIAnalysisServer table with ServerName = 'SQL01\AX01'.
2013-03-15 09:17:52Z Error executing command: USE [MicrosoftDynamicsAX];
2013-03-15 09:17:52Z DECLARE @tableName NVARCHAR(64);
2013-03-15 09:17:52Z DECLARE @tableId int;
2013-03-15 09:17:52Z DECLARE @utilElementTypeTable AS INT;
2013-03-15 09:17:52Z SELECT @tableName = N'BIAnalysisServer';
2013-03-15 09:17:52Z SELECT @utilElementTypeTable = 44;
2013-03-15 09:17:52Z SELECT @tableId = [AxId] FROM [ModelElement] WHERE [ElementType] = @utilElementTypeTable AND [Name] = @tableName;
2013-03-15 09:17:52Z SELECT @tableId;
2013-03-15 09:17:52Z Invalid object name 'ModelElement'.
2013-03-15 09:17:52Z Error executing command: USE [MicrosoftDynamicsAX]; EXEC [sp_AddBIAnalysisServer] @serverInstanceName = N'SQL01\AX01', @recId = 5637147955
2013-03-15 09:17:52Z Could not find stored procedure 'sp_AddBIAnalysisServer'.
2013-03-15 09:17:52Z Changed database context to 'MicrosoftDynamicsAX'.
2013-03-15 09:17:52Z Updating OLAP Data Source.
2013-03-15 09:17:52Z Adding the Microsoft Dynamics AX .NET Business Connector proxy to the SQL Server Analysis Services Administrator role.
2013-03-15 09:17:52Z The user Domain\AxProxy has been added successfully to the SQL Server Analysis Services Administrator role on SQL01\AX01.
2013-03-15 09:17:52Z Analysis Service Extension was not configured. An unknown issue occurred. Please contact your administrator.
2013-03-15 09:17:52Z Registering tracing manifest file "C:\Program Files\Microsoft Dynamics AX\60\Server\Common\TraceProviderCrimson.man".
2013-03-15 09:17:52Z WEvtUtil.exe install-manifest "C:\Users\axadmin\AppData\Local\Temp\3\tmpB5F1.tmp"
2013-03-15 09:17:52Z **** Warning: Publisher {8e410b1f-eb34-4417-be16-478a22c98916} is installed on
2013-03-15 09:17:52Z the system. Only new values would be added. If you want to update previous
2013-03-15 09:17:52Z settings, uninstall the manifest first.
2013-03-15 09:17:52Z
2013-03-15 09:17:52Z
2013-03-15 09:17:52Z Tracing manifest file has been registered successfully.
2013-03-15 09:17:52Z ******************************************************************************************************
2013-03-15 09:17:52Z Component installation task stopped due to an error.

This is AX 2012 R2 running on SQL server SP1 CU2 (11.0.3339).

The admin user running the installer clearly has installed the other components fine.

I've gone over technet.microsoft.com/.../gg731841.aspx a few times and don't think I missed anything. Has anyone else seen this?

I also have a few developer workstations (standalone) with the same error going on. 

Error executing command: USE [MicrosoftDynamicsAX]
Error executing command: USE [MicrosoftDynamicsAX]; EXEC  
Could not find stored procedure 'sp_AddBIAnalysisServer'. 
Analysis Service Extension was not configured. An unknown issue occurred. Please contact your administrator. 
Component installation task stopped due to an error. 

Verified Answer
  • Ok. I should have checked the business database first, and it is supposed to be in the business database, not the model database.

    Just create it yourself. Here is the query to create it:

    CREATE PROCEDURE [dbo].[sp_AddBIAnalysisServer] 
     @serverInstanceName NVARCHAR(64), 
     @recId BIGINT 
     AS 
     BEGIN 
      SET NOCOUNT ON; 
      DECLARE @isDefault AS INT 
      IF (@serverInstanceName IS NOT NULL AND @serverInstanceName  <> '') 
      BEGIN
        IF (COL_LENGTH('[dbo].[BIANALYSISSERVER]', '[PARTITIONS]') IS NULL)
        BEGIN 
    	  /* Handle minor version upgrade scenario where partition column does not exist yet */
          IF (SELECT COUNT(RECID) FROM BIANALYSISSERVER WHERE SERVERNAME = @serverInstanceName) = 0 
    	  BEGIN 
    	    SELECT @isDefault = 1 
    		IF (SELECT COUNT(ISDEFAULT) FROM [BIANALYSISSERVER] WHERE [ISDEFAULT] = 1) > 0 
    		BEGIN 
    			SELECT @isDefault = 0 
            END 
            INSERT INTO [dbo].[BIANALYSISSERVER]
                 ([SERVERNAME],[DESCRIPTION],[ISVALID],[ISDEFAULT],[DEFAULTDATABASENAME],[RECID],[RECVERSION]) 
            VALUES 
                 (@serverInstanceName,'',1,@isDefault,'',@recId, 1) 
          END       
     	END
        ELSE    
    	BEGIN
    	  IF (SELECT COUNT(RECID) FROM BIANALYSISSERVER WHERE [PARTITIONS] = 0 AND SERVERNAME = @serverInstanceName) = 0 
    	  BEGIN 
    		SELECT @isDefault = 1 
    		IF (SELECT COUNT(ISDEFAULT) FROM [BIANALYSISSERVER] WHERE [PARTITIONS] = 0 AND [ISDEFAULT] = 1) > 0 
    		BEGIN 
    			SELECT @isDefault = 0 
            END 
            INSERT INTO [dbo].[BIANALYSISSERVER]
                 ([SERVERNAME],[DESCRIPTION],[ISVALID],[ISDEFAULT],[DEFAULTDATABASENAME],[PARTITIONS],[RECID],[RECVERSION]) 
             VALUES 
                 (@serverInstanceName,'',1,@isDefault,'',0,@recId, 1) 
    	  END
        END 
      END 
     END
    GO
    

    Tommy Skaue | Dynamics AX Developer from Norway | http://yetanotherdynamicsaxblog.blogspot.no/ | www.axdata.no

All Replies
  • It looks like you are running the RTM version of the installer against an R2 version of the databases? It looks like it is assuming the application is located in the database MicrosoftDynamicsAX and not the MicrosoftDynamicsAX_Model database.

    Can you check the version of the installer?

    Tommy Skaue | Dynamics AX Developer from Norway | http://yetanotherdynamicsaxblog.blogspot.no/ | www.axdata.no

  • Looking at the file version of setup.exe, I can see its 6.2.158.0. This isn't an upgrade of any sort either, its a fresh install. The core along with EP & SSRS have been running fine for about two weeks.

    You gave me a random thing to try though and decided to point the cube to the AX_model instead of the AX database. 

    2013-03-15 13:05:48Z Error executing command: USE [MicrosoftDynamicsAX_model]; DECLARE @recId bigint; EXEC [sp_GetNextRecId] @tableId = 1063, @recId = @recId OUTPUT; SELECT @recId
    2013-03-15 13:05:48Z Could not find stored procedure 'sp_GetNextRecId'.
    2013-03-15 13:05:48Z Error executing command: USE [MicrosoftDynamicsAX_model]; EXEC [sp_AddBIAnalysisServer] @serverInstanceName = N'SQL01\AX01', @recId = 0
    2013-03-15 13:05:48Z Could not find stored procedure 'sp_AddBIAnalysisServer'.

    Here I get the extra error that I can't find GetNextRecID like I would expect, but I still can't find the sp_AddBIAnalysisServer stored procedure. When is that created? 

  • Ok. I should have checked the business database first, and it is supposed to be in the business database, not the model database.

    Just create it yourself. Here is the query to create it:

    CREATE PROCEDURE [dbo].[sp_AddBIAnalysisServer] 
     @serverInstanceName NVARCHAR(64), 
     @recId BIGINT 
     AS 
     BEGIN 
      SET NOCOUNT ON; 
      DECLARE @isDefault AS INT 
      IF (@serverInstanceName IS NOT NULL AND @serverInstanceName  <> '') 
      BEGIN
        IF (COL_LENGTH('[dbo].[BIANALYSISSERVER]', '[PARTITIONS]') IS NULL)
        BEGIN 
    	  /* Handle minor version upgrade scenario where partition column does not exist yet */
          IF (SELECT COUNT(RECID) FROM BIANALYSISSERVER WHERE SERVERNAME = @serverInstanceName) = 0 
    	  BEGIN 
    	    SELECT @isDefault = 1 
    		IF (SELECT COUNT(ISDEFAULT) FROM [BIANALYSISSERVER] WHERE [ISDEFAULT] = 1) > 0 
    		BEGIN 
    			SELECT @isDefault = 0 
            END 
            INSERT INTO [dbo].[BIANALYSISSERVER]
                 ([SERVERNAME],[DESCRIPTION],[ISVALID],[ISDEFAULT],[DEFAULTDATABASENAME],[RECID],[RECVERSION]) 
            VALUES 
                 (@serverInstanceName,'',1,@isDefault,'',@recId, 1) 
          END       
     	END
        ELSE    
    	BEGIN
    	  IF (SELECT COUNT(RECID) FROM BIANALYSISSERVER WHERE [PARTITIONS] = 0 AND SERVERNAME = @serverInstanceName) = 0 
    	  BEGIN 
    		SELECT @isDefault = 1 
    		IF (SELECT COUNT(ISDEFAULT) FROM [BIANALYSISSERVER] WHERE [PARTITIONS] = 0 AND [ISDEFAULT] = 1) > 0 
    		BEGIN 
    			SELECT @isDefault = 0 
            END 
            INSERT INTO [dbo].[BIANALYSISSERVER]
                 ([SERVERNAME],[DESCRIPTION],[ISVALID],[ISDEFAULT],[DEFAULTDATABASENAME],[PARTITIONS],[RECID],[RECVERSION]) 
             VALUES 
                 (@serverInstanceName,'',1,@isDefault,'',0,@recId, 1) 
    	  END
        END 
      END 
     END
    GO
    

    Tommy Skaue | Dynamics AX Developer from Norway | http://yetanotherdynamicsaxblog.blogspot.no/ | www.axdata.no

  • 2013-03-15 17:10:55Z Component installation task completed successfully.

    I tried that first on a developer workstation but it ended up working on all 7 of the environments I have going. Not sure why the installer in not creating that 1 stored procedure, but using the script above was able to get everything successfully installed. Thank you for the help Tommy.

  • Glad I could help! Good job pulling it through!

    Tommy Skaue | Dynamics AX Developer from Norway | http://yetanotherdynamicsaxblog.blogspot.no/ | www.axdata.no