Good morning, an application developed in the centura (which has already been tested in another Oracle base, and works ...) is presenting strange behavior .. an option where it was possible to click with the mouse to activate a routine no longer operating, all connectivity With the bank has already been revised, the bank was already taken out of the air but nothing solves ... the database has already been analyzed and no mistake was found. Any tip ?? Thank you very much.
strange behavior...
-
- Rank: Estagiário Pleno
- Posts: 5
- Joined: Tue, 27 Oct 2009 10:11 am
- Location: Ribeirão Preto
Luiz Carlos Bonissoni
-
- Moderador
- Posts: 1396
- Joined: Fri, 01 Feb 2008 2:06 pm
- Location: Rio de Janeiro - RJ
- Contact:
Have you tested on another machine?
Sometimes the routine is executed but by containing errors is not having the expected result ... type is called a PROC. This may be decompiled at the base .. or an inactive trigger
In order I hope I have helped
Sometimes the routine is executed but by containing errors is not having the expected result ... type is called a PROC. This may be decompiled at the base .. or an inactive trigger
In order I hope I have helped
-
- Rank: Estagiário Pleno
- Posts: 5
- Joined: Tue, 27 Oct 2009 10:11 am
- Location: Ribeirão Preto
Luiz Carlos Bonissoni
Good Morning!!
Thank you very much for the answer ... We have already tested on other machines ... and this same application connected to other databases, it works normally ... and connecting back from these other environment to This bank where the problem occurs, it also does not work.
Thanks.
Thank you very much for the answer ... We have already tested on other machines ... and this same application connected to other databases, it works normally ... and connecting back from these other environment to This bank where the problem occurs, it also does not work.
Thanks.
-
- Moderador
- Posts: 1396
- Joined: Fri, 01 Feb 2008 2:06 pm
- Location: Rio de Janeiro - RJ
- Contact:
Well ..
So and almost sure the problem is in the seat ne ..
You tried to use any other client (type PL SQL Developer) to connect on that basis?
Firewall?
Can you drip the bench machine?
So and almost sure the problem is in the seat ne ..
You tried to use any other client (type PL SQL Developer) to connect on that basis?
Firewall?
Can you drip the bench machine?
-
- Rank: Estagiário Pleno
- Posts: 5
- Joined: Tue, 27 Oct 2009 10:11 am
- Location: Ribeirão Preto
Luiz Carlos Bonissoni
We already used yes ... everything works .. is a great system and everything works, only this functionality that stopped functioning suddenly, there was no update or the bank or the application ... replaces the application by earlier versions, and impacts on the same point as well. In the bank there are no invalid objects, we already verified.
Thanks !!
Thanks !!
- dr_gori
- Moderador
- Posts: 5024
- Joined: Mon, 03 May 2004 3:08 pm
- Location: Portland, OR USA
- Contact:
Thomas F. G
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Você já respondeu a dúvida de alguém hoje?
https://glufke.net/oracle/search.php?search_id=unanswered
Idea:
Have you tried running the routine manually in the bank?
Some unexpected error may be happening that your program is not treating.
See if running manual is all OK!
Have you tried running the routine manually in the bank?
Some unexpected error may be happening that your program is not treating.
See if running manual is all OK!
-
- Rank: Estagiário Pleno
- Posts: 5
- Joined: Tue, 27 Oct 2009 10:11 am
- Location: Ribeirão Preto
Luiz Carlos Bonissoni
Good afternoon!!
We performed a TCP Dump and managed to capture Query, which when executed on the bank does not demonstrate any errors.
Thank you !!
We performed a TCP Dump and managed to capture Query, which when executed on the bank does not demonstrate any errors.
Thank you !!
-
- Rank: Estagiário Pleno
- Posts: 5
- Joined: Tue, 27 Oct 2009 10:11 am
- Location: Ribeirão Preto
Luiz Carlos Bonissoni
Sorted out!!!
The problem was on another table that the application accessed to verify a parameter, and this parameter was null ... what for me reveals a failure in its own application for not demonstrating where the problem, it simply stopped ...
Thank you all for cooperation.
The problem was on another table that the application accessed to verify a parameter, and this parameter was null ... what for me reveals a failure in its own application for not demonstrating where the problem, it simply stopped ...
Thank you all for cooperation.
-
- Moderador
- Posts: 1396
- Joined: Fri, 01 Feb 2008 2:06 pm
- Location: Rio de Janeiro - RJ
- Contact:
Can not be anything about the Grant of the Object for the User of Application as well as the absence of a synonym ??
You said this happened without any bank or application update .. Do you really have this control?
I say .. could not have any bank update or app without your knowledge?
would not have scheduled tasks that could do that? Maybe even a bkp?
What does this routine exactly? What objects does it access? What form?
: Shock:
You said this happened without any bank or application update .. Do you really have this control?
I say .. could not have any bank update or app without your knowledge?
would not have scheduled tasks that could do that? Maybe even a bkp?
What does this routine exactly? What objects does it access? What form?
: Shock:
-
- Moderador
- Posts: 1396
- Joined: Fri, 01 Feb 2008 2:06 pm
- Location: Rio de Janeiro - RJ
- Contact:
We turn in the same minute ..l.bonissoni wrote: Solved !!!
The problem was on another table that the application accessed to verify a parameter, and this parameter was null ... what for me reveals a failure in its own application for not demonstrating where the problem, it simply stopped ...
Thanks to all by cooperation.
How good it solved
embrace
-
- Information
-
Who is online
Users browsing this forum: No registered users and 11 guests