My Oracle Support Banner

ORA-01000 Database Error And Server Busy Error Encountered When Trying to Create New Connection In Migration Application On RR Environment (Doc ID 2695836.1)

Last updated on JULY 29, 2020

Applies to:

Siebel CRM - Version 17.0 [IP2017] and later
Information in this document applies to any platform.

Symptoms

When attempting to create a new connection in target environment in Siebel Migration Application, the connection fails with server busy on migration application and migration.log shows the following error occurs.

[ERROR] 2020-07-21 15:11:39.243 [https-jsse-nio-443-exec-5] Migration - com.siebel.migration.server.MigrationEngine:saveConnection Unable to insert a new connection due to exception java.sql.SQLException: ORA-01000: maximum open cursors exceeded

STEPS TO REPRO
-----------------------
The issue can be reproduced at will with the following steps:

1. In a target environment configure and deploy Migration profile in Siebel Management Console (SMC).
2. Check to see if the Migration application is running and login is successful.
3. Inside the target environment migration application, try to create a new connection and see if it is successful.


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
Cause
Solution


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