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 220.127.116.11 and later
Information in this document applies to any platform.
Oracle Argus Safety Version 18.104.22.168
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?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document