The user is intermittently unable to create Field Activities, as the system returns a negative acknowledgment along with error messages. (25R1)
The issue:
-
Occurs sometimes and only for some users
-
Cannot be consistently reproduced
-
Does not occur every time the action is performed
Test steps to replicate the issue -
- Navigate to the page “Prepare work order” and select a work order
- Go to the bottom of the page to the Attachments section
- Select the DOCUMENTS tab
- Click the New Document button

Attach the PDF and click OK

Error message:
Error when writing the file: Error while uploading the file. Detail: Error while uploading the file. Error from inside uploadFileNew: Failed to create the file entry. ORA-01502: index 'IFSAPP.EDM_FILE_STORAGE_RK' or partition of such index is in unusable state
ORA-06512: at "IFSAPP.EDM_FILE_STORAGE_API", line 2320
ORA-06512: at "IFSAPP.EDM_FILE_STORAGE_API", line 2352
ORA-06512: at "IFSAPP.EDM_FILE_STORAGE_API", line 2360
ORA-06512: at "IFSAPP.EDM_FILE_STORAGE_API", line 656
ORA-06512: at "IFSAPP.EDM_FILE_STORAGE_API", line 2206
ORA-06512: at "IFSAPP.EDM_FILE_STORAGE_API", line 2021
ORA-06512: at line 1