Wednesday, August 22, 2012

Synchronize Database Problem - Missing Field in SQL Table


During Syncronize process could happen that for certain Tables the System table SqlDictionary present all columns, but the relative SQL Table have some fields missing.

The problem occur with the Check\Synchronize Action. Seems that AX update correctly the system table SQLDictionary, but don't create the new fields in the SQL Tables.

Due to solve the problem, run the Synchronize Database Action from the SQL Administration form. This action first update the system table SQLDictionary and finally create the fields in SQL Table if missing.
Seems that the Check\Synchronize Action, if a field is present in the system table SQLDictionary don't check if the same is present in the SQL Table !

See also Troubleshooting AOT Synchronization Errors

Enjoy !


Tuesday, August 21, 2012

AX 2012 - WCF Service Configuration Editor

View and modify the AOS Configuration : AX 2012 - Service Configuration Editor

AX 2012 - The DefaultValue expression for the report parameter ‘AX_CompanyName’ contains an error

We run into issue that whenever we used a Microsoft Dynamics AX configuration file with a Reporting Services instance (as mentioned in here: the following error was reported the first time a report was run after the restart of the SQL Reporting Services instance:
"The DefaultValue expression for the report parameter ‘AX_CompanyName’ contains an error: Request for the permission of type 'System.Security.Permissions.EnvironmentPermission, mscorlib, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. (rsRuntimeErrorInExpression)"
Running the report for the second time, it renders without any error. The error is mostly seen with subsequent instances of Reporting Services because only then an Microsoft Dynamics AX configuration file (Microsoft.Dynamics.AX.ReportConfiguration.axc) is used but any Reporting Services instance that is set up to use an AX configuration file will throw this error.

The resolution we found was to use "FullTrust" permission set in place of "Execute" for the "Report_Expressions_Default_Permissions" in the rssrvpolicy.config but maybe there is some other solution that I was not aware of.

AX 2012 - SSRS Report issues page