Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating new workarea problem

Status
Not open for further replies.

Lenarto

Programmer
Mar 24, 2002
1
SI
I have Oracle 9.0.1 database running on Caldera OpenLinux Server 3.1 and it's working fine. I've just installed Oracle Designer 6i Release 4.1.1 on to my Win2K client, installed repository and enabled versioning.
When I try to create a new workarea (besides Global.Shared Workarea) I get the following message:
Message
-------
RME-02014: Database connection lost

Cause
-----
Your established connection to the database was lost. It is
possible that 1) the database was shutdown, 2) an internal
database problem has occurred, or 3) you have a software or
hardware configuration problem.


Action
------
Contact your systems administrator.


--------------------------------------------------------------------------------

Message
-------
RME-02124: Failed to execute SQL statement: declare
utility varchar2(3);
curr_el integer;
begin
savepoint rm_dispatch;
rmmes.clear;
curr_el := 0;
RMOACTIVITY.CLOSE:)p1_el0,:p2_el0);
:errcnt := 0;
exception when others then
rmmes.get_error_state(utility,:excode);
rmmes.get_product(utility,:exprod);
:exutil := utility;
:errcnt := rmmes.getsize;
:sqlcod := SQLCODE;
:sqlmsg := SQLERRM;
:currel := curr_el;
rollback to savepoint rm_dispatch;
end;

Cause
-----
An error occurred while executing a SQL statement.


Action
------
Examine reported errors for specific details.


--------------------------------------------------------------------------------

Message
-------
RME-00222: Failed to dispatch operation to Repository

Cause
-----
Requested operation failed because of other errors.


Action
------
Examine other reported errors for specific details.


--------------------------------------------------------------------------------

Message
-------
RME-00224: Failed to close activity

Cause
-----
Could not close ('commit') an activity.


Action
------
Examine other reported errors for specific details.


--------------------------------------------------------------------------------

Any suggestions? Is this problem caused by Oracle9i DB, since it does not use rollback segments (it uses undo tables instead)?

thanks, Lenart
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top