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.CLOSEp1_el0,2_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
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.CLOSEp1_el0,2_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