WS3: PAM Core Attachment Storage

Scope Limitation

Assessment Only

Investigation & Assessment ONLY This workstream covers investigation, analysis, and feasibility assessment only. Mass file extraction, file repair, or full recovery are NOT included. A separate Change Request with additional budget will be required for execution.

Problem Statement

Reported Issue Within PAM Core System, some documents that were previously uploaded can no longer be opened or viewed. PAMC needs to understand where files are stored, why some are inaccessible, and whether recovery is possible.

Key Questions to Answer

Where are files stored?

How does DB link to files?

Why can't some files open?

Can all files be extracted?

Can damaged files recover?

Investigation Checklist

Check DB structure for file references

Tables, columns, relationships

Check file storage path & structure

Physical location on server

Map DB records to physical files

Verify consistency

Check upload/view process

Source code review

Check file permissions & access

Inspect sample inaccessible files

Missing, corrupt, or path issue?

Attempt sample file extraction

Task & Timeline

Investigation and Assessment

Medium • 2 working days

Deliverables

Attachment Storage Assessment Report

DB-to-File Mapping Description

File Storage Path & Structure

Sample File Inspection Results

File Extraction Procedure

Recovery Feasibility Report

Mass Recovery Estimate (if needed)

Acceptance Criteria

Storage structure & path identified

DB-to-file relationship explained

Sample files tested (open/extract)

Cause of inaccessible files identified

Extraction procedure documented

Recovery feasibility concluded

All reports delivered to PAMC & IT

Out of Scope

Not Included

Mass file extraction (all files)

Requires separate Change Request

Repairing corrupted files

Requires separate Change Request

Large-scale recovery operations

To be estimated in this WS

Fixing PAM Core upload functionality

Not in scope