OraFAQ Forum: Forms » Got Error ORA-00028 When Form 6i's Process Going on (merged)

Home » Developer & Programmer » Forms » Got Error ORA-00028 When Form 6i's Process Going on (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Got Error ORA-00028 When Form 6i's Process Going on (merged) [message #245855]

Tue, 19 June 2007 01:29

brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India

Junior Member

Dear all,
In my developement environment, There is D2K 6i Form. Which contain long process. In execution of this form, many time I got following error.
"ORA-00028 Your Session has been killed."
So how can I remove error from this form.
Due to this error all users have to login again, and again have to repet same process.
So please help me step by step process to solve problem.
Also let me know, is it D2k 6i side problem or Oracle 9i Database side?

Thanks
Brijal

Report message to a moderator

Re: ORA-00028 Error come when use perticular Form [message #245858 is a reply to message #245855]

Tue, 19 June 2007 01:38

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This is not an error.
Your DBA seems to estimate your process last too long and has killed your session.

Regards
Michel

Report message to a moderator

Re: ORA-00028 Error come when use particular Form [message #245867 is a reply to message #245858]

Tue, 19 June 2007 01:59

brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India

Junior Member

Thanks Michal,
I got this error in only one form. And it is too important form contain sales transaction.
So can u suggest any steps at server side like Increase memory or other steps.
Regards
Brijal

Report message to a moderator

Re: Got Error ORA-00028 When Form 6i's Process Going on [message #245879 is a reply to message #245855]

Tue, 19 June 2007 02:46

aciolac
Messages: 242
Registered: February 2006

Senior Member

see configuration of profile DEFAULT and the profile which have uses. Possible that due to setting of profile, session cannot exists more that some period of time, or cannot consume more that some number of CPU units.

Report message to a moderator

Re: ORA-00028 Error come when use particular Form [message #245882 is a reply to message #245867]

Tue, 19 June 2007 02:55

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Ask your DBA to not kill the session.
Nothing to do with server or parameters.

Regards
Michel

Report message to a moderator

Re: Got Error ORA-00028 When Form 6i's Process Going on [message #245886 is a reply to message #245879]

Tue, 19 June 2007 03:03

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

When it is a disconnection from profile the message is:

Quote:

exceeded session limit on ... usage, you are being logged off

and not

Quote:

Your Session has been killed

ora-00028: your session has been killed
 *Cause:  A privileged user has killed your session and you are no longer
          logged on to the database.
 *Action: Login again if you wish to continue working.

Regards
Michel

Report message to a moderator

Re: Got Error ORA-00028 When Form 6i's Process Going on [message #245890 is a reply to message #245886]

Tue, 19 June 2007 03:08

aciolac
Messages: 242
Registered: February 2006

Senior Member

1)If You make audit of connections, You can see audit logs from sys.aud$. This can help.
2)You can start trace on your session. And You will see fix point when Your connection are killed and what he are executing.

Report message to a moderator

Re: Got Error ORA-00028 When Form 6i's Process Going on [message #245902 is a reply to message #245879]

Tue, 19 June 2007 03:44

brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India

Junior Member

I check Profile in Enterprice Manager of ORACLE 9i Database. There is only one Profile in Database "DEFAULT" and it has all values set to "UNLIMITED".
So now what can be reason? Do I have to changes in server like Increase RAM or etc? Currently On server there is 1GM RAM.
Regards
Brijal

Report message to a moderator

Re: Got Error ORA-00028 When Form 6i's Process Going on [message #245907 is a reply to message #245902]

Tue, 19 June 2007 04:01

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

FOR THE FOURTH TIME:
THE REASON IS THAT YOUR DBA HAS KILLED YOUR SESSION(S).

Regards
Michel

Report message to a moderator

Re: Got Error ORA-00028 When Form 6i's Process Going on [message #246097 is a reply to message #245907]

Tue, 19 June 2007 22:08

brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India

Junior Member

Thank michal,
U r right. But here i am DBA of Server. So I have to take some action to solv this problem. Only one form get this type of error. all other forms work very fine.
Regards
Brijal

Report message to a moderator

Re: Got Error ORA-00028 When Form 6i's Process Going on [message #247187 is a reply to message #246097]

Mon, 25 June 2007 00:31

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

How long is your form running before this happens? I suggest you review the code in the Form and fix the performance issue that is giving rise to the long response time.

David

Report message to a moderator

Re: Got Error ORA-00028 When Form 6i's Process Going on [message #247193 is a reply to message #247187]

Mon, 25 June 2007 00:39

brijal_j_patel
Messages: 28
Registered: May 2007
Location: Surat,India

Junior Member

thanks djmartin for reply

After user click on Save button, too many time pass and form will remain "Not Responding" at that time. and few time it will done but many time error come.

This form will update many tables, also insert many records. So I think u r right. I start reviewing that form and let see I can reduce Database round trip. Then i will tell u

Reagrds

Report message to a moderator

Previous Topic:	PDE-PER001 Internal error (scaba 18)
Next Topic:	how use loop in from for two block

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 23:49:49 CST 2025