Florian's weblog

Limitations of the Dynamics Ax service references

flo2005 — Thu, 01 Jul 2010 09:39:57 GMT

The article about service-references limitations is available on my new blog.

Cross domain access to AIF Web Services (Dynamics Ax 2009)

flo2005 — Wed, 30 Jun 2010 21:29:40 GMT

I published the new article on my new blog.

.net programming for Dynamics AX developers slides

flo2005 — Wed, 30 Jun 2010 21:27:40 GMT

I published the slides from my last years presentation on my new blog. This is has been the working draft, but it contains much more slides as the final version, so I’m publishing this one.

Installing the COM Business Connector

flo2005 — Wed, 23 Jun 2010 16:11:10 GMT

I published the new article on my new blog.

My blog is Moving

flo2005 — Fri, 05 Feb 2010 09:40:29 GMT

I’m moving to Blogger since I’m writing these articles for personal purposes and I want to have as much control as possible on my postings. So Please be aware that I will will publish my next articles on the new blog.

Enterprise Portal license required for workflows with dynamics Ax 2009

flo2005 — Mon, 25 Jan 2010 16:58:12 GMT

Dynamics Ax workflow does require the Enterprise Portal (EP) license. License changes since Dynamics Ax 4 can be found here.

Please double-check that the EP license is well configured when the BC.Net throws the following exception (can be found in the Windows application-EventLogs):

Session log on for Microsoft Dynamics failed.
Dynamics Adapter LogonAs failed.
Microsoft.Dynamics.Framework.BusinessConnector.Session.Exceptions.FatalSessionExcept
ion
at
Microsoft.Dynamics.Framework.BusinessConnector.Session.DynamicsSession.HandleExcepti
on(String message, Exception exception, HandleExceptionCallback callback)
at
Microsoft.Dynamics.Framework.BusinessConnector.Session.DynamicsAdapter.LogonAs(Strin
g user, String domain, NetworkCredential bcProxyCredentials, String company, String
language, String objectServer, String configuration)

Delete TEMP files when sending mails with attached files

flo2005 — Mon, 25 Jan 2010 15:53:58 GMT

Attaching Documents is a frequently used functionality in Ax (PDF is just an example, but it is true for any attached file):

That is why tmp-files, that are generated each time you are using this, might consume quickly an important part of your hard disk, since they are not deleted at the end of the process. The temp-files are copies of the generated text, pdf or RTF files from the tmp-directory. This directory is defined as an user environment variable:

The easiest way is to schedule a batch which is cleaning the temp directly each time you are starting or shutting down your system. But even this is sometimes not enough. The it is necessary to change the X++ code.

When sending a report as an attachment, the kernel calls the method reportSendMail of the Info-class and passes all necessary information about the attachment in a variable of type PrintJobSettings.

The email is sent in the last line of this method:

m.sendMailAttach(p1.mailTo(),p1.mailCc(), p1.mailSubject(),'axapta report', true, p1.fileName(), fileName);

“m” is a variable of type SysINetMail. The path and file-name of the temp-file is passed as argument with p1.fileName(). Because the tmp-file is only used to attach the file to mail by using the Mapi, the is no risk to delete the file at the end of this process. The best place to delete this file is after the logoff of the Mapi session in the method sendMailAttach:

   1:          this.logoff();

   2:          if (!isRunningOnServer())

   3:          {

   4:              if(WinAPI::fileExists(_attachPath))

   5:              {

   6:                  WinAPI::deleteFile(_attachPath);

   7:              }

   8:          }

Line 2 to 8 is the new code. Line 2 checks if the code is called from the AOS, which is always false, but to be sure that any other custom-code will work, it is better to check this nevertheless. It would be better to encapsulate the delete-call in a try-catch-block, because deleting files is always a risk and must be treated, but this is just an example of course.

Working with Images (BLOBS) between Dynamics Ax and external applications (UPDATED: 06/01/2010)

flo2005 — Mon, 04 Jan 2010 15:00:00 GMT

(updated the 05/01/2010 and 06/01/2010)

The idea

Whenever you need to transfer data in a platform specific format (like Images), the easiest way of doing this is to create an envelope (in Xml) and put the data in an encoded format in this envelope.

Here’s a schema that shows such a scenario:

The Ax layer

On the Ax layer (the 2nd row) the image is transformed in a base64 string (the text file in the schema) and then put into an Xml-document (the envelope in the schema).

Just have a look at the table CompanyImage, that is used to persist the picture of an employee:

The type of the column in which the image is saved is “Container”. There is no explicit type for Images, but you will notice that the table in the SQL-Server database uses the type “Image” to persist the container information. The image-type of the SQL-Server 2008 is defined as:

Variable-length binary data from 0 through 2^31-1 (2,147,483,647) bytes.

In contrast to its name (“image”) this type is used to persist any binary data from Ax (container). Working in X++ with the binary data in the container requires the conversion to the type BinData which provides all necessary information to load, save, encode or decode binary data. This is what I will do in the following example.

Here’s a simple code that reads out the image (CompanyImage) and puts this in a XmlDocument:

   1:  public static XmlDocument  getImageXml(dataAreaId refDataAreaId, tableId refTableId, recId refRecId)

   2:  {

   3:      XmlDocument xmlEnvelope;

   4:      XmlElement childNode;

   5:      str content;

6:

   7:      CompanyImage ci;

8:

   9:      BinData bin = new BinData();

  10:  ;

11:

  12:  //getting image from CompanyImage

  13:  ci = CompanyImage::find(refDataAreaId, refTableId, refRecId);

14:

  15:  //creating BinData object from Container in the CompanyImage object

  16:  bin.setData(ci.Image);

  17:  //encoding the image to base64

  18:  content = bin.base64Encode();

19:

  20:  //creating the envelope and inserting a XmlElement that contains the image

  21:  //in a base64 string

  22:  xmlEnvelope = new XmlDocument();

  23:  childNode =  xmlEnvelope.CreateElement("image");

  24:  childNode.innerXml(content);

25:

  26:  xmlEnvelope.AppendChild(childNode);

27:

  28:  return xmlEnvelope;

  29:  }

Here’s the code for testing this function

   1:  static void Job11(Args _args)

   2:  {

   3:      str xmlContent;

   4:      XmlDocument xmlEnvelope;

5:

   6:      recId refRecId;

   7:      tableId refTableId;

   8:      dataAreaId refDataAreaId;

9:

  10:  int i;

  11:  ;

  12:  //Sample Data...

  13:  refDataAreaId = "ceu";

  14:  refTableId = 103;

  15:  refRecId = 5637144576;

  16:  xmlEnvelope = new XmlDocument();

  17:  //getting image from CompanyImage

  18:  xmlEnvelope = A1::getImageXml(refDataAreaId, refTableId, refRecId);

19:

  20:  xmlContent = xmlEnvelope.xml();

  21:  }

Just an useful hint: If you need to encode large images, you might run into an issue with the base64Encode method. Unfortunately this is not documented on msdn, but this is related to a limitation of the buffer size. This can be fixed as described by Paul Steynberg on his blog.

Whenever you communicate with an external application that can’t convert the Ax type XmlDocument, you need to wrap the method getImageXml with a method that returns a string:

   1:  public static str  getImage(dataAreaId refDataAreaId, tableId refTableId, recId refRecId)

   2:  {

   3:      return A1::getImageXml(refDataAreaId, refTableId, refRecId).xml();

   4:  }

The client (using BC.Net)

Now that we have a method that return a string instead of a XmlDocument, we can directly use CLR objects instead of using wrapper classes. In .Net we can handle the XmlDocument-content from the Ax 2009 in a string. But, since Xml is much more flexible than a simple encoded string, a method that does the conversion to a System.Xml.XmlDocument is recommended:

   1:          /// <summary>

   2:          /// Getting the Xml-envelope with the image

   3:          /// </summary>

   4:          /// <param name="refDataAreaId">ceu</param>

   5:          /// <param name="refTableId">103</param>

   6:          /// <param name="refRecId">5637144576</param>

   7:          /// <returns>The Xml-envelope with the image as content</returns>

   8:          private static XmlDocument GetXmlDocument(string refDataAreaId,

   9:              int refTableId,

  10:              long refRecId)

  11:          {

  12:              XmlDocument xml = new XmlDocument();

13:

  14:              using (Axapta ax = new Axapta())

  15:              {

  16:                  ax.Logon(refDataAreaId, string.Empty, string.Empty, string.Empty);

17:

  18:                  string xmlImageValue = (string)ax.CallStaticClassMethod("A1", "getImage", refDataAreaId, 103, 5637144576);

19:

  20:                  xml = new System.Xml.XmlDocument();

  21:                  xml.InnerXml = xmlImageValue;

  22:                  ax.Logoff();

  23:              }

24:

  25:              return xml;

  26:          }

Please be aware that this is just an example and that in a real world application you must implement an exception handling which I do not implement here to have code that is easier to read.

Now that we do have the xmlEnvelope with the encoded image as content, we need a method that does read out the content and returns the image:

   1:          private static Image UnwrapImage(XmlDocument xmlEnvelope)

   2:          {

   3:              XmlElement imageContent = (XmlElement) xmlEnvelope.FirstChild;

   4:              string base64Image = imageContent.InnerXml;

5:

   6:              byte[] imageBytes = Convert.FromBase64String(base64Image);

7:

   8:              MemoryStream stream = new MemoryStream(imageBytes);

   9:              Image content = Image.FromStream(stream);

10:

  11:              return content;

  12:          }

All that we need is an event that dos call this method and that assigns the image-content for example to a visual control like a picture-box:

   1:          private void button6_Click(object sender, EventArgs e)

   2:          {

   3:              string refDataAreaId = "ceu";

   4:              int refTableId = 103;

   5:              long refRecId = 5637144576;

6:

   7:              XmlDocument xmlEnvelope =

   8:                  GetXmlDocument(refDataAreaId,

   9:                      refTableId,

  10:                      refRecId);

11:

  12:              Image content = UnwrapImage(xmlEnvelope);

13:

  14:              pictureBox1.Image = content;

  15:          }

The Ax layer (using the AIF)

The first schema was based on the communication with Xml data. I was not explicitly showing the possibility to use the BC.Net because the real advantage of the xmlEnvelope data is given when all the communication is based on Xml. This is the case with WebServices. Creating an AIF-service that exposes a method returning the XmlEnvelope is quite easy. First you need a class that is derived from the AifDocumentService and that implements the following methods:

   1:  class AifSampleImageService extends AifDocumentService

   2:  {

   3:  }

   1:  public static str  getImage(dataAreaId refDataAreaId, tableId refTableId, recId refRecId)

   2:  {

   3:      return A1::getImageXml(refDataAreaId, refTableId, refRecId).xml();

   4:  }

   1:  protected void new()

   2:  {

   3:      ;

   4:      super();

   5:  }

   1:  public static AifSampleImageService construct()

   2:  {

   3:      return new AifSampleImageService();

   4:  }

After that a new Service and the operator needs to be configured in the AOT:

Be careful that the security key is configured. Otherwise this will result in an authorization error.

Once the Service is configured this new service is available in the AIF-configuration by refreshing the available AIF-services and enabling the new AIF-service the AIF-services in the AIF-administration:

Then the services need to be regenerated (“Generate button). The new service is now available and accessible with the Internet Explorer:

The Xml-schema (Xsd) that represents the AIF-operator is the following:

   1:  <?xml version="1.0" encoding="utf-8"?>

   2:  <xs:schema elementFormDefault="qualified" targetNamespace="http://tempuri.org" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:tns="http://tempuri.org">

   3:    <xs:element name="AifSampleImageServiceGetImageRequest">

   4:      <xs:complexType>

   5:        <xs:sequence>

   6:          <xs:element minOccurs="0" name="refDataAreaId" nillable="true" type="xs:string"/>

   7:          <xs:element minOccurs="0" name="refRecId" type="xs:long"/>

   8:          <xs:element minOccurs="0" name="refTableId" type="xs:int"/>

   9:        </xs:sequence>

  10:      </xs:complexType>

  11:    </xs:element>

  12:    <xs:element name="AifSampleImageServiceGetImageResponse">

  13:      <xs:complexType>

  14:        <xs:sequence>

  15:          <xs:element minOccurs="0" name="response" nillable="true" type="xs:string"/>

  16:        </xs:sequence>

  17:      </xs:complexType>

  18:    </xs:element>

  19:  </xs:schema>

As you can see in line 15, the return type of the operator “GetImage” has the type “string”. This is certainly not the best solution in a SOA-context, since you loose the type information of your Xml-document. In a real world application it would be much better to define a special type within Ax that describes the format. It seems to be clear, that the following schema explains perfectly, that image-element contains a encoded base64 value:

   1:  <?xml version="1.0" encoding="utf-8"?>

   2:  <xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">

   3:    <xs:element name="image" type="xs:base64Binary" />

   4:  </xs:schema>

The type “base64Binary” is part of the Xml-schema specification of the W3C and defined as:

base64Binary represents Base64-encoded arbitrary binary data. The ·value space· of base64Binary is the set of finite-length sequences of binary octets. For base64Binary data the entire binary stream is encoded using the Base64 Alphabet in [RFC 2045].

This is exactly what the XmlDocument contains:

   1:  <?xml version="1.0" encoding="UTF-8"?>

   2:  <envelope>

   3:  <image> [the image encoded in a base64 value] </image>

   4:  </envelope>

How to create data types is explained on the Aif blog in a good article about creating custom Ax services. There you could implement the method “getSchema” of the interface “AifXmlSerializable”. The article explains you in detail how to do this and this would go too far for this article. Just keep in mind that communicating Xml-documents in a string is a ‘no do’ in a SOA environment and that there are better ways with Dynamics Ax.

The .Net client (Consuming the AIF-service)

The Wsdl, that is exposed by this new service, can now be referenced in a Visual Studio 2008 project as a Service Reference:

The GetXmlDocument method from the first example (using the BC.Net) is changed to consume a WebService:

   1:          /// <returns>The Xml-envelope with the image as content</returns>

   2:          private static XmlDocument GetXmlDocumentFromAif(string refDataAreaId,

   3:              int refTableId,

   4:              long refRecId)

   5:          {

   6:              XmlDocument xml = new XmlDocument();

7:

   8:              AifSampleImageServiceClient client = new AifSampleImageServiceClient();

   9:              string xmlImageValue = client.getImage(refDataAreaId, refRecId, refTableId);

  10:              xml = new System.Xml.XmlDocument();

  11:              xml.InnerXml = xmlImageValue;

12:

  13:              return xml;

  14:          }

Now the an event lets us consume get and unwrap the image and display in a PictureBox as in the first example. The method UnwrapImage is taken from the first example.

   1:          private void button8_Click(object sender, EventArgs e)

   2:          {

   3:              string refDataAreaId = "ceu";

   4:              int refTableId = 103;

   5:              long refRecId = 5637144576;

6:

   7:              XmlDocument xmlEnvelope =

   8:                  GetXmlDocument(refDataAreaId,

   9:                      refTableId,

  10:                      refRecId);

11:

  12:              Image content = UnwrapImage(xmlEnvelope);

13:

  14:              pictureBox1.Image = content;

  15:          }

Memory leaks and profiling with .Net

flo2005 — Wed, 04 Nov 2009 21:48:00 GMT

I wrote some moths ago an article about the GC and highlighted some particularities (unsafe and unmanaged code, disposing and finalizing, etc).

When you are developing with .Net you will be sometimes faced to memory or resource leaks. Especially if you are using the BC.Net, since the BC.Net is using unsafe and unmanaged code. But even with X++ you will be more and more faced to such problems. So it is very useful to know as much as possible about causes, identification and resolving.

Fabrice Marguerie (co-author of LINQ in Action) wrote a great article on MSDN (his blog entry for the trackback) about this subject. Enjoy this article!

IDynamicsAXExpressionBuilder returned error code 0x80131509 - reloaded

flo2005 — Thu, 20 Aug 2009 12:21:12 GMT

As I already wrote it in the update of that blog entry in my first posing about this issue:

The origin of this issue can be found in the method 'buildEnumerationXml' of the class 'SysExpression':

Currently, a loop iterates until the last element:
for (i = sysDictEnum.firstValue(); i <= sysDictEnum.lastValue(); i = sysDictEnum.nextValue(i)) 
I you replace this (sysDictEnum.lastValue(); ) by the number of elements (sysDictEnum.values();) the issue is solved.

[UPDATE 03/09/2009]

The hotfix for this bug has been published: KB974925 (Build: 5.0.1500.1255).

Importing Leads and Contacts

flo2005 — Wed, 19 Aug 2009 01:11:00 GMT

You can find a very good description on our team blog (EMEA Dynamics AX Support) how to import leads and contact Xml files with Dynamics Ax 2009 here. The problem you will be faced by using this is, that you can’t import data with non Ascii characters, which might cause some difficulties. The reason for that is the way how the Xml files is proceeded during the transformation process.

Ax creates first a copy of the Xml file and the Xslt File in the temp directory of the AOS which is by default:

C:\Program Files\Microsoft Dynamics AX\50\Application\appl\DynamicsAx1\tmp\

Unfortunately this is done by reading out the Xml file into a container and then creating a new Xml file by using the method:

SysImportUtil/createFileFromContainer

Unfortunately because it is using the AsciiIo to create the file. Since this class is intended to encode the content of the container into Ascii, it is incompatible with Xml files. The sample files are using Xml files encoded in Utf-8 which is some kind of an extension to Ascii and this is the reason why you can’t use this import for non Ascii characters:

[..] AsciiIO supports only ANSI code page (ACP) characters.

But you can fix this by replacing the AsciiIo by the TextIo class. Msdn describes it as follow:

TextIO replaces AsciiIO to provide support for non-ANSI code page file I/O. The TextIO constructor has an additional optional parameter to set the code page of the file.

This is exactly what we need. The most common codepages are:

0 - CP_ACP; the ANSI code page
437 - OEM code page 437
850 - Code page 850
1200 - UTF-16LE (default value)
1201 - UTF-16BE
65001 - UTF-8
54936: GB-18030

So, if you want to use the Xml-files from the example without any modification you need to change the codepage to 65001, but it is easier to change the Xml-file to Utf-16. This can be done easily by using Visual Studio:

Just open the Xml-file, change the Utf-8 to Utf-16 and safe the changes. Why not using the notepad ?

Visual Studio reads out the Xml encoding information:

<?xml version="1.0" encoding="utf-16"?>

and adds the required file signature to that file (called BOM). These information can be consulted with the Visual Studio binary editor (File/Open/File/<select Xml-file>/Open as/binary editor): “EF BB BF” for Utf-8 and “FF FE” for Utf-16.

So in order to import data with non-Ascii data, you have to:

replace the AsciiIo class by TextIo
import Utf-16 encoded Xml data.

Template Wizard does create SheetNames with more than 30 characters

flo2005 — Tue, 18 Aug 2009 22:14:53 GMT

The Template Wizard (Administration/Periodic/Data export/import/Excel spreadsheets/Template Wizard) creates unfortunately SheetNames that might exceed 30 characters, which is not allowed by Excel and results in annoying message boxes that are requesting a new SheetName with less than 31 characters.

The following code change in the method SysDataExcelDef/buildTmpExcelWorksheet will resolve this problem:

   1:          //modifications done for working with long tablenames

   2:          //    str tempSheetName;

   3:          //    str suffixName;

   4:          //    int suffixlength;

   5:          //original code:

   6:          //tmpExcelWorksheet.SheetName = tmpExcelWorksheet.TableName + '_' + int2str(sysExpImpTable.OccurrenceId) + '-1';

7:

   8:          tempSheetName = tmpExcelWorksheet.TableName + '_' + int2str(sysExpImpTable.OccurrenceId) + '-1';

9:

  10:          if (strlen(tempSheetName) > 30)

  11:          {

  12:              tempSheetName = tmpExcelWorksheet.TableName;

  13:              suffixName =  '_' + int2str(sysExpImpTable.OccurrenceId) + '-1'; //as this is done in the original code

  14:              suffixLength = strlen(suffixName);

  15:              tempSheetName = substr(tempSheetName, 0, 30 - suffixLength);

  16:              //assigning the new name

  17:              tmpExcelWorksheet.SheetName = tempSheetName + suffixName;

  18:          }

  19:          else

  20:          {

  21:              tmpExcelWorksheet.SheetName = tempSheetName;

  22:          }

Large Xml-documents with an AIF-WebService.

flo2005 — Tue, 11 Aug 2009 12:48:00 GMT

If you are faced to 'large' Xml-documents with AIF-WebServices, you might be faced to difficulties for Inbound and OutBound services. The following two points should be applied for the client app.config, if the client uses the WCF for communicating with...(read more)

‘0’-values don’t appear in Xml files generated by the AIF

flo2005 — Tue, 11 Aug 2009 11:57:21 GMT

Numeric values that are 0 (not null) are not serialized and don't appear in the Xml file. The reason for this is, that the numeric types in Dynamics Ax are not nullable (must have a value) and do interpret the value 0 as a "null value" (0 as...(read more)

AIF-service call with COM and .Net Business Connector

flo2005 — Tue, 11 Aug 2009 11:48:46 GMT

When executing an AIF-service with the COM and .Net Business Connector the client will not be notified about exceptions during the execution. The reason for this is, that AIF-services are always executed within a transaction ( ttslevel = 1) even when...(read more)

Request for the permission of type 'SecurityPermission' failed

flo2005 — Mon, 10 Aug 2009 20:49:00 GMT

When you get the following exception while executing a report on the SSRS or within Ax: System.Security.SecurityException was unhandled Message=" Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version...(read more)

base64Encode() of the kernel class ‘Image’ does return an empty string

flo2005 — Mon, 10 Aug 2009 18:32:24 GMT

A partner asked me why the base64Encode method of the Image class does always return an empty string. In the following example: 1: Image image; 2: str sBase64Encode; 3: ; 4: image = new Image(); 5: image.loadImage(@ 'C:\sample.bmp...(read more)

Gender information in Employees-form and the Global Address Book (GAB)

flo2005 — Mon, 10 Aug 2009 12:47:00 GMT

You can open the information about employees with the Global Address Book (Basic/Global Address Book) and with the Employees form (Basic/Employees). Normally it is no problem to modify data in both forms, but unfortunately this is not true for the...(read more)

IDynamicsAXExpressionBuilder returned error code 0x80131509

flo2005 — Tue, 05 May 2009 18:05:00 GMT

In forms that are using the ActiveX-control ExpressionBuilder (like TrvPolicyForm) you might be faced to the following error message: Method 'initialize' in COM object of class 'IDynamicsAXExpressionBuilder' returned error code 0x80131509 (<unknown>...(read more)

Webcast: .Net for X++ programmers

flo2005 — Thu, 19 Mar 2009 20:32:00 GMT

I will do a short Webcast about .Net basics for X++ developers which is based on the articles I posted here recently. During 1 hour I’ll talk about the basics of .Net and how to do’s. If you are a X++ programmer and you are new to .Net, this Webcast might...(read more)

Some links to IIS 7 information

flo2005 — Tue, 03 Mar 2009 13:28:00 GMT

IIS 7 changed fundamentally since IIS 6. Here are some links that might help you when you feel lost with all these changes ;-) IIS 7 Links: http://technet.microsoft.com/en-us/library/cc732976.aspx ( IIS 7.0: Operations Gui de) http://www.iis.net/ConfigReference...(read more)

Deploying service references with Dynamics Ax 2009

flo2005 — Mon, 09 Feb 2009 16:46:12 GMT

Service references are are great feature in Dynamics Ax 2009 and using WCF with Ax is now really easy. But unfortunately it is not easy to deploy this service reference. If you now need to deploy a service reference from the development environment to...(read more)

RPC error 1702 when calling a WinAPI method from a batch job

flo2005 — Thu, 29 Jan 2009 16:55:00 GMT

You probably already noticed that error messages are sometimes not really helpful when you are trying to understand a problem. The following code creates such misleading error message: 1: public void run() 2: { 3: ; 4: if (WinApi::folderExists...(read more)

AxUpdatePortal Utility

flo2005 — Wed, 28 Jan 2009 13:52:59 GMT

I just want to remind the existence of this nice little tool , which is be very useful for any deployment or redeployment of your WebParts and EP-sites. Basically it is a simple .Net command-line executable which calls the same method as the AxSetup does...(read more)

Internet Explorer 8 RC1

flo2005 — Tue, 27 Jan 2009 13:37:00 GMT

Because I blogged about Google Chrome when it was getting beta, I’m doing this with the IE 8, too. You can now install the RC1 of this version, which is very close the the final version. This version is available here . The key features of this version...(read more)