My Oracle Support Banner

Siebel Migration Fails with Intermittent Error ORA-03135: connection lost contact, ORA-03114: not connected to ORACLE (Doc ID 2681162.1)

Last updated on NOVEMBER 24, 2022

Applies to:

Siebel CRM - Version 19.12 and later
Information in this document applies to any platform.

Symptoms

Asynchronous migration execution to Target fails with intermittent errors when importing the repository

The repimexp.log file:


2020-06-11 20:23:18 SQL Warning, SQL State 08S01, 3135, [tp][ODBC Oracle driver][Oracle]ORA-03135: connection lost contact
2020-06-11 20:23:18 08S01: [tp][ODBC Oracle driver][Oracle]ORA-03114: not connected to ORACLE
2020-06-11 20:23:18 REPIMEXP-ERR-1124: Unable to import table "S_COLUMN" (UTLOdbcTransactCommit).
2020-06-11 20:23:18 REPIMEXP-ERR-1123: Partially imported 139000 rows for table "S_COLUMN".
2020-06-11 20:23:18 Repository import process fails in table S_COLUMN
2020-06-11 20:23:18 Rollback imported tables ...
2020-06-11 20:23:18 SQL Statement:
DELETE FROM SIEBEL.S_ASGNOBJ_UPROP WHERE REPOSITORY_ID = '1-5F-1'
2020-06-11 20:23:18 [tp][ODBC Oracle driver][Oracle]ORA-03114: not connected to ORACLE

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.