OraFAQ Forum: Forms » Urgent ..Form using partitioning tables crashes everytime with oerr ora 03114

Home » Developer & Programmer » Forms » Urgent ..Form using partitioning tables crashes everytime with oerr ora 03114

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

Urgent ..Form using partitioning tables crashes everytime with oerr ora 03114 [message #136838]

Sun, 11 September 2005 10:36

jkong21
Messages: 6
Registered: September 2005
Location: Mauritius

Junior Member

Please help.
I have a form that crashes with me everytime. This form has been modified with addition of new columns and creation of a new index on this new column. Now form is crashing with me everytime an update is triggerred..
Form has based block a partitioning table.
I've drop the index and recreate the indexes + its partitioning also...the form crashes less but still do from time to time.
Please help

Report message to a moderator

Re: Urgent ..Form using partitioning tables crashes everytime with oerr ora 03114 [message #136856 is a reply to message #136838]

Sun, 11 September 2005 21:25

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

Senior Member
Account Moderator

Please confirm - you are saying 'the form always worked until (1) we added the new fields or (2) we partitioned the table'?

Please reply.

David

Report message to a moderator

Re: Urgent ..Form using partitioning tables crashes everytime with oerr ora 03114 [message #137190 is a reply to message #136838]

Tue, 13 September 2005 12:47

jkong21
Messages: 6
Registered: September 2005
Location: Mauritius

Junior Member

Hi, thnks...
When i have added the new fields....i have tried to remove the fields and it works perfectly...when i re insert the new fields on my block. the form crashes...
Do you think the update sql statement sending to the database is too long...by the way forgot to mention i have approximately 100 columns in my table. Do you think its because of that??

Report message to a moderator

Re: Urgent ..Form using partitioning tables crashes everytime with oerr ora 03114 [message #137212 is a reply to message #137190]

Tue, 13 September 2005 19:03

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

Senior Member
Account Moderator

Okay, this is our starting point ... no new fields, the form works ... add new fields, it stops.

Add one field at a time, check that the datatype on the new Forms field DOES match the datatype in the database, see if it works, continue until it fails.

Tell us the datatype of the field which 'killed' the form, plus anything else that you can think of that pertains to this field.

David

Report message to a moderator

Re: Urgent ..Form using partitioning tables crashes everytime with oerr ora 03114 [message #137604 is a reply to message #137212]

Thu, 15 September 2005 11:45

jkong21
Messages: 6
Registered: September 2005
Location: Mauritius

Junior Member

Well,
already checked the datatype they matched in the database.
well specially when i'm updating a column of type varchar2. However whats weird is the fact that not on all columns of varchar2 it crashes(specially on varchar2(250)).
Please note i mentioned update coz my form do not have any insert or delete. i have tried to debug it and it seems that on update makes it lose connection with the database...and at the moment post -update triggers , no connection found.
In fact, the property update only changed columns was set to NO. I cant use property Yes due to the higher no of parses if i use yes.
Thnks

Report message to a moderator

Re: Urgent ..Form using partitioning tables crashes everytime with oerr ora 03114 [message #137642 is a reply to message #137604]

Thu, 15 September 2005 18:46

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

Senior Member
Account Moderator

Okay ... what version of Forms and database are you using?

David

Report message to a moderator

Re: Urgent ..Form using partitioning tables crashes everytime with oerr ora 03114 [message #137644 is a reply to message #137642]

Thu, 15 September 2005 19:16

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

Senior Member
Account Moderator

How many columns in your table? How many indexes do you have for this table?

What is the total length of the varchar2 fields? Do you have any idea as to the size (length) of your various database working areas?

David

[Updated on: Thu, 15 September 2005 19:17]

Report message to a moderator

Previous Topic:	HOW TO USE SQL LOADER IN FORMS 6i
Next Topic:	Web.Show_document error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:45:21 CDT 2024