RSS

Monthly Archives: January 2015

AX 2012 R3 Enterprise portal installation error

Today I was trying to install EP component, and it is failing every time.

Everything up until the Enterprise Portal part went smoothly but the installer continuously threw an error when trying to complete the installation.Following is the log description.

2015-01-20 22:38:54Z Entering method deployEPOnSharepoint
2015-01-20 22:38:54Z Deploying Static files…

2015-01-20 22:38:54Z Microsoft.Dynamics.AX.ManagedInterop.CLRErrorException
2015-01-20 22:38:54Z at Microsoft.Dynamics.AX.ManagedInterop.Object.CallWithReturnType(String methodName, Type returnType, Object[] paramList)
2015-01-20 22:38:54Z at Microsoft.Dynamics.Framework.BusinessConnector.Session.DynamicsObjectAdapter.Call(String methodName, Object param1, Object param2)
2015-01-20 22:38:54Z An error occurred during setup of Enterprise Portal (EP).
2015-01-20 22:38:54Z Reason: Setup encountered an error during deployment of the Role Center and Enterprise Portal framework.
2015-01-20 22:38:54Z
2015-01-20 22:38:54Z Entering method deployEPOnSharepoint
2015-01-20 22:38:54Z Deploying Static files…
2015-01-20 22:38:54Z Registering tracing manifest file “C:\Program Files\Microsoft Dynamics AX\60\Server\Common\TraceProviderCrimson.man”.
2015-01-20 22:38:54Z WEvtUtil.exe install-manifest “C:\Users\AXADMIN\AppData\Local\Temp\tmpEBEF.tmp”
2015-01-20 22:38:56Z **** Warning: Publisher {8e410b1f-eb34-4417-be16-478a22c98916} is installed on
2015-01-20 22:38:56Z the system. Only new values would be added. If you want to update previous
2015-01-20 22:38:56Z settings, uninstall the manifest first.
2015-01-20 22:38:56Z
2015-01-20 22:38:56Z
2015-01-20 22:38:56Z Tracing manifest file has been registered successfully.
2015-01-20 22:38:56Z === Rolling back setup of Enterprise Portal (EP) due to error ===
2015-01-20 22:38:56Z Running Msiexec.exe with these parms: /i “F:\MSI\Components64\Components64.msi” /qb! /l*v “C:\Program Files\Microsoft Dynamics AX\60\Setup Logs\2015-01-20 22-26-07\Components64 Rollback Log.txt” DIRECTEXECUTE=1 /norestart INSTALLDIR=”C:\Program Files\Microsoft Dynamics AX\60″ INSTALLDIR32=”C:\Program Files (x86)\Microsoft Dynamics AX\60″ ADDLOCAL=”AnalysisServicesExtensions,EnterprisePortal,EPSearch,NetBusinessConnector,Debugger,EnterprisePortalTools,ReportingServicesExtensions,ReportingTools,ModelManagement,ClientConfig” REMOVE=”EnterprisePortal”
2015-01-20 22:38:56Z Running synchronously.
2015-01-20 22:39:42Z === Rolling back setup of Enterprise Portal (EP) due to error ===
2015-01-20 22:39:42Z The Rollback has been completed. For details about why the installation failed, see the previous messages in the log.
2015-01-20 22:39:42Z ******************************************************************************************************

2015-01-20 22:39:42Z Component installation task stopped due to an error.

2015-01-20 22:39:42Z ******************************************************************************************************
2015-01-20 22:39:43Z S260FinishedInfo

I checked the Error log file “DynamicsSetupLog” and found one error Set-up encountered an error during deployment of the Role Center and Enterprise Portal framework.

Not the most elaborating message to start troubleshooting from. The solution was found through a bit of googling and here is the quick solution to resolve this

Open regedit and find this key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions

EP1

On SharePoint 2010 environments you can have both 14.0 and 15.0 keys, and the 15.0 key typically has a single “Csom” sybkey.

If this is true for your machine rename the 15.0 key to 15.0_newname and

EP2

now try to rerun EP install and it was successfully installed

EP7

To avoid any issues revert the key rename after EP install.

EP1

Happy Daxing  🙂

 

Tags: , , , , , ,

SSRS Report in R3 – VS 2012 vs. VS 2010

Problem:
In Microsoft Dynamics AX  2012 R3 CU8 environment, when I tried to to edit a report,  I received the following message

AOT > Visual Studio Projects > Select a project > Right Click > Edit

Notice that VS 2010 is still being used as a default one.

Solution:
Dynamics AX 2012 R3 still needs to integrate with Visual Studio 2010 and therefore you have to have BIDS (Business Intelligence Development Studio). You can use a SQL Server 2008 R2 or SQL Server 2010 SP2 installation image to install it (it’s one of the components you can select during installation of “A new standalone server or additional components” on the client machine.

Please follow below link for more details to get rid of this issue and add feature SSRS reporting services without report server configuration an existing SQL installation.

http://mssqltrek.com/2012/02/10/installingadding-featuressrs-to-an-existing-sql-installation/

 

Tags: , ,

Microsoft Dynamics AX 2012 VM License Expired

If you try to run your VM R2 or R3, you will receive an information like below. Your VM license was expired on DEC 31, 2014 and it needs to renew.

How to verify:
System Administration > License Information .

If this shows 12/31/2014, you will need to load a new license file

Solution: You can use either step 1A or step 1B

Step 1A: Goto Partnersource
https://mbs.microsoft.com/partnersource/northamerica/sales-marketing/demo-tools/virtual-machines/AX2012DemoToolsMaterials

Scroll down to the end of the page

Link to license file
https://mbs.microsoft.com/files/customer/AX/Downloads/Servicepacks/AX2012DemoLicenseKeysexp12312015.tx

Step 2:
System Administration > License Information > Load License file and prompt for the license file > Yes to synchronize

It is going to take a while to synchronize  the DB . Once it is complete, you should see this

I tested with R2,R3 and R3 CU8.  🙂

Happy Daxing 🙂

 

Tags: , , , ,

SQL script for rebuild/reindex indexes for Dynamics AX 2012

This script will evaluate each index in the database, and determine if it should be reindexed or rebuilt based on how fragmented they are.

I have very good experience in doing this, and it really increases performance the Dynamics AX 2012 databases.

-- Ensure a USE <databasename> statement has been executed first.
Use MicrosoftDynamicsAX
SET NOCOUNT ON;
DECLARE @objectid int;
DECLARE @indexid int;
DECLARE @partitioncount bigint;
DECLARE @schemaname nvarchar(130); 
DECLARE @objectname nvarchar(130); 
DECLARE @indexname nvarchar(130); 
DECLARE @partitionnum bigint;
DECLARE @partitions bigint;
DECLARE @frag float;
DECLARE @command nvarchar(4000); 
-- Conditionally select tables and indexes from the sys.dm_db_index_physical_stats function 
-- and convert object and index IDs to names.
SELECT
    object_id AS objectid,
    index_id AS indexid,
    partition_number AS partitionnum,
    avg_fragmentation_in_percent AS frag
INTO #work_to_do
FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL , NULL, 'LIMITED')
WHERE avg_fragmentation_in_percent > 10.0 AND index_id > 0;

-- Declare the cursor for the list of partitions to be processed.
DECLARE partitions CURSOR FOR SELECT * FROM #work_to_do;

-- Open the cursor.
OPEN partitions;

-- Loop through the partitions.
WHILE (1=1)
    BEGIN;
        FETCH NEXT
           FROM partitions
           INTO @objectid, @indexid, @partitionnum, @frag;
        IF @@FETCH_STATUS < 0 BREAK;
        SELECT @objectname = QUOTENAME(o.name), @schemaname = QUOTENAME(s.name)
        FROM sys.objects AS o
        JOIN sys.schemas as s ON s.schema_id = o.schema_id
        WHERE o.object_id = @objectid;
        SELECT @indexname = QUOTENAME(name)
        FROM sys.indexes
        WHERE  object_id = @objectid AND index_id = @indexid;
        SELECT @partitioncount = count (*)
        FROM sys.partitions
        WHERE object_id = @objectid AND index_id = @indexid;

-- 30 is an arbitrary decision point at which to switch between reorganizing and rebuilding.
        IF @frag < 30.0
            SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REORGANIZE';
        IF @frag >= 30.0
            SET @command = N'ALTER INDEX ' + @indexname + N' ON ' + @schemaname + N'.' + @objectname + N' REBUILD';
        IF @partitioncount > 1
            SET @command = @command + N' PARTITION=' + CAST(@partitionnum AS nvarchar(10));
        EXEC (@command);
        PRINT N'Executed: ' + @command;
    END;

-- Close and deallocate the cursor.
CLOSE partitions;
DEALLOCATE partitions;

-- Drop the temporary table.
DROP TABLE #work_to_do;
GO
 

Tags: , , , , ,