Well, I tried to attach the log file but I guess it didn't go. So here it is
as a paste.
2008-02-13 00:15:04.071 Microsoft SQL Server Replication Queue Reader Agent
9.00.3042.00
2008-02-13 00:15:04.071 Copyright (c) 2005 Microsoft Corporation
2008-02-13 00:15:04.071 Microsoft SQL Server Replication Agent: qrdrsvc
2008-02-13 00:15:04.071
2008-02-13 00:15:04.071 The timestamps prepended to the output lines are
expressed in terms of UTC time.
2008-02-13 00:15:04.071 User-specified agent parameter values:
-Distributor JGPIOLA\CREATIVESOLUTION
-DistributionDB distribution
-DistributorSecurityMode 1
-Continuous
-Output C:\Temp\OUTPUTFILE.txt
-Outputverboselevel 2
-XJOBID 0x47D1B9F8C4BDE9448971506E0BBAF684
-XJOBNAME [JGPIOLA\CREATIVESOLUTION].6
-XSTEPID 2
-XSUBSYSTEM QueueReader
-XSERVER JGPIOLA\CREATIVESOLUTION
-XCMDLINE 0
-XCancelEventHandle 00000430
-XParentProcessHandle 00000428
2008-02-13 00:15:04.071 Connecting to OLE DB QueueReader at datasource:
'JGPIOLA\CREATIVESOLUTION', location: '', catalog: 'distribution',
providerstring: '' using provider 'SQLNCLI'
2008-02-13 00:15:04.180 OLE DB QueueReader: JGPIOLA\CREATIVESOLUTION
DBMS: Microsoft SQL Server
Version: 09.00.3054
catalog name: distribution
user name: dbo
API conformance: 0
SQL conformance: 0
transaction capable: 1
read only: F
identifier quote char: "
non_nullable_columns: 0
owner usage: 15
max table name len: 128
max column name len: 128
need long data len:
max columns in table: 1000
max columns in index: 16
max char literal len: 131072
max statement len: 131072
max row size: 131072
2008-02-13 00:15:04.180 OLE DB QueueReader: JGPIOLA\CREATIVESOLUTION
DBMS: Microsoft SQL Server
Version: 09.00.3054
catalog name: distribution
user name: dbo
API conformance: 0
SQL conformance: 0
transaction capable: 1
read only: F
identifier quote char: "
non_nullable_columns: 0
owner usage: 15
max table name len: 128
max column name len: 128
need long data len:
max columns in table: 1000
max columns in index: 16
max char literal len: 131072
max statement len: 131072
max row size: 131072
2008-02-13 00:15:04.180 OLE DB QueueReader 'JGPIOLA\CREATIVESOLUTION': {call
sp_MSensure_single_instance('Queue Reader Main (distribution)', 9)}
2008-02-13 00:15:04.180 OLE DB QueueReader 'JGPIOLA\CREATIVESOLUTION':
select top 1 id, name from dbo.MSqreader_agents
2008-02-13 00:15:04.180 OLE DB QueueReader 'JGPIOLA\CREATIVESOLUTION':
select SERVERPROPERTY('IsClustered')
2008-02-13 00:15:04.180 Queue Reader Agent [JGPIOLA\CREATIVESOLUTION].6 (Id
= 1) started
2008-02-13 00:15:04.180 OLE DB QueueReader 'JGPIOLA\CREATIVESOLUTION':
execute dbo.sp_MShelp_profile 1, 9, N''
2008-02-13 00:15:04.180 Parameter values obtained from agent profile:
-historyverboselevel 1
-logintimeout 15
-pollinginterval 5000
-querytimeout 1800
2008-02-13 00:15:04.180 OLE DB QueueReader 'JGPIOLA\CREATIVESOLUTION': exec
sp_MSenum_replsqlqueues N'distribution'
2008-02-13 00:15:04.196 OLE DB QueueReader 'JGPIOLA\CREATIVESOLUTION': exec
sys.sp_MShelp_repl_agent N'JGPIOLA\CREATIVESOLUTION', N'CSP_0_Sample',
N'CSP_0_Sample', N'JGPSERVER\CREATIVESOLUTION', N'CSP_0_Sample', 3
2008-02-13 00:15:04.212 Connecting to OLE DB JGPSERVER\CREATIVESOLUTION at
datasource: 'JGPSERVER\CREATIVESOLUTION', location: '', catalog:
'CSP_0_Sample', providerstring: '' using provider 'SQLNCLI'
2008-02-13 00:15:04.633 OLE DB JGPSERVER\CREATIVESOLUTION:
JGPSERVER\CREATIVESOLUTION
DBMS: Microsoft SQL Server
Version: 09.00.3054
catalog name: CSP_0_Sample
user name: JGPPA\repl_user
API conformance: 0
SQL conformance: 0
transaction capable: 1
read only: F
identifier quote char: "
non_nullable_columns: 0
owner usage: 15
max table name len: 128
max column name len: 128
need long data len:
max columns in table: 1000
max columns in index: 16
max char literal len: 131072
max statement len: 131072
max row size: 131072
2008-02-13 00:15:04.633 OLE DB JGPSERVER\CREATIVESOLUTION:
JGPSERVER\CREATIVESOLUTION
DBMS: Microsoft SQL Server
Version: 09.00.3054
catalog name: CSP_0_Sample
user name: JGPPA\repl_user
API conformance: 0
SQL conformance: 0
transaction capable: 1
read only: F
identifier quote char: "
non_nullable_columns: 0
owner usage: 15
max table name len: 128
max column name len: 128
need long data len:
max columns in table: 1000
max columns in index: 16
max char literal len: 131072
max statement len: 131072
max row size: 131072
2008-02-13 00:15:04.633 Connecting to OLE DB JGPSERVER\CREATIVESOLUTION at
datasource: 'JGPSERVER\CREATIVESOLUTION', location: '', catalog:
'CSP_0_Sample', providerstring: '' using provider 'SQLNCLI'
2008-02-13 00:15:04.946 OLE DB JGPSERVER\CREATIVESOLUTION:
JGPSERVER\CREATIVESOLUTION
DBMS: Microsoft SQL Server
Version: 09.00.3054
catalog name: CSP_0_Sample
user name: JGPPA\repl_user
API conformance: 0
SQL conformance: 0
transaction capable: 1
read only: F
identifier quote char: "
non_nullable_columns: 0
owner usage: 15
max table name len: 128
max column name len: 128
need long data len:
max columns in table: 1000
max columns in index: 16
max char literal len: 131072
max statement len: 131072
max row size: 131072
2008-02-13 00:15:04.946 OLE DB JGPSERVER\CREATIVESOLUTION:
JGPSERVER\CREATIVESOLUTION
DBMS: Microsoft SQL Server
Version: 09.00.3054
catalog name: CSP_0_Sample
user name: JGPPA\repl_user
API conformance: 0
SQL conformance: 0
transaction capable: 1
read only: F
identifier quote char: "
non_nullable_columns: 0
owner usage: 15
max table name len: 128
max column name len: 128
need long data len:
max columns in table: 1000
max columns in index: 16
max char literal len: 131072
max statement len: 131072
max row size: 131072
2008-02-13 00:15:04.946 OLE DB JGPSERVER\CREATIVESOLUTION
'JGPSERVER\CREATIVESOLUTION': {? = call sp_getsqlqueueversion (?, ?, ?, ?)}
2008-02-13 00:15:05.008 OLE DB JGPSERVER\CREATIVESOLUTION
'JGPSERVER\CREATIVESOLUTION': {? = call sp_replsqlqgetrows
(N'JGPIOLA\CREATIVESOLUTION', N'CSP_0_Sample', N'CSP_0_Sample')}
2008-02-13 00:15:06.602 OLE DB QueueReader 'JGPIOLA\CREATIVESOLUTION': exec
sp_helpdistpublisher @publisher = N'JGPIOLA\CREATIVESOLUTION'
2008-02-13 00:15:06.602 Connecting to OLE DB JGPIOLA\CREATIVESOLUTION at
datasource: 'JGPIOLA\CREATIVESOLUTION', location: '', catalog:
'CSP_0_Sample', providerstring: '' using provider 'SQLNCLI'
2008-02-13 00:15:06.602 OLE DB JGPIOLA\CREATIVESOLUTION:
JGPIOLA\CREATIVESOLUTION
DBMS: Microsoft SQL Server
Version: 09.00.3054
catalog name: CSP_0_Sample
user name: dbo
API conformance: 0
SQL conformance: 0
transaction capable: 1
read only: F
identifier quote char: "
non_nullable_columns: 0
owner usage: 15
max table name len: 128
max column name len: 128
need long data len:
max columns in table: 1000
max columns in index: 16
max char literal len: 131072
max statement len: 131072
max row size: 131072
2008-02-13 00:15:06.602 OLE DB JGPIOLA\CREATIVESOLUTION
'JGPIOLA\CREATIVESOLUTION': set arithabort on set numeric_roundabort off set
concat_null_yields_null on set quoted_identifier on set ansi_nulls on set
ansi_padding on set ansi_warnings on
2008-02-13 00:15:06.602 OLE DB JGPIOLA\CREATIVESOLUTION
'JGPIOLA\CREATIVESOLUTION': select pubid, conflict_policy from
dbo.syspublications where name = N'CSP_0_Sample'
2008-02-13 00:15:06.602 OLE DB JGPIOLA\CREATIVESOLUTION
'JGPIOLA\CREATIVESOLUTION': {? = call sp_getqueuedarticlesynctraninfo
(N'CSP_0_Sample', 297)}
2008-02-13 00:15:06.602 SQL Command : <exec
[dbo].[sp_MSsync_ins_User_Session_Pattern_1] N'JGPSERVER\CREATIVESOLUTION',
N'CSP_0_Sample', '29A4C46D-7A7A-47C5-BF57-C59D227D3E20', '2008-02-12
02:28:26.747000000', N'ADMIN', N'JGPSERVER',
N'11111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111',
N'Practice CS', N'CreativeSolutions.Common.Schema.Online, Version=2.1.3.25,
Culture=neutral, PublicKeyToken=7384cb34d6e92705', N'administrator',
'D1B2BD42-676E-4D48-A408-23B5911EB970', 1>
2008-02-13 00:15:06.602 The Queue Reader Agent has encountered the error
'Explicit value must be specified for identity column in table
'Last_Table_Modification' either when IDENTITY_INSERT is set to ON or when a
replication user is inserting into a NOT FOR REPLICATION identity column.'
when connecting to 'CSP_0_Sample' on 'JGPIOLA\CREATIVESOLUTION'. Ensure that
the publication and subscription are defined properly and that both servers
are running.
2008-02-13 00:15:06.618 Failed while applying queued message to publisher
2008-02-13 00:15:06.618 Worker Thread 1368 : Task Failed
2008-02-13 00:15:06.618 Disconnecting from OLE DB JGPSERVER\CREATIVESOLUTION
'JGPSERVER\CREATIVESOLUTION'
2008-02-13 00:15:06.618 Disconnecting from OLE DB JGPSERVER\CREATIVESOLUTION
'JGPSERVER\CREATIVESOLUTION'
2008-02-13 00:15:06.618 Disconnecting from OLE DB JGPIOLA\CREATIVESOLUTION
'JGPIOLA\CREATIVESOLUTION'
2008-02-13 00:15:06.618 Queue Reader aborting
Post by Hilary CotterEdwin, I have got this working using both push and pull subscriptions.
This is on SQL 2005 Standard Edition, SP2 running on XP SP2.
I don't have any issues.
Can you enable logging as per this kb article and post the log back
here?
http://support.microsoft.com/kb/312292
TIA
Hilary
Post by Edwin SmithWell Apparently the two errors below were unrelated since I managed to fix
one of them by double checking my security settings.
However it still doesn't work and I still have this error in the replication
Failed while applying queued message to publisher (Source: MSSQL_REPL, Error
number: MSSQL_REPL36046)
I'm apparently the only person in the (SQL) universe who has ever seen this
error since a Google search only returns my previous post and Microsoft has
nothing.
Has anyone on this forum ever gotten Subscriber-Updateable Transactional
Replication to work? If so please let me know how to do it. I cannot use
Merge replication because the application would need to be changed to
support it.
PLEASE HELP!
Edwin
Post by Edwin SmithWell I have this working one way now but I still can't get updates from
the subscriber to work.
I started out with immediate updating but that setting would not let me
login to my application, probably because the login process needed to
update the database which was failing. The application was reporting a
password error but this is a sample database and no password is required.
The password issue is most likely due to a general exception handler
catching all SQL errors and is a red herring.
I switched the Subscriber to Queued updating mode and this let my
application run but the updates still don't work.
Failed while applying queued message to publisher (Source: MSSQL_REPL,
Error number: MSSQL_REPL36046)
02/11/2008 13:33:10,spid62,Unknown,Replication-Replication Transaction
Queue Reader Subsystem: agent [JGPIOLA\CREATIVESOLUTION].6 failed. Queue
Reader aborting
02/11/2008 13:33:10,spid62,Unknown,Error: 14151<c/> Severity: 18<c/>
State: 1.
Hopefully this will be the last problem.
Thank you.
Edwin- Hide quoted text -
- Show quoted text -