Database Error in LP Movement in Mobile Device

on
Hi,

Issue: Database Error in LP Movement in Mobile Device


Findings: User wants to move stock from Location One to another new Location  via LP Movement in Mobile Device.


ERROR:


Cannot delete a record in Interunit account entry total (LedgerTmpInterunitBalancerTotal).
The SQL database has issued an error.
Object Server Azure:
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name
'DBO.t16234_CFD80B0F900B43B0B2938BA92F01EEBB'.
DELETE FROM "DBO".t16234_CFD80B0F900B43B0B2938BA92F01EEBB WHERE (PARTITION=5637144576)
session 1014 (SKannadasan)

SOLUTION: PRODUCTION ISSUE RESOLVED AFTER RUNNING DATABASE CONSISTENCY CHECK IN SYSTEM ADMINISTRATION AND WITH FIX OPTION WITH ALL MODULE WHICH RUN FOR 7 HOURS CONTINUOUSLY 



https://community.dynamics.com/365/financeandoperations/f/765/p/307952/891276#891276



Comments

Post a Comment