Exception DBD...Statement(s) could not be prepared

[Former Member]

I have a universe designed from one SQL Server 2005 server, and a universe from a seperate SQL 2005 server. Both universes work fine on their own, one is my main Analytics universe and the other is a geographic table that links to the analytics universe (theoretically) on zipcode.

When I imported the Geo universe in and made the joins, I get that exception and when I do an integrity check in fails on all the Geo tables.

Any suggestions? I'm very "green" to this product. I was unable to find anything via search so I'll appreciate replies in the form of a link to a good thread. I'm using Edge BO XI 3.1, fresh install.

[Former Member · Accepted solution]

Hi,

If you have outer joins specified in the universe them goto prm files of SQL SErver and check it there whether those outer joins option is enabled or not. Path for prm file of sql server is ../program files/ bo /bo version/win32_x86/dataaccess/..

Cheers,

Suresh A.