OraFAQ Forum: Server Administration » db server not allowing to insert or update.

Home » RDBMS Server » Server Administration » db server not allowing to insert or update.

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

db server not allowing to insert or update. [message #289002]

Wed, 19 December 2007 04:43

mrkcse
Messages: 62
Registered: November 2007
Location: Mumbai,India

Member

Iam using database server system installed with oracle 10g.Iam accessing the server through vb6.0 application, for some months it has worked fine all insertions,updations presently from last last week it is not working.
Recently server accidently got shutdown and services were not automatically restarted so we have restarted it manually from then all insertions,updations are not working from front end with same application.

what might be the reason can i resume my previous server settings? how to fix this problem.

Report message to a moderator

Re: db server not allowing to insert or update. [message #289013 is a reply to message #289002]

Wed, 19 December 2007 05:00

varu123
Messages: 754
Registered: October 2007

Senior Member

>>db server not allowing to insert or update.
Is this the error message you got in your alert files,trace fiels and listener.log files?

Report message to a moderator

Re: db server not allowing to insert or update. [message #289060 is a reply to message #289013]

Wed, 19 December 2007 07:00

mrkcse
Messages: 62
Registered: November 2007
Location: Mumbai,India

Member

from front end any updations or insertions are not performing how to fix this.

Report message to a moderator

Re: db server not allowing to insert or update. [message #289066 is a reply to message #289060]

Wed, 19 December 2007 07:33

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What does the front-end application say? Is there any error message? If so, which one is it?

Report message to a moderator

Re: db server not allowing to insert or update. [message #289186 is a reply to message #289002]

Thu, 20 December 2007 00:46

mrkcse
Messages: 62
Registered: November 2007
Location: Mumbai,India

Member

in one partucular table one date column it is not getting updated.Same application working using local database perfectly.

we have to approve the todays date. Using local database it is approved. Whenever we are accessing the application with database present in server it is showing the message " already approved"

Report message to a moderator

Re: db server not allowing to insert or update. [message #289197 is a reply to message #289186]

Thu, 20 December 2007 01:49

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Which part of the application is responsible for displaying this message? For example, if it is a form trigger, what does it do? If it is a database (stored) function or a procedure, how does it look like? Also, what does a user have to do in order to "approve" something? Click a button? If so, what's the code behind it?

Report message to a moderator

Re: db server not allowing to insert or update. [message #289200 is a reply to message #289197]

Thu, 20 December 2007 02:27

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

So now we have gone from

Quote:

all insertions,updations are not working from front end

Quote:

in one partucular table one date column it is not getting updated

Let me have a look in my crystal ball. /forum/fa/1659/0/

Hmmmm.. There is something behind that fog on the left side, I believe. Could be someone developer having used implicit date conversions somewhere. Could of course be something completely different too. Maybe it's time to sacrifice a chicken.

Report message to a moderator

Re: db server not allowing to insert or update. [message #289271 is a reply to message #289200]

Thu, 20 December 2007 08:37

mrkcse
Messages: 62
Registered: November 2007
Location: Mumbai,India

Member

actually one particular table it is not getting updated depending on this data in this particular table other tables are not updating.so thats why i mentioned like that.

actuall problem is iam not able to update one particular table from my vb6.0 application to server sytem.The same application when i try to update using local database to my sytem it is working.From coding side everything is fine.

what could be the problem and please tell some suggestions.

Report message to a moderator

Re: db server not allowing to insert or update. [message #289282 is a reply to message #289271]

Thu, 20 December 2007 09:31

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Quote:

From coding side everything is fine

I don't think so. If the coding would be fine, you would get some sort of error message when a database transactions fails.

And you already have suggestions, follow up on them. Without seeing the actual code that is failing I'm out of suggestions.

Report message to a moderator

Re: db server not allowing to insert or update. [message #289302 is a reply to message #289282]

Thu, 20 December 2007 10:55

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Check for Triggers if some one created trigger to block insertion /updation?

Report message to a moderator

Re: db server not allowing to insert or update. [message #289306 is a reply to message #289302]

Thu, 20 December 2007 11:21

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Or, did someone DISABLE a trigger which is enabled in your local database (and this trigger, actually, should insert/update records in another table)?

Report message to a moderator

Previous Topic:	Archive backup
Next Topic:	Max SGA Size on Windows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 18 22:35:06 CDT 2024