Query created via universe designer not working (WIS 10901)

Article Id: 33577

Status: Published

Updated On: 14-02-2018 08:19

Legacy Id: TEC1956661

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