Microsoft Dynamics AX

Forums

Home » Microsoft Dynamics AX » Microsoft Dynamics AX Forum
Related Search Results

Analysis Services Configuration ERROR

by
on 3 Apr 2012
  • Suggested Answer

Dynamics AX 2012 R2 Installation failed

by
on 18 Feb 2013
  • Suggested Answer

Compile and CIL Generation errors when reporting extensions is not installed.

by
on 7 Nov 2011
  • 0 comments
Troubleshooting an Issue?

Our support engineers have assembled the top recommended solutions for you.

Microsoft Dynamics AX 2012

CRM Connector in Microsoft Dynamics AX 2012

Financials Management in Microsoft Dynamics AX 2012

Upgrading to Microsoft Dynamics AX 2012


Microsoft Dynamics AX 2009

Application Object Server (AOS)

Enterprise Portal and Role Centers

Inventory Costing in Microsoft Dynamics AX 2009 

 Invoice Settlements/Discounts/Reversals

 SSRS and SSAS Integration

 Workflow

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

This question is answered
Jordan Schuetzle
Posted by
on 15 Mar 2013 10:47 AM

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. 

SSAS SQL Server 2012 AX 2012 R2 SP1 CU2 Unknown Error
Verified Answer
  • Tommy Skaue
    Posted by
    on 15 Mar 2013 3:26 PM
    Verified Answer
    Verified by

    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
  • Tommy Skaue
    Posted by
    on 15 Mar 2013 12:03 PM

    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
  • Jordan Schuetzle
    Posted by
    on 15 Mar 2013 2:03 PM

    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? 
  • Tommy Skaue
    Posted by
    on 15 Mar 2013 3:26 PM
    Verified Answer
    Verified by

    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
  • Jordan Schuetzle
    Posted by
    on 15 Mar 2013 6:13 PM

    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.

  • Tommy Skaue
    Posted by
    on 16 Mar 2013 6:15 AM

    Glad I could help! Good job pulling it through!

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