Missing LAM Attachments: SQL execution error, ORA-01407: cannot update ("ARGUS_APP"."LAM_ACTION_ITEM"."FROM_CENTRAL") to NULL (Doc ID 1504794.1)

Last updated on DECEMBER 04, 2012

Applies to:

Oracle Argus Affiliate - Version 5.0.5.1 and later
Information in this document applies to any platform.

Symptoms

 Oracle Argus Safety Version 5.0.5.1

Some issues regarding missing LAM attachments which are not saved within a case save.

It seems like that Argus sometimes has problems to copy the temporary file located at the WEB_OPEN_CASES_ATTACH table to the CASE_NOTES_ATTACH table when the user tries to save the case.

All seems to be fine to the user who attached the attachment.

We observed in the error log following entry for the user/s on each reported missing LAM attachment:

 
We do not know what this definitely means and if this is the root cause of this issue. What happens to a case save when Argus hits an error like this?

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms