on 04-13-2010 6:45 AM
Hi,
I'm using BO XI R3.1 and database is sqlserver2005. When i try to use the outerjoin in universe it is throwing the error as mentioned below. I"ve also set the ANSI-92 parameter as Yes under universe parameters but still no luck.Could any one please advise.
Exception: DBD, [Microsoft OLE DB provider for SQL server]: The query uses non-Ansi outer join operators ("=" or "="). To run this query without modification, please set the compatibility level for current database to 80 or lower, using stored procedure sp_dbcmptlevel. It is strongly recommended to rewrite the query using ANSI outer join operators (LEFT OUTER JOIN, RIGHT OUTER JOIN). In the future version of SQL server, non-ANSI join operators will not be supported even in backward-compatibility modes.State: 42000
Thanks,
Eswar
I've tried changing the parameter ANSI 92 to yes in universe again and it worked now.
thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.