OWB 11.2.0.2 Design Center Fails With Repository Connection Error And ORA-00600: internal error code, arguments: [15570] (Doc ID 1324967.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

Symptoms

The OWB 11.2.0.2 Design Center shows poor performance and fails with following message:

Warehouse Builder Error
Repository Connection Error: The connection to the repository was lost, because of the following database error: Closed Connection
Exit OWB without committing.


With Design Center trace set ( See <Note 943928.1>  on how to set it ) the generated log file reports :

[System.err ()] 10:44:42 AM: <DEBUG_ALL> Caused by: SQLException
Persistent Layer Error:SQL Exception..
Class Name: CMPPersist.
Method Name: queryObjNameInfo.
Persistent Layer Error Message: ORA-00600: internal error code, arguments: [15570], [], [], [], [], [], [], [], [], [], [], []
SELECT cal_property.elementid, cal_property.classname, schedulable.name || '_JOB' name, schedulable.name || '_JOB' logicalname, cal_property.uoid, cal_property.classname, cal_property.notm, cal_property.editable editable, cal_property.customerrenamable, cal_property.customerdeletable, cal_property.seeded, cal_property.UpdateTimestamp, cal_property.strongTypeName, cal_property.metadatasignature signature, 0 iconobject FROM Schedulable_v schedulable, CMPStringPropertyValue_v cal_property, CMPCalendarInstalledModule_v cal_mod, CMPPhysicalObject_v sched_phys, CMPCalendar_v cal, ( select prop.firstclassobject moduleid from CMPPhysicalObject_v phys, CMPStringPropertyValue_v prop where prop.logicalname = 'SCHEDULE_MODULE_CONFIG.DEPLOYMENT.LOCATION' and substr(to_char(prop.value),0,32) = '6A56798334E7E52EE040A8C02EC82E5B' and prop.propertyOwner = phys.elementid and phys.namedconfiguration = 42623 union select installedmodule from CMPLocationUsage_v locUse where location = 77025 and deploymentdefault = 1 and not exists ( select null from CMPPhysicalObject_v phys, CMPStringPropertyValue_v prop where prop.logicalname = 'SCHEDULE_MODULE_CONFIG.DEPLOYMENT.LOCATION' and prop.firstclassobject = locUse.installedmodule and prop.propertyOwner = phys.elementid and phys.namedconfiguration = 42623) ) usage WHERE cal_mod.elementid = usage.moduleid and cal_mod.elementid = cal.calendarmodule and substr(cal_property.value,0,32) = cal.uoid and cal_property.logicalname='SCHEDULABLE.PROPERTY' and (cal_property.firstclassobject = schedulable.elementid or cal_property.firstclassobject = sched_phys.elementid and sched_phys.logicalobject = schedulable.elementid) and cal_mod.owningproject = 42618 and cal_property.propertyowner = sched_phys.elementid and sched_phys.namedconfiguration=42623 ORDER BY schedulable.name || '_JOB'.

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