DG4MSQL 11gR2 - ORA-28506: parse error in data dictionary translation for ALL_CATALOG stored in sys.hs_all_dd
Last updated on FEBRUARY 01, 2017
Applies to:Oracle Database Gateway for SQL Server - Version 184.108.40.206 and later
Information in this document applies to any platform.
Oracle database 220.127.116.11 on Windows server 2008, database gateway for MSSQL (dg4msql) 18.104.22.168 too.
SQL Server upgraded from 2005 to 2012.
Running the following query accessing SQL Server 2005 - works fine
select * from all_catalog@DBLINK - Getting 1256 rows.
Running the same query pointing to the new SQL Server 2012 sql server, getting the below error:
ORA-28506: parse error in data dictionary translation for ALL_CATALOG stored in sys.hs_all_dd
ORA-28559: FDS_CLASS_NAME is MSSQL22.214.171.124.0_0019, FDS_INST_NAME is tg4msqlr
ORA-00604: error occurred at recursive SQL level 1
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding 4 lines from DBLINK
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms