OBIEE on InfiniDB

2 posts / 0 new
Last post
fullorbit014
fullorbit014's picture
Offline
Last seen: 2 years 11 months ago
Joined: Jul 26 2011
Junior Boarder

Posts: 2

Sander Meerkerk
OBIEE on InfiniDB

Hi,

I am experimenting with OBIEE on InfiniDB and I experience the following interesting situation.

First my setup :
- OBIEE 11.1.5
- ODBC : MySQL ODBC 5.1 Driver Version: 05.01.0009
- DB : Calpont InfiniDB 2.2

InfiniDB is accessed via ODBC using the MySQL driver.

I can import tables from InfiniDB and I can do an 'update row count', but if I ask 'view data..' then I get an error :

[nQSError: 16015] SQL Statement execution failed.
[nQSError: 16001] ODBC error state: S1000 code: 138 message: [MySQL][ODBC 5.1 Driver][mysql-5.1.39].

If I check the myodbc.sql log file I see the following:

-- Query logging
--
-- Driver name: MySQL ODBC 5.1 Driver Version: 05.01.0009
-- Timestamp: 111005 15:52:00

select count(*) from dmd_clients;
-- Query logging
--
-- Driver name: MySQL ODBC 5.1 Driver Version: 05.01.0009
-- Timestamp: 111005 15:52:02

select count(*) from dmd_clients;
-- Query logging
--
-- Driver name: MySQL ODBC 5.1 Driver Version: 05.01.0009
-- Timestamp: 111005 15:52:02

select ADDRESS1, ADDRESS2, [ .. lots of columns ..], STATUS, TERRITORY from dmd_clients;
select ADDRESS1, ADDRESS2, [ .. lots of columns ..], STATUS, TERRITORY from dmd_clients;

The first two log entries are from only one execution of 'update row count' and the third log entry is from the execution of 'view data..' .
That last entry is also the one that gives me the error message. We see here an immediate repetition of the select statement. If I feed a single version of that statement to InfiniDB it runs perfectly well. So the statement is OK. But the thing that bothers me is the repetition of the statement while that does not happen with the update row count.

The same phenomenon happens if I try to make a report via Answers. I get the same error and I see the statement repeated.

Does anyone know of this ? Is this simply solved by setting some parameter ? Or should I report a bug ?

I also tested this with the same MySQL driver on a MySQL database but there it works well and I don't see the repetition.
So it must have something to do with the way OBIEE talkes to InfiniDB underneath (I guess).

Any (constructive) ideas are most welcome.

Regards,
Fullorbit014

fullorbit014
fullorbit014's picture
Offline
Last seen: 2 years 11 months ago
Joined: Jul 26 2011
Junior Boarder

Posts: 2

Sander Meerkerk
Re: OBIEE on InfiniDB

As an additional piece of information: some requests DO work in Answers because in many cases where I select a dimension column AND a fact column then I tend to get an answer.
But when I just ask for a column from a dimension it never works and it gives me the error I showed.

I also downloaded ClienteODBC (a very simple ODBC client) and made a connection to both the BI Server (via BI Server ODBC) and the InfiniDB (via MySQL ODBC).
When I then issue a piece of logical SQL to the BI Server it tends to fail (unless I request for a dimension and a fact column). But if I then issue the database SQL to the InifiDB directly it always gives me an answer, wether I query only a dimension or a fact column or both.

So I suspect the BI Server does not talk to InfiniDB properly via the MySQL odbc connector. Although when I test with a MySQL database via the same odbc connector it works well.
Does OBI do different things depending on the database that is 'hidden' under the odbc connector ?
Or does it expect something in the resultset that IS returned by the MySQL database but NOT by the InfiniDB ?

Interesting.

Grez,
Fullorbit014