SAP with Oracle 12C DB connect to SQL SERVER 2008 with oracle gateway 10. (Doc ID 2320954.1)

Last updated on MAY 11, 2022

Applies to:

Symptoms

Getting an ORA-28534: Heterogeneous Services preprocessing in the SAP log:

" *** ERROR => ORA-28534 occurred at SQL stmt (parse error offset=0)
[dbsloci.c 19335]
  Dump statement cache (after SQL error):
  sc_p=0000000003A2DCB0,no=208,idc_p=0000000000000000,con=0,act=1,slen=122,smax=256,#vars=3,stmt=00000000211380A0,table=INT_BLOCKS@
  INSERT INTO INT_BLOCKS@LINK ( "Int_PalletID", "Int_BlockStatus", "Int_CreationTimeStamp" ) VALUES \
  ( :A0 , :A1 , :A2 );
  statement for table 'INT_BLOCKS@LINK':
  INSERT INTO INT_BLOCKS@LINK ( "Int_PalletID", "Int_BlockStatus", "Int_CreationTimeStamp" ) VALUES ( :A0 , :A1 , :A2 )
  stmt_execute() -> orc=28534 (orc1=28534), rc=99=DBSL_ERR_DB
  Dump statement cache (rc=99=DBSL_ERR_DB):
  sc_p=0000000003A2DCB0,no=208,idc_p=0000000000000000,con=0,act=1,slen=122,smax=256,#vars=3,stmt=00000000211380A0,table=INT_BLOCKS@
  Dumping stmt. cache (DBSL private attributes)"

Changes

This occurred after upgrading the Oracle Gateway version to 12.1.  After this, the ORA-28534: Heterogeneous Services preprocessing error appeared in the SAP LOG.  The previous Oracle Gateway, version 10, did not have this issue.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.