30 June 2015

AX 2012 R3 | Mobile Device Portal | Connect to different AOS

You can install the Warehouse Mobile Devices Portal on whatever server you like. It just needs IIS
By default, Warehouse Mobile Devices Portal is configured to connect to an AOS instance that is installed on the same computer with ServicePort 8201.
If that is not the case, you must modify the web.config file for the instance of Warehouse Mobile Devices Portal.

Therefor open Internet Information Services (IIS) Manager:
  1. Right-click the website for an instance of Warehouse Mobile Devices Portal and click Explore: 
  2. Open the web.config file in a text editor and locate the net.tcp binding that is named NetTcpBinding_WHSMobileDevicesService. 
  3. Update the endpoint address that is associated with the net.tcp binding. 
  4. Save and close the web.config file.

AX 2012 R3 | Mobile Device Portal | display settings

If the mobile device is showing this error:

Die Schnittstelle des mobilen Geräts kann nicht geöffnet werden, da entweder die Anzeigeeinstellungen nicht oder falsch konfiguriert sind. Konfigurieren Sie gültige Einstellungen für die Anzeige des mobilen Geräts.

The mobile device interface cannot be opened because either the display settings are not configured or they are configured incorrectly. Configure valid settings for the mobile device display.

Check the default company account for the user that is used by the warehouse mobilde device portal to coneect ot AX. Then jump into that company and check the display settings:

Warehouse management > Setup > Mobile device > Work user mobile device display settings

In most cases the settings are not correct in that company:
One valid line can look like: Default, Yes, defaultrf.css, DisplayIEOS

11 June 2015

SSRS / SSAS: AdomdErrorResponseException user or db connection error

When you get this error when you try to open an SSRS Report from AX that contains SSAS Cubes you should check if there is a security issue.

Microsoft.ReportingServices.ReportProcessing.ReportProcessingException

Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: 
Der Benutzer 'DOMAIN\user123' kann nicht auf die Dynamics AX-Datenbank zugreifen, oder die Datenbank ist nicht vorhanden. 

Either the user, DOMAIN\user123, does not have access to the Dynamics AX database, or the database does not exist.

If the security settings are fine navigate to the SSRS Report manager and check the OLAP Connection string:
  1. Open Report Manager. http://[SSRSServerName]:80/Reports
  2. Click the DynamicsAX folder
  3. Click the DynamicsAXOLAP data source
  4. In the Connection string field, check the Database and Initial Catalog
  5. Change it if neccessary and try again


    Provider=MSOLAP.4;Integrated Security=SSPI;Persist Security Info=True;Data Source=SSASServerName;Initial Catalog=SSASDatabaseName



10 June 2015

DIXF | Error while importing product data from staging to target

When importing product data with the data import export framework into dynamics ax I faced the following error:

SysDictTable Objekt ist nicht initialisiert. 

Stack-Trace 
(C)\Classes\DMFEntityWriter\write - line 244 
(S)\Classes\DMFEntityWriter\runOnServerWriter - line 14 
(C)\Classes\DMFEntityWriter\run - line 98 
(C)\Classes\DMFEntityWriter\main - line 24 
(C)\Classes\xMenuFunction\run 
(C)\Classes\MenuFunction\run - line 85 
(C)\Forms\DMFWriteData\Designs\DesignList\DMFEntityWriterBatch\Methods\Clicked - line 23

Checking the code I found out that this is where the table structure is taken and the targettbales are added to a query. There I noticed that one table from the structure could not be found. But why that?

First thing I tried was opening the target mapping > refresh and regenerate the mapping, without a result. After a bit more debugging I found out that the Table that created this error was the RetailInventTable which was not available because the config keys for retail was disabled.
So I checked the entity structure and tried to remove it. But we are not allowed to delete here.



To fix this I had to go into the development workspace. Navigate to Queries > DMFProductTargeEntity > DataSources > InventTable > DataSources and delete RetailInventTable here.
After that navigate back to the target mapping > refresh and regenerate the mapping. Have a look at the entity structure. The Table that created the problem is no longer in there.

After that change the import to target is working fine :)

03 June 2015

SSMS Activity Monitor - access denied

If you receive the message "Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) (mscorlib)" when trying to open Activity Monitor from SQL Server Management Studio you should try to start SSMS as administrator. If that does not help follow the suggested workaround in this connect post:

https://connect.microsoft.com/SQLServer/feedback/details/770897/after-installing-sp1-sql-server-2012-activity-monitor-gives-access-denied

I had this issue in a failover cluster starting as administrator solved it for me.

01 June 2015

SSRS Error: rsErrorInOnInit

When the SSRS Server is showing the following error when you try to open an SSRS Report:

An error occurred while executing OnInit: The report execution failed to start. Verify that Report Extensions have been installed or are configured correctly. Please consult your administrator or the documentation. (rsErrorInOnInit)

German Message:
Fehler beim Ausführen von 'OnInit': Fehler beim Starten der Berichtsausführung. Überprüfen Sie, ob die Berichtserweiterungen installiert bzw. richtig konfiguriert wurden. Weitere Informationen erhalten Sie vom Administrator oder in der Dokumentation. (rsErrorInOnInit)

Then you have to check your SSRS Server config files. They should contain the AX specific settings as described on technet: http://technet.microsoft.com/EN-US/library/hh389762.aspx