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.

• 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. javax.servlet.ServletException:..com.crystaldecisions.sdk.occa.report.lib.ReportSDKServerException: 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