BI4.1 Univ Design Table Browser Missing Columns after insert

building semantic layer
1

Hi Folks,

DB: Oracle
BO: SAP BO 4.1 SP2 Designer

Problem Description:
Following migration from BOXI 3.1 to BI 4.1 SP2, I have an issue with the Universe Design Tool.

Essentially when I click on insert a new table to a universe, the table browser inserts an empty table into the universe.
No columns are displayed in the table. When I attempt to expand the table in the table browser by clicking on the ‘+’ beside
the table names nothing is displayed.

Also I have tried to ‘Refresh Structure’ but get an informational message to the effect “The selected tables were not found” which I think is linked to the above issue.

Incidentally when I use the older version of designer in our BO 3.1 environment everthing works as normal.

Have checked Universe/Connection security & Universe Design Tool rights in CMC all to no avail.

Anyone experienced this issue before or have any suggestions or solutions?

Cheers,
Enda.

Enda :ireland: (BOB member since 2011-12-06)

2

Hi,

Are you able to open the already designed universe that was existing in BO 3.0 in the universe tool.
Try to import all the existing universe inside the designer tool in BO 4.0.
After that you can try to create a new universe.

Try and let me know.

Regards,
Judia

judia (BOB member since 2008-06-24)

3

Does the user as defined in the universe connection in 4.1 have rights to see the database tables?

Mak 1 :uk: (BOB member since 2005-01-06)

4

Yes.

The universe connection is the same for the both old and new system.

Enda :ireland: (BOB member since 2011-12-06)

5

Enda :ireland: (BOB member since 2011-12-06)

6

What happens in the Universe Designer tool in 4.1?
Are you sure that you are actually pointing to the same DB, if using TNS names, are these exactly the same (3.1 vs 4.1)?

Mak 1 :uk: (BOB member since 2005-01-06)

7

Hi Enda,

Check this link

Regards,
Judia

judia (BOB member since 2008-06-24)

8

Yes

One thing I forgot to mention is that when you right click on Table/Table Values I get an exception as follows
"ORA-00980: synonym translation is no longer valid "

Enda :ireland: (BOB member since 2011-12-06)

9

This may help you:-

https://bobj-board.org/t/218416

Mak 1 :uk: (BOB member since 2005-01-06)

10

Hi Enda,

Just have a look into this.
ORA-00980: synonym translation is no longer valid
The above error occurs when
1.You created a synonym on non-existing object by mistake.

2.You dropped an object but you did not drop the synonyms referencing the object.

3.You dropped a user, but you did not drop synonyms referencing the objects owned by that user.

Regards,
Judia

judia (BOB member since 2008-06-24)

11

Hi Enda,

Please read this .

Regards,
Judia

judia (BOB member since 2008-06-24)

12

Solution Found

Thanks Mak 1 for the pointer. After reading a little bit about a similar issue I changed the Oracle.sbo file as follows

False
to
True

The file was located on my pc in the following folder
C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\oracle

Once I changed and saved the file and restarted the Universe design Tool I was able to see the columns instantly.

Thanks to all for the help

Enda :ireland: (BOB member since 2011-12-06)

13

No worries Enda, once you had added the error info, I remembered that particular post…

Mak 1 :uk: (BOB member since 2005-01-06)

14

Hello all !

I’ve read carefully this post, and make all the suggestions presented, but alas nothing works by me, even the “true” parameter.

I’ve something quite similar : when I want to insert tables, I’ve ALL the table in the window (system, oracles,etc …), and that makes a lot !!! :shock:

More than this, I’ve also another problem : the tables are not in the schema’s repository but directly on the “root”, so they are not prefixed & not usable.
And, more again, some don’t have the columns when I click on the “+”.

So you see, diffcult to use Designer properly ! :?

Thanks for your help, if anybody has an idea! :frowning:

… Forgot :
DB: Oracle 9/11
BO: SAP BO BI4.1 SP5
:wink:

kisepfl :switzerland: (BOB member since 2009-10-09)

15

I don’t believe Oracle 9 is still supported…

Mak 1 :uk: (BOB member since 2005-01-06)

16

OK, thanks, I’m going to see my DBA ! … 8)

kisepfl :switzerland: (BOB member since 2009-10-09)

17

… in fact I tried with another DB Oracle 11, and we have the same problem, so …

kisepfl :switzerland: (BOB member since 2009-10-09)

18

Can you state the driver type and version numbers you are using in both instances, please?

Mak 1 :uk: (BOB member since 2005-01-06)

19

We use the connexion Oracle InstantClient 11.2.0.4.
for the 2 platforms Oracle 11g (11.2.0.2) & 9i (9.2.0.8 )

Thanks Mak1 :+1:

kisepfl :switzerland: (BOB member since 2009-10-09)

20 
Oracle InstantClient 11.2.0.4.

Again, not supported. Drivers are one of the most important things to ensure they are within support, IMO.

Supported Oracle datasource Components 4.1 SP5:-

Relational	Oracle	Oracle DB *	10gR1	JDBC	SQL	Oracle JDBC 10g R1 (10.1.0.3)
Relational	Oracle	Oracle DB *	10gR1	Oracle OCI	SQL	Oracle Net Client 10.1
Relational	Oracle	Oracle DB *	10gR2	JDBC	SQL	Oracle JDBC 10gR2 (10.2.0.1)
Relational	Oracle	Oracle DB *	10gR2	Oracle OCI	SQL	Oracle Net Client 10.2
Relational	Oracle	Oracle DB *	11gR1	JDBC	SQL	Oracle JDBC 11g R1
Relational	Oracle	Oracle DB *	11gR1	Oracle OCI	SQL	Oracle Net Client 11.1
Relational	Oracle	Oracle DB *	11gR2	JDBC	SQL	Oracle JDBC 11g R2
Relational	Oracle	Oracle DB *	11gR2	Oracle OCI	SQL	Oracle OCI 11g R2
Relational	Oracle	Oracle Exadata *	11	OCI	SQL	OCI Driver Version 11.1.0.6
Relational	Oracle	Oracle Exadata *	11	JDBC	SQL	JDBC Driver Version 11.2.0.1.
Relational	Oracle	Oracle DB *	12c	Oracle OCI	SQL	Oracle 12.1.0.1 Native Driver
Relational	Oracle	Oracle DB *	12c	JDBC	SQL	Oracle JDBC version ojdbc6.jar
Relational	Oracle	Oracle EBS	10	OCI	SQL	Oracle OCI 10.2.0.4.0

Mak 1 :uk: (BOB member since 2005-01-06)