Question

Payment Advice Print Error in Print Manager


Userlevel 4
Badge +9

Hi comunity,

When creating Payment , there is an event that send a mail to suppliers wiht a PDF create with cristal report, this process is getting an error in Print manager and the mail is not send until restart this process in Print manager. Message indicated is: ORA-04061: existing state of has been invalidated.

 

Running a IFSAPP10

 

 

 

 


4 replies

Userlevel 7
Badge +11

Hi @ConAlberM,

Multiple scenarios can throw this error. One scenario is when an existing DB object has been invalidated during the time you are using the application. This can happen if there is an ongoing technical investigation in the mentioned environment, perhaps you can look into that.

Or another scenario, you could log into the database and see whether there are any ‘invalid objects’ in the database. If any, try to compile & clear them up. But if this is production environment, then please consult a DBA before proceeding since recompiling DB objects during working hours can cause more harm to the ongoing users and processes.

Userlevel 4
Badge +9

Hi, @Nalaka Samarasinghe. thanks for answering. for some incident, it is not happening in all cases, some payment advice work well and then some other does stop with this error message.

Userlevel 4
Badge +9

there is nothing decompiled and the UPD is 10

Userlevel 1
Badge +6

Hi @ConAlberM did you get a resolution to this?

W have noticed our payment advices are randomly not sending and we have the errors just like you describe.

Reply