OGG-00551 OGG Extract On MS SQL Server Abended While Executing Query In SQLEXEC. (Doc ID 2254904.1)

Last updated on JULY 16, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.3 to 12.2.0.1.0 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Using GG version 12.1.2.1.3, running on windows 2008 R2, extract fails with the following error

ERROR OGG-00551 Database operation failed: SQLDescribeParam Statement: (lookup3), param (1). ODBC error: SQLSTATE S1002 native database error 0. [Microsoft][ODBC SQL Server Driver]Unable to derive parameter information when parameter marker is a function argumen[Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index.

when using

SQLEXEC (
ID lookup3,
QUERY
"
SELECT
  TR.Pending_Item_Num,
  TaxLot_Id= stuff ((SELECT '; ' + cast(TT.Trade_Taxlot_Sequence_Num as varchar)
  FROM dbo.TRADE_TAXLOT TT
  WHERE TT.Pending_Item_Num = TR.Pending_Item_Num
  FOR XML PATH('')), 1, 1, '') ,
  Related_TaxLot_Num = stuff ((SELECT '; ' + cast(TT.Taxlot_Record_Num as varchar)
  FROM dbo.TRADE_TAXLOT TT
  WHERE TT.Pending_Item_Num = TR.Pending_Item_Num
  FOR XML PATH('')), 1, 1, '')
  FROM dbo.TRADE TR
  WHERE Pending_Item_Num = ?
",
PARAMS (p1 = Pending_Item_Num )
),

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms