SAP Knowledge Base Article - Public

1947043 - synonym not being found in SQL Server


Add synonyms to a report and it should work as expected when using the method reportClientDocument.getdatabaseController.addTable(ITable table, TableLinks relatedTableLinks).


  • Crystal Reports Server Embedded 2008 v1 SP 5 & SP 6
  • MS SQL Server.
  • Report Application Server SDK.

Reproducing the Issue

  • Create a system DSN for MSSQL server 2008 using SQL Server Native. Client 10.0 Driver.
  • Create a Crystal report on the created DSN using the ODBC (RDO).
  • Add one table to the crystal report from the crystal report designer and save the report to desktop.
  • Login to Microsoft SQL Server Management Studio with your SQL. Authentication credentials.
  • Create a synonym on the SQL Server on one of the tables.
  • Run the attached samples to add the created synonym to the report.
  • The sample throws the following exception. The table 'AdventureWorks.dbo.SynTest' could not be found...Error in File AddSynonymTest {0B4F0186-C385-44A8-ADEC-158A6D1A10B3}.rpt: The table could not be found.---- Error code:-2147482939 Error code name: failed.


The issue has been identified and logged under Problem Report ID ADAPT01709680.


This issue has been fixed with AURORA_4.0_SP09


Error code:-2147482939 , ADAPT01709680, synonyms , KBA , BI-DEV-JAV , BI Software Development Kits (SDKs) - Java , Problem


Crystal Reports Server 2008 V1, OEM edition ; SAP Crystal Reports 8.0