Missing LAM Attachments: SQL execution error, ORA-01407: cannot update ("ARGUS_APP"."LAM_ACTION_ITEM"."FROM_CENTRAL") to NULL
Last updated on DECEMBER 04, 2012
Applies to:Oracle Argus Affiliate - Version 18.104.22.168 and later
Information in this document applies to any platform.
Oracle Argus Safety Version 22.214.171.124
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?
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