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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy