Your Ad Here

Friday, September 26, 2014

Universe Errors



Open Session: Unexpected error

Issue: Start getting error “Open Session: Unexpected error” at universe designer login

Version: BI 4.1 sp2

Solution: find lsi files and delete them or copy it to another folder.

Location for lsi files are

Old : %Documents and Settings\\Application Data\Business Objects\Business Objects 12.0\lsi

New: %User\\AppData\Roaming\SAP BusinessObjects\ SAP BusinessObjects Enterprise XI 4.0\lsi

Note: if Appdata is not visible then goto Organize menu -> Folder and Search Option -> View

And select “Show hidden files, folders and drives”


Universe Connection Errors

Got following error while creating an connection for new Business Objects Universe in 4.1 SP2

DBD: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

Note: After research found that it is nothing to do with Business Objects version but it’s because of 64 bit and 32 bit ODBC.

Solution: This worked for me

You might be seeing only 64 bit ODBC connection window through control panel, so go to following directory

C:\Windows\SysWOW64

And run odbcad32.exe and add same system DSN there. This will fix the issue. For more details go to following link

http://msdn.microsoft.com/en-us/library/ms712362(v=vs.85).aspx

You are not authorized to use this document. (FRM 00008)

Issue : Universe got deleted from CMS or you have some old universe and trying to open it again. It gives above error.

Solution:

1.       Create a new Universe.
2.       In Universe Parameters window -> go to Links tab -> click on Add links
3.       Now select Universe and hit open
4.       Once you see universe name in links tab.
5.       Click on Include button. (name will go away)
6.       Now click ok and you can see universe schema (old universe is imported in new universe).

Great tip : Thanks to Dominic Cotton (http://scn.sap.com/thread/1112182)