Error opening Universe in Web Intelligence

[Former Member]

Hi,

I'm running into an error any time I try to open a Universe built on top of Sybase IQ from Web Intelligence.  After selecting the Universe and clicking "Select" I get the following error:

while trying to invoke the method com.businessobjects.mds.datafoundation.SQLDataSource.getConnection() of an object loaded from local variable 'sqlDataSource' (WIS 00000)

Anybody ever run into this before and successfully resolved it?

[Former Member · Accepted solution]

I resolved this issue:

It turns out that apparently BOBJ does not like it when your ODBC Data Source names have spaces in them.  As soon as I changed my ODBC data source name (both 32 bit and 64 bit) from ‘IQ Trans – Demo Space’ to ‘IQTransDemoSpace’ everything worked!

[Sujit · Accepted solution]

Also, I believe the ODBC connection needs to be defined as System DSN on the server side, it may not work if you have it as User DSN on the server.

Sujit Honrao

[Former Member]

I should add, I am able to create Explorer Information Spaces off of the same Universe with no problem.

[Former Member]

Verify the connection in the Data foundation layer. Make sure you export the connection and the business layer with the connection properly. And then retry.

Thank,

Karthik

[Former Member]

I am using the secured connection that I published to the BI Platform, so I've already done this step.  Unfortunately that doesn't seem to be the cause.

A little more background.  The universe I am trying to access is built on top of Sybase IQ.  However, I am able to access the eFashion universe with no problems.

[former_member188911]

What is the middleware you are using?  If ODBC then you need to bear in mind that when you create the connection in Information Design Tool or Universe Designer the 32 bit ODBC will be used, whilst on the BI server you need ODBC 64 bit.

Please be also sure to be using a supported Sybase DB and middleware, the below table is for BI4.0 SP02

Relational	SAP / Sybase	Sybase IQ	12.7	JDBC	SQL	Sybase JConnect 6.05 JDBC Driver
Relational	SAP / Sybase	Sybase IQ	12.7	ODBC	SQL	Sybase ODBC 9 for Adaptive Server IQ 12.7
Relational	SAP / Sybase	Sybase IQ	15.1	JDBC	SQL	Sybase JConnect 6.05 JDBC Driver
Relational	SAP / Sybase	Sybase IQ	15.1	ODBC	SQL	Sybase IQ Client 15.1 - ODBC

To find the supported datasources you need to go to the supported platform documents for the version you are using  and then find the link that opens the Semantic Layer data sources document.

for more info please see

Getting started with Web Intelligence BI4.0 SP02

or

Getting started with Web Intelligence BI4.0 FP03

Thanks

[Former Member]

I am using Sybase IQ 15.4, which I've used with BOBJ many times before.  I've set up my ODBC data source in both the 32 bit and 64 bit.

I've been working with BOBJ and Web Intelligence for years, and used IQ 15.4 for a long time with no problems.  This is a new error to me.

Thanks,

Jeff

[former_member188911]

Because everything is properly setup then you may wish to contact support to investigate the root cause

Thanks!

Simone