September 6, 2013 at 6:37 am
Hi All,
I have configured transactional replication between a SQL2008R2 (SP2) instance to an Oracle 11g subscriber and am receiving the following error (in pre production):
Command attempted:
SELECT * FROM sp_MSins_TABLE_NAME WHERE 0 = 1
(Transaction sequence number: 0x000007A700006DE9004700000000, Command ID: 1)
Error messages:
ORA-04044: procedure, function, package, or type is not allowed here (Source: MSSQL_REPL_ORACLE, Error number: 4044)
Get help: http://help/4044%5B/i%5D
This is the command that is trying to replicate (found using sp_browsereplcmds on the distributor)
{CALL [sp_MSins_TABLE_NAME] (29927,'xxx','A','123456789',NULL,'A ',100,2013-09-06 11:16:00.000,10,NULL)}
Our Oracle guys think that the issue could be with the date as it's not passed in quotes - however when I check sp_browsereplcmds in our LIVE environment there are no quotes either.
Does anyone have any ideas on what I could check next? The posts I've found through Google aren't much help...
Cheers,
Chris
September 9, 2013 at 7:32 am
FIXED:
My sp_addarticle command was missing the @status parameter (with a value of 0).
I don't fully understand why a value of zero made this work though as BOL state that "A value of 0 means that the article is inactive and no additional properties are defined"
http://technet.microsoft.com/en-us/library/ms173857(v=sql.105).aspx
However, it's fixed. I'm now slightly wiser ... and with less hair!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply