ERP form error message on a SQL database

Tags:
ERP
SQL
SQL Database
SQL Server errors
We have a problem with the ERP system on our SQL database. Whenever an ERP form at our client’s end remains idle for 15 minutes, an error message pops up when the form is made active again. This message is: “FRM-40733: PL/SQL built-in DBMS_ERROR_CODE failed.” Our DBA team is blaming it on a network issue, but we insist that that it is a problem with either the form design or with compatibility. Do you know what the issue might actually be?

Answer Wiki

Thanks. We'll let you know when a new response is added.

It could be useful to know some more details about your database and forms versions.
It sounds to me like a network issue, but I think it could also be that the database connection is timing out due to some database/sqlnet setting.

Is there some network device between the database and the application (or app server) ? If yes, I would review any timeout setting on that device.

I found this on metalink, but with no solution:

<pre>Problem
——-
While trying to open up an AERS case, error message FRM-40733 appears.
Session appears to hang and user must restart their application session.

FRM-40733 PL/SQL built in DBMS_error_code failed

Analysis
========
This can be a generic error for any application that exploits FORMS.

1. If at a particular point in time,the instance encountered an error
( eg : ORA-3113 – end of file on communication channel …or
ORA-3114 – database connection lost … or some Internal ORA -600 error
that lead to stoppage of any of the Background Processes…
( SMON, PMON ……) then the form would have abruptly thrown the exception
as its database connection thread to the kernel can no
longer communicate to the DB kernel. At that point in time the form is capable
of throwing any error message. </pre>

If the forms can be modified, you could try to set some timer in the form, to issue any simple select statement against the database every 5 minutes, and see what happens.

Hope this helps.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Nido77
    thanx for reply. here are some more information about our setup. cisco asa5520 firewall between database server and clients. any port is opened on firewall for database server. database server operating system is Linux database version 10g. Forms 6i hope this information will be suffice. anxiously waiting for your precious comments.
    10 pointsBadges:
    report
  • Farookh
    Dear All, Same issue we are facing in prod.

    We are using OAS 10g and DB 10g both hosted on linux 5.4.

    Kindly advise

    Regards
    Farookh
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following