A user wishes to update the Item group for a released product.

They right-click on the Item group field and selects the Record Info menu item.

In the Record information form they click the Fill Utility button.

We get the following error:

Error executing code: Wrong argument types for comparison.

Stack trace

(C)\Forms\SysFillUtility\Methods\initializeMainQuery - line 61

(C)\Forms\SysFillUtility\Methods\init - line 53




What happened?
In this case, the error was caused by the fact that the primary field of the table (the table that the field belongs to that they wanted to change) is not of type string.


What did we do to resolve this?

1. First we found what the tableid was by doing some x++ debugging. Put a breakpoint, for example on method at the top of the stack in line 61. When the code stops, after closing the stack trace window, in this method you can find there a variable called tableid. Note the value.

2 Several methods can be used to then convert the tableid to a table name, see for more information on how to use tablename2id x++ function.

3 In the AOT, we located our table

4. and found the PrimaryIndex property

5. In our case the value of this property was set to SurrogateKey and that means RecId.

6. So In general, to fix this, we found what the field type is and added a line to the ‘InitializeMainQuery’ method of the SysFillUtillity form.

To fix our error, the following if clause was added in Forms\ SysFillUtillity\ InitializeMainQuery:

else if (mainTablePrimaryField)
if (!queryBuildRange)






Other related articles:

1. Solving Fill Utility errors on Microsoft Dynamics AX 2012 - SysDictFieldGroup object not initialized

2. Solving Fill Utility errors on Microsoft Dynamics AX 2012 - Fill Utility incorrectly updates a field that is not in the field list of the main datasource

4. Solving Fill Utility errors on Microsoft Dynamics AX 2012 - Error executing code: Wrong argument types for comparison (another scenario)


--author: Erco van Harn
--reviewer: Mansour Yahya Mohamad Mansour