mixture between connections

Hi,
I have some problem with connections on Webi.
My repository is on DB2
My universe is based on Oracle Database
When I want to run a wqy report on this universe, I receive a DB2 message

BUSSCNX is the account used on the key file.
CLMAAZTX is the name of the Oracle table called by the report.

It seems that webi makes a mixture between his connection to the repository and the connection used by the universe.

Can someone help me to solve this problem?

Fandor


ChristopheA :fr: (BOB member since 2003-09-04)

Make sure the database middleware is configured correctly on the WebI server, and that it is using the current *.key file.

Does this report run fine in Full Client?


Andreas :de: (BOB member since 2002-06-20)

Hi Andreas,

All middlewares are correct (DB2 and Oracle). The connection to the repository is OK also.
This error is not systematic, we don’t arrive to find the exact workflow to reproduce this message.

Fandor


ChristopheA :fr: (BOB member since 2003-09-04)

You need to open the WQY and look at the SQL code it is generating. Then you’ll see what’s going on.


Steve Krandel :us: (BOB member since 2002-06-25)