Update AX 2012 Labels through SQL

If you need to replace a word within all  Labels of a layer there is a very easy way using a SQL command:

USE TWIAX_model
UPDATE ModelElementLabel
    SET Text = REPLACE(Text, 'Hafen', 'Port')
    WHERE (Module = 'SYP' OR Module = 'SYS') AND Language = 'de'

This SQL command will replace the word 'Hafen' in all Labels of the SYS and SYP layer in german label file with the word 'Port'.

After execution of this command it is required to stop the AOS and delete the *.ald files in the server folder:

C:\Program Files\Microsoft Dynamics AX\60\Server\TWIAX\bin\Application\Appl\Standard

Afterwards restart AOS again.

Fix Windows 8 when it's not booting

Just a post to remember what to do when the harddrive is unable to boot windows 8 after playing around with partitions in linux :)

I tried to use the repair function within the windows 8 installation and got the following message:

Windows 8.1 auffrischen – Fehler “Das Laufwerk ist gesperrt, bitte entsperren Sie das Laufwerk”

To fix it open the command prompt and use these commands:

• bootrec /fixmbr 
• bootrec /fixboot 
• bootrec /scanos 
• bootrec /rebuildbcd

Restart and windows should be able to boot again. If not run chkdsk

• chkdsk C: /f /x /r

DIXF crashs when using SQL Server 2012 SP2

Today I was asked how to solve the problem of service crashes of the data import export framework service in an environment that is running SQL Server 2012 SP2.
We had this issue some month ago at a customer who updated the SQL Server according to his regular update plan. Suddenly we were not able to import data with the DIXF anymore. The solution to this issue is the cumulative update CU2 for SQL Server 2012 (http://support.microsoft.com/kb/2983175).

Microsoft announcend the compatibility to SQL Server 2012 SP2 CU2 or higher in the following blog post:
http://blogs.technet.com/b/dynamicsaxse/archive/2014/10/09/announcing-support-for-sql-server-sharepoint-and-office-2013-service-packs-as-well-as-visual-studio-team-foundation-server-and-visual-studio-online.aspx

• Microsoft SQL Server 2012 SP2 CU2 or later with Microsoft Dynamics AX 2012 R3, Dynamics AX 2012 R2 CU7 and Dynamics AX 2012 CU7

Copy Company is back :)

Thanks to Munib who has reimplemented a copy company function based on the way it was done back in AX 2009. He made it available on codeplex so that we all can test it: https://dax2012copycompany.codeplex.com/
Have fun with it but keep in mind that deleting a company can also lead to problems :)

AX 2012 R2 SSAS: Process Production Cube error 22007

If you cannot process the Production cube and get the following error:

OLE DB-Fehler: OLE DB- oder ODBC-Fehler : Warnung: Ein NULL-Wert wird durch einen Aggregat- oder sonstigen SET-Vorgang gelöscht.; 01003; Bei der Konvertierung eines nvarchar-Datentyps in einen datetime-Datentyp liegt der Wert außerhalb des gültigen Bereichs.; 22007.

OLE DB or ODBC error: Warning: Null value is eliminated by an aggregate or other SET operation.; 01003; The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.; 22007.

This error occurs when your language != English

You should check the method daysDelayed in the ProductionTableExtended View:
It should not use the date2StgrUsr() method!

str todayDate = SysComputedColumn::comparisonLiteral(date2StrUsr(today(), DateFlags::None));
str todayDate = SysComputedColumn::comparisonLiteral(date2str(today(), 321,
DateDay::Digits2,
DateSeparator::Hyphen, DateMonth::Digits2,
DateSeparator::Hyphen, DateYear::Digits4,
DateFlags::None));

Check - KB 2859489 - Cannot process the Production cube

If that does not help replace Hyphen with None

str todayDate = SysComputedColumn::comparisonLiteral(date2str(today(), 321,
DateDay::Digits2, DateSeparator::None, DateMonth::Digits2,
DateSeparator::None, DateYear::Digits4,
DateFlags::None));

Check your Business Connector Configuration

Lately I had the following error in the eventlog of the SSRS Server. After several checks I found out that this missleading error message was produced by a business connector call to an AX environment that was no longer up and running.
After changing the business connector configuration everything is working fine again.

Message:

Protokollname: Application

Quelle:        Microsoft Dynamics AX Enterprise Portal

Datum:         24.12.2014 14:48:45

Ereignis-ID:   1000

Aufgabenkategorie:Keine

Ebene:         Fehler

Schlüsselwörter:Klassisch

Benutzer:      Nicht zutreffend

Computer:      abc.defg

Beschreibung:

Beim Anmelden am Server durch Benutzer abc.defg\ABCDEFG ist ein Fehler aufgetreten, als der Dynamics-Adapter LogonAs von Prozess 'ReportingServicesService' und Threadkennung '26' verwendet wurde.

The server is unavailable. Microsoft Dynamics will try to connect to other servers in your configuration.

Microsoft.Dynamics.AX.ManagedInterop.ServerUnavailableException

   bei Microsoft.Dynamics.AX.ManagedInterop.Session.LogonAs(String user, String domain, NetworkCredential bcProxyCredentials, String company, String language, String objectServer, String configuration, String tenant)

   bei Microsoft.Dynamics.Framework.BusinessConnector.Session.DynamicsAdapter.LogonAs(String user, String domain, NetworkCredential bcProxyCredentials, String company, String language, String objectServer, String configuration, String partitionKey)

Install Enterprise Portal on SharePoint 2013 on AX 2012 R2 CU7

If you install Enterprise Portal on a SharePoint 2013 environment always follow the installation instructions on technet: http://technet.microsoft.com/de-de/library/dn169057.aspx

Install SharePoint 2013 and do not start the configuration. After that install the update for Microsoft SharePoint Foundation 2013 (KB2768000) When the update is installed start the configuration.

In the real world it often occurs that SharePoint is already installed and maybe also updated. There you should check if you need to install the update KB2768000.
If it is installed you can directly jump to the AX installation and select EP. If not run the KB Setup.

When the prerequisite check fails with the error "update SharePoint 2013" close the AX installation and run the SharePoint Products Configuration Wizard (Start -> All Programs -> Microsoft SharePoint 2013 Products -> SharePoint 2013 Products Configuration Wizard)
The Wizard will tell you that it processes an upgrade.

After that the prerequisite check should run through.