Warehouse builder logon on error due to unregistered

Asked By John V Bates 0 points N/A Posted on - 08/10/2014

Hi there,

I have this Logon Error and it seems like I am not registered to any Warehouse Builder. Is for the first time when I have this error and it started to appear after I made the necessary updates of my OS. Can anyone help me please to skip this error ?

Thank you !

Logon Error

API5055: This user has not been registered to any warehouse Builder workspace. Do you want to proceed to create a new workspace for it , or register it to an existing one?

Skip This Message Next Time

• Status: Open
• Question Views: 884
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Misc Software

Answered By Sharath Reddy 590495 points N/A #180489

Warehouse builder logon on error due to unregistered

If you are using the Oracle Warehouse Builder, remember you need to be running either Linux or Microsoft Windows both x86 or x64. Mac OS X is not supported. If you are not using the latest version, download and install Oracle Warehouse Builder 11gR2. For Linux, the 32-bit and 64-bit patches are available.

It seems this issue is a bug in Oracle database/gateway 11g. Though it is possible to get access to a worksheet from a Microsoft Office Excel file but selecting from dictionary views doesn’t work alongside ODBC HS connection to Microsoft Office Excel or possibly other sources as well over ODBC.

In case you are already using the latest release, try using the previous release of the database software. Don’t create a new database on your Oracle home. Just configure the listener on port but different from 1521 and use hsodbc instead of dg4odbc.

About Sharath Reddy

Questions
1

Answers
14599

Best Answers
2290

• Vote Up 0 Vote Down

• Posted on - 09/11/2014
• Question Category: Misc Software