SP_2018 .
asked on
Replication error
Hi,
I have a scheduled SQL ETL job which has a stored procedure ,but it keeps on failing due to below error.
Message
Executed as user: domain/user. Schema change failed on object '[dbo].[tablename]'. Possibly due to active snapshot or other schema change activity. [SQLSTATE 42000] (Error 21386). The step failed.
This table is also getting replicated(transactional replication) to our reporting server.
Please advise....
I have a scheduled SQL ETL job which has a stored procedure ,but it keeps on failing due to below error.
Message
Executed as user: domain/user. Schema change failed on object '[dbo].[tablename]'. Possibly due to active snapshot or other schema change activity. [SQLSTATE 42000] (Error 21386). The step failed.
This table is also getting replicated(transactional replication) to our reporting server.
Please advise....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
did you check my post?
btw: in what compatibility mode your replicated DB? 2000 or 2008?
btw: in what compatibility mode your replicated DB? 2000 or 2008?
ASKER
Compatibilty level is 100 both on publisher and subscriber end
ok - it is time to post the code\ changes are you doing to this table
as you should know --replicated tables have some limitations ..
as you should know --replicated tables have some limitations ..
Did you made any schema changes at the subscriber? the changes at subscriber could cause replication to fail.
ASKER
The ETL logic is in the form of a stored procedure which is scheduled to run every hour..