errors SELECT dbo.InventUpdateOnHandSqlTransactionHashing() shows up during PO confirmation

-

 

Hi All,

 

 facing the below error message during the confirmation of purchase order. So, if you are facing the same issue in your dev machine below is the fix which needs to be perform.

 

PROBLEM :- errors SELECT dbo.InventUpdateOnHandSqlTransactionHashing().

 



 

SOLUTION:-  A new SQL function is introduced InventUpdateOnHandSqlTransactionHashing to improve the performance.  However, this SQL function will be added during post actions of database synchronization. 

 

The issue should only happen in dev box. And as a quick fix, please run below script in command window( Run as Admin) with proper parameter value updated:

 

K:\AOSService\PackagesLocalDirectory\bin\Microsoft.Dynamics.AX.Deployment.Setup.exe -bindir "K:\aosservice\packageslocaldirectory" -metadatadir "K:\aosservice\packageslocaldirectory" -setupmode sync -sqlserver "wg-dev-4" -sqldatabase "AxDB" -sqluser axdbadmin -sqlpwd xxxxxxx> DbSync.log 2> DbSync.err


Example command :- K:\AOSService\PackagesLocalDirectory\bin\Microsoft.Dynamics.AX.Deployment.Setup.exe -bindir "K:\aosservice\packageslocaldirectory" -metadatadir "K:\aosservice\packageslocaldirectory" -setupmode sync -sqlserver "wg-dev-4" -sqldatabase "AxDB" -sqluser axdbadmin -sxxxx> DbSync.log 2> DbSync.err

 

It will take a time to complete the execution process, but once finished put the complete model build n sync to resolve error.

Comments

Post a Comment

Popular posts from this blog

Customization on Sales invoice Report in D365 F&O

-
 We have a requirement to create a new design and show some new fields in the sales invoice report.  So for that we need to consider the below steps :-  1) Controller class than extends standard class and create alogic. 2) Create a print management class to call the new design. 3) Extension of DP class to write a logic. 4) Report design. ==================================================================== 1) Controller class : -  /// <summary> /// Extension of the controller class to call the custom design of report "MMSSalesInvoice.report" for MMS legal entity. /// </summary> class MMSSalesInvoiceController extends SalesInvoiceController {        public static MMSSalesInvoiceController construct()         {             return new MMSSalesInvoiceController();         }         public static void main(Args _args)         { ...
Read more

75) COC - Create a coc of the table modified method

-
 /// <summary> /// The <c>AvaEntAssetChecklistVariableOptionsDbt_Extension</c> contains the TransMountain extending logic for the <c>EntAssetChecklistVariableOptions</c> table. /// </summary> [ExtensionOf(tableStr(EntAssetChecklistVariableOptions))] final class AvaEntAssetChecklistVariableOptionsDbt_Extension {     /// <summary>     /// Processes the modified field event for TransMountain fields.     /// </summary>     /// <param name = "_fieldId">reference to field id</param>     public void modifiedField(FieldId _fieldId)     {         EntAssetChecklistVariableOptions entAssetChecklistVariableOptions;         next modifiedField(_fieldId);         // Default must be marked for only one check list line for the varaible.         if (_fieldId == fieldNum(EntAssetChecklistVariableOptions,...
Read more

46) D365 FO: SHAREPOINT FILE UPLOAD USING X++

-
Image
Requirement : Uploading a file in Sharepoint online using X++ and inside from Microsoft Dynamics 365 finance and operations. Prerequisites: The current user id of Microsoft Dynamics 365 Finance and operations should have proper rights and privileged in Sharepoint Online. Sample Code: In this scenario i am creating a text file in Microsoft Dynamics 365 finance and operations and then uploading its memory Stream in Sharepoint online using X++ . You can modify the X++ code in D365 finance and operations as per your need. class RunnableClassRun { /// /// Runs the class with the specified arguments. /// /// The specified arguments. public static void main(Args _args) { System.UriBuilder builder = new System.UriBuilder(“ https://XXXXXX.sharepoint.com&#8221 ;); str extId = xUserInfo::getExternalId(); Microsoft.Dynamics.AX.Framework.FileManagement.SharePointDocumentStorageProvider provider; Microsoft.Dynamics.AX.Framework.FileManagement.DocumentLocation documentLocation ...
Read more