Dynamics 365 Dairy

Resolving “Exclusive Access Could Not Be Obtained” Error in SQL Server Resolving the “Exclusive Access Could Not Be Obtained” Error in SQL Server When attempting to restore a database in Microsoft SQL Server Management Studio (SSMS), you might encounter this error: Exclusive access could not be obtained because the database is in use. Full error message: Restore of database 'AxDB' failed. Microsoft.Data.SqlClient.SqlError: Exclusive access could not be obtained because the database is in use. This occurs when the database is still being accessed by other sessions, preventing the restore operation. Below are several effective approaches to fix the issue. 1️⃣ Close Existing Connections in SSMS You can close existing database connections directly from SSMS: Open the Restore Database window. Go to the Options tab. Check: Close existing connections to destination database ...

 If you're working with Microsoft Dynamics 365 for Finance and Operations (D365 F&O) and encounter the dreaded error “Can’t stop DynamicsAxBatch” while using the Admin User Provisioning Tool , you're not alone. This guide walks you through a quick and effective solution to resolve the issue and get back to work without delays. 🛠️ What Is the Admin User Provisioning Tool? The Admin User Provisioning Tool is used to register a user as an administrator on a D365 F&O instance—typically for development and customization purposes. You provide your Azure AD credentials (email address) to gain admin access. ❌ The Problem: “Can’t Stop DynamicsAxBatch” Error While registering via the Admin Provisioning Tool or attempting to stop the service manually through Windows Services , you might encounter an error stating: “Can’t stop DynamicsAxBatch” This error prevents you from proceeding with the registration process.  The Solution: Step-by-Step Fix  Step 1: Try Stoppi...

Why This Happens:   The “Not Secure” message appears because the site certificate doesn’t meet the latest security standards. Chrome, unlike Internet Explorer, treats it as invalid. From Chrome 58 onwards, only the   subjectAlternativeName   extension is used to match the domain name and site certificate, not the   commonName . A registry fix was available but only worked up to version 65. More details can be found here. How to Fix It:   You need to issue a new self-signed certificate for  *.cloud.onebox.dynamics.com  and update the website binding settings to use it. Step 1: Create a New Self-Signed Certificate  Run the following PowerShell command as an administrator: New-SelfSignedCertificate -Subject "CN=*.cloud.onebox.dynamics.com,O=Microsoft Corporation,L=Redmond,S=WA,C=US" -DnsName "*.cloud.onebox.dynamics.com", "usnconeboxax1ecom.cloud.onebox.dynamics.com", "usnconeboxax1pos.cloud.onebox.dynamics.com", "usnconeboxax1ret.cloud.onebox....

  BatchHeader batchHeader         = this.getCurrentBatchHeader();         int         timeUnitsSelected   = 0;         if(this.isExecutingInBatch())         {             RefRecId batchRecId = batchHeader.parmBatchHeaderId();             BatchJob batchJob;             select firstonly batchJob             where batchJob.RecId == batchRecId;                      SysRecurrenceData recurrenceData = batchjob.recurrenceData;             SysRecurrenceUnit timeUnits = conPeek(recurrenceData, 7);             timeUnitsSelected = timeUnits;         }

Primary key A primary key is one type of key. The other type of key is an alternate key. There is a maximum of one primary key per table , whereas a table can have several alternate keys . The primary key is usually the type of key that other tables, called child tables, refer to when a foreign key field in those other tables need a relational identifier. Starting in Microsoft Dynamics AX 2012 the primary key for every new table is always enforced by an index that has exactly one field. The one field is usually an incremented number or a completely meaningless number that is generated by the system. For new tables the default is a primary key based on the RecId field. This is represented as the surrogate key in the user interface. The following table describes the  PrimaryIndex   property and other major properties that are related to keys. Property Description PrimaryIndex The drop-down list contains the surrogate key plus every index on the table that has its  Alternate...

The research, reread, and refresh methods are used to update the data displayed in a form in D365FO. Research reruns the existing form query against the database, therefore updating the list with new/removed records as well as updating all existing rows. Reread queries the database and re-reads the current record contents into the datasource form cache. This does not update the form controls, so you need to call refresh() after reread() to update the form controls. Refresh refreshes the data displayed in the form controls with whatever is stored in the form cache for that particular datasource record. Here is a table that summarizes the differences between these methods: Method Description Research Reruns the existing form query against the database, updating the list with new/removed records as well as updating all existing rows. Reread Queries the database and re-reads the current record contents into the datasource form cache. Does not update the form controls. Refresh Refre...