19 February 2015

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:

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.

06 February 2015

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