Tuesday, October 25, 2016

SQL Server trial license expired on your cloud boxes for AX7?

If you have made deployments before summer, you might have deployments where the SQL Server is installed with a trial license and it is set to expire november 1st. When it expires you are not able to start the SQL Server service anymore.

Here are the necessary steps to update SQL Server:

  • Obtain a valid installation media and license. 
  • Stop the "Hyper-V Time Synchronization Service" service.
  • Change the system date on the server, to a date before the trial expiry date.
  • Run SQL Server installation and choose "Upgrade from preview version"
  • Start the "Hyper-V Time Synchronization Service" service again.

The reason for changing the system date is that the upgrade won't run if it can't start the existing SQL Server service.

Wednesday, October 5, 2016

Why you can't find any delete actions for the DocuRef table in AX7

There aren't any...

In AX7 clean up of records in DocuRef is handled by a recurring batch job. The batch job is automatically created during AX initialization when you deploy a new solution. The batch job is listed as "Scan for orphaned document references" and it is scheduled to run every sixth hour.

I can't find the job between the batch jobs in the demo data though. But you can add it by calling the loadData method of the class DocumentManagementSetup.