RSS

Monthly Archives: April 2014

An error occurred invoking the Report Definition Customization Extension (RDCE).

I ran across this SSRS report past few weeks and had a hard time to solve the issue. I could deploy and view all the report but one report. It kept giving me this error

  • An error occurred invoking the Report Definition Customization Extension (RDCE). (rsRdceInvalidCacheOptionError)
    • Fatal exception performing AXRDCE transformation step. The report cannot be rendered. Please contact your system administrator.

By goggling, all of searching lead me to this page http://community.dynamics.com/ax/f/33/t/69658.aspx or this page
https://community.dynamics.com/ax/b/brandongeorge/archive/2013/03/03/ax-2012-fatal-axrdce-exception-error-addressed.aspx

I thought i found the answer, but it deviated me even further from the solution.

The following didn’t work:

– Adding report to the “Report Deployment Settings” – the same error was thrown when deploying the report

– SSRS restart

– Deleting AUC and regenerating WCF config.

– Stop/Start Reporting Services

– Delete the report and redeploy

– Create a new config file

– Clear user usage

– Monitor event viewer

– Monitor database

– Use SSRS diagnostic tool to gather information about enviroment

Basically, I tried everything i can to get this to work but no matter what I tried the issue still persisted

One thing to keep in mind report, query  has never been modified. I decided to take different approach by looking at the report itself from VS perspective. I started seeing lights at the end of the tunnel. Recompiling the report in VS, i collected additional information. When I looked at data source, I found out the report was using a query. Looking at the query and tracking all of its datasources, I found out one of the table was missing an index. I removed the bad index field from the index, and reran the report and it worked like a charm

Image

SNAGHTML1400214b

Advertisements
 
Leave a comment

Posted by on April 30, 2014 in Development

 

Tags: , , , , ,

Make sure disk space is available before generating CIL.

I was trying to generate a full CIL and kept getting this error

The CIL generator found errors and could not save the new assembly.”

I took the follow steps in order to attempt to fix the issue

1> Restart AOS

2> Regenerate full CIL

I kept getting the same error again. and errors in few other classes. After I compiled the classes individually, the errors went away but when i generated CIL, it came back again. It was really frustrated. I decided something else must have caused this. This time i took different approach

1> Stop AOS

2> Delete all of the source in the C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin\XppIL directory

3> Start AOS

4> Perform a full compile and this time i got an additional message “There is not enough space on the disk”

clip_image002[4]

After verifying the hard drive, indeed there isn’t enough space in C drive

clip_image004[4]

Problem was solved after i freed up more space

 

Tags: , , ,

Warehouse management training

For those who are interested in Warehouse Management R3

image

 
Leave a comment

Posted by on April 24, 2014 in Development, Video

 

Tags: , , , ,

Delta – Another success story

Delta Air Lines is offering a new, in-flight customer experience. Designed and developed on the Microsoft Dynamics for Retail mobile point-of-sale platform and running on Nokia Lumia devices powered by Windows Phone 8, flight crews can now create a seamless, connected experience for travelers.

 
Leave a comment

Posted by on April 24, 2014 in Articles

 

Tags: , , , ,

Map:createFromXML parses incorrecly in IL mode

I need to serialize a Map and convert this back to Map when it reaches server side.  This piece of code works fine if running in XPP but fails in IL. I discovered this bug when i was trying to build code to extract trial balance and pass in dimension ranges map. Since this code has to be run in batch, i need to serialize this Map. I’m able to simplify this issue to the class below.

class MapTest

{
}

public server static void main(Args _args)
{
XppILExecutePermission permission = new XppILExecutePermission();
permission.assert();

runClassMethodIL(classStr(MapTest),
staticMethodStr(MapTest,run),
conNull());

}

public static server container run(container _con)
{
XmlDocument xDoc;
Map dimRangeMap = new Map(Types::Int64, Types::String);
SerializedDimensionRange    serializedDimensionRanges;
dimRangeMap.insert(5637144583, “40000..69999”);
serializedDimensionRanges = dimRangeMap.xml();
info(“BEFORE”);
info(serializedDimensionRanges);
xDoc = new XmlDocument();
xDoc.loadXml(serializedDimensionRanges);
dimRangeMap = new Map(Types::Int64, Types::String);
dimRangeMap = Map::createFromXML(xDoc.root() as XmlNode);
info(“AFTER”);
info(dimRangeMap.xml());
return conNull();
}

image

Hope Microsoft will solve this kernel bug soon

 
4 Comments

Posted by on April 22, 2014 in Development

 

Tags: , , ,

Management Reporter – Free Training (6 hours)

2014 Microsoft Management Reporter Forum Spring

Join other users of Management Reporter for Microsoft Dynamics ERP in a one-day online user conference discussing the latest information on Management Reporter, tips and tricks on getting the most out of this financial reporting and analysis solution and how others are using it in their operations.

When:  Friday, April 18, 2014 (11am-5pm Eastern; 8am-2pm Pacific)

Where:  Online

Cost:   FREE!

To register:  https://www1.gotomeeting.com/register/469755528

________________________________________________________________________

What is going on during our Management Reporter day? Plenty! So register soon as seating is limited even though this is a virtual conference. Below is an overview of the planned sessions:

April 18, 2014

The user group conference will run from 11am to 5pm ET (8am to 2pm PT). Times below are listed in Eastern Time.

* Session 1: 11:00-12:00 Product Overview

* Session 2: 12:15-1:15 Beginner Training Session 1

* Session 3: 1:30-2:30 Intermediate Session 1

* Session 4: 2:45-3:45 Intermediate Session 2

* Session 5: 4:00-5:00 Open Town Hall Q&A and Closing

Session 1 – Product Overview: This session is intended for those who are new to the product or who might benefit from a quick refresher on Management Reporter’s key features. An overview of the product functionality will be demonstrated.

Session 2 – Beginner Training Session 1: Get a crash course on the basic use of the application.

• Management Reporter: Learn how to create 4 key financial reports from start to finish – Trial Balance Detail & Summary, Income Statement by Company & Department

Session 3 – Intermediate Training Session 1: Build upon your fundamental product knowledge by seeing intermediate design techniques you may leverage for your reporting and analysis.

• Management Reporter: This session will cover upgrade recommendations for moving from FRx to Management Reporter.

Session 4 – Intermediate Training Session 2: Build upon your fundamental product knowledge by seeing intermediate design techniques you may leverage for your reporting and analysis.

• Management Reporter: This session will cover new features and functionality of Management Reporter will be shown to make the transition from FRx to MR seamlessly.

Session 5 – Open Town Hall Q&A and Closing: This open forum will address the most common questions that may be on your mind.

 
Leave a comment

Posted by on April 16, 2014 in Development

 

Tags: , ,

How to kill a blocking session

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

 
Leave a comment

Posted by on April 10, 2014 in Development

 
 
%d bloggers like this: