Query created via universe designer not working (WIS 10901)

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• KNOWLEDGE TOOLS
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

PROBLEM:

- create a derived universe to set relation ship between tables
- Set an external join between two tables, we have Systematically an error msg :
[DataDirect][ODBC OpenAccess SDK driver][OpenAccess SDK SQL Engine]syntax error, unexpected LBRACE at name ... {. (WIS 10901)

          
SOLUTION:

We have to set ansi92:
1. Import the Universe in the Universe Designer Wizard.
2. Click on 'File' -> 'Parameters' and set the parameter 'ANSI92' to Yes.
3. Save and export the Universe.
4. Restart the CABI Services.
5. And check for the issue.

Environment

Release:
Component: SDBOXI