RSS

Monthly Archives: May 2015

How to kill a blocking session

AX

Problem:
A user can’t log into AX. After looking at online users (System Administrator > Users > Online Users), you will see a user with status “Ending – Blocked”. This is because AX locks the user session when there was a problem in processing the transaction

Steps :
1> On the User Online screen we can see which userID and which session has status is Ending –Block

SNAGHTML4a02d6

2> Go to the SQL server, look into SYSCLIENTSESSIONS table to see all user sessions.

image

SQL –
SELECT        TOP (200) SESSIONID, SERVERID, VERSION, LOGINDATETIME, LOGINDATETIMETZID, STATUS, USERID, SID, USERLANGUAGE, HELPLANGUAGE,
CLIENTTYPE, SESSIONTYPE, CLIENTCOMPUTER, DATAPARTITION, RECVERSION, RECID
FROM            SYSCLIENTSESSIONS
WHERE        (USERID = ‘Admin’)

3> Delete exactly the line with USERID and SESSIONID of that user

View original post

Advertisements
 
Leave a comment

Posted by on May 18, 2015 in Uncategorized

 

Exception from HRESULT: 0xC004802-Data Import/Export Framework AX 2012 R3

I have been trying to import data from an Excel file using Data Import Export Framework. The mapping and validation works but when I try to import the data into staging table – I get the below error:

Exception from HRESULT: 0xC0048021

I am using Dynamics AX 2012 R3 RTM with Excel 2013 64 bit.So before going in to solution please install 64-bit Microsoft Excel Driver on 64-bit machine (OS) with ‘Microsoft Access Database Engine 2010 Redistribute’ (AccessDatabaseEngine_x64.msi) by using “/passive” argument.

Let’s review the Problem statement and Solution in details

Problem Statement.

First off I’ll be using Source data format of Type = Excel to import the data from Excel file

Source data format

Please note that Source data format Type = “File” and File format = “Excel”.To begin with I’m going to use standard DIXF “Vendor” Target entity and I’ll introduce a processing group

Processing group

Pr

Then I selected Source file and I’ll use “Generate source mapping” option

Untitled1

I found entity mapping is done successfully.

Capture1

Now Select entities for processing group – Preview file contents. you will get below error.

Capture

Solution:

AX Version: Microsoft Dynamics AX 2012 R3 RTM
Microsoft Office: Office 2013, Excel 2013
OS: Windows Server 2012
SQL: SQL 2014
If you’re using Excel 2013 32 bit or 64 bit , the problem is caused by DMConfig XML file.

Go to the DMConfig.xml file in the “C:\Program Files\Microsoft Dynamics AX\60\DataImportExportFramework” folder and replace the PipelineComponentInfo_Multicast, PipelineComponentInfo_ExcelSource and  <PipelineComponentInfo_ExcelDestination> nodes by the following:

<PipelineComponentInfo_Multicast>
{EC139FBC-694E-490B-8EA7-35690FB0F445}
</PipelineComponentInfo_Multicast>
<PipelineComponentInfo_ExcelSource>
{8C084929-27D1-479F-9641-ABB7CDADF1AC}
</PipelineComponentInfo_ExcelSource>
<PipelineComponentInfo_ExcelDestination>
{1F5D5712-2FBA-4CB9-A95A-86C1F336E1DA}
</PipelineComponentInfo_ExcelDestination>

That solved the issue for me!

if above tags value does not work then try below lines

<PipelineComponentInfo_Multicast>
    {33D831DE-5DCF-48F0-B431-4D327B9E785D}
  </PipelineComponentInfo_Multicast>
  <PipelineComponentInfo_ExcelSource>
    {9F5C585F-2F02-4622-B273-F75D52419D4A}
  </PipelineComponentInfo_ExcelSource>
  <PipelineComponentInfo_ExcelDestination>
    {90E2E609-1207-4CB0-A8CE-CC7B8CFE2510}
  </PipelineComponentInfo_ExcelDestination>

 
Leave a comment

Posted by on May 11, 2015 in Uncategorized