Hi,
We got below error in our prod environment when added 2 more tables and 1 view to replicate to another server in existing replication setup. We tested out that scenario in our staging and dev environment and no issue occurred.
We are not sure it's happened because of object schema or data issue. Please help advise how we can overcome below issue.
2021-11-13 10:46:30.094 Connecting to Subscriber 'ServerName'
2021-11-13 10:46:30.125 Initializing
2021-11-13 10:47:27.766 Skipping file 'ORC_MTL_ONHAND9ce349e7_148.pre' because it has already been delivered for a previous article or by a previously interrupted snapshot.
2021-11-13 10:47:27.766 Skipping file 'ORC_MTL_ONHANDa7c3e34f_116.pre' because it has already been delivered for a previous article or by a previously interrupted snapshot.
2021-11-13 10:47:27.781 Skipping file 'ORC_MTL_ONHANDc7c3e34f_115.pre' because it has already been delivered for a previous article or by a previously interrupted snapshot.
2021-11-13 10:47:27.828 Agent message code 1934. INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
2021-11-13 10:47:27.860 Category:COMMAND
Source: Failed Command
Number:
Message: create procedure [sp_MSins_dboORC_MTL_ONHAND_QUANTITIES_1]
@c1 numeric(15,0),
@c2 int,
@c3 int,
@c4 datetime2,
@c5 datetime2,
@c6 int,
@c7 datetime2,
@c8 int,
@c9 numeric(38,0),
@c10 nvarchar(10),
@c11 int,
@c12 int,
@c13 int,
@c14 datetime2,
@c15 int,
@c16 numeric(38,0),
@c17 numeric(38,0)
as
begin
insert into [dbo].[ORC_MTL_ONHAND_QUANTITIES_1] (
[MTL_ONHAND_QUANTITIES_KEY],
[INVENTORY_ITEM_ID],
[ORGANIZATI
2021-11-13 10:47:27.860 Category:NULL
Source: Microsoft SQL Server Native Client 11.0
Number: 1934
Message: INSERT failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.
Thanks & Best Regards,
Theingi
