Query created via universe designer not working (WIS 10901)

Document ID : KB000033577
Last Modified Date : 14/02/2018
Show Technical Document Details

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.