Jan122010

robocopy – retry timeout or how long are 30.000.000 seconds

robocopy = robust copy of files

but what happens, when the process can’t access a file??
robocopy will wait and try again….
and try again,
and try again

sorry, this is german……
the default value for the timeout is 30 seconds
the default value for the retrycount is 1 million times ( 1.000.000x )
30 seconds * 1.000.000 = 30.000.000 seconds
30.000.000 seconds / 60 = 500.000 minutes
500.000 minutes / 60 = 8.333,333333 hours
8.333,333333 / 24 = 347,222222 days ~ 0.951 years

so, the parameters /r and /w must be used !!!!!!!
(shit….. i saw this after my job started and runs since several hours……)

Dec292009

Identify installed hotfixes

How can you identify the installed hotfixes in Dynamics AX2009?

In earlier versions the published hotfixes have to be imported like any other XPO project file. So, the imported hotfixes can be found in the used layer and the changes can easily be found and located in the system.
But since version 2009 hotfixes can be “poked” into the standard layers (sys,syp,…),
so it’s hard to identify and locate them.
The first sign for imported hotfixes is the size of the layer-files.

Normally the offical hotfixes published by microsoft will insert a new method into the class SysHotfixManifest whose name is the same as the kb number of the installed hotfix

Dec052009

Extending Cubes for virtual companies

The first release of this white paper is from 24 March 2009 and now (3rd December) Microsoft published an update for it.
It’s a really important document for any Dynamics AX 2009 installations using virtual companies and SSAS cubes or their KPI’s.
Extending Default Cubes for Virtual Companies

Dec032009

Install Problem with SSRS 2005 SP3

Installing the Dynamics AX 2009 Reporting Extensions for SSRS 2005 SP3 and got an error message “works only with SSRS 2005 SP2″ !!!
This sounds like the error message you’ll get when installing the Reporting Extensions for SSRS 2008,
and Microsoft knows about this and published an workaround for SSRS 2008:

1. Locate the AX Reporting services dll from the extracted AX 2009 SP1 folder [\\AX2009SP1\support\axsetupresources\microsoft.dynamics.setup.reportingservices.dll;File Version - 5.0.1000.52]
2. Extract the AX 2009 .iso to a shared folder
3. Copy the microsoft.dynamics.setup.reportingservices.dll into the folder: \\DynamicsAX\Msi\Components32\Program Files\Microsoft Dynamics AX\50\Setup \\DynamicsAX\Msi\Components64\Program Files\Microsoft Dynamics AX\50\Setup
4. It will ask to replace the existing dll having File Version – 5.0.593.0. Say Yes and replace.

But this won’t work with SSRS 2005 SP3 !
What is the problem?
I don’t know exactly, but when creating/changeing the registry key with the version number for the reporting services
(the registry key, the Dynamics AX setup looks in)
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\Reporting Services
Reg_SZ:Version = “9.00.3042.00“
9.00.3042.00 == 2005 SP2
9.00.4035.00 == 2005 SP3
the setup for the Reporting Extension will run…..

Additional informations i found while searching a solution:
http://daxguy.blogspot.com
http://blog.ak-home.net

Nov262009

select vs. fieldselect vs. select fieldlist

I found an interesting blog entry Difference b/w SELECT AND FIELDSELECT in Dynamics AX by Santosh, describing the difference between a select and a fieldselect.
It’s an interesting posting; Dynamics AX builds the sql statement in context of the used table and the fields used in the where condition. Btw. here are some more informations explaining how Dynamics AX will build the statement.

writing an normal x++ select statement

results to the translated sql statement as mentioned in the blog entry: (all fields of the table are listed)

writing a fieldselect statement

Read More »