New UI: API-1019 error gets thrown when trying to publish a Status Report

book

Article ID: 141038

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Using the New UI, navigate to a Project and click on its "Status" tab (If this tab is not available, then it might have to be configured through Blueprints). Click on the "Report" sub tab. It is expected for a PDF to be generated and displayed within this tab, with an option to Publish it. But instead of this expected behaviour, "API-1019" error gets thrown.

This error is accompanied by the following logs in the app-ca.log:

ERROR 2019-11-20 09:08:56,155 [http-nio-8081-exec-46] pagebuilder.FilePageBuilder (someuser:503135477:50503074__B4FC8444-AEEE-9A1AD77C250E:PPM_REST_API) File "10885526" not found in path "/clarity/filestore/clarity/Files/885/010"

ERROR 2019-11-20 09:08:56,155 [http-nio-8081-exec-46] ppm.rest (someuser:503135477:50503074__B4FC8444-AEEE-9A1AD77C250E:PPM_REST_API) Error while loading Attachment Data from Document Manager.Could not retrieve file from file store.

 

In a system working as expected, there are references to the PDF in the DB. These references might also be missing when this issue is experienced. The following SQL query can be used to verify if the references have been inserted or not.

SELECT
    ver.id file_version_id,
    fil.name,
    fil.parent_folder_id,
    fol.path_name,
    fil.last_updated_date
FROM
    clb_dms_folders fol
    INNER JOIN clb_dms_files fil ON fol.id = fil.parent_folder_id
    INNER JOIN clb_dms_versions ver ON ver.file_id = fil.id
ORDER BY last_updated_date DESC;

Environment

Latest Relevant Version: 15.6.1.

Resolution

It is not known what exactly caused this issue, and a fix has not been verified yet. But the following might be useful:

1. Verify that the path being logged in app-ca.log is actually present on the server

2. If it is a multi-node system, then verify that the NFS mount is available to all the specific nodes

3. Use admin search recreate-index-files to rebuild indexes. Relevant KB reference: https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=23362

Additional Information

Per Case Number: 32269220, Georgia Tech Research Institute(2000301) saw the same error in this KB in their app-ca.log error and was a result of that the attachments/files can not be found.

ERROR 2021-05-13 10:14:29,412 [http-nio-80-exec-146] pagebuilder.FilePageBuilder (clarity:unknown:none:PPM_REST_API) File "10729960" not found in path "C:\ClarityDocs2\clarity\Files\729\010"
ERROR 2021-05-13 10:14:29,412 [http-nio-80-exec-146] ppm.rest (clarity:unknown:none:PPM_REST_API) Error while loading Attachment Data from Document Manager.Could not retrieve file from file store.

After a Dev to Prod refresh if they want the files to be accessible in refreshed environment (prod) they need to copy the filestore up from lower to prod (which is the db refresh direction they are going with) so that all references are matching. 

Resolution: Customer should move file store so that all references are matching.