OWB 11.2 Design Center Fails to Connect With API5022: Cannot connect to the specified account. Verify connection information.

(Doc ID 1464958.1)

Last updated on JULY 12, 2018

Applies to:

Oracle Warehouse Builder - Version 11.2 and later
Information in this document applies to any platform.

Symptoms

The OWB 11.2 Design Center fails to connect with :

API5022: Cannot connect to the specified account. Verify connection information.

  Starting the Design Center in trace mode as described in <Note 943928.1>, the log file shows:

[System.out ()] 3:01:44 PM: <DEBUG_ALL> Controller Initializer: oracle.wh.ui.environment.utils.EnvironmentInfoBusController
[System.out ()] 3:02:25 PM: <DEBUG_ALL>     OMUEventController: Posting GUI_FINISHED on oracle.wh.ui.owbcommon.OWBWizard$6[dialog0,627,196,346x371,invalid,layout=java.awt.BorderLayout,modal,title=Design Center Logon,defaultCloseOperation=DO_NOTHING_ON_CLOSE,rootPane=javax.swing.JRootPane[,8,30,330x333,invalid,layout=javax.swing.JRootPane$RootLayout,alignmentX=0.0,alignmentY=0.0,border=,flags=16777673,maximumSize=,minimumSize=,preferredSize=],rootPaneCheckingEnabled=true], isCancelled = false
[System.err ()] 3:02:26 PM: <DEBUG_ALL>
[System.err ()] 3:02:26 PM: <DEBUG_ALL>     at oracle.wh.repos.pdl.foundation.CMPConnection.getRawConnection(CMPConnection.java:442)
[System.err ()] 3:02:26 PM: <DEBUG_ALL>     at oracle.wh.repos.pdl.foundation.CMPConnection.getRawConnection(CMPConnection.java:362)
[System.err ()] 3:02:26 PM: <DEBUG_ALL>     at oracle.wh.repos.impl.CMPWBAPIFactory.getRawConnection(CMPWBAPIFactory.java:2229)
[System.err ()] 3:02:26 PM: <DEBUG_ALL>     at oracle.owbimpl.console.RepositoryConnectionDialog.doLogin(RepositoryConnectionDialog.java:668)
[System.err ()] 3:02:26 PM: <DEBUG_ALL>     at oracle.owbimpl.console.RepositoryConnectionDialog.connect(RepositoryConnectionDialog.java:491)
[System.err ()] 3:02:26 PM: <DEBUG_ALL>     at oracle.owbimpl.console.OWBAddin$7.mainWindowOpened(OWBAddin.java:938)
[System.err ()] 3:02:26 PM: <DEBUG_ALL>     at oracle.ide.IdeCore.fireIdeEvent(IdeCore.java:855)
[System.err ()] 3:02:26 PM: <DEBUG_ALL>     at oracle.ide.IdeCore.mav$fireIdeEvent(IdeCore.java:124)
[System.err ()] 3:02:26 PM: <DEBUG_ALL>     at oracle.ide.IdeCore$3.run(IdeCore.java:815)
[System.err ()] 3:02:26 PM: <DEBUG_ALL>     at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
[System.err ()] 3:02:26 PM: <DEBUG_ALL>     at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
[System.err ()] 3:02:26 PM: <DEBUG_ALL>     at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
[System.err ()] 3:02:26 PM: <DEBUG_ALL>     at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
[System.err ()] 3:02:26 PM: <DEBUG_ALL>     at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
[System.err ()] 3:02:26 PM: <DEBUG_ALL>     at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
[System.err ()] 3:02:26 PM: <DEBUG_ALL>     at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
[System.err ()] 3:02:26 PM: <DEBUG_ALL> Caused by: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms