SQL Server Metadata Import In OWB 11.2 Fails With "No more data to read from socket" (Doc ID 1315609.1)

Last updated on MAY 09, 2017

Applies to:

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

Symptoms

When attempting to import SQL Server tables with constraints into OWB 11.2 using the Gateway, the following exception occurs in OWB:

SQL Exception
SQL Exception
Persistent Layer Error:SQL Exception..
Class Name: CacheMediator.
Method Name: getSQLResult.
Persistent Layer Error Message: No more data to read from socket.

at oracle.wh.repos.pdl.foundation.CacheMediator.getSQLResult(CacheMediator.java:584)
at oracle.wh.repos.impl.CMPWBAPIFactory.getSQLResult(CMPWBAPIFactory.java:2207)
at oracle.wh.service.sdk.integrator.RepositoryUtils.getSQLResult(RepositoryUtils.java:465)
at oracle.wh.ui.integrator.sdk.RelationalEntityAccessor.getConstraintOwningTablesSQLResult(RelationalEntityAccessor.java:2850)
at oracle.wh.ui.integrator.sdk.RelationalEntityAccessor.getConstraintOwningEntity(RelationalEntityAccessor.java:2104)
at oracle.wh.ui.integrator.common.ImportEntityAlgorithm.doFinalRefConstraintResolution(ImportEntityAlgorithm.java:5200)
at oracle.wh.ui.integrator.common.ImportEntityAlgorithm.concludeImportSeries(ImportEntityAlgorithm.java:446)
at oracle.wh.ui.integrator.sdk.EntityAccessor.concludeImportSeries(EntityAccessor.java:95)
at oracle.wh.ui.integrator.common.ImportService.concludeImport(ImportService.java:1269)
at oracle.wh.ui.integrator.common.wizards.ImportElementTransaction.run(ImportWizardDefinition.java:775)
Caused by: java.sql.SQLException: No more data to read from socket
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1142)


This might cause an ORA-07445 in the RDBMS:

Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x24] [PC:0x57AF52, _rpibp2()+76]
Incident 15753 created, dump file: C:\ORACLE\diag\rdbms\o11202\o11202\incident\incdir_15753\o11202_ora_1788_i15753.trc
ORA-07445: exception encountered: core dump [rpibp2()+76] [ACCESS_VIOLATION] [ADDR:0x24] [PC:0x57AF52] [UNABLE_TO_READ] []

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