topic Re: SQL Server Error Message 20586 - (default destination) in Qlik Replicate

SQL Server Error Message 20586 - (default destination)

Orlandis — Wed, 20 Nov 2024 15:06:55 GMT

Hello.
When using transactional replication SQL Server, after running the Attynity task I see a message 20586 - (default destination) - in the SQL Server error log. I wanted to ask if this is a normal behavior or a problem ?
The code that causes this error message is as follows

if not exists
(
select a.name from sysarticles a,sysobjects o
where a.[objid]=o.[id]
and schema_name(o.[uid]) =N'dbo'
and object_name(a.[objid])=N'wbExternalUsers'
and a.[type] in(1,3,5,7)
and a.status & 1 = 1
)
begin
-- Adding the transactional articles
exec sp_addarticle
@publication = N'AR_PUBLICATION_00007', --Publication Name
@article = N'AR_ARTICLE_00007_1089438955', --Article Name
@Source_owner = N'dbo', --Owner
@Source_object = N'wbExternalUsers', --Table
@type = N'logbased',
@description = N'',
@creation_script = N'',
@pre_creation_cmd = N'drop',
/*@schema_option = 0x00000000000000F3,*/
@schema_option = 0x050D3,
@identityrangemanagementoption = N'none',
@destination_table = N'wbExternalUsers', --Table
@destination_owner = N'dbo', --Owner
@status = 16,
@vertical_partition = N'false',
@ins_cmd = N'CALL [sp_MSins_wbExternalUsers]', --Table
@del_cmd = N'CALL [sp_MSdel_wbExternalUsers]', --Table
@upd_cmd = N'MCALL [sp_MSupd_wbExternalUsers]',--Table
@filter_clause = N'(1=0)'
-- Adding the article filter
exec sp_articlefilter
@publication = N'AR_PUBLICATION_00007', --Publication Name
@article = N'AR_ARTICLE_00007_1089438955', --Article Name
@filter_name = N'AR_FILTER_00007_1089438955', --Filter name
@filter_clause = N'(1=0)',
@force_invalidate_snapshot = 1,
@force_reinit_subscription = 1
end

Re: SQL Server Error Message 20586 - (default destination)

OritA — Thu, 21 Nov 2024 08:40:25 GMT

Hi ,

When you see the error you mentioned, do you see it in the Replicate log? or in the MS SQL log? If the error is related to Replicate please open a case in the SalesForce and attach to the case the task diagnostic package & the logs with the error so we can further analyze it and get more details on the Replicate version you are running and the its settings.

If the error is in MS-SQL logs then please contact your MS-SQL DBA.

thanks & regards,

Orit

Re: SQL Server Error Message 20586 - (default destination)

Orlandis — Thu, 21 Nov 2024 10:41:56 GMT

Hello
I am getting this error in SQL Server Extended Events "error_reported" on behalf of the account that Attunity is running under. There are no errors on the Attunity side and everything is working correctly, there are also no errors in the SQL server transaction replication logs. I have no idea what this error is and how critical it is

Re: SQL Server Error Message 20586 - (default destination)

Dana_Baldwin — Fri, 22 Nov 2024 17:56:28 GMT

Hi @Orlandis

The error is logged with severity code 16 which is: Indicate errors that can be corrected by the user.

Database Engine error severities - SQL Server | Microsoft Learn

I have not found helpful information on the error on the internet, but did find this. Maybe there are more details that can be found in other SQL Server log files:

SQL Server Error : 20586, Severity: 16. (default destination) - SQL Server DBA

The error could be informational, but I do not know. You may need to contact Microsoft for further clarification.

Sorry I could not be of further help.

Regards,

Dana