Installing - Intelligent Data Management Framework - MSDTC

Before you can install the Intelligent Data Management Framework (IDMF) you need to configure the Microsoft Distributed Transaction Co-Ordinator (MSDTC) which is part of the server OS.

 

 

1. run the component Services (run: dcomcnfg) or go to ControlPanel -> AdministrativeTools -> Component Services
2. Navigate to the Distributed TRansaction Coordinator and right click on the Local DTC select Properties
   
3. Navigate to security and check the following checkmarks:
   
   

   Network DTC Access	Enabled
   Client and Administration
   Allow Remote Clients	Enabled
   Allow Remote Administration	Enabled
   Transaction Manager Communication
   Allow Inbound	Enabled
   Allow Outbound	Enabled
   No Authentication Required	Enabled

4. Click Okay and yes to let the MS DTC do a restart. After that try to install IDMF again

Prerequisite check: WSDL URI not accessible (port missing)

When installing the Helpserver on I got the error message from prerequisite check 'Application Object Server (AOS) Services WSDL URI accessible'. - Check failed."Resolution: Attempt to access the WSDL port manually by entering the URI http://[NameOfTheServer]:8101/DynamicsAx/Services/MetadataService. ..."

The problem in my Case was that the AOS 1 was uninstalled and obviously the port (8101) is not accessible. But there is a quick workaround. Just let the check talk to another WSDL port by forwarding the port 8101 to another WSDL port. In my Case 8101 --> 8103.

Therefor just open a command prompt an d enter the following command:

netsh interface portproxy add v4tov4 listenport=8101 listenaddress=[NameOfTheServer] connectport=8103 connectaddress=[NameOfTheServer]

German message:

URI der AOS-Dienste-WSDL zugreifbar

Von dem Computer auf dem Setup ausgeführt wird muss auf den URI der AOS-Dienste-WSDL (Web Services Definition Language) zugegriffen werden können. Beim Setup werden Webdienste zum Kommunizieren mit Microsoft Dynamics AX verwendet, um einen Teil der Konfiguration abzuschließen.

Versuchen Sie, manuell auf den WSDL-Port zuzugreifen, indem Sie den URI http://DEWUE-VS-PLDEV2:8101/DynamicsAx/Services/MetadataService eingeben. Wenn Sie nicht auf den URI zugreifen können und die Firewall aktiviert ist, versuchen Sie gemeinsam mit dem Netzwerkadministrator zu ermitteln, warum der URI auf dem Anwendungsobjektserver (AOS) nicht erreicht werden kann.

Informationen zur Überprüfung der Voraussetzung erhalten Sie durch Klicken auf den Link 'Protokolldatei anzeigen'. Detaillierte Problembehandlungsschritte finden Sie im Problembehandlungsabschnitt des Installationshandbuchs unter http://go.microsoft.com/fwlink/?LinkId=211990.

SSRS Report Error: Parameter FormLetterRecordId does not exist on this Report

When you see this error "Parameter FormLetterRecordId does not exist on this Report" when trying to open an SSRS Report then you should check the corresponding TMP Tables for the Report. These DataProvider tables are normally temp tables and should not contain data. In my case in the VendInvoiceDocumentTMP where still two records left which created this message. Deleting these records solved the Problem for me ;)

Dataimport/-export Framework DMF / DIXF - broken target entity

The Dataimport/-export Framework is a great tool to get a lot of data into AX. But like most of the nice tools the Feedback is sometimes not as detailed as it could be.

While working on some imports with standard entities I was unable to move data from staging to target.

The infolog showed the well known message that 0 records had been inserted into target. So I started some research. Best hint was the message from the Validation of the target entity which was:

Target XML tags are not generated and hierarchy cannot be found

Die Ziel-XML-Markierungen wurden nicht generiert, und die Hierarchie kann nicht gefunden werden.

So I checked the structure of the entity which was empty. I still don't know how this could happen, but there is an easy way to recreate this structure. The following lines of code will help:

DMFEntity   dmfEntity;

select dmfEntity where dmfEntity.EntityName == "BrokenEntityName";

if (dmfEntity.EntityType == DMFEntityTypes::Entity)
{
    DMFTargetXML::buildQueryDS(dmfEntity);
    DMFTargetXMLToEntityMap::generateMapping(dmfEntity);
}

Test Data Transfer Tool - TDTT is unable to transfer memo fields

we recently had problems transfering test data from a test to a dev environment using the test data transfer tool. After some research we figured out that the problem occurs when transfering tables that contain memo fields.

the error log is always showing the following BCP Error: "Warning: BCP Import with a format file will convert empty strings in delimited columns to NULL"

Error = [Microsoft][SQL Server Native Client 11.0] Warnung: Beim BCP-Import mit einer Formatdatei werden leere Zeichenfolgen in durch Trennzeichen getrennten Spalten in NULL konvertiert.
After some discussions with Microsoft the actual Statement is that TDTT is still beta and right now it is not supported to transfer tables with Memo fields containing NULL Values.

So we transfered These tables manually with some SQL commands and requested MS to add this functionality in the final Version of the Test Data Transfer Tool.

Please vote for this request on the connect platform:  https://connect.microsoft.com/dynamicssuggestions/feedbackdetail/view/957734

LCS Diagnostic Tools - Failed to Invoke Diagnostik External Services

I just installed LCS System Diagnotic to get an overview of the functionality provided within the life cycle services. After the Installation process I started Diagnostics Services and got the following error message:
"Failed to Invoke Diagnostic External Services:  Keyset does not exist" or in german:
"Failed to Invoke Diagnostic External Services:  Der Schlüsselsatz ist nicht vorhanden"

After some research I found out that this is due to the fact that my service is running with an account which is not within the administrators group.

So I followed these steps to allow the service account to access the certificate;

1. Start the Microsoft Management Console from the start menu (typing mmc and hitting enter is enough).
2. Click on File > Add or remove Snap-In
3. Select Certificates
4. Click on Add and select “Computer account”
5. Select “Local Computer”
6. Click finish
7. Under Certificates > Personal > Certificates look for the one you created
8. Right click on the certificate and select All Tasks > Manage Private Keys…
9. On the Security tab add the service account for the Diagnostics Service and grant full control to it.
10. Click on accept.
11. Restart the Diagnostics service.

That's it - Thank you Microsoft!

SSRS Report Pro-upgrade remaining accruals is empty

When opening the SSRS report Accounts Payable \ Reports \ Purchase Orders \ Pro-upgrade remaining accruals (in German: Restabgrenzung von vor der Aktualisierung) I was wondering why there is no data shown on that Report.
So I tried to find out what the use of this report is. It is only populated with data if you do a data upgrade from AX 4.0 to AX 2012 with open purchase orders that are not yet invoiced. These will be schown within that report. Once all the purchase orders that were received not yet invoice in AX 4.0 get finally invoiced in AX 2012 the report is obsolete.