IBM Support

An internal error occurred during : "Loading Core Provider". in the Database Explorer view when trying to access schema table from a MySQL v4.1/v5.0 database

Troubleshooting


Problem

This technote provides information on how to resolve an Error pop-up which is displayed in the Database Explorer view when trying to access tables defined in a MySQL v4.1 or MySQL v5.0 database through Rational Application Developer (RAD) v7.0.0.4 . This problem does not occur when using RAD v7.0.0.3 or any other earlier versions of RAD.

Symptom

After creating a successful connection to a MySQL v4.1 or MySQL v5.0 database through RAD v7.0.0.4, when trying to access the schema tables you will see the following Loading Core provider error:

An internal error occurred during: "Loading Core provider".




The .log file in the <workspace>/.metadata directory will also display the error

Error Stack Trace :
!ENTRY org.eclipse.core.jobs 4 2 2007-11-20 09:54:45.468
!MESSAGE An internal error occurred during: "Loading Core provider".
!STACK 0
java.lang.ArrayStoreException
at org.eclipse.emf.common.util.BasicEList.assign(BasicEList.java:188)
at org.eclipse.emf.common.util.BasicEList.addUnique(BasicEList.java:666)
at org.eclipse.emf.common.notify.impl.NotifyingListImpl.doAddUnique(NotifyingListImpl.java:384)
at org.eclipse.emf.common.notify.impl.NotifyingListImpl.basicAdd(NotifyingListImpl.java:667)
at org.eclipse.wst.rdb.internal.models.sql.schema.impl.SchemaImpl.eInverseAdd(SchemaImpl.java:461)
at org.eclipse.emf.ecore.impl.BasicEObjectImpl.eInverseAdd(BasicEObjectImpl.java:985)
at org.eclipse.emf.ecore.util.EcoreEList.inverseAdd(EcoreEList.java:264)
at org.eclipse.emf.common.notify.impl.NotifyingListImpl.addUnique(NotifyingListImpl.java:310)
at org.eclipse.emf.common.util.BasicEList.add(BasicEList.java:600)
at org.eclipse.wst.rdb.internal.mysql.catalog.MySqlCatalogDatabase.getSchemas(MySqlCatalogDatabase.java:40)
at org.eclipse.wst.rdb.server.internal.ui.explorer.providers.content.layout.vnode.ServerExplorerVNodeContentProviderNav.displaySchemaNodeChildren(ServerExplorerVNodeContentProviderNav.java:94)
at org.eclipse.wst.rdb.server.internal.ui.explorer.providers.content.layout.AbstractOnDemandContentProviderNav.getChildren(AbstractOnDemandContentProviderNav.java:176)
at org.eclipse.wst.rdb.server.internal.ui.explorer.providers.content.layout.AbstractOnDemandContentProviderNav.getChildren(AbstractOnDemandContentProviderNav.java:250)
at org.eclipse.wst.rdb.server.internal.ui.explorer.providers.content.layout.AbstractLayoutProviderNav.getChildren(AbstractLayoutProviderNav.java:88)
at org.eclipse.wst.rdb.server.internal.ui.explorer.providers.content.impl.ServerExplorerContentProviderNav.load(ServerExplorerContentProviderNav.java:236)
at org.eclipse.wst.rdb.server.internal.ui.explorer.loading.LoadingJob.run(LoadingJob.java:43)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:58)


This error does not occur when using an earlier release or fixpack of RAD such as. v7.0.0.3.

Cause

The jar org.eclipse.wst.rdb.mysql_1.0.105.v200703122014.jar that comes packaged with RAD v7.0.0.4 is creating the problem.
This issue has been identified as a product defect and has been logged under APAR# PK57332.

Resolving The Problem

Workaround

    • Shut down RAD v7.0.0.4 if running
    • Download the Web Tools Platform 1.5.5 (WTP) from the Eclipse.org Web site
    • Replace the plug-in jar org.eclipse.wst.rdb.mysql_1.0.105.v200703122014.jar from the <RAD Installation Directory>/SDP70Shared/plugins with the extracted jar from the eclipse/plugins directory of the downloaded archive
    • Start RAD v7.0.0.4 with the "-clean" parameter

[{"Product":{"code":"SSRTLW","label":"Rational Application Developer for WebSphere Software"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Data Access Applications","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.0.0.4;7.0.0.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}},{"Product":{"code":"SSYK2S","label":"Rational Software Architect Designer"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Data Access Applications","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.0.0.4;7.0.0.5","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
10 September 2020

UID

swg21289028