strange behavior...

[l.bonissoni]

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.

[victorhugomuniz]

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

[l.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.

[victorhugomuniz]

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?

[l.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 !!

[dr_gori]

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!

[l.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 !!

[l.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.

[victorhugomuniz]

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:

[victorhugomuniz]

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.

We turn in the same minute ..

How good it solved

embrace