Issue:
We were experiencing this problem with a specific number of items. Whenever a purchase receipt was posted for any one of these specific items, the posting would hang at 100%. Upon investigation, it looked as though all posting actually completed in the tables, but the original work document was failing to delete from the work tables.
No error message was being returned to screen
We enabled the DEXSQL Log, and saw this error coming up
[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'MOP1041'.*/
Also, when we switched the posting to transaction level posting, and attempted to post, we got the error message
A Get Change operation failed on POP Line Hist
Solution:
Create the MOP1041 object
/****** Object: Table [dbo].[MOP1041] Script Date: 7/26/2017 2:25:58 PM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[MOP1041](
[MANUFACTUREORDER_I] [char](31) NOT NULL,
[MOPDOCNUM] [char](31) NOT NULL,
[CALLEDBY] [smallint] NOT NULL,
[TO_SITE_I] [char](11) NOT NULL,
[BIN] [char](15) NOT NULL,
[SEQNUMBR] [int] NOT NULL,
[ITEMNMBR] [char](31) NOT NULL,
[IVDOCNBR] [char](17) NOT NULL,
[QUANTITY] [numeric](19, 5) NOT NULL,
[DEX_ROW_ID] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PKMOP1041] PRIMARY KEY CLUSTERED
(
[MANUFACTUREORDER_I] ASC,
[MOPDOCNUM] ASC,
[CALLEDBY] ASC,
[SEQNUMBR] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
No comments:
Post a Comment